Event Details
6 hours
Combination lecture and classroom exercises. Each student must bring their own laptop with Excel pre-loaded.
This course is designed for those who would like to get the most out of Excel and are experienced with formulas and functions.
Contact us to get notifications about future courses or to schedule a private workshop.
6 hours
Combination lecture and classroom exercises. Each student must bring their own laptop with Excel pre-loaded.
Microsoft Excel Advanced training is a powerful tool you can use to create and format spreadsheets and analyze and share information to make more informed decisions. This class is designed for students that want to use the full power of Excel with functions, VLookups, PivotTables and Macros.
Students who would like to get the most out of Excel and are experienced with formulas and functions.
Students will gain advanced Microsoft Excel skills, including:
Working with Advanced Functions
Working with Functions
Using the IF Function
Nesting Functions
Using Multiple Conditions with the IF Function
Using Table Lookup Functions (H & VLookup)
Using Text Functions
Analyzing Data
Using Automatic Outlining
Consolidating Information by Position or Category
Inserting Subtotals
Creating an Advanced Filter
Using Database Functions
Working with Data
Importing Data from a Text File
Exporting Data
Converting Text to Columns
Using Flash Fill
Connecting to Data in an Access Database
Creating a Web Query
Importing Web Data using a Saved Query
Working with Hypertext Links
Creating and Working with PivotTables
Working with Recommended PivotTables
Creating a PivotTable using Worksheet Data
Laying out a PivotTable on a Worksheet
Modifying PivotTable Fields
Using a Report Filter
Refreshing & Formatting a PivotTable
Enhancing PivotTables
Working with Summary Functions
Sorting Items in a PivotTable
Creating a Slicer
Grouping Data
Using a Timeline
Applying Label and Value Filters
Creating a Calculated Field
Creating a Calculated Item
Creating Charts from PivotTables
Working with Macros
Recording a Macro
Saving a Macro-Enabled Workbook
Executing a Macro
Creating a Macro Button
Working with Macro Buttons
Working with Data Analysis Tools
Creating Scenarios
Working with Scenarios
Using Goal Seek
Using One-Input Data Tables
Using Two-Input Data Tables
Understanding Solver
Defining a Problem
Solving a Problem
Generating a Report of Results
Good afternoon Jim,
I participated in the Leadership Training program that you facilitated at Zoll. Today was actually my last class. First, I would like to thank you. It was a pleasure to participate in your training session. I truly enjoyed the experience. I knew a lot of the information that we reviewed in the program and exhibit many of the leadership qualities on a regular basis, but I also gained a lot of knowledge and useful information that I have been able to apply to my professional and personal life. I believe you did an amazing job! You’re very insightful, knowledgeable and a great communicator. I also enjoyed and appreciated you sharing some of your personal experiences with the group. I love your perspective on life and appreciate your contribution to making this world a better place. As a NY Giants fan, I would have preferred less NE Patriot references lol. Jokes aside, you have made a huge impact on me, my coworkers and Zoll as an organization. I wish you continued success. Have a great day!
Your presentation was excellent. Thank you. The students were diverse in many ways but your presentation of the material was clear and engaging for everyone. Great examples and explanations as well.
Good Morning Jack,
Thank you so much for sending over the presentations and providing your analysis of the training. Based on the positive feedback I received from participants, the training went very well and the employees seemed to be much more engaged in this training class. You did a great job on developing and delivering the content in a way that was tailored to the skill level of Antaya’s workforce. Also, the interactive group exercises were very effective and a great way to incorporate blended learning into the sessions.
We appreciate the time you took to understand our training needs and providing us with excellent customer service. We look forward to working with you and the Quality Support Group in the future.
Google Privacy and Terms of Service apply
Thanks for letting us know!
Please fill in the information below so that we can keep you informed.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, please see here: Cookie Policy
Explore our revamped website and experience a more user-friendly interface designed to serve you better!
If you have any questions, would like more information, or would like to speak with a QSG representative, please contact us at any time!
