Microsoft Excel Course

Course Content

1. Introduction to Microsoft Excel

1. Overview of Excel interface
2. Navigating worksheets and workbooks
3. Data entry and basic formatting
4. Saving and printing worksheets

2. Basic Formulas and Functions

3. Data Formatting and Management

4. Charts and Visualization

5. Advanced Formulas and Functions

6. PivotTables and Data Analysis

7. Advanced Excel Features

8. Introduction to Macros and VBA

Student Ratings & Reviews

No Review Yet

Microsoft Excel Course

Course Content

1. Introduction to Microsoft Excel

1. Overview of Excel interface

2. Navigating worksheets and workbooks

3. Data entry and basic formatting

4. Saving and printing worksheets

2. Basic Formulas and Functions

1. Introduction to formulas and functions

2. Arithmetic operations (+, -, *, /)

3. Common functions: SUM, AVERAGE, MIN, MAX

4. AutoFill and Flash Fill

3. Data Formatting and Management

1. Cell formatting (number, text, date)

2. Conditional formatting

3. Sorting and filtering data

4. Working with multiple worksheets

4. Charts and Visualization

1. Creating different types of charts (bar, line, pie)

2. Customizing charts

3. Using sparklines for quick data insights

5. Advanced Formulas and Functions

1. Logical functions (IF, AND, OR)

2. Lookup functions (VLOOKUP, HLOOKUP, XLOOKUP)

3. Text functions (LEFT, RIGHT, MID, CONCATENATE, TRIM)

4. Date and time functions

6. PivotTables and Data Analysis

1. Creating and modifying PivotTables

2. Using PivotCharts

3. Data summarization techniques

4. Introduction to Power Query

7. Advanced Excel Features

1. Data validation and drop-down lists

2. Goal Seek and What-If Analysis

3. Protecting and securing workbooks

8. Introduction to Macros and VBA

1. Recording and running macros

2. Basics of VBA programming

3. Automating repetitive tasks