Introduction to Analyzing Data with Excel PivotTables

Learn to analyze and summarize data in seconds using Excel's most powerful data feature - PivotTables and Pivot Charts!

Created by: Ian Littlejohn
Microsoft Power BI and Business Intelligence Specialist

What Will I Learn?

• Learn to use the most POWERFUL tool in Microsoft Excel to easily summarize and create reports from your data
• Enjoy CLEAR, CONCISE and LOGICAL step by step instructions from a best selling Excel and Power BI Udemy Instructor
• In SECONDS create aggregated and summarized tables of data from VAST quantities of spreadsheet data
• LIFETIME access to course materials and practice activities with a 100% MONEY-BACK guarantee
• At the click of a mouse, create percentages, running totals, difference from and ranking calculations with no formulas!
• Learn to use filters and slicers to display INTERACTIVE views of data with no complex coding or VBA
• Get COMPREHENSIVE understanding of trends within data with a few clicks of the mouse
• Learn to ANALYZE Human Resource data using grouping and frequency analysis

Requirements

• Excel 2016 or above
• You should be able to work with data in Excel and do basic reporting

Target audience

• Excel users who want to learn how to create professional reports
• Excel users who want to summarize and aggregate data
• Excel users who want to learn new methods and techniques to analyze data