Excel Fast Forward: Beginner Levels 1 & 2

Boot Camp2 DaysVersion 365Official CPE Provider

Course Outline

6 lessons · 29 topics

1Creating a Worksheet

Explore the User Interface
Update a Workbook’s Properties
Navigate and Select Data in Excel
Enter Data and Save a Workbook
Customize the Quick Access Toolbar
Obtain Help
Use Microsoft Office Templates

2Performing Calculations

Calculate with Formulas
Calculate with Functions (Nested IF, Basic SUMIFS)
Copy Formulas and Functions
AutoFill Options and Series List
Apply Absolute Referencing

3Formatting a Worksheet

Modify Fonts
Add Borders, Color, and Cell Styles
Change Column Width and Height
Apply Number Formats
Position Cell Contents

4Printing Workbook Contents

Print Workbook Contents
Set Page Layout and Print Options
Set Page Breaks
Go Thru Page Break Preview

5Working with Data

Named Range
Sheet Grouping
Sorting/Filtering
Series Lists
Basic Chart

6Inserting Graphic Objects

Insert and Modify Graphics
Illustrate Workflow Using SmartArt
Layer and Group Graphic Objects

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals