Excel Level 1: Fundamentals of Excel

Level 1Full Day1 DayVersion 365Official CPE Provider · 6.5 CPE hours

Build practical, real world, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.

Course Objective

Students will create and edit Excel worksheets and manage workbooks, use formulas and functions, and apply formatting and printing techniques.

Prerequisites

To ensure your success, each student should have a general knowledge of Microsoft Windows and Microsoft Office concepts.

Course Outline

7 lessons · 30 topics

1Creating a Basic 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
Copy Formulas and Functions
Calculate Data Across Worksheets
Use Absolute and Mixed References
AutoFill Options, Flash Fill and Series List

3Modifying a Worksheet

Manipulate Data
Insert & Delete Cells, Columns and Rows
Find and Replace Data
Manipulate Worksheet Elements

4Formatting a Worksheet

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

5Printing Workbook Contents

Print Workbook Contents
Set Page Layout and Print Options
Set Page Breaks

6Managing Large Workbooks

Format Worksheet Tabs
Manage Worksheets in a Workbook

7Inserting Graphic Objects

Insert and Modify Graphics
Draw and Modify Shapes and Icons
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