fbpx

How to create a fully interactive Project Dashboard with Excel – Tutorial

How to create a fully interactive Project Dashboard with Excel – Tutorial

Do you manage projects? You are going to LOVE ? this one. In this in-depth tutorial, learn how to create a fully interactive & dynamic Excel Project Management dashboard. Sample files & video instructions are also provided.

Continue »

Extract data from PDF to Excel – Step by Step Tutorial

Extract data from PDF to Excel – Step by Step Tutorial

Recently I had to extract data from multiple credit card statements and combine them to one Excel table. In this tutorial, let me share you simple steps to deal with PDF data and extracting it to Excel.

Continue »

10 Advanced IF formula tricks you must know

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

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]

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

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 »

Dynamic Arrays Live Masterclass – Replay

Dynamic Arrays Live Masterclass – Replay

Excel Dynamic Array functions are going to change the way to you work your data forever. Watch the replay of the event here and learn about…

* What is so different about Excel’s dynamic array functions
* The new # operator
* 6 important dynamic array functions – FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY
* 25 practical examples of dynamic array functions for business analysis
* Your questions & answers

Continue »