Excel 101: Pivot Tables, Pivot Charts and Dashboards For Beginners

Chris Benjamin, Instructor, MBA and CFO

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

      2:40
    • Excel Basics

      11:30
    • Introduction To The Data Set

      6:08
    • Basic First Pivot Table

      7:01
    • Formatting Sorting and Fixing Data

      5:37
    • Value Field Settings

      6:57
    • Pie Chart Graph of Commissions

      6:11
    • Buyer Type Avg List Price

      12:36
    • Offer Status Type Pivot

      8:11
    • Dashboard Creation

      6:28
    • Dashboard Slicer

      7:47
    • Course Conclusion

      2:07

About This Class

Learn how to create pivot tables, amazing dashboards, and make sense of large data sets

JOIN THE 1,000'S OF STUDENTS AND COMPANIES I HAVE TAUGHT MICROSOFT EXCEL AND LEARN FROM A PROFESSIONAL BUSINESS CONSULTANT WITH A PROVEN TRACK RECORD FOR SUCCESS!

Three reasons to TAKE THIS COURSE right now!

  1. You get lifetime access to lectures, including all new lectures, assignments, quizzes and downloads I add
  2. You can ask me questions and see me respond to every single one of them thoroughly!  This is an interactive course!
  3. You will are being taught by a professional with a proven track record of success!  

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 a pivot table.  From there we will explore all of the options you have with pivot tables.  

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.  

**********************************************************************************************************************************************

***** Click the button and enroll today!  Let me teach you how to make pivot tables work for you! *****

**********************************************************************************************************************************************

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