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.
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.
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
This course will help you develop data management, advanced formatting, complex formulas, pivot tables, conditional functions, and chart creation skills, enabling you to enhance efficiency, reporting accuracy, and data analysis capabilities.
QSG offers a variety of business productivity and data analysis training programs, including Microsoft Excel Advanced, Data Visualization, and Statistical Process Control (SPC).
We offer customized Excel training tailored to your organization’s data management and reporting needs. Contact us at info@qualitysupportgroup.com to discuss personalized training solutions.
Yes! Participants will receive a Certificate of Completion, demonstrating their proficiency in intermediate Microsoft Excel techniques.
You can register online by selecting your preferred course dates and completing the enrollment process.
QSG members receive exclusive discounts on training programs.
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.
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.
Thanks for letting us know!
Please fill in the information below so that we can keep you informed.
This website uses cookies that are needed for the site to work properly and to get data on how you interact with it, as well as for marketing purposes. By accepting, you agree to the use of cookies for ads and analytics as described in our Cookie policy.
QSG has secured over $20M in training grants for companies across the USA. We specialize in expert grant writing and comprehensive support, creating tailored training solutions for organizations in states like in Massachusetts, Connecticut, Florida, Ohio, Michigan, and beyond!
If you have any questions, would like more information, or would like to speak with a QSG representative, please contact us at any time!
