Skip to content
  • Home
  • About
  • All posts
  • Contact
  • Ask a question
  • Home
  • About
  • All posts
  • Contact
  • Ask a question
Login to online classes
  • Start Here
  • Blog
  • Classes
    • Excel School
    • VBA Classes – Learn VBA Macros today
    • Power BI Play Date
    • 50 Ways to Analyze your Data
    • Mini-Courses
    • Power BI Remote Training Options
  • Videos
    • Intro to Excel
    • Writing Formulas
    • … more
  • Topics
    • Excel Basics
    • Advanced Excel Skills
    • Learn Power BI
    • Power Query Tutorial
    • Excel Pivot Tables – Full guide
    • Project Management using Excel
  • Formulas
    • Tables & Structural Refs
    • IF
    • CHOOSE
    • XLOOKUP
    • SUMIFS
    • SUBTOTAL
    • INDEX
    • VLOOKUP & other lookups
    • 100+ Formula Examples
    • Multi-condition lookups
    • Array formulas
    • Top 10 formulas
  • Dashboards
    • What are they, how to make one?
    • Dynamic Dashboard in Excel
    • Customer Service Dashboard
    • 200+ Examples
    • Dashboard Training Course
  • Charts
  • VBA
    • 40+ Examples
    • More on VBA
  • Resources
    • 100s of FREE Excel Templates
    • Resources for Freelancers
    • Mini-Courses
  • Start Here
  • Blog
  • Classes
    • Excel School
    • VBA Classes – Learn VBA Macros today
    • Power BI Play Date
    • 50 Ways to Analyze your Data
    • Mini-Courses
    • Power BI Remote Training Options
  • Videos
    • Intro to Excel
    • Writing Formulas
    • … more
  • Topics
    • Excel Basics
    • Advanced Excel Skills
    • Learn Power BI
    • Power Query Tutorial
    • Excel Pivot Tables – Full guide
    • Project Management using Excel
  • Formulas
    • Tables & Structural Refs
    • IF
    • CHOOSE
    • XLOOKUP
    • SUMIFS
    • SUBTOTAL
    • INDEX
    • VLOOKUP & other lookups
    • 100+ Formula Examples
    • Multi-condition lookups
    • Array formulas
    • Top 10 formulas
  • Dashboards
    • What are they, how to make one?
    • Dynamic Dashboard in Excel
    • Customer Service Dashboard
    • 200+ Examples
    • Dashboard Training Course
  • Charts
  • VBA
    • 40+ Examples
    • More on VBA
  • Resources
    • 100s of FREE Excel Templates
    • Resources for Freelancers
    • Mini-Courses

Month: March 2021

10 Advanced IF formula tricks you must know

IF is the most used Excel function out there. Here are 10 advanced IF tricks to take your formulas to next-level ?

Write a formula to get Department Budget for a Month [Homework]

department-budget-2d-lookup-problem

Time for another homework. You got a spreadsheet of department budgets and need to write a formula to get budget for a given department, month combination.

How to embed Excel files, calculators on your website? – Step by step instructions

Here is an awesome way to enhance your website and impress clients. Embed an Excel calculator on your webpage. Check out below demo and if this is what you want, read on.

Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free. 

Yes, sign me up

Get Started

  • Excel Basics
  • Advanced Excel
  • 100+ Formulas
  • Free Crash Course
  • Pivot Tables
  • Power BI

Online Classes

  • Excel School
  • VBA Classes
  • Power BI Classes
  • 50 ways to analyze data
  • Mini Courses

About

  • My Story
  • Welcome Message
  • Contact
  • Forum & Community

Downloads

  • 20+ Excel Templates
  • 200+ Dashboards
  • 40+ VBA Code samples
  • Ebooks & More
Twitter Facebook-f Youtube Linkedin-in

© All rights reserved.