Excel
Excel Level 1: Fundamentals of Excel
Build practical, real world, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.
CPE Eligible - 6.5 CPE credit hours. Visit /cpe for details.CPE page →
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
Creating 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
Performing 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
Modifying a Worksheet
- Manipulate Data
- Insert & Delete Cells, Columns and Rows
- Find and Replace Data
- Manipulate Worksheet Elements
Formatting a Worksheet
- Modify Fonts
- Add Borders, Color, and Cell Styles
- Change Column Width and Height
- Apply Number Formats
- Position Cell Contents
Printing Workbook Contents
- Print Workbook Contents
- Set Page Layout and Print Options
- Set Page Breaks
Managing Large Workbooks
- Format Worksheet Tabs
- Manage Worksheets in a Workbook
Inserting Graphic Objects
- Insert and Modify Graphics
- Draw and Modify Shapes and Icons
- Layer and Group Graphic Objects