Excel Intermediate Functions & Features
Offered By: YouTube
Course Description
Overview
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 EconometricsUniversity 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