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.
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.
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,
ALL YOU Need to Know About Excel HYPERLINKS (Function & Feature) Hyperlinks! They’re everywhere…even in Excel! “But Excel isn’t a Web browser. How can hyperlinks be of any value?” Here are the
GUESS what's HIDDEN in Excel? (Cool Trick) Who says Excel can’t be fun? We will show how you can bring some fun to your next meeting or lecture using only Excel and
Project Plan in Excel with Gantt Chart 3 Views (Plan, Actual & Progress) in 1 View This article will show how to create a Gantt Chart in Excel that displays Actual and
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