Improve Your Productivity: Master Excel Pivot Tables

MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 2.5 Hours | Lec: 45 | 1.21 GB

Genre: eLearning | Language: English

Become a Microsoft Excel Certified Specialist! The perfect first step towards a Professional Microsoft Certification!

Pro tip: Want to improve your Resume? Become a Microsoft Certified Excel Specialist! This course is the first step towards becoming certified! It will prepare you in a core aspect of the certification and set you on the path towards one of the most valuable Professional Certifications you can earn!

Excel 2010 Certification Exam Offered via Microsoft Learning Exam #77-882

See Promo Video for Link!

There are numerous ways to learn, yet many lack the real world application you desire. You need to be able to take data sets your job uses and turn them into user-friendly, easy-to-analyze reports that your boss and even his bosses can read to use to make real-time decisions. Today's industries are more data driven than ever; will you be the one to shine?

This is comprehensive PivotTable course will provide you with a step-by-step guide into developing and using PivotTables. It is designed in a way that even the most basic beginner to an experienced user can follow along and take away valuable knowledge and skills you can immediately apply to your job. These are Excel's most important tools. Quite literally, all analysis stems from PivotTables. In short, they are a summarizing tool to the basic user. But developed by an ace, they can literally shape the decisions a company makes!

By the end of this course you will be able to not only be well versed in Excel PivotTables, but empowered with the skills to develop and implement powerful, real-time reports your bosses, even executives would be impressed with!

This course covers:

Formatting data as a table

Optimizing your Workbook

Using logic functions to extract information

Applying filters and sorts

Creating multiple PivotTables

Applying PivotTable Styles

Drilling down details

Presenting sales data

Using Advanced Formulas

GetPivotData

IfError

Left & Right

Manipulating and configuring data for real-time decision making

Refreshing you PivotTables

Fixing Common Errors

Creating PivotCharts

Advanced PivotChart Formatting

Building & Using PivotChart Dashboards

Mastering PivotTables is a massive leap forward to mastering Excel, this is the solution!