Microsoft Excel for Beginners – 90 Day Plan – FinAcc Plus

Course Content

Overview of Microsoft Excel (Basic)

Excel Navigation and Support 5 Topics

Module Content

0% Complete 0/5 Steps

Launching Excel

Excel User Interface

Keyboard Shortcuts

Getting Help with Excel

Creating Spreadsheets 5 Topics

Module Content

0% Complete 0/5 Steps

Excel Templates

Blank Workbooks

Basic Data Validation

Data Entry Form

Exercise – Creating Spreadsheets

Cell and Worksheet Formatting 5 Topics

Module Content

0% Complete 0/5 Steps

Cell Formatting

Number Formatting

Conditional Formatting

Format as a Table

Exercise – Cell and Worksheet Formatting

Data Manipulation Tools 3 Topics

Module Content

0% Complete 0/3 Steps

Copy and Paste Options

Sorting and Filtering Data

Exercise – Data Manipulation Tools

Excel Formulas and Functions 4 Topics

Module Content

0% Complete 0/4 Steps

Introduction to Excel Formulas and Functions

The Primary Excel Functions

Conditional Functions

Exercise – Excel Formulas and Functions

Cell References and Links 3 Topics

Module Content

0% Complete 0/3 Steps

Relative and Absolute References

Internal and External Links

Exercise – Cell References and Links

Visualization Tools 3 Topics

Module Content

0% Complete 0/3 Steps

Data Visualization

Other Visual Elements

Exercise – Visualization Tools

Workbook Display Options 3 Topics

Module Content

0% Complete 0/3 Steps

Workbook Views and Zoom Options

Managing Multiple Windows

Exercise – Workbook Display Options

Spreadsheet Management Tools 3 Topics

Module Content

0% Complete 0/3 Steps

Page Layout and Print Options

Protecting Workbooks

Exercise – Spreadsheet Management Tools

Excel Online 3 Topics

Module Content

0% Complete 0/3 Steps

Microsoft 365 Portal

Working with Excel Online

Collaboration and Sharing Options

Course Conclusion