Intro to Excel Functions for Data Analytics

Setting the baseline for advanced data analytics using basic functions.

This course is designed to provide entry-level tools and education about excel functions. The excel functions provided in this course will set the baseline for more advanced data analytics when looking at large data sets. Basic excel functions will also allow a student to perform simple data analytics on smaller data sets or math/simple calculations. Students will be able to practice each function on provided workbooks and excel sheets when going through the course. Videos, workbooks, and links to download large data sets will be provided within the course to help foster the learning environment.

What you’ll learn

  • Students will learn how to use excel to analyze data in numerous settings and professions..
  • Students will learn the basic layout of excel and the best functions for data analysis..
  • Students will learn advanced functions to analyze large data sets..

Course Content

  • Introduction –> 4 lectures • 16min.
  • Creating a Data Set –> 3 lectures • 17min.
  • Tables –> 3 lectures • 16min.
  • SUM Functions –> 3 lectures • 17min.
  • Count Functions –> 4 lectures • 18min.
  • Statistical Functions –> 6 lectures • 31min.
  • IF/IFS Functions –> 2 lectures • 24min.
  • Date Functions –> 3 lectures • 18min.
  • Look Up Functions –> 1 lecture • 9min.
  • Conditional Formatting –> 1 lecture • 3min.

Intro to Excel Functions for Data Analytics

Requirements

  • Access to excel on Mac or Windows computer..

This course is designed to provide entry-level tools and education about excel functions. The excel functions provided in this course will set the baseline for more advanced data analytics when looking at large data sets. Basic excel functions will also allow a student to perform simple data analytics on smaller data sets or math/simple calculations. Students will be able to practice each function on provided workbooks and excel sheets when going through the course. Videos, workbooks, and links to download large data sets will be provided within the course to help foster the learning environment.

As you go through the course, the instructor will be there every step of the way to help you understand and apply the function concepts needed to perform data analysis. Students should be able to apply basic excel functions, charts, formulas, and analytics to increase the productivity in business, sport, and daily life.

The designer of this course has 10+ years in business, athletics, and education to guide students in the right direction when it comes to applied data analytics. Using this course as a tool will improve the field of data analytics to make better decisions in all fields and professional settings. We hope you enjoy the course and take the tools provided to help a large number of people and professionals.