Excel: Skills for Business - Data Analysis

This course will show you how to use Excel for analyzing large groups of data.

Excel is a naturally powerful tool for data analysis that enables users to manipulate, analyze, and visualize large amounts of data easily. With its built-in features such as pivot tables, data tables, and various statistical functions, Excel is widely used in many industries, from finance and accounting to marketing and sales.

A variety of options are available for this including Conditional Formatting, Ranges, Tables, Text Functions, Date Functions, Subtotals, Formula Auditing, What If Analysis, and more.

Analytical functions such as CONCATENATE, LEN, DAYS, NETWORKDAYS, SUMIFS, AVERAGEIFS, COUNTIFS, COUNTA, VLOOKUP, IF, IFERROR, FIND, SEARCH, LEFT, RIGHT, RANK, Data Validation, and Data regression will be used in an exercise from start to finish to analyze data.

Please bring a flash drive to each class.