What will you learn?

We will cover everything you need to know to get up and running.

• Raw data structure
• Table layouts & styles
• Design & formatting options
• Sorting, filtering, & grouping tools
• Calculated fields, items & values
• Pivot Charts, slicers & timelines
• Custom, Interactive dashboards

We will explore and analyze data from a number of real-world case studies.

• San Diego burrito ratings
• Shark attack records from 1900-2016
• Facebook Post data from Spartan Race
• Major League Baseball team statistics
• San Francisco employee salaries
• Daily stock market data
• IMDb movie ratings
• And more…

Whether you are looking for a primer, trying to improve your skills, or trying to step up your game, there is something for you. You have found the right place.

There is a shortage of analytic skills in today’s world. It’s very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very very Those with the ability to transform data into insight are leading the charge. I can help you become a better person. Rock star.

What is included in the course?

• LIFETIME access to all content
• Downloadable project files and resources
• Unique, hands-on demos and case studies
• Course quizzes & homework exercises
• Certificate of Completion
• 100% MONEY-BACK GUARANTEE

Who is this course for?

• Anyone who works with data in Excel on a regular basis
• Excel users who have basic skills but would like to become more proficient in data exploration and analysis
• Students looking for a comprehensive, engaging, and highly interactive approach to training

There is a course onCURRICULUM.

Getting started. StartCourse structure and outline Start with the course resources. Get to know the movie database. Start setting expectations. There is a PivotTable 101. The question is, start why pivot tables? There is a preview of the source data. StartInserting your first table. Start looking at the field list. StartAnalyze & Design Options can be used. Start selecting, clearing, moving and copying. Updating andRefreshingPivots There is a tip about dealing with growing source data. Data can be removed from the cache. StartHow pivot tables actually work. StartQUIZ: PivotTable 101. StartHOMEWORK:PivotTable 101 Formatting and customization of the pivot table. The start number is formatted. Start tip: Formatting empty cells. The StartTable has layout and styles. Startpro has a tip on how to create new tables. It’s time to start customizing labels. The preview added some formats. There is a data bar with invisible text. Start Advanced Formatting. StartQUIZ: How to format a table. Start Homework:PivotTable Formatting Grouping, sorting, and filters. Start Basic Sorting Options. Incorrect alphabetical sorting is a startpro tip. The start label has filters and manual selections. Startpro has a tip about label filters with wild cards. The start value filters were mentioned. The preview tip is to enable multiple filters. The start grouping data. Automatic Date Grouping starts. StartFiltering with Slicers and timelines. The start of the report filter pages. StartQUIZ: Sorting, Filtering, and Grouping. Sort, Filtering, and Grouping are part of Start Homework. The values and fields are calculated. The start sums up values. Avoid the count of trap. The show values are calculated. Values as % of Column/Row StartShow values are % of parent. The start show values are the difference from 4. Startshow values are running total Values as: Rank Start show values as index The startInserting of calculated fields. Calculations in pivots and raw data The first part of calculating using counts. The second part of calculating using counts. StartCalculated items are not recommended. StartSolve has an order and list of Formula Tools. The startQUIZ has calculated values and fields. There are calculated values and fields in Start Homework. Data visualization with pivot charts Start intro to the data. The column chart is StartDEMO. StartDEMO: Pie and Donut Charts. StartDEMO: Clustered bar chart. Stop Charts from Resizing with Cells is a Startpro tip. Change chart types on the fly. StartDEMO: Stacked Area chart. The StartPivotChart has layout and styles. Start moving pivot charts to new sheets. There are slicers and timelines to multiple charts. StartDEMO: Building a Dynamic Dashboard. The startQUIZ is about pivot charts. StartHOMEWORK:PivotCharts. There are case studies. Start setting expectations. StartU.S. Voters StartHOMEWORK: U.S. Voters. San Francisco salaries are 13:06. San Francisco salaries. StartShark Attack Records is a record. Start Home: Shark Attack Records. StartStock Market Data. There is stock market data. Start baseball team statistics Baseball team statistics. StartSan Diego Burrito Ratings The ratings for San Diego Burritos. The start of the weather day. There are daily weather conditions. StartSpartan Race Facebook Posts Spartan Race Facebook Posts. The StartApple App Data is 18 minutes. StartHOMEWORK: Apple App Data. Wine Tasting Scores (17:13) is a preview. Wine Tasting Scores. They are wrapping up. The preview is from Maven Analytics.