Course Length
Full day
Prerequisites
Excel 2013 Introduction or equivalent experience
Course Description
This class is designed for the user interested in going beyond the basics of Excel. Users will learn how to use conditional formatting, create tables, sort, filter, outline, and connect cells, worksheets, and workbooks. Charting and more than twenty practical functions are included.
Topics
- Use highlight cells rules
- Clear rules
- Use top/bottom rules
- Apply data bars, color scales, and icon sets
- Edit a formatting rule
- Create a new formatting rule
- Manage formatting rules
- Create, navigate, select, & move a table
- Change the table style
- Insert and delete rows and columns
- Change table style options
- Display calculations in the total row
- Convert a table back to a range
- Sort rows by one column
- Sort rows by multiple columns
- Sort by cell color, font color, or icon
- Sort using a built-in custom list
- Create and remove a custom list
- Use AutoFilter
- Create a custom AutoFilter
- AutoFilter by color or icon, top or bottom numbers, above or below average numbers, and use advanced filtering
- Create and work with slicers in a table
- Convert text to columns
- Remove duplicate rows
- Manually outline a worksheet
- Collapse and expand an outline
- Ungroup an outline level
- Use Auto Outline & clear an outline
- Create & remove subtotals and a grand total
- Link cells between worksheets
- Link worksheets using formulas & functions
- Link multiple workbooks using a formula
- Link multiple workbooks using a function
- Enter a function using the Insert Function dialog box, Function Library, Formula AutoComplete, AutoSum button, and AutoSum button drop-down list
- Return the current date using TODAY
- Return the current date & time using NOW
- Return any date using DATE
- Return the number of days between two dates using DAYS
- Change the case of text using UPPER, LOWER, and PROPER
- Remove excess spaces using TRIM
- Repeat text using REPT
- Extract substring with LEFT, RIGHT, & MID
- Join text strings using CONCATENATE
- Perform lookups using VLOOKUP & HLOOKUP
- Calculate a payment using PMT
- Return the future value using FV
- Use ROUND, ROUNDUP, and ROUNDDOWN
- Truncate a number using TRUNC
- Sum Cells using SUMIF
- Use IF and the nested IF function
- Test for multiple criteria using AND & OR
- Explore chart types
- Identify and select chart elements
- Create, select, move, resize, and delete an embedded chart
- Change chart type & chart location
- Print an embedded chart on a page by itself
- Resize, move, and delete a chart element
- Use chart buttons
- Add, remove, and change chart elements
- Format chart elements
What Participants Receive
Each participant receives a guide containing step-by-step instructions and practice exercises.
