Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel Intermediate Functions & Features

via YouTube

Overview

Prepare for a new career with $100 off Coursera Plus
Gear up for jobs in high-demand fields: data analytics, digital marketing, and more.
This course covers intermediate Excel functions and features for all versions of Excel. By the end of the course, learners will be able to use advanced IF formulas, VLOOKUP, IFS function, transpose data, customize number formatting, work with hyperlinks, utilize Flash Fill, apply SUMIFS, COUNTIFS, and AVERAGEIFS with multiple criteria, work with Workday and NETWORKDAYS functions, apply conditional formatting with formulas, and calculate ratios in Excel. The teaching method includes practical examples and demonstrations. This course is intended for individuals looking to enhance their Excel skills beyond the basics.

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

Reviews

Start your review of Excel Intermediate Functions & Features

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.