In MS Excel beginner to advance package you will get advance level knowledge. If anyone buy this package then they will get MS Excel Beginner level also. because beginner level course already included in this package;
What you'll learn
In Advance level package i have explained each and every topic in detail with practical.So that anyone can learn MS Excel in 45 days easily.No prior knowledge needed.You may Join this course if you want to learn all functions of MS Excel.
COURSE CONTENT
-
Lesson 1 - Introduction of MS Excel
-
(00:05:18 min)
-
Lesson 2 - How to use Special Commands in Excel?
-
(00:15:00 min)
-
Lesson 3 - Cell References with types
-
(00:09:16 min)
-
Lesson 4 - Working_with_cells_in_Excel
-
(00:37:23 min)
-
Lesson 5 - Marksheet Report In Excel
-
(00:18:32 min)
-
Lesson 6 - Attendance Report in Excel
-
(00:04:34 min)
-
Lesson 7 - Salary_Report_in_Excel
-
(00:15:52 min)
-
Lesson 8 - Payroll_Report_in_Excel
-
(00:21:09 min)
-
Lesson 9 - TimeSheet_Report_in_Excel
-
(00:02:07 min)
-
Lesson 10 - Overtime_Report_in_Excel
-
(00:04:40 min)
-
Lesson 11 - Interest_Calculation_Report_in_Excel
-
(00:05:18 min)
-
Lesson 12 - Product Report in Excel
-
(00:06:01 min)
-
Lesson 13 - Formatting_of_Data_in_Excel
-
(00:17:05 min)
-
Lesson 14 - Home_Ribbon(Conditional_Formatting Part-1 in Excel)
-
(00:21:47 min)
-
Lesson 15 - Home_Ribbon(Conditional_Formatting-Part-2_in_Excel
-
(00:33:16 min)
-
Lesson 16 - Home_Ribbon (Conditional_Formatting-_Part-3)
-
(00:20:14 min)
-
Lesson 17 -Home_Ribbon(Paste Special part-1)
-
(00:09:41 min)
-
Lesson 18 - Home_Ribbon (Paste_Special Part-2)
-
(00:06:52 min)
-
Lesson 19 - MS Excel Home_Ribbon(Paste_Special Part-3)
-
(00:04:17 min)
-
Lesson 20 - MS Excel (Custom_Format - Zero_Format)
-
(00:06:17 min)
-
Lesson 21 - MS Excel (Custom_Format- Custom_Date_Format)
-
(00:05:24 min)
-
Lesson 22 - MS Excel (Custom_Format- Decimal Values)
-
(00:04:40 min)
-
Lesson 23 - MS Excel (Custom_Format- Hash_Format)
-
(00:04:11 min)
-
Lesson 24 - MS Excel (Custom_Format-Billion_Format)
-
(00:07:31 min)
-
Lesson 25 - MS Excel (Custom_Format-Highlight_Number)
-
(00:14:11 min)
-
LEsson 26 - MS Excel (Custom_Format-Number_Format)
-
(00:23:34 min)
-
Lesson 27 - MS Excel (Series in Excel)
-
(00:23:04 min)
-
Lesson 28 - MS_Excel_Home_Ribbon (Style_Group-Format_as_Table__cell_style)
-
(00:09:09 min)
-
Lesson 30 - MS_Excel_Pagelayout_Ribbon (Set_Margin_in_Excel)
-
(00:06:41 min)
-
Lesson 29 - MS_Excel_(Pivot_Table-In_Detailed)
-
(00:26:15 min)
-
Lesson 31 - MS_Excel_Pagelayout_Ribbon (Orientation_in_Excel)
-
(00:01:28 min)
-
Lesson 32 - MS_Excel_Pagelayout_Ribbon (Pagebreak_in_Excel)
-
(00:04:44 min)
-
Lesson 33 - MS_Excel_Pagelyout_Ribbon (Printarea_in_Excel)
-
(00:02:28 min)
-
LEsson 34 - MS_Excel_Pagelayout_Ribbon (Papersize_in_Excel)
-
(00:03:29 min)
-
Lesson 35 - MS_Excel_Pagelayout_Ribbon (Header and Footer_in_Excel)
-
(00:03:43 min)
-
Lesson 36 - MS Excel Pagelayout_Ribbon (Theme Group in Excel)
-
(00:02:03 min)
-
Lesson 37 - MS Excel Pagelayout_Ribbon (Print title in Excel)
-
(00:06:16 min)
-
Lesson 38 - MS Excel Pagelayout_Ribbon (Page_background in Excel)
-
(00:02:51 min)
-
Lesson 39 - MS Excel Text_Function (Char, Code, Concatenate, Dollar)
-
(00:15:19 min)
-
Lesson 40 - MS Excel Mathematical_Function (sum, average, max, min, small, large, product)
-
(00:06:28 min)
-
Lesson 41 - MS Excel Date and Time_Function (add and Sub in days, Months, Years in Date in Excel)
-
(00:06:53 min)
-
Lesson 42 - MS_Excel_Date and Time_Function (Create_date_range_Between_Two_dates_in_Excel)
-
(00:02:26 min)
-
Lesson 43 - MS_Excel_Date and Time_Function(Date_Format_in_Excel)
-
(00:03:30 min)
-
Lesson 44 - MS_Excel_Date and Time_Function(Today__Now__Day__Month__Year__Hour__Minute__Second__Time__Days360__Networkdays__weekdays__Weeknum__Workday_)
-
(00:17:56 min)
-
Lesson 45 - MS_Excel_Mathematical_Function(SQRT__SQRTPI__RAND__POWER__RANDBETWEEN__QUOTATION)
-
(00:07:43 min)
-
Lesson 46 - MS_Excel_Mathematical_Function(Subtotal__Sumif__Sumifs)
-
(00:06:49 min)
-
Lesson 47 - MS_Excel_Text_Function(Exact__Fixed__left__right__mid__upper__lower__proper__rept)
-
(00:09:13 min)
-
Lesson 48 - MS Excel Date and Time Function(Add, Sub in Hour, Minute, Second in time in Excel)
-
(00:04:29 min)
-
Lesson 49 - MS Excel Formula_Ribbon(Calculation_group in Excel)
-
(00:03:31 min)
-
Lesson 50 - MS_Excel_Formula_Tab(Auditing_Group_in_Excel)
-
(00:06:18 min)
-
Lesson 51 - MS_Excel_Text_Function(Find__Search__Replace__Substitute)
-
(00:14:44 min)
-
Lesson 52 - MS Excel Data_Ribbon (Remove duplicate in Excel)
-
(00:01:21 min)
-
Lesson 53 - MS Excel Data_Ribbon (Text_to_Column Option in Excel )
-
(00:03:55 min)
-
Lesson 54 - MS_Excel_(Data_Filter_with_Excel)
-
(00:27:08 min)
-
Lesson 55 - MS Excel Data_Ribbon(Data Validation in Excel)
-
(00:18:11 min)
-
Lesson 56 - MS_Excel_(Data_Sorting_in_ascending_and_descending_order_in_excel)
-
(00:08:18 min)
-
Lesson 57 - MS_Excel_Data_Ribbon(Consolidate_of_data_and_sheet_in_Excel)
-
(00:08:42 min)
-
Lesson 58 - MS_Excel_Data_Ribbon(Datatable_in_Excel)
-
(00:02:22 min)
-
Lesson 59 - MS_Excel_Data_Ribbon(FlashFill_in_Excel)
-
(00:02:00 min)
-
Lesson 60 - MS_Excel_Data_Ribbon(Goel_Seek_in_Excel)
-
(00:02:26 min)
-
Lesson 61 - MS_Excel_Data_Ribbon(scenario_Manager_in_Excel)
-
(00:04:19 min)
-
Lesson 62 - MS_Excel_Review_Ribbon(review_part-1)
-
(00:10:01 min)
-
Lesson 63 - MS_Excel_Review_Ribbon(Review_part-2)
-
(00:04:19)
-
Lesson 64 - MS Excel View_Ribbon(View tab part-1)
-
(00:12:45 min)
-
Lesson 65 - MS_Excel_View_Ribbon(View_Tab_Part-2)
-
(00:09:48 min)
-
Lesson 66 - MS_Excel_View_Ribbon(View_Tab_Part-3)
-
(00:09:13 min)
