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.
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)
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.
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.
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’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
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.