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