Microsoft Excel Basic to Advanced Excel Course

Course Content

Introduction to Excel

1. What is Excel?
2. Excel Interface: Ribbon, Quick Access Toolbar, Worksheet, Cells, Columns, Rows
3. Navigating Excel Workbooks
4. Understanding Workbooks and Worksheets

Basic Operations

Formatting Basics

Customizing Quick Access Toolbar and Basic Function or Formulas

Excel Basics

Printing and Sharing

Data Management

Basic Formulas and Functions

Working with Text

Advanced Formatting

Working with Tables

Logical Functions

Lookup Functions

Date and Time Functions

Charts and Graphs

PivotTables

Data Analysis Tools

Advanced Formulas

Power Query

Macros and VBA Basics

Data Protection and Sharing

Student Ratings & Reviews

No Review Yet

Course Content

Introduction to Excel

1. What is Excel?

2. Excel Interface: Ribbon, Quick Access Toolbar, Worksheet, Cells, Columns, Rows

3. Navigating Excel Workbooks

4. Understanding Workbooks and Worksheets

Basic Operations

1. Creating, Saving, and Opening Workbooks

2. Working with Workbooks and Worksheets

3. Data Entry and Editing

4. Selecting Cells, Rows, and Columns

5. Inserting and Deleting Rows, Columns, and Cells

6. Undo and Redo Actions

Formatting Basics

1. Font Formatting (Bold, Italic, Underline, Color)

2. Cell Alignment (Merge, Wrap Text, Orientation)

3. Number Formatting (Currency, Percentage, Date, Time)

4. Borders and Shading

5. Using Format Painter

Customizing Quick Access Toolbar and Basic Function or Formulas

1. Customizing Quick Access Toolbar

2. Basic Function or Formulas

Excel Basics

1. Managing worksheet

2. Copying and moving data

3. Using Find and Replace

4. Cell Styles and Themes

Printing and Sharing

1. Setting up print areas and page layout

2. Adding headers and footers

3. Previewing and printing worksheets

4. Saving and sharing workbooks

Data Management

1. Sorting Data (Single and Multiple Columns)

2. Filtering Data (AutoFilter, Custom Filters)

3. Data Validation (Dropdown Lists, Input Messages, Error Alerts)

4. Removing Duplicates

Basic Formulas and Functions

1. Introduction to Formulas and Functions

2. Common Functions: SUM, AVERAGE, MIN, MAX, COUNT

3. Cell References (Relative, Absolute, Mixed)

4. Basic Arithmetic Operations

Working with Text

1. Concatenation (Using & and CONCATENATE)

2. Text Functions: LEFT, RIGHT, MID, LEN, TRIM, UPPER, LOWER, PROPER

Advanced Formatting

1. Conditional Formatting (Highlight Cells, Data Bars, Color Scales, Icon Sets)

2. Custom Number Formatting

3. Using Styles and Themes

Working with Tables

1. Creating and Formatting Tables

2. Table Features: Sorting, Filtering, and Total Row

3. Structured References in Tables

Logical Functions

1. IF, NESTED IF, AND, OR

2. Using IFERROR for Error Handling

Lookup Functions

1. VLOOKUP and HLOOKUP

2. INDEX and MATCH (Combined Usage)

3. XLOOKUP

Date and Time Functions

1. TODAY, NOW

2. DATEDIF, NETWORKDAYS, WORKDAY

3. YEAR, MONTH, DAY, HOUR, MINUTE, SECOND

Charts and Graphs

1. Creating Charts (Column, Bar, Line, Pie, Area, Scatter)

2. Formatting Charts (Titles, Axes, Legends, Data Labels)

3. Advanced Chart Types (Combo Charts, Sparklines)

PivotTables

1. Creating and Modifying PivotTables

2. Grouping and Ungrouping Data

3. Using Slicers and Timelines

4. PivotTable Calculations (Summarize Values, Show Values As)

Data Analysis Tools

1. What-If Analysis (Goal Seek, Data Tables, Scenario Manager)

2. Solver Add-In

3. Descriptive Statistics with Analysis ToolPak

Advanced Formulas

1. Array Formulas

2. INDIRECT, OFFSET, CHOOSE