Microsoft Excel – Part 1
- Duration
- 1 day
- Starting Price
- From $145.00
This course provides foundational Excel knowledge and practical skills for creating and developing worksheets and workbooks to work with and analyze organizational data.
At Completion
- Create and develop Excel worksheets and workbooks for data analysis and manipulation.
Exams & Certifications
Covers objectives for Microsoft Office Specialist Program exams MO-200 (Excel Associate) and MO-201 (Excel Expert) for Office 365 and Office 2019.
Course Outline
1 - Getting Started with Excel
- Navigate the Excel User Interface
- Use Excel Commands
- Create and Save a Basic Workbook
- Excel Online
- Enter Cell Data
- Use Excel Help
2 - Performing Calculations
- Create Worksheet Formulas
- Insert Functions
- Reuse Formulas and Functions
3 - Modifying a Worksheet
- Insert, Delete, and Adjust Cells, Columns, and Rows
- Search for and Replace Data
- Use Proofing and Research Tools
4 - Formatting a Worksheet
- Apply Text Formats
- Apply Number Formats
- Align Cell Contents
- Apply Colors, Borders, and Styles
- Apply Basic Conditional Formatting
- Create and Use Templates
5 - Printing Workbooks
- Preview and Print a Workbook
- Set Up the Page Layout
- Configure Headers and Footers
6 - Managing Workbooks
- Manage Worksheets
- Manage Workbook and Worksheet Views
- Manage Workbook Properties
Upcoming Sessions
- Nov 11, 2026 Online9:00 AM - 4:30 PM ET$145.00Register →
- Dec 16, 2026 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Jan 26, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Mar 17, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Apr 22, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- May 17, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Jun 17, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Jul 16, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Aug 19, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →
- Sep 16, 2027 Online9:00 AM - 4:30 PM ET$145.00Schedule TentativeRegister →