fbpx
Search
Close this search box.

Archive for March, 2021

10 Advanced IF formula tricks you must know

Published on Mar 31, 2021 in Learn Excel
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 ?

Continue »

What is XLOOKUP? 13 formula examples to really understand it

Published on Mar 17, 2021 in Excel Howtos
What is XLOOKUP? 13 formula examples to really understand it

Office 365 now boasts a powerful successor to the VLOOKUP function – XLOOKUP formula. Think of XLOOKUP as VLOOKUP 2.0. In this article, learn all about the function, syntax, optional parameters and 13 xlookup examples.

Continue »

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

Published on Mar 12, 2021 in Excel Challenges
Write a formula to get Department Budget for a Month [Homework]

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.

Continue »

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

Published on Mar 3, 2021 in Learn Excel, Templates
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.

Continue »