Microsoft Excel - Pivot Tables and What if Analysis | Nejla Z. | Skillshare

Microsoft Excel - Pivot Tables and What if Analysis

Nejla Z., Manager of Information Technologies

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
6 Lessons (17m)
    • 1. Introduction to pivot tables

    • 2. Pivot - Filters

    • 3. Pivot - slicers

    • 4. Pivot - Charts

    • 5. What if Anlaysis - goal seek 1

    • 6. What if Analysis - goal seek 2

14 students are watching this class

About This Class

Microsoft Excel can be tricky. 
Tons of people can format cells and and apply formulas. 
But few can do it in a way that helps their boss see
what point they’re trying to prove. 
Plenty of people can present data visually. 
But few can present data in an engaging way that increases, 
their chance of securing a sale.

Excel is used to:
- store database records
- conduct planning
- manage budgets
- create charts and graphs 
- analyze business intelligence, sales and marketing data
- keep customer and staff records 

As per the following infographic, 
professions in which Excel power-users can stand out include
marketing analyst (with a starting salary of $50,232), 
business intelligence analyst ($55,386), and management consultant ($70,676).

If your current or future job requires you to compile, analyze, 
and present data, would you feel confident in your ability to do it? 
Simply put, can you maneuver expertly around a spreadsheet?

If you are not you are at the right place! Here in this course you 
will start to make yourself familiar with the spreadsheet, than you will come
at the level where you will start to use it as a real pro! 

If you want to enhance your Excel skills, you’ve got your work cut out for you. 
Don’t be fooled into thinking you can master Excel in one sitting. 
Nor is there one be-all and end-all course that will ensure your success
with every spreadsheet in your future. 
It’s hard work understanding pivot tables, using filters to get just
the right result, tweaking data series, and resizing charts.

If you are ready to become real excel specialist click enroll and enjoy us! 

Good luck! :)