Microsoft Office Excel Beginners Course
Prerequisites
This course assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Excel is necessary.
Course Outline
- Getting started with Excel
- Creating and opening workbooks
- Saving and sharing workbooks
- Cell basics
- Modifying columns, rows and and cells
- Formatting cells
- Understanding number formats
- Working with multiple worksheets
- Using find & replace
- Checking spelling
- Page layout and printing
- Creating formulas
- Relative and absolute cell references
- Functions
- Working with data
- Feezing panes and view options
- Sorting data
- Filtering data
- Groups and subtotals
- Tables
- Charts
- Conditional formatting