YoVDO

Top Excel Formulas for Accounting and Finance! Become more efficient at your job! Vlookup | Filters

Offered By: Skillshare

Tags

Microsoft Excel Courses Finance Courses Accounting Courses VLOOKUP Courses AVERAGEIFS Courses COUNTIFS Courses

Course Description

Overview

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

  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... 


Syllabus

  • 01 Excel Intro
  • 03 What we will not cover
  • 04 Excel File Explanation
  • 05 Vlookup
  • 06 If Statements
  • 07 Sumif
  • 08 Average If
  • 09 Count If
  • 10 TRIM
  • 11 Concatenate
  • 12 LEFT, MID, RIGHT
  • 13 Nested Formulas
  • 14 Data Validation
  • 15 Remove Duplicates
  • 16 Conditional Formatting and Data Filter
  • 17 - Excel Outro

Taught by

BrainyMoney And Son Han, CFA,CPA

Related Courses

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard