Pivot Tables and their charts are the quintessential tool used for summarising data in Excel. This 2-hour course will introduce you to how a Pivot Table is setup, what goes where and best practices for keeping your reports simple yet effective. You'll also be able to illustrate your Pivot Table data using Pivot Charts for a more effective report. This introduction to pivot tables and charts is suitable for intermediate level Excel users who need a thorough grounding in creating their own Pivot Tables and Charts to summarise large quantities of data.
TRAINING AT YOUR SITE
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
Guaranteed to RunWhen you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.
Partial Day EventLearning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.
Course attendance is live, online from internet enabled locactions. You will be sent a system validation check prior to your training.
Yes! This course is available live online on our public schedule and as Private Team Training.
The Analysing Data with Excel (20779) course is a 3-day official Microsoft course that goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI.