This Event has Passed
Thursday, June 14, 2018
3:00 PM - 4:30 PM
3:00 PM - 4:30 PM See all dates and Times
https://goo.gl/T9QjTC
OVERVIEW Pivot Tables are one of the most powerful tools in Excel’s data analysis and Business Intelligence (BI) armory. Mike discusses how to quickly and easily build the reports, dashboards and charts that help you to summarize, analyze, interpret and understand your data.
The webinar provides a clear and deep understanding about:
• Creating a simple Pivot Table with 6 clicks
• Using Filters and Slicers to limit what is shown in a Pivot Table report
• Best practices for updating a Pivot Table when the source data changes
LEARNING OBJECTIVES
Use Pivot Tables to turn raw data into meaningful and insightful reports
Structure your raw data in the right way
Design and format your Pivot Table reports so that they are easy to read and understand
Summarise your data in different ways including totals, counts and percentages
Use Pivot Tables to create monthly summary reports
Convert a Pivot Table into a visualisation
WHO WILL BENEFIT
You should attend this training if you need to use Excel to quickly build reports and summaries or if you simply want to learn how to create Pivot Tables to improve your knowledge of Excel.
You don't have to be proficient in the use of Excel to attend. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you’ll be able to follow along.
Although the training will be delivered using Excel 2016 for Windows, most of the functionality demonstrated is available in earlier versions of Excel (2007, 2010, 2013)
SPEAKER
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac.
For more detail please click on this below link:
https://goo.gl/xZPVoK
Email: [email protected]
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882
The webinar provides a clear and deep understanding about:
• Creating a simple Pivot Table with 6 clicks
• Using Filters and Slicers to limit what is shown in a Pivot Table report
• Best practices for updating a Pivot Table when the source data changes
LEARNING OBJECTIVES
Use Pivot Tables to turn raw data into meaningful and insightful reports
Structure your raw data in the right way
Design and format your Pivot Table reports so that they are easy to read and understand
Summarise your data in different ways including totals, counts and percentages
Use Pivot Tables to create monthly summary reports
Convert a Pivot Table into a visualisation
WHO WILL BENEFIT
You should attend this training if you need to use Excel to quickly build reports and summaries or if you simply want to learn how to create Pivot Tables to improve your knowledge of Excel.
You don't have to be proficient in the use of Excel to attend. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you’ll be able to follow along.
Although the training will be delivered using Excel 2016 for Windows, most of the functionality demonstrated is available in earlier versions of Excel (2007, 2010, 2013)
SPEAKER
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac.
For more detail please click on this below link:
https://goo.gl/xZPVoK
Email: [email protected]
Toll Free: +1-888-300-8494
Tel: +1-720-996-1616
Fax: +1-888-909-1882
