Data Review and Analysis in Excel - Make Sense of Big Data

Chris Benjamin, Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
11 Videos (59m)
    • Course Introduction

      2:14
    • Instructor Introduction

      3:05
    • Introduction to Excel

      10:40
    • Introduction to Big Data Sets

      2:54
    • Text to Columns

      4:43
    • Sorting Inserting Deleting

      4:44
    • Vlookup

      4:36
    • Filters

      6:07
    • Conditional Formatting

      6:26
    • Pivot Tables

      12:12
    • Course Conclusion

      1:38

About This Class

Learn how to take large data sets in Microsoft Excel & use pivot tables, lookups, filters and more to analyze it all

** New Course for 2018! **

We've all faced the problem of being given a large set of data in Microsoft Excel and asked to create reports from it that are meaningful and useful.  Maybe you had to solve a specific problem, or maybe you just need to analyze and interpret the data and don't know where to start.

In this course you will learn multiple ways to take large data sets and do exactly what you need to with it.  By the end of this course, you will be able to use any of the multiple tools, tips and techniques you'll be learning to effectively and quickly take data, create professional reports and most important read and interpret large data sets. 

What We Do In The Course:  

  • Learn basic Excel functionality for beginners
  • Examine what a large data set may look like through examples
  • Learn how to use Pivot Tables to quickly take data and be able to report on it from many views
  • Use Vertical Lookups (vlookup) to have Excel find data and report it back to us
  • Use Filters and drop down menus to quickly extract information we are trying to find
  • Use charts and graphs to take a visual look at data
  • And much more! We'll be covering other tools and formulas in Excel that are very useful

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.  

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, Microsoft Excel and big data analysis.  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

3

Students

--

Projects

0

Reviews (0)

Chris Benjamin

Instructor, MBA and CFO