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
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
