YoVDO

Excel Intermediate Functions & Features

Offered By: YouTube

Tags

Microsoft Excel Courses VLOOKUP Courses Flash Fill Courses COUNTIFS Courses

Course Description

Overview

Learn advanced Excel functions and features applicable to all versions, covering IF formulas, VLOOKUP, IFS, data transposition, custom formatting, hyperlinks, Flash Fill, SUMIFS, COUNTIFS, AVERAGEIFS, WORKDAY, NETWORKDAYS, and conditional formatting. Master techniques for efficient data analysis, presentation enhancement, and time-saving shortcuts through practical examples and interview preparation tips. Explore ratio calculations and discover how to properly implement complex formulas to elevate your Excel skills for professional applications.

Syllabus

Excel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions).
VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples.
Properly Use Excel IFS Function.
3 Ways to Transpose Excel Data (Rotate data from Vertical to Horizontal or Vice Versa).
Better Excel Presentations: Increase Font Size of Formula Bar.
Why you SHOULD be USING Custom Number Formatting in Excel.
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature).
5 Excel INTERVIEW Questions You NEED to Get RIGHT.
Excel Flash Fill For MAJOR Time Saving (7 Examples).
Excel SUMIFS (better version of SUMIF), COUNTIFS & AVERAGEIFS (Multiple Criteria).
Excel Workday function: Find end date - exclude weekends & holidays.
Excel NETWORKDAYS function: Calculate the number of working days between two dates.
Excel Conditional Formatting with Formula | How to Get it RIGHT Every Time.
Easily Calculate Ratios in Excel.


Taught by

Leila Gharani

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