Let Me Help You Gain the Knowledge You Need to Create Useful Tools, Solve Problems and Get More Done.

Hi. I’m Leila Gharani. The Excel tools we have for data analysis & visualization have never been so easy to use. We just need to learn how to use them and how to get creative with them. That’s my aim with this site.

Leila Gharani

Unlock Excel VBA & Macros Course is here!

22 hours top quality content!

Over 50 Excel macro examples for download & useful VBA codes you can use for your work.

LEARN MORE

Work Smarter with my Top 10 Excel Formulas eBook

You’ll also receive free tutorials, news & discounts from time to time. You can unsubscribe with one click.

Latest Tutorials

Excel XLookup Explained

Excel XLOOKUP Explained (Goodbye VLOOKUP!) In this post, we will examine Excel’s BEST function for performing a lookup… We’re going to look at how the new (upcoming) XLOOKUP function solves common lookup

Progress Circle using Excel Doughnut Chart

Progress Circle using Excel Doughnut Chart When displaying progress, it is common to represent the percentage complete with an advancing bar. To make the visual more interesting, we can connect the ends

Microsoft Excel Justify

The QUICKEST & EASIEST Way to Work with TEXT in Excel Justify Feature When creating a solution for a user, it’s a good idea to give the user an instruction sheet. 

MAXIFS MINIFS with Multiple Criteria

Excel MAXIFS MINIFS (MAX MIN with Multiple Criteria) Finding the largest or smallest value in a set is one of the first tasks beginning Excel users discover.  Just after the SUM function,

Trusted by