About This Course

This Excel Training Course covers all the essential aspects from basic functionality to advanced tools, ensuring participants of varying levels can improve their Excel skills effectively. Each module is designed to be practical, helping learners apply the features in real-world scenarios.

Module 1: Introduction to Excel

1. Overview of Microsoft Excel
   • What is Excel?, Excel Interface (Ribbon, Workbook, Worksheet), Excel File Types (.xlsx, .xlsm, .xlsb)
2. Basic Excel Operations
   • Creating a New Workbook, Saving and Opening Workbooks, Understanding Workbooks and Worksheets, Moving and Copying Data Between Worksheets
3. Basic Excel Functions
   • Data Entry and Editing, Basic Formulae (Addition, Subtraction, Multiplication, Division), AutoSum and Quick Functions
4. Navigating Excel
   • Using the Mouse and Keyboard for Navigation, Selecting and Managing Rows and Columns, Freeze Panes and Split Windows

Module 2: Formatting and Organizing Data

1. Cell Formatting
   • Number Formatting (Currency, Percent, Date, Time), Font and Alignment Adjustments, Borders and Shading
2. Formatting Cells Based on Conditions
   • Conditional Formatting, Color Scales, Data Bars, and Icon Sets
3. Working with Rows and Columns
   • Inserting, Deleting, and Resizing Rows and Columns, Hiding and Unhiding Rows/Columns, Merging and Centering Cells
4. Using Format Painter and Themes
   • Copying Formatting with Format Painter, Applying Themes and Cell Styles

Module 3: Data Management and Analysis

1. Sorting and Filtering Data
   • Sorting Data (Ascending, Descending, Custom Sorting), AutoFilter and Custom Filters, Advanced Filters and Filter Criteria
2. Data Validation
   • Creating Drop-down Lists, Setting Data Validation Rules (Whole Number, Date, Text Length), Error Messages and Input Messages
3. Using Tables
   • Converting Data to a Table, Table Features (Structured References, Table Styles), Sorting and Filtering within Tables
4. Working with Ranges
   • Named Ranges, Range Names in Formulas, Managing Named Ranges

Module 4: Intermediate Excel Functions

1. Text Functions
   • CONCATENATE, TEXTJOIN, LEFT, RIGHT, MID, UPPER, LOWER, PROPER, LEN, FIND and SEARCH
2. Logical Functions
   • IF, AND, OR, Nested IF Functions, IFERROR and IFNA
3. Lookup Functions
   • VLOOKUP, HLOOKUP, INDEX and MATCH, XLOOKUP (in newer versions)
4. Date and Time Functions
   • DATE, DAY, MONTH, YEAR, WEEKDAY, NETWORKDAYS, NOW and TODAY
5. Mathematical Functions
   • SUM, AVERAGE, COUNT, COUNTA, COUNTIF, ROUND, ROUNDUP, ROUNDDOWN, SUMIF, AVERAGEIF, COUNTIFS

Module 5: Visualizing Data

1. Creating Charts
   • Types of Charts (Column, Line, Pie, Bar, etc.), Customizing Chart Titles, Axes, and Legends, Changing Chart Types and Styles
2. Advanced Charting Techniques
   • Creating Combo Charts, Adding Trendlines and Error Bars, Creating Sparklines
3. Using PivotTables
   • Introduction to PivotTables, Creating a PivotTable from Data, Filtering, Sorting, and Grouping Data in PivotTables, Calculated Fields and Items

Module 6: Advanced Excel Features

1. Advanced Formulas and Functions
   • Array Formulas (CTRL+SHIFT+ENTER), SUMPRODUCT, TRANSPOSE, INDIRECT, Advanced Lookup Techniques
2. Working with Multiple Worksheets
   • Linking Data Between Worksheets, Grouping and Ungrouping Worksheets, 3D Formulas
3. Data Analysis Tools
   • What-If Analysis (Scenario Manager, Goal Seek), Solver, Data Tables
4. Excel Dashboards
   • Creating Interactive Dashboards, Using Form Controls (Buttons, Dropdowns, Sliders), Combining Multiple Charts and PivotTables in Dashboards

Module 7: Excel Automation and Macros

1. Introduction to Macros
   • Recording Macros, Assigning Macros to Buttons, Understanding the VBA Editor
2. Basic VBA Programming
   • Introduction to VBA (Visual Basic for Applications), Writing Simple VBA Code, Automating Repetitive Tasks with VBA
3. Advanced Macro Techniques
   • Writing Custom Functions (UDFs), Error Handling in Macros, Creating User Forms

Module 8: Collaboration and Sharing

1. Sharing and Protecting Workbooks
   • Sharing Workbooks with Multiple Users, Protecting Cells, Sheets, and Workbooks, Password Protection and Permissions
2. Tracking Changes
   • Using Comments and Notes, Tracking and Accepting/Rejecting Changes, Comparing Workbooks
3. Exporting Data
   • Saving Workbooks as PDF or Other Formats, Importing Data from External Sources (CSV, Text Files), Using Power Query to Import and Clean Data

Module 9: Tips, Tricks, and Best Practices

1. Excel Shortcuts and Productivity Tips
   • Keyboard Shortcuts for Faster Navigation, Time-Saving Tips and Tricks
2. Excel Troubleshooting
   • Common Excel Errors and How to Fix Them, Optimizing Excel Performance
3. Excel Best Practices
   • Organizing Data for Better Analysis, Documenting Formulas and Data Sources, Maintaining Data Integrity