Microsoft Excel Basic

Course Outline

Module 1: Getting Started

• Using the Menu System & Quick Access Toolbar

• Understanding OneDrive

• Creating New Workbooks

• Saving and Sharing Workbooks

Module 2: Working with Cells and Sheets

• Cell Basics

• Modifying Columns, Rows, and Cells

• Formatting Cells

• Understanding Number Formats

• Using Find and Replace

• Checking Spelling

Module 3: Formulas and Functions

• Introduction to- Formulas

• Relative and Absolute Cell References

• Excel Basic Functions

Module 4: Formatting

• Exploring font styles and effects

• Align text in vertical & horizontal manner

• Designing Borders

• Formatting values as numbers, currency, percentages

Module 5: Sorting & Filtering

• Sorting Data

• Filtering Data

Module 6: Charts

• Creating Charts

• Exploring chart types

• Formatting Charts

• Creating charts with Sparklines

Module 7: Printing

• Accessing Print Pane & Printing a workbook

• Choosing a Print Area

• Adjusting conten