What is this course?
These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create charts, make them interactive, summarize data intelligently, present output in an intuitive dashboard or slice & dice data using Pivot tables & Power Pivot. Having these vital skills can make you invaluable to your organization & expose you to new opportunities. Not to mention the amount of time, money & effort you can save by efficiently using Excel.
That is why we have created 3 powerful courses – Excel School, Power Pivot & Advanced Power Pivot classes. Think of these as steps in a ladder.
Excel School program teaches you how to analyze data, create pivot tables, make charts, design interactive dashboards using Excel.
Power Pivot class shows you how to use Power Pivot (an Excel add-in) to connect to your enterprise databases, analyze data, create advanced reports & prepare dashboards right from familiar interface of Excel.
Advanced Power Pivot class takes you in to the depths of data analysis thru measures & brilliant techniques so that you can dig insights out of mountains of raw data.
– Greg
All these courses are ideal for data analysts, reporting & MIS professionals, business analysts, managers & dashboard makers.
That said, Excel School is suitable for you if you are a beginner or intermediate level user of Excel.
On other hand, Power Pivot courses are for you if you are an advanced user of Excel & looking for ways to enhance your skills in data analysis, pivoting & reporting areas.
To Enjoy Excel School: You can be a beginner or intermediate level user with Excel 2007 or above.
To enjoy Power Pivot course: You should be familiar with Excel & Pivot Tables and running at least Excel 2010. You must have Power Pivot installed on your computer.
Topics of this course
- Introduction to Excel
- Basic Excel formulas
- Advanced Formulas
- Awesome Formatting Tips
- Conditional Formatting
- Excel Tables
- Pivot Tables
- Charting Basics
- Advanced Charting
- Interactive Charts
- Data Validation & Sorting
- Introduction to Macros & VBA
- Dashboard Design
- Dashboard Tutorials – 8
- Guest Lessons & Bonus Content
Click here to see detailed lesson plan
- Introduction to Excel 2010 & 2013
- Installation & Set up of Power Pivot
- Power Pivot features
- Power Pivot Case Study
- Using Tables & Structured References
- Using Pivot Tables & Slicers
- SQL Basics
- Power Pivot formulas & DAX
- Complex DAX examples
- Working with time-intelligence
- Disconnected tables & slicers
- Simple Power Pivot Dashboards
- Form controls & interactivity
- Charting & Dashboard Theory
- Complex Power Pivot Dashboard
- Advanced Concepts & Guest Lectures
Click here to see detailed lesson plan
- Introduction to Advanced Power Pivot
- Working with Multiple Tables
- Cube Formulas
- Disconnected Slicer Techniques
- Standard Time Intelligence
- Custom Calendars
- Advanced Power Pivot Techniques – Part 1
- Advanced Power Pivot Techniques – Part 2
- Power Pivot Performance Optimization
- Macros for automating Power Pivot work
- Bonus Concepts & Guest Lectures
Click here to see detailed lesson plan
Apart from all these lessons, you will also get below mentioned special bonuses
For Power Pivot Courses:
- Rob Collie’s DAX formulas for Power Pivot e-book
- Top 10 DAX formulas – Cheat sheet
- Guest lessons by Bill Jelen (Mr. Excel), Ken Puls, Miguel Escobar, Zack Baresse.
For Excel School Course:
- Excel Fromula Cheat sheet
- Important Keyboard shortcuts – Poster
- Designing good charts – eBook
- Master Excel Ribbon – eBook
- Guest lesson by Debra Dalgleish on “Pivot table tricks”
- Guest lesson by Mike Alexander on “Connecting Excel to Access”
- Guest lesson by Robert on “Excel Dashboards & Maps”
- Introduction to Power Pivot [30 mins]
- Power Pivot Real-life Example – Distinct count [17 mins]
You get 3 kinds of benefits from this course.
1. Course Videos
In Excel School:
- 12 modules on Excel & advanced Excel
- 4 modules on Excel dashboards
- 3 Guest modules by Robert Mundigl, Debra Dalgliesh & Mike Alexander
In Power Pivot course:
- 10 Modules on Power Pivot
- 6 Bonus modules on Excel, dashboards & SQL
- Guest module by Rob Collie
- Guest module by Ken Puls
In Advanced Power Pivot course:
- 9 Modules on Advanced Power Pivot taught by Rob Collie
- Bonus modules on Power BI features
- Guest modules by Bill Jelen (Mr. Excel), Zack Baresse & Miguel Escobar
2. Downloads
With any course, you get:
- Excel Workbooks & material
- HD Quality videos for download
Apart from this, in Excel School:
- Excel formula cheat sheet
- Frequent Keyboard shortcuts poster
- Chart Design e-book
And in Power Pivot course:
- Rob Collie’s DAX formulas for Power Pivot eBook
- Top 10 Power Pivot Formulas – Cheat Sheet
In Advanced Power Pivot course:
- Rob Collie’s DAX formulas for Power Pivot eBook
- Top 10 Power Pivot Formulas – Cheat Sheet
- DAX Patterns for Power Pivot – eBook
3. Online Classroom
Once you join this course, you will be able to access our online classroom with below benefits:
- 12 months access
- View lessons 24×7
- Discuss with classmates
- Ask questions & doubts
- Home work problems
- Course completion certificate
- 30 day money-back guarantee
|
Excel School
What you get?
All for just $247 |
Power Pivot
What you get?
All for just $247 |
Adv. Power Pivot
What you get?
All for just $247 |
Any 2 Courses
What you get?
All for just $447 |
All 3 Courses
What you get?
All for just $647 |
– John Geiger
Q. Can I upgrade to include Power Pivot or Excel School after joining?
Yes, you can upgrade by paying $217 to include either Power Pivot or Excel School course after joining. You will find details about this in the classroom area.
Q. Which version of Excel do I need?
For Excel School course: You need Excel 2007 or above (for Mac users, Excel 2011)
For Power Pivot course: You need Excel 2010 or Excel 2013 Professional Plus or Office 365 with Power Pivot add-in enabled.
Q. Do you have discounts for team enrollments?
Oh yes, we have. Visit team discounts page to know more & enroll with discounted prices.
2. The topics covered are exhaustive
3. Practical examples are taken from various industry
4. There is index on the start of every chapter for the topics covered
5. I received revert for few of my queries and that helped me in my job
6. The download of chapter can be a ready reference for life long
7. The reference website give for more exploration helped to get detail knowledge on topic
-Shrikant K
If you have any problem during signup process or still have some un-answered questions, write to me at chandoo.d@gmail.com or call me at +1 216 527 8597 or +91 994 888 9566. I will be very glad to answer your questions.
I hope to see you in Power Pivot & Excel School.