Power Excel for Analysts and Managers

Level:	Intermediate / Advanced
Duration & Schedule:	Expected to spend 20 hours for course recordings + 20 hours for practice/self-learning Typically completed in 3-5 weeks. You get online access for 12 weeks.
Delivery Methods:	Instant On-Demand

Course Fees: $97 USD

PayPal account not required. More Info.

Course Info

Register for a Free Trial

What to expect from the Course?

http://www.vimeo.com/10837729

Click here for a direct link to the video

The video calls this course 'Excel School'. The 12 week program as mentioned in the video is now available entirely on-demand and can be completed in 3-5 weeks.

What will you Learn?

Who should Attend?

Data / Business Analysts
Project / Product Managers
Anyone who uses Excel a lot
PRE-REQUISITES: This is not a course for beginners. You should kn ow to use create Excel formulas and simple charts.

Most careers require proficiency in a spreadhseet software like Excel. Specifically, an analyst or a manager is required to have a good understanding of data and the ability to work with it. Learning the core concepts in Excel can help capture, analyze, visualize and gather trends. This on-demand course explains the core excel concepts using informative videos and animations on how to mine large volumes of data and the right way to visualize it so you can derive useful information. The course is designed to help you learn Excel in a useful and fun way! This course is useful for:

Training Methodology

Login to On-Demand Recordings will be provided. No need to call-in at a specified time.
You can review the recordings as many times as you want for 6 months.
Instructor support will be provided on the course website in forum format.

Key Benefits

Course developed and instructed by Purna Duggirala MBA, MS Excel MVP, author of chandoo.org, a popular resource for Excel tips and resources. Purna has over 6 years of Excel experience and is well respected for his Excel expertise.
Convenience of taking the program using Video Recordings at your own time. You get access to video recordings and materials for 12 weeks.
The video recordings and all supporting materials are downloadable, so you can keep the reference materials for yourself forever!
Instructor-led training: post your questions in the forums
Online Course Website: Course materials, Reference materials, Articles, Assignments

View Course Overview

Course Content

Course Outline

Formulas

1. References, Using $

2. COUNTIF

3. SUMIF

4. IF, Nested IF, CHOOSE

5. VLOOKUP, Adv. VLOOKUP

6. MATCH

7. INDEX

8. OFFSET

9. SUMPRODUCT

10. ROWS, COLUMNS

11. SUMIFS, COUNTIFS

12. IFERROR, ISERROR

13. SMALL, LARGE

14. Formula Debugging

Formatting

1. Paste Special

2. Format Painter

3. Custom Cell Formats

4. Date / Time Formatting

5. Table Formats

6. Formatting Best Practices

7. Freezing Rows, Splits

Conditional Formatting

1. Intro to CF

2. Formulas in CF

3. Using Traffic Lights, Icons

4. Adv. CF thru Examples

5. Removing CFs, Cleaning

Data Visualization – Charting

1. Choosing correct chart

2. Various charts in Excel

3. Chart formatting Options

4. Chart templates

5. Best practices

6. Combo charts

7. Dynamic charts

Tables

1. Excel 2007 Tables –Intro

2. Benefits of using tables

3. Table formatting

4. Table formulas

5. Table –named ranges

Pivot Tables

1. What is a Pivot and why use one?

2. Creating Pivots

3. Summarizing data

4. Calculated Fields, Calculated Items

5. Grouping Data

6. Pivot Table Tips

7. Pivot Charts – Intro

Data Filters

1. Data Filters

2. Sorting

3. Data Validation

4. Error Messages, Invalid Data

5. Advanced Filters

6. Filters in Tables, Pivots

Importing Data

1. Text to Columns

2. Importing CSV Files

3. Importing Text Files

4. Importing Web Data

5. Importing MS Access Data

Advanced Formulas

1. Named Ranges, What are they and why use them?

2. Dynamic Ranges using OFFSET

3. Formula Audit

4. 3D References

5. Array Formulas –Intro

6. Circular References –Intro

7. Calculation Modes and uses

8. Formula Errors and What to do?

Form Controls, Macros

1. Developer Toolbar / Ribbon

2. What are Form Controls

3. Using Scroll-bar Control

4. Using Checkboxes

5. What is a Macro?

6. Using Macro Recorder

7. Getting used to Visual Basic Editor

8. Introduction to Macros

9. Where to find help?

Shortcuts & Productivity

1. 20 Most useful Excel Shortcuts

2. Understanding Ribbon

3. Customizing Quick Access Toolbar

4. Setting Defaults

5. Using Templates

6. Where to find help & best practices

FAQs

General FAQs

On the free course

What are the pre-requisites of this course?

This course is not a beginners' level course. You must have some background in Excel and know how to operate basic formulas (like SUM, AVERAGE, IF, etc.) how copy-pasting of Excel formulas works, how to create basic bar charts and pie charts.

Who is this course aimed at?

Most careers require proficiency in a spreahsheet software like Excel. Specifically, an analyst or a manager is required to have a good understanding of data and the ability to work with it. Learning the core concepts in Excel can help capture, analyze, visualize and gather trends.

This on-demand course explains the core excel concepts using informative videos and animations on how to mine large volumes of data and the right way to visualize it so you can derive useful information. The course is designed to help you learn Excel in a useful and fun way!

Data / Business Analysts
Project / Product Managers
Anyone who uses Excel a lot
PRE-REQUISITES: This is not a course for beginners. You should kn ow to use create Excel formulas and simple charts.

On the free trial

Is a credit card or any payment commitment required to register for the trial class?

No. There is no commitment required to participate in the trial class.

How do I take the trial class?

You must register to attend the trial class. You may attend the trial class by participating in the Recorded On-Demand at your own convenience. Pick any date to get instant access to the trial class

What is covered in the trial class

The trial class covers Excel conditional formatting

On-Demand Recorded FAQs

How long are the recordings available?

Recordings are available for 30 days.

Does the on-demand training come with assignments and online tests?

Yes, the On-Demand course website has the same assignments and tests which are administered to live participants to help you apply what you learn from the course.

How is the On-Demand course supported?

The On-Demand course comes with instructor support. You can email the trainer using the course website for technical questions. You can also set up a time to speak to the trainer as needed.

How is the On-Demand course supported?

The On-Demand course comes with instructor support. You can email the trainer using the course website for technical questions. You can also set up a time to speak to the trainer as needed.

Payment FAQs

I have a payment question.

Click here for payment questions.

Testimonials

Helen

I just wanted to give you some feedback on our lessons so far. While I wouldn’t consider Excel school to be a beginner’s 101 course, I wish I had found something with this level of instruction years ago. I’m having a blast looking at things that I thought I understood well. You have given some new insight into several things that I’ve been able to apply to some workbooks at my job. Just with one powerful little formula tweaks I figured you saved me and a colleague 475 minutes per month on a monthly report that we have to prepare. Over a years time that equates to over $3500. That’s only one instance. This is the best instruction that I’ve ever come across. You make Excel fun! THANK YOU! Thank you for being so generous with all of the great information that you share. You truly are awesome!

Mehdi

I am a member of your Excel School and continuously watching your postings. I just want to thank you personally for providing me such a good excel tutorials.

Georgine

I really am learning a lot…I am stubborn and will keep trying till I get the ideas. And you have so many wonderful tricks I never knew about. I got started with you in charting and I have learned so much and done some nifty charts. I am looking forward to learning a lot more from you in the future. I am amazed how much you know and how well you are able to explain things. I thought I was pretty proficient in formatting till I watched week 2 and I have discovered that there is much more I do not know than I do. Can’t wait for the rest of the classes.

Rob

I just wanted to tell you that so far in the Excel School, I am blown away with the quality and amount of information I’m getting out of the course. I have always been the excel expert where ever I work, and it’s inspiring to see what you’ve been able to do with it. I didn’t realize there was so much more to learn.

Steve M (link to blog post)

Been taking an online class in Excel. About 6 weeks into it and wow, I have learned a lot. And I am the best Excel user in my department at work. Class is hosted by Chandoo and he is good, really good. Runs a great blog called Pointy Haired Dilbert. A lot of value in this thing: class was approximately $100 for 15 weeks of awesome-ness. … I am loving it. … The surprising thing I have learned is how to better present information for others. I have always taken pride in making good spreadsheets instinctively, but this has made me much better.

Ask Us