Excel Fast Forward (Session 1): Beginner Levels 1 & 2

Full Day1 DayVersion 365Official CPE Provider

The fastest way to get a business user productive in Excel - Levels 1 and 2 combined into one hands-on, faster-paced day. Available for private/group training only.

Course Objective

Students will cover the key topics from Excel Levels 1 and 2 at a faster pace, learning to build and format worksheets, write formulas and functions, use absolute references and AutoFill, and work with data through named ranges, sorting, filtering, and basic charts. (Available for private/group training only).

Prerequisites

To ensure your success, each student should have a general knowledge of Microsoft Windows and Microsoft Office concepts. This is a faster-paced class that combines two levels.

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