Excel Intermediate Functions & Features

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.