All Courses Data Science Courses Microsoft Courses

Data Analysis Essentials Using Excel

Data Analysis Essentials Using Excel

Learn to apply the important concepts and techniques of data analysis using Excel.

What you’ll learn

Data Analysis Essentials Using Excel

  • Confidently use the most crucial Excel functions and techniques for analysis
  • Correctly use the appropriate charts in Excel
  • Apply analysis techniques to datasets in Excel
  • Manipulate and prep datasets in Excel
  • Build presentation-ready dashboards in Excel
  • Create your own formulas in Excel
  • Turn real-world data into business insights in Excel


  • You should be able to use a PC or Mac at the beginner level
  • Microsoft Excel 2013+


Every business generates data.  But whether you’re able to turn that into useful insights depends on your ability to process, manipulate, and ultimately translate that data.Whether you’re working for a company or running your own, being able to make better decisions requires you to be able to analyze and interpret data.

What data do you need? How do you prep that data? How do you analyze it to answer specific questions?

In this course, we’re going to show you step-by-step, exactly how to do that, by starting with the very basics.

Why Microsoft Excel?

This course is as much about Excel, if not more, than data analysis concepts and techniques. Why?

Yes, there are many tools out there but if you learn and master the core concepts and techniques of data analysis in Excel, you’ll be able to apply your knowledge to a broad range of applications.

Don’t underestimate Excel–a single worksheet can technically hold more than 17 BILLION data points (granted, it will make your computer REALLY slow). Fortunately, most of us running analysis will need to process far fewer data points than that. Still, it speaks to the power of the program.

What if I don’t have any data analysis or Excel background?

No worries! You can be a complete beginner and take this course.  It might sometimes feel like you’re drinking out of a fire hose, but if you put in the time and effort we promise you’ll see results by following our course and doing the exercises.

We then progressively increase the difficulty as you move along in the course, culminating in advanced techniques taught through our case studies.

If you do have an Excel background, you can skip or skim through the foundational sections and move directly into the more advanced topics.

Learn through practice.

Like most things in life, becoming proficient at data analysis in Excel takes practice.  A lot of practice.

Sure, you’ll pick up plenty just from watching, but you’ll be doing yourself a disservice if you don’t download our more than 100 custom-built Excel practice files specifically designed to help you master the program.

In conclusion, does any of the following apply to you?

1.     Do you want to really know your way around Excel?

2.     You have data for your work or business but you’re not sure what to make of it?

3.     You might know your way around Excel but you’re not confident about turning data into business insights

4.     You frequently receive Excel spreadsheets from others but want to better understand how they arrived at their conclusions?

5.     You want to learn the best practices when it comes to using Excel for data analysis.

6.     You want to learn a skill set that is useful for any role in any industry you get into later.

Who this course is for:

  • Anyone who wants to learn the core concepts of data analysis in the Excel environment
  • Anyone who wants to learn to apply data analysis techniques using Excel
  • Who wants to become proficient at using Excel for data/business analysis
  • Anyone who wants to be able to turn data into business insights in Excel
  • Anyone who wants to be able to run simply too sophisticated analysis on data using Excel
  • Who wants to learn the most frequently used Excel functions and techniques used by analysts

Data Analysis Essentials Using Excel