Scheduled dates
No public dates scheduled yet
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 outline
Creating 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
Performing Calculations
- Calculate with Formulas
- Calculate with Functions (Nested IF, Basic SUMIFS)
- Copy Formulas and Functions
- AutoFill Options and Series List
- Apply Absolute Referencing
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
- Go Thru Page Break Preview
Working with Data
- Named Range
- Sheet Grouping
- Sorting/Filtering
- Series Lists
- Basic Chart
Inserting Graphic Objects
- Insert and Modify Graphics
- Illustrate Workflow Using SmartArt
- Layer and Group Graphic Objects