YoVDO

Learn Excel in 60 Minutes: Using Real Company Data

Offered By: Udemy

Tags

Microsoft Excel Courses Data Analytics Courses Pivot Tables Courses AVERAGEIFS Courses COUNTIFS Courses

Course Description

Overview

Filtering, SUMIFS, Pivot Tables, Conditional Formatting

What you'll learn:
  • Have a core understanding of Excel essentials (on a Mac)
  • Have familiarity in organizing and analyzing real business data

UseExcel to organize a real company's accounting and customer data. Then apply key practices in data analytics todraw insights from the data.

Thiscourse is verystraightforward and targets peoplethat wantto pick up Excel as quickly as possible. Keep in mind that this course may not be for everyone because we move fast. Video tutorialsare also done onaMac, and it may be a little different onaWindows PC.

You are not required to have any prior experience with Excel, but there will be some knowledge gaps if you are 100% unfamiliar with it. In any case, we have structured the course so that you can easily follow along, but we expect students to be resourceful (i.e. Google) to fill in any gaps.

Excel tools you will learn: Pivot Tables,SUMIFS, COUNTIFS, AVERAGEIFS,filtering, conditional formatting, copying formulas, usingdollar signs, and more!



Taught by

Tony Li

Related Courses

Excel Statistics and Finance Function Playbook
Pluralsight
Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | Filters
Skillshare
Excel Spreadsheet Formulas - Old School or Dynamic Arrays?
ExcelIsFun via YouTube
Average, Moving Average at Different Granularity - DAX or Excel Formulas
ExcelIsFun via YouTube
Average of Customer Total Sales by Product - Formulas, DAX or Array Formula?
ExcelIsFun via YouTube