From Beginner to Master of Pivot Tables - Best Tool in Excel
What you'll learn
- Extensive productivity skills that and how to solve complex solutions for with Excel
- First Step Towards Microsoft Excel Specialist Certification
- Improve Productivity
- Immediately Apply Skills to your Job
- Create PivotTables
- Format Data into Tables
- Analyze Data in PivotTables
- Filter Data based on desired Information
- Extract Data using Formulas
- Create PivotCharts based on PivotTables
- Reformat PivotCharts
- Rename, Rearrange, Delete Worksheet Tabs
- Insert Columns into a worksheet
- Maintain PivotTables with current data using Refresh
Requirements
- Microsoft Excel
- The want to attain the Microsoft Excel Specialist Certification
- The need to advance career
- The need to increase productivity
Description
Over 1500+ enrolled since January 2016! One of Udemy's fastest growing courses!
In today's job market Excel proficiency is required. The ability to not only fluently use Excel but implement it into the daily routine is increasingly mandatory. A majority of employers requires Excel proficiency but lack any real on-the-job training in this software.
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!
Who this course is for:
- People working towards Microsoft Excel Specialist Certification
- Project Management Professionals (PMP's) Looking to Satisfy PDU Requirements
- Course can be completed by all levels of experience with Excel
- Beginners can follow this course easily
- Intermediate Users can Learn Advanced Techniques such as Dashboards
- Anyone who wants to make themselves more valuable in the workplace
- Anyone who wants to advance their professional careers
Instructor
- 4.5 Instructor Rating
- 105 Reviews
- 1,548 Students
- 1 Course
I am an Excel Whiz Certified By Microsoft! I have spent the past 15 years working professionally as a consultant specializing in the Microsoft Suite and business process implementation.
I began college in Texas where I played Division III baseball. I developed a passion for business and knew consulting and training were a passion.
A year after finishing my undergraduate studies in Arizona, I landed a career in business consulting. I had the incredible opportunity to work with some of the world's largest companies including Suncor a Major Oil Refinery and SalutarisMD startup medical device firm. The past several years I have worked in the Finance sector but have found a real niche in the use and implementation of Excel as well as all things business.
I have also earned my Masters of Business Administration Degree (MBA) and use that knowledge to help people like you get to where they want to be professionally. I specialize in small business growth, employee training, and technology implementation.
I look forward to sharing my knowledge of technology, and my passion for business management, growth, and marketing with you.