Excel Fast Forward (Session 1): Beginner Levels 1 & 2
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.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
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
- 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
- Calculate with Formulas
- Calculate with Functions (Nested IF, Basic SUMIFS)
- Copy Formulas and Functions
- AutoFill Options and Series List
- Apply Absolute Referencing
- Modify Fonts
- Add Borders, Color, and Cell Styles
- Change Column Width and Height
- Apply Number Formats
- Position Cell Contents
- Print Workbook Contents
- Set Page Layout and Print Options
- Set Page Breaks
- Go Thru Page Break Preview
- Named Range
- Sheet Grouping
- Sorting/Filtering
- Series Lists
- Basic Chart
- Insert and Modify Graphics
- Illustrate Workflow Using SmartArt
- Layer and Group Graphic Objects