Choose your timezone
Register Below or Call (888) 804-1132
and Talk to a Training Specialist Today
$50 off each course when you book more than one course or more than one person per course. Discount will be applied at checkout.
Class sizes are kept small for a better learning experience. Limited to 15 people per class.
Have more than 6 people for a course? Call us at (888) 804-1132 and ask about our group rates.Want to run this as a private class for your team? Enquire about running this event as a private class
Description
This course builds on the concepts and skills of our Level 1 and Level 2 courses to provide advanced tools for solving real-world problems in Microsoft Excel: lookup and decision-making functions, auditing and error-handling, array functions, date and text functions, importing and exporting, and macros.
Advanced Functions
- Creating and Using Named Ranges
- Creating Named Constants
- Linking Data Between Worksheets
- Creating and Using Functions
Logical and Reference Functions
- Using Nested Functions
- IF, AND, OR Functions
- SUMIF, COUNTIF
- VLOOKUP, HLOOKUP, and XLOOKUP
- MATCH and INDEX
Date, Time and Text Functions
- TODAY, NOW, DATE
- Using Dates in Calculations
- CONCAT, TRIM, TEXTJOIN, LEFT, RIGHT, MID,
- UPPER, LOWER, PROPER
Advanced Formatting
- Using Styles, Themes, and Effects
- Working with Styles
- Applying a Style
- Modifying Existing Styles
- Using Format Painter
- Creating Custom Number Formats
- Applying an AutoFormat (Table Format)
External Data and Protecting Data
- Importing and Exporting Files
- Protecting Data
- Using Worksheet Protection
- Password Protecting a Workbook
Automate Tasks with Macros
- Recording and Running Macros
- Introduction to Editing Macros
Prerequisites
The course assumes you know how to use a computer, that you're familiar with Microsoft Windows, and that you've taken the Level 1 and Level 2 courses or have equivalent introductory experience with Excel. The exercises are more detailed and complex than those in the previous levels.
Who should attend?
Those who want to use Excel to perform real-world tasks such as getting information from large amounts of data from sources inside and outside of Excel, creating output that varies according to conditions, manipulating dates and text, and automating repetitive tasks.
