arrow_back
00. Message from Educator
01. Opening first Excel worksheet, intoduction of every element on sheet and defining range
02. Navigation, Data Entry, Formatting and basic calculation
03. Copying formulas, Relative and Absolute Referencing
04. Comprehensive practice of Relative and absolute referencing
05. Referencing further practice
06. Quick revision, explaining ribbon and excel shortcuts
07. Backstage of excel i.e. File Tab and introducing the operational shortcuts L1
08. Backstage of excel ie. File Tab and introducing the operational shortcuts L2
09. Customizing the ribbon intro to formula tab
10. TRUE, FALSE, IF, AND, OR function
11. IF Function together with AND, OR function
12. Nested if function
13. Autosum functions and mathematical exercises
14. Paste special function
15. Paste link, transpose, insert, delete and format cells function
16. Linking data between the sheets and its benefit
17. Conditional formatting
18. Count Function
19. Rank function, Minimum, MAX, Large and Small Function
20. Sumif, SumIFs
21. CountIF, AverageIf Function
22. Mround, Ceiling, Floor
23. Rounddown, RoundUp functions
24. Integer and Trunc functions
25. Trim and Proper Function
26. Find and Search Function
27. Upper, Lower and Proper Function
28. AND FUNCTION
29. Concatenate Function
30. Repeat and Substitute Function
31. Substitute function practice
32. Substitute and Repeat Function
33. Replace Function
34. Date and Time Function Introduction
35. Customise your own date format
36. Today Function and addition, subtraction to dates
37. EDATE Function
38. EOM Function
39. Introduction to chart and different ways of inserting a chart
40. Introducing all the chart elements and formatting each element
41. Improving your chart by using various charts layouts, colors and designs
42. Data series editing, saving a template and other basic chart details
43. When to use which chart type-an intro and winding up session
44. VLOOKUP Function
45. MATCH and HLOOKUP Function
46. Tell me what do you want option in excel
47. Protecting, freeze panes, show and customize the ribbon
48. Undo last step vs. Undo many steps at one go.mp4
49. Table making, designng, Sort and Filter in table mode and with the use of Slicer option
50. AutoCorrect function for short hand wriring, Automatic decimal entry and various miscellaneous points in FILE Tab
Ebook & Practice Workbook
Excel Worksheet 1
Excel Worksheet 2
Excel Worksheet 3
Excel Worksheet 4
Excel Worksheet 5
Excel Worksheet 6
Excel Worksheet 7
Excel Worksheet 8
Excel Worksheet 9
Excel Worksheet 10
Excel Worksheet 11
Excel Worksheet 12
Excel Worksheet 13
Shortcuts PDF
Excel Shortcuts