2019 Complete Excel Course Pivot Tables, Charts & Dashboards | Chris Benjamin | Skillshare

2019 Complete Excel Course Pivot Tables, Charts & Dashboards

Chris Benjamin, Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Lessons (1h 23m)
    • 1. Course and Instructor Introduction

    • 2. Excel Basics

    • 3. Introduction To The Data Set

    • 4. Basic First Pivot Table

    • 5. Formatting Sorting and Fixing Data

    • 6. Value Field Settings

    • 7. Pie Chart Graph of Commissions

    • 8. Buyer Type Avg List Price

    • 9. Offer Status Type Pivot

    • 10. Dashboard Creation

    • 11. Dashboard Slicer

    • 12. Course Conclusion

22 students are watching this class

About This Class

Are You A Beginner to Intermediate Excel User?

Have You Heard Of Pivot Tables But Never Fully Understood How To Create Them?

Are You Not Even Sure What You Can Do With A Pivot Table?

Do You Want To Create Sleek Dashboards Using Big Data Sets Condensed Into Useful Reports?

If You Answered "Yes" To Any Of The Above, Look No Further.  This Is The Course For You!

*** Updated June 2019 with new content! ***

Enroll today and join the 100,000+ successful students I have taught as a Top Rated instructor!

Three reasons to TAKE THIS COURSE right now:

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads

  2. You can ask me questions and see me respond to every single one of them thoroughly! 

  3. You will are being taught by a professional with a proven track record of success!

  4. Bonus reason: Udemy has a 30 day 100% money back guarantee if for some reason you don't enjoy the course!

Recent Review:

Matthew F. says: "Terrific course, pivot tables always seemed so confusing to me.  After this course I realized it's really not that hard at all to put one together.  So powerful, such a useful tool.  Creating charts and dashboards was pure bonus material for me.  Really recommend the course, Chris made learning fun and easy."

Why You Should Take This Course With Me:

Microsoft Excel is a very powerful tool when used to its fullest extent.  Pivot tables are one tool that is not one of the first things you learn in Excel, but should be in your backpack of tools you have available.  They are an amazing tool to quickly make sense of big data sets and analyze information from multiple different views, all very quickly.  While they may seem confusing at first, once you learn the in's and out's of pivot tables, you'll be a pivot table wizard. 

In this course we will start with a blank Excel workbook, open a sample large data set, and then demonstrate how to create multiple pivot tables as well as pivot charts.  From there we will explore all of the options you have with pivot tables by adding to them.  After that, we then create a dashboard that any manager would love!

What We Do In The Course:  

  • Learn Excel basics to start

  • Review a large data set

  • Build a basic pivot table to begin

  • Build multiple additional pivot tables to give us a selection of reports

  • Create charts using our pivot table data

  • Create a fully functional Dashboard with multiple graphs and selection abilities

  • And much more!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  


About The Instructor

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, financial reporting, small business and business consulting.  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA