What’s included in Lessons

1 Microsoft Excel Introduction
2 Create and Close Workbook
3 SAVE WORKBOOK
4 Change number of worksheets
5 Set Password for excel file
6 Insert and Rename worksheets in Excel
7 Hide and Unhide Worksheets in Excel
8 Move or Copy entire worksheets with in Workbook
9 Insert Rows and Columns in Excel
10 How to hide and unhide Rows and Columns
11 How to Delete Rows and Columns in Excel
12 Insert and Delete Cells
13 Freeze pane at Rows and columns in Excel Worksheet
14 How to enter data in Excel
15 How to edit data in Excel
16 Move Data in Excel
17 How to duplicate data in Excel
18 Enter data with fill handler in Excel
19 Custom patterns with the fill handle in Excel
20 How to use drag and drop in Excel
21 How to delete data in Excel
22 How to find a value in Excel
23 How to find a formatted value in Excel
24 How to find all matches at once in Excel
25 How to find and Replace a value
26 How to find and Replace formatted values in Excel
27 What is formula and Function in Excel
28 Arthimatic operations in formula
29 Order of Operation in Excel
30 What is cell Reference in Excel
31 Relative Reference
32 Relative Reference Examples
33 Absolute Reference
34 Absolute Reference -Example
35 Mixed Reference
36 Year,month,day,date
37 NOW and Today Function
38 HOUR,NIMUTE,SECOND and TIME functions
39 EDATE and EOMONTH Functions
40 WEEKDAY and WEEKNUM
41 AND Function
42 NOT Function in Excel
43 OR Function in Excel
44 Count Function
45 COUNT IF Function
46 SUMIF Function
47 SUM Function
48 Calculate Average Value
49 Find Minimum and Maximum Values using MIN and MAX
50 ISERROR Function
51 ISNUMBER Function in Excel
52 ISNA Function
53 isblank function
54 ABS Function
55 EVEN Function
56 INT Function
57 RAND Function
58 RANDBETWEEN Function
59 What is conditional formatting
60 How to create a conditional formatting rule
61 How to revise a conditional formatting rule
62 How to add additional conditional formatting rules
63 How to delete conditional formatting rules
64 How to highlight top and bottom values
65 How to use data bars with conditional formatting
66 How to use color scales with conditional formatting
67 How to use Icon sets with conditional formatting
68 How to highlight text values with conditional formatting
69 How to show duplicate values with conditional formatting
70 How to highlight rows with conditional formatting
71 How to highlight rows using multiple criteria
72 What is an Excel table
73 How to Create a Table in Excel
74 How to Remove Table an Excel
75 Excel table Options
76 How Excel Table Range Works in Excel
77 How to add a totals row to a Table
78 How to Remove Duplicates from a Table
79 How to sort an excel table
80 How to use Table filters
81 Working with Table Rows and Columns
82 How to add a Slicer to a table
83 How to use Table Slicer Options