Let Me Help You Gain the Excel 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

Sum Cells by Color

Sum Cells by Color In this VBA tutorial we will look at a way to sum cells based on their background color. Unfortunately, Excel does not possess a function that will provide

Use PowerPoint SLIDE ZOOM the RIGHT WAY

Use PowerPoint SLIDE ZOOM the RIGHT WAY Imagine walking into a meeting and seeing that the speaker is about to embark on a PowerPoint journey.  The first thought you may have is,

Unprotect Cells by Color

Lock Cells & Protect Worksheet EVEN by Cell Color! This post will demonstrate how to lock and unlock cells.  That doesn’t sound like much to read about, but there’s a twist. We’re

Excel Dynamic Arrays Filter Function

LOOKUP ALL values b/w two dates (Excel Dynamic Arrays Filter Function to return many match results) Extracting records from a data set that matches defined criteria is a skill most users acquire

Trusted by