YoVDO

Most Common Excel Formulas - Excel at Your Job

Offered By: Udemy

Tags

Microsoft Excel Courses VLOOKUP Courses

Course Description

Overview

Get better and more efficient at work!

What you'll learn:
  • Students will know all intermediate level Excel formulas and functions
  • Students will be significantly faster at their jobs when using Excel

We will cover the following most common Excel formulas for intermediate users:

  1. Vlookup
  2. If Statements
  3. SumIF
  4. AverageIF
  5. CountIF
  6. TRIM
  7. Concatenate
  8. Left, Right, Mid
  9. Data Validation
  10. Removing Duplicates
  11. Conditional Formatting
  12. Data Filters

We also cover dynamic formulas versus static formulas, a few shortcuts here and there and the relative versus absolute references (otherwise known as locking cells).This course is designed for Intermediate users as we do not cover basic formulas like addition, subtraction, etc...


Taught by

BrainyMoney and Son Han, CFA, CPA

Related Courses

Análisis de datos: Llévalo al MAX()
Delft University of Technology via edX Create Charts and Dashboard using Google Sheets
Coursera Project Network via Coursera Data Processing and Analysis with Excel
Rochester Institute of Technology via edX Grab Data Fast with Vertical and Horizontal LOOKUP
Coursera Project Network via Coursera Evaluate Profit Margins with VLOOKUP in Google Sheets
Coursera Project Network via Coursera