Event Details
6 hours
Combination lecture and classroom exercises.
Available at QSG’s training facilities, on-site at your organization, and virtually.
This course is designed for those who would like to get the most out of Excel and are experienced with formulas and functions.
Not Yet a Member? Request Membership Now
Please contact us if you are interested in private training for this workshop.
6 hours
Combination lecture and classroom exercises.
Available at QSG’s training facilities, on-site at your organization, and virtually.
Boost your Microsoft Excel knowledge base with this advanced course, covering key functions like IF, lookup, text, and date functions, along with dynamic arrays. Learn to analyze data using tables, PivotTables, and data analysis tools such as Goal Seek and Solver. Gain expertise in importing/exporting data, working with macros, advanced charting and automating tasks. Perfect for professionals looking to streamline workflows and improve data management and analysis skills. This is a hands-on session includes practice exercises to follow along with the instructor.
Professionals looking to streamline workflows and improve data management and analysis skills.
Students will gain Advanced Microsoft Excel skills, including:
Working with Advanced Functions
• Functions Overview
• Using the IF Function
• Nesting Functions
• Lookup Functions
• Text Functions
• Date Functions
• Dynamic Arrays
• Running Totals
Working with Data
• Importing Data and Exporting Data
• Converting Text to Columns
• Using Flash Fill
• Connecting to External Source Data
• Working with Hypertext Links
Analyzing Data
• Review Tables – Sorting & Filtering
• Using Automatic Outlining
• Inserting Subtotals
• Creating an Advanced Filter
• Using Database Functions
Working with Complex Charts
• Add a Trendline
• Create a Combo Chart
• Add a Secondary Axis
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 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
• Using Goal Seek
• Using Two-Input Data Tables
• Creating & Working with Scenarios
• 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!
