Table Of Content In Excel

Module 1: Introduction to Excel

1. Understanding the Excel interface
2. Navigating the workbook and worksheets
3. Basic Excel terminology

Module 2: Entering and Editing Data

1. Entering data into cells
2. Editing cell content
3. Using AutoFill to fill data quickly
4. Using AutoSum for basic calculations

Module 3: Formatting and Styling

1. Formatting cells (font, size, color, etc.)
2. Applying cell borders and shading
3. Formatting numbers and dates
4. Using cell styles for consistency

Module 4: Managing Worksheets

1. Adding, renaming, and deleting worksheets
2. Moving and copying worksheets
3. Grouping and ungrouping worksheets

Module 5: Basic Formulas and Functions

1. Understanding formulas and cell references
2. Using basic arithmetic operators (+, -, *, /)
3. Introducing common functions (SUM, AVERAGE, MAX, MIN)
4. Using relative and absolute references

Module 6: Working with Ranges and Tables

1. Selecting and manipulating ranges
2. Inserting and deleting rows and columns
3. Creating and formatting tables

Module 7: Charts and Graphs

1. Creating different types of charts (column, line, pie, etc.)
2. Modifying chart elements (titles, labels, legends)
3. Formatting charts to make them visually appealing

Module 8: Conditional Formatting

1. Applying conditional formatting rules
2. Working with data bars, color scales, and icon sets
3. Creating custom conditional formatting rules

Module 9: Data Sorting and Filtering

1. Sorting data in ascending or descending order
2. Using Excel's built-in filters
3. Applying advanced filters to extract specific data

Module 10: Basic Data Analysis

1. Using PivotTables to summarize data
2. Creating PivotCharts for visual analysis

Module 11: Data Validation

1. Setting up data validation rules
2. Creating drop-down lists for data entry

Module 12: Collaboration and Printing

1. Protecting worksheets and workbooks
2. Using comments and track changes
3. Printing options and page setup

Excel Mastery: Free Course & Table of Contents