Excel 101: Big Data Analysis & Reporting in Excel for 2019 | Chris Benjamin | Skillshare

Excel 101: Big Data Analysis & Reporting in Excel for 2019

Chris Benjamin, Instructor, MBA and CFO

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

    • 2. Instructor Introduction

    • 3. Introduction to Excel

    • 4. Introduction to Big Data Sets

    • 5. Text to Columns

    • 6. Sorting Inserting Deleting

    • 7. Vlookup

    • 8. Filters

    • 9. Conditional Formatting

    • 10. Pivot Tables

    • 11. Course Conclusion

36 students are watching this class

About This Class

Do You Want To Harness The Power Of Excel To Manipulate Your Data Set?

Do You Know The Answers To Your Questions Lye In The Data But Aren't Sure How To Use Excel To Find Those Answers?

Do You Want To Improve Your Excel Skill Set?

Do You Want To Make Your Job Far Easier?

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!

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.

Become a data analysis expert and make award winning reports!

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 text to columns to split 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.  


About The Instructor

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