One-Day Advanced Training for Microsoft Excel
As an Excel user, you know that the software has nearly unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This LIVE, virtual workshop will teach you the most advanced features and functions Excel offers — taking your level of proficiency from mid-level to advanced. After a few hours of training, you’ll be amazed at how this powerful program can work for you.
This intensive training puts you in command of Excel’s most advanced features and functions. We strongly recommend that you be an experienced or mid-level Excel user in order to get the most out of this incredible training.
For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.
Course Preview
Course Outcomes
- Utilize advanced Excel features to optimize data management and reporting
- Create, configure and customize tables to effectively organize and present data
- Summarize and analyze large datasets using PivotTables for insightful reporting
- Develop and implement robust formulas with both absolute and relative cell references
- Apply common functions to streamline and simplify complex calculations
4.6out of 5
5,000
people have taken this course
99%
found this course to be helpful in their workplace
Course Agenda
Event Dates & Locations
| Date | Time | Price | Action | ||
|---|---|---|---|---|---|
Live Virtual Workshop
Save when you enroll multiple attendees!
Just $189 per person when you enroll 4+ learners
Included in
SkillPath Unlimited+Live
$ per year
- Access this course and 6000+ other live virtual workshop sessions(includes live virtual events priced $399 or less)
- 500+ webinars broadcast daily
- 2,000+ on-demand resources
- And so much more!
More Courses in
FAQs
Related Courses
 | skillpath.com/XAEXL |
One-Day Advanced Training for Microsoft Excel
As an Excel user, you know that the software has nearly unlimited capabilities for making your job easier and less stressful. But learning the countless features available to you can be a daunting task. This LIVE, virtual workshop will teach you the most advanced features and functions Excel offers — taking your level of proficiency from mid-level to advanced. After a few hours of training, you’ll be amazed at how this powerful program can work for you.
This intensive training puts you in command of Excel’s most advanced features and functions. We strongly recommend that you be an experienced or mid-level Excel user in order to get the most out of this incredible training.
For an optimal experience with this course, we recommend Excel 2016 and later. Windows platform preferred.
Session 1: Excel Tables and PivotTable Reports
- Determine the best way to organize your data
- Recognize the difference between reports, crosstabs and tables
- How to build a table – complete with shortcuts
- Work more effectively with tables using Table Tools
- How to create a PivotTable
- Create a relationship between two tables
- Understand the PivotTable Tools Analyze and Design tabs
- Practice converting a table to a PivotTable report
Session 2: Absolute vs. Relative Cell References and Formatting
- Write formulas with relative and absolute cell references
- Build formulas with cell references, rather than fixed values
- Audit workbooks with formulas to troubleshoot errors
- Use a table to simplify the need to use absolute and relative cell references
- Practice your understanding of relative and absolute references
Session 3: VLOOKUP and Other Common Functions
- Understand the most common text functions like UPPER, PROPER, MID and CONCAT
- Discover how to use IF functions to make logical comparisons
- Understand the purpose – and drawbacks – of VLOOKUP
- Efficiently use VLOOKUP, INDEX and MATCH
- How to use logical formulas (TRUE/FALSE)
- Practice building formulas with functions
You’ll also receive the Microsoft Excel for Office 365 Tool Kit, a robust reference guide containing helpful shortcuts and a glossary of Excel terms.