Instructor
Jenny Douras
Category
MS Excel
Date
June 25, 2026
Time
8:00 am - 12:00 pm Mountain Time | Thursday | 4 Hours
Review
Excel Advanced Training 4 Hours
This Advanced Excel class is designed for everyday users of Excel, who want to take their skills to the next level. Advanced Excel training covers more intricate formulas, creating validations, writing macros, embedding other documents, and protecting your data in Excel. The class includes useful functions for various business applications, as well as how to combine these with other functions. Our instructors will be on hand to answer any questions you have and lead you to a thorough understanding of Excel at an advanced level.
Why You Should Attend?
In the Advanced Excel class students will come from this class feeling confident using many of the advanced features within Microsoft Excel, including nested IF statements, VLookups, HLookups, macros, and validations.The primary focus of the Advanced Excel training course is on formulas, specifically functions, and how to nest them with other functions for more advanced automation.
Tools for making your spreadsheets easier for others to use and view are also included.
These include validations, custom views, protecting worksheets, and embedding other documents or spreadsheets within your workbook.
Advanced Formulas:
Viewing available Excel functions
Basic text functions
Basic “IF” conditional formulas
Nesting “IF” statements
Concatenate and “IF” statements with concatenate
ISBLANK Function
COUNTBLANK Function
Arrays
Using name ranges in formulas
Look Ups and Other Functions
Lookups and Lookup functions
HLookup
VLookup
Calculating days of the week
Calculating number of weekdays from a date
Calculating months between 2 dates
SUMIF Function
Data Views, Layouts, and Rules
Transposing Data
Validations for length and drop-down lists
Custom Views
Introduction to Macros
Developer Tools
Saving Macros
Absolute vs Relative Macros
Recording Macros
Creating Macro buttons
Additional Tools in Advanced Excel
Embedding and linking
Editing and embedded object
Editing a linked object
Linking as an icon
Protecting worksheets
Locking cells
Protecting a workbook
Jenny Douras
Speaker
Jenny Douras is President and founder of AdvantEdge Training & Consulting and is a national speaker conducting workshops across the country. She has over 25 years of experience in management, employee development, operations, knowledge management, technology, organizational development, and instructional design and training. She has written over 40 courses on Microsoft Office and Professional Development topics, that have been sold around the world.
Write a Review
Customer Reviews
No reviews yet. Be the first to review!
Pricing Details
Membership Details
Become a member of our platform and you'll get a discounted ticket. All pricing has a membership rate attached to it. Check the prices.
Membership Plan