01. & 02. Getting Started & Data Entry

• Navigation: Menu system, Quick Access Toolbar, and Formula Bar
• Workbook Structure: Using the Status bar and Mouse pointers
• Data Entry: AutoFill techniques and working with Dates/Times
• Efficiency: Undo/Redo, adding Comments, and Save strategies

03. Formulas and Functions

• Creating simple formulas: Totals, Averages, and YTD Profits
• Mastering References: Relative, Absolute, and Mixed
• Calculating percentage increases
• Using common functions: SUM, AVERAGE, and more

04. & 05. Formatting and Layout

• Font styles, effects, and Row/Column adjustments
• Alignment, Wrap Text, and Designing Borders
• Numeric and Special formatting for dates and currency
• Conditional Formatting and Table creation
• Managing Data: Hiding, moving, and finding/replacing data

06. & 07. Printing and Charting

• Page Layout: Previewing page breaks and Print Setup
• Introduction to Charting: Creation, Types, and Formatting
• Working with Labels, Gridlines, and Axes
• Creating in-cell Sparklines for quick visualization

08. & 09. Worksheet Views & Multiple Files

• Freezing/Unfreezing panes and Splitting screens
• Using the Outlining feature for complex data
• Managing Multiple Sheets: Renaming, grouping, and linking
• Maintaining external links between workbooks

10. & 11. Logic, Lookups, and Security

• Using IF functions and Relational Operators
• VLOOKUP: Finding Exact and Approximate table data
• The COUNTIF family of functions
• Security: Unlocking cells, protecting workbooks, and Passwords
• Sharing: Tracking changes in collaborative environments

12. & 13. Data Management & PivotTables

• Sorting, Filters, and Subtotals
• Cleaning Data: Splitting columns and removing duplicates
• Creating PivotTables and manipulating data fields
• Grouping by Date/Time and using Slicers
• Visualizing results with PivotCharts

14. Introduction to Macros

• Definition and practical examples of automation
• Creating and running a simple Macro