This intermediate Excel course equips students with essential skills in formulas, functions, advanced workbook management, and data analysis, culminating in mastery of PivotTables & PivotCharts, and powerful lookup functions for dynamic decision-making.
$299.00
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 virtually.
Class 1: January 14, 2025
Start time: 01:00 p.m. EDT
End time: 04:00 p.m. EDT
Class 2: January 16, 2025
Start time: 01:00 p.m. EDT
End time: 04:00 p.m. EDT
Venue: Virtual on Zoom
Directions: Training will occur on Zoom. You will be provided with a unique link per registrant. Please plan to login 10 minutes prior to the session start time.
Elevate your Excel skills with this comprehensive intermediate course designed to enhance your confidence in working with spreadsheets. You’ll master essential formulas, functions, and cell references, including relative and absolute references, and improve your navigation skills with quick tips. Dive into Excel essentials like conditional formatting, data validation, and date management while gaining expert tips for printing. Explore advanced workbook management with three-dimensional cell references, named ranges, and range-based functions. Unlock the power of graphing by learning various chart types, formatting, and data manipulation. Master the IF function for dynamic decision-making and explore powerful lookup functions like VLOOKUP and XLOOKUP. Finally, prepare your data with tables and discover the full potential of PivotTables and PivotCharts, including the use of slicers and timelines for interactive data analysis.
Students who have some experience using Excel and are comfortable with the basics of the structure and functionality.
Students will gain intermediate Microsoft Excel skills, including:
Review of Spreadsheets
• Formulas, Functions and Cell References
• Relative and Absolute Cell References
• Viewing the Excel Screen
Understand Excel Essentials
• Freezing Row and Column Headings
• Conditional Formatting
• How Dates Work
• Printing Tips
Work with Workbooks & Ranges
• Managing Sheets
• Three-Dimensional Cell References
• Naming Ranges
• Ranges in Functions
Chart Your Data
• Chart types
• Chart formatting
• Editing a chart
• Changing the source data
Utilize the IF Function
• IF: Letting Excel Make a Decision for You
• Calculating within an IF Function
Lookup Data Dynamically
• VLOOKUP
• XLOOKUP
• Data Validation
Tables: Prep to Pivot
• Intro to Tables
• Sorting & Filtering
Insert PivotTables & PivotCharts
• Into to PivotTables
• Into to PivotCharts
• Slicers
• Timelines
Please visit our Training Page for all Training Events.
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!
