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.

NEW COURSE

EXCEL ESSENTIALS FOR THE REAL WORLD

Learn Excel from Scratch or Fill in the Gaps to Become Confident

LEARN MORE

Packed with Challenges & Files (Excel 2016, 2019, Office 365)

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 3-D Formulas

With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.

Cash vs Accrual Accounting

There are 2 different accounting methods: Cash Accounting and Accrual Accounting. Check out this article which explains the difference with a story. This makes it really easy to understand the difference between cash basis and accrual method of accounting.

Excel DGET Function

Quickly learn how to use Excel's DGET Function to lookup one or more criteria. DGET can also do a left lookup (unlike VLOOKUP). It's a forgotten Excel database function. Can you apply DGET to a range of cells? Find out in this article.

Excel FILTER Function

Excel’s New Dynamic Array FILTER Function

The FILTER function can be thought of as the new power lookup function; in many cases replacing the traditional VLOOKUP and INDEX/MATCH functions when searching for

Excel Printing Repeat Header Rows

As explored in a previous post (Your Excel Printing Problems, Solved!), we outlined the reasons why printing in Excel is a bit trickier than printing in Word.

Trusted by