MS Excel Course

Module 1: Introduction to Excel
- 1.1 Getting Started with Excel
- 1.2 Working with Excel Worksheets
- 1.3 Entering and Editing Data
- 1.4 Using Excel Shortcuts
Module 2: Basic Excel Functions and Formulas
- 2.1 Understanding Formulas
- 2.2 Using Basic Excel Functions
- 2.3 Working with Relative, Absolute, and Mixed References
- 2.4 Applying Conditional Formatting
Module 3: Data Management
- 3.1 Sorting and Filtering Data
- 3.2 Using Data Validation
- 3.3 Removing Duplicates
- 3.4 Text Functions
Module 4: Data Analysis with Excel
- 4.1 Using Lookup Functions
- 4.2 Creating PivotTables
- 4.3 Using PivotCharts
- 4.4 Data Analysis with What-If Tools
Module 5: Advanced Excel Functions
- 5.1 Using Advanced Excel Functions
- 5.2 Working with Nested Functions
- 5.3 Using Array Formulas
- 5.4 Working with Date and Time Functions
Module 6: Data Visualization
- 6.1 Creating Basic Charts
- 6.2 Using Sparklines
- 6.3 Creating and Formatting Advanced Charts
- 6.4 Applying Conditional Formatting to Charts
Module 7: Excel Macros and VBA
- 7.1 Recording Macros
- 7.2 Editing Macros
- 7.3 Writing Simple VBA Code
- 7.4 Creating User Forms
Module 8: Collaboration and Security
- 8.1 Sharing Workbooks
- 8.2 Protecting Workbooks and Worksheets
- 8.3 Tracking Changes and Comments
- 8.4 Creating and Managing Templates
Module 9: Integrating Excel with Other Tools
- 9.1 Importing Data from External Sources
- 9.2 Linking Excel with Other Office Applications
- 9.3 Using Power Query
- 9.4 Automation
Module 10: Final Project
- 10.1 Creating a Comprehensive Excel Solution