1. Welcome
2. Using the Exercise Files

3. Knowing the Three Common Uses of Excel
4. Understanding The Interface
5. Finding The Commands You Need
6. Using The Office Button
7. Managing File Compatibility

8. Creating a Worksheet
9. Techniques for Copying And Pasting
10. Entering Data Automatically using Auto-fill
11. Targeting Large Data groups
12. Changing A Worksheet's Structure

13. Understanding Formula and Functions
14. Entering Data in a Worksheet
15. Adding Numbers Manually
16. Adding Numbers Using the Sum and AutoSum
17. Adding a Whole Worksheet
18. Working with Numbers in Columns
19. Preventing Errors using Absolute References
20. Working with Dates and Time
21. Using IF
22. Using SUMIF and AVERAGEIF
23. Naming and Using Cell Ranges

24. Formatting Numbers and Dates
25. Applying Fonts, Background Colours and
Borders
26. Adjusting Columns, Rows and Texts
27. Using Conditional Formatting
28. Using Custom Conditional Formatting

29. Adding Pictures and Shapes
30. Inserting SmartArt
31. Coordinating a Look Using Themes
32. Applying Built-in Styles
33. Creating and Sharing Styles
34. Using Templates
35. Creating and Using Original Templates

36. Making the Pieces Fit
37. Inserting Headers and Footers
38. Printing and Converting to PDF

39 Finding and Replacing Data
40 Freezing Panes
41 Repeating Row and Column Titles
42 Creating Multiple Custom Worksheet Views
43 Hiding and Grouping Rows and Columns (Part1)
44 Hiding and Grouping Rows and Columns (Part2)
45 Managing Worksheets
46 Calculating Formulas Across Worksheets

47 Importing and Exporting Data in Excel
48 Setting Workbook Permissions
49 Inserting and Editing Comments
50 Sharing a Workbook
51 Tracking Changes

52 Splitting Cell Data into Multiple Cells
53 Joining Data from Multiple Cells
54 Basic and Multi-field Sorting
55 Using Tables to Sort and Filter
56 Inserting Automatic Subtotals
57 Creating Lookup Tables

58 Using Auditing to Diagram
59 Using Evaluation in Excel
60 Working with Goal Seek
61 Using Data Tables in Formulas
62 Using Scenarios in formulas
63 Exploring the Analysis Tool Pack

64 Discovering Pivot Tables
65 Creating a Basic Pivot Table
66 Modifying a Pivot Table
67 Creating and Modifying a Pivot Chart

68 Choosing Chart Types
69 Creating a Column Chart
70 Modifying a Column Chart
71 Creating and Modifying a Pie Chart
72 Placing Excel Charts into Other Application

73 Understanding Macros
74 Recording and Using a Simple Macro
75 Editing a Macro

76 Customizing the Quick Access Toolbar
77 Setting Excel Options
78 Conclusion

1 Applying Auto Filter On Record
2 Using Advanced Filter Features On Excel
3 Consolidating Of Data From Multiple Range
4 Summarizing Worksheet Using Subtotal
5 Splitting Of Data Into Multiple Column
6 Applying Remove Duplicate Feature Of Excel To Remove Duplicate Transaction
7 Applying Validation For Effective Control

8 Calculating Bonus Using Simple IF Function
9 Applying Nested IF When The Possible Outcome Is More Than Two
10 Using And Or In Compound IF

11 Counting With Condition Using Count IF
12 Applying Count IF On Multiple Criteria
13 Averaging With Condition Using Average IF
14 Counting The Number Of Blank Cells In A Range Using Count Blank
15 Applying Large Functions On Control

16 Introduction To Pivot Table
17 Creating Pivot Table
18 Manipulating Pivot Table By Changing The View One
19 Manipulating Pivot Table Two
20 Manipulating Pivot Table Three
21 How To Group Data On Pivot Table 

22 Other Method Of Grouping On Pivot Table
23 How To Create Pivot Chart From Table 24
24- How To Create Pivot Chart From Source Record
25 How To Move Multiple Chart To A Single Location

26 Introduction To Lookup Functions
27 Using VLOOKUP On Approximate Match
28 Applying VLOOKUP On Exact Mach
29 Nesting VLOOKUP Function
30 Applying VLOOKUP On Large Table
31 Introduction To Match Function
32 Applying Choose Function On Spreadsheet
33 Using Index On Array
34 Combining Index And Match Function
35 Practical Application On VLOOKUP And Match To Reconcile Two Month Payroll
36 Applying HLOOKUP WHATIF ANALYSIS
37 Introduction To WHAT-IF Analysis
38 How To Apply Goal Seek To Maximize Profit
39 Introduction To Solver And Adding Solver To Quick Access Toolbar
40 How To Analyse WHATIF Using Solver
41 How To Create And Use Scenario Manager
42 How To Generate Scenario Summary Report
43 How To Change A Single Variable Using One Input Table
44 How To Work With Two Input Data Table

45 How To Use Date Function
46 How To Apply Today And Now Function To Generate Current Date And Time On Spread sheet
47 How To Group Transactions To Actual Day Of The Week.
48 How To Calculate Actual Working Days In A Project Using NETWORKDAYS Function
49 How To Use Workday Function
50 How To Calculate Date Difference Using DATEDIF
51 How To Use EDATE Function
52 How To Convert Date To Value Using DATEVALUE Function

53 How To Merize Date With Condition Using SUM-IF
54 How To Get Aggregate Value On A Worksheet Using AGGREGATE Function
55 How To Use MOD Function
56 How To Generate Random Date Using Ran between
57 How To Convert Measurement Using Convert
58 How To Truncate Value And Generating Odd And Even Number Using TRUCODD Function MACROS
59 Introduction To Macros
60 How To Record Macros For Formatting Sheet
61 How To Record Macros For Highlighting Constant Value On Worksheet

62 How To Apply Frequency Function
63 How To Transpose Column To Row And Row Into Column Using Transpose
64 How To Use Trend Function
65 How To Apply Array Function With Match Function

66 How To Use Find To Locate Data On Worksheet
67 How To Use Left And Right Function To Extract Value On Spreadsheet
68 How To Join Words Using Concatenate Function
69 How To Apply Text Into Proper Function
70 How To Use Replace And Substitute Function To Replace By Position And Substitute By Content
71 How To Remove All Leading Space Using Trim Function

72 How To Use Offset Function To Extract The Last Reporting Date In Worksheet
73 How To Apply Indirect Function To Generate Report From Multiple Sheet
74 How To Apply Indirect Function With Validation

75 How To Use Hyperlink On The Index
76 How To Link Multiple Sheet On A Workbook
77 How To Manipulate Worksheet Through Renaming And Moving Sheet

78 How To Hide Sheet, Formula And Making Cell Not Editable On A Worksheet
79 How To Apply Protection On Workbook
80 How To Share Workbook For Collaboration

81  How To Import Data From Microsoft Word To Excel
82  How To Export Worksheet With Link To Other Application