Microsoft Excel Data Analysis with PivotTables and PivotCharts
Advances in technology have made it possible to store ever increasing amounts of data. Therefore, the need to analyze that data and gain actionable insight is also greater than ever before.
You already have experience working with Excel and creating basic PivotTables to summarize data, but Excel is capable of doing much more. Harness the power of advanced PivotTable and PivotCharts features to summarize, organize, and analyze data to gain actionable insights and a competitive advantage.
Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyze your raw data.
- Prepare data for PivotTable reporting and create PivotTables from various data sources
- Analyze Data Using PivotTables
- Work with PivotCharts
To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses:
8:30 am - 12:30 pm
10% discount for University of Arkansas Faculty, Staff and Current Students. To receive the discount, you must register with your uark email address and enter coupon code 'UA10' at checkout. Status will be verified and correct rate will be applied. Additional discounts do not apply.
No refunds of the UA 10% discount, or any other discount, will be granted once registration is complete.
This course is not yet scheduled, but we can notify you when it is.
- Prepare Data
- Create a PivotTable from a Local Data Source
- Create a PivotTable from Multiple Local Data Sources
- Create a PivotTable from an External Data Sources
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart