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