SUMPRODUCT, OFFSET, SUMIFS, Goal Seek, Solver—turn your spreadsheet into a decision engine. Start with Leila Gharani.
- ▶ How to use Excel Index Match (the right way) 12 min
- ▶ Excel OFFSET Function for Dynamic Calculations - Explained in Simple Steps 14 min
- ▶ How to Use SUMPRODUCT in Excel 15 min
- ▶ Excel Dynamic YTD Calculations: OFFSET, SUMPRODUCT & SUM 13 min
- ▶ Excel Goal Seek Explained in Simple Steps 6 min
- ▶ Excel Solver - Example and Step-By-Step Explanation 10 min
- ▶ How to Remove Hidden Data and Personal Information from Excel Workbooks 10 min
- ▶ How to Easily Import External Data into Excel & Import Data from the Web 11 min
- ▶ Excel SUMIFS: Sum Alternate Columns based on Criteria and Header 11 min
- ▶ (Promo) Advanced Excel: Top 10 Tips & Formulas to Work Smarter 2 min
- ▶ Excel: How to debug your Excel formulas and keep your eyes on certain cells 9 min
- ▶ Excel Conditional Formatting with Symbols and Icons (for better reports) 10 min
- ▶ How to Reset Week Number Every Month in Excel - (WEEKDAY & WEEKNUM Functions Explained) 17 min
- ▶ How to Conditional Formatting the Lookup Result in Excel Data Table (Index Match) 9 min
- ▶ Return Multiple Match Results in Excel (2 methods) 14 min
- ▶ Excel MOD Function - Easy Explanation & Practical Examples of MOD for Work 20 min
- ▶ Excel Complex VLOOKUP to Create Description: Excel COUNTA, INDEX & MATCH for Blank Cells 17 min
- ▶ Excel SUMIFS Date Range Formula | Sum between dates & sum with multiple criteria 9 min
- ▶ How to Change the Number Format of a Cell Based on a Condition in Excel 7 min
- ▶ How to Use SUMIFS with Partial Match and Wildcards in Excel 9 min
- ▶ How to Count a Specific Day of the Week Between Two Dates | How many Fridays? 6 min
- ▶ How to Fix VLOOKUP Not Working | Convert Text to Date? (Excel Text to Columns) 5 min
- ▶ How to Rank Duplicate Values in Excel without Skipping Numbers (Top 3 Report with Duplicates) 13 min
- ▶ How to Change HORIZONTAL Data to VERTICAL in Excel (NO Transpose Function needed) 6 min
- ▶ Convert NUMBERS to WORDS in Excel | No VBA (free file included) 9 min
- ▶ Excel IF Function with PARTIAL Text Match (IF with Wildcards) 7 min
- ▶ Excel MAX or MIN with CONDITIONS (MAXIFS & AGGREGATE Method) 8 min
- ▶ Send Fully Dynamic Emails from Excel with a SINGLE FORMULA | No VBA Required! 9 min
- ▶ Excel 3D Formulas Explained (Sum Across Multiple Sheets) 9 min
- ▶ Remove ALL Unwanted Spaces in Excel (TRIM ALL Function?) 8 min
- ▶ Calculating Returns On a Rental Property (ROI with Excel Template) 16 min
- ▶ Why You NEED to know the Time Value of Money Formula (Excel NPV function) 14 min
- ▶ How to Count Cells With Text in Excel (Mysterious Formula as NEVER Seen Before) 7 min
- ▶ Find Multiple Match Results in Excel (Easier Solution For ALL Excel versions) 13 min
- ▶ How to Use Power Automate to Send Emails from Excel with PERSONAL Attachments 11 min
- ▶ How to Create Random Numbers in Excel (including no repeats) 7 min
- ▶ How to Calculate Working Days in Excel & Exclude ANY Days you WANT (weekends too) 7 min
- ▶ How to SUMIFS With Multiple Criteria In the SAME Column in Excel 4 min
- ▶ Properly Calculate Percentile and Percentile RANK in Excel (INC vs EXC) 7 min
- ▶ How to Calculate YTD (Year to Date) Values in Excel using the SCAN function 8 min
- ▶ Forecasting in Excel Made SIMPLE (include seasonality & make predictions) 6 min
- ▶ Excel LOOKUP Function Only PROS Use (simple to complex examples) 12 min
- ▶ Excel What-If Analysis Data Table | Easy to Use Once you Learn This☝️ 9 min
- ▶ You Won't Believe These Crazy PIVOT TABLE Hacks! 12 min
- ▶ Introducing REGEX Excel Functions - Extract, Clean, and Format Data Easily! (NEW!) 19 min
- ▶ Stop Using COUNTIF! The Better Way to Count in Excel 12 min
Leila Gharani
YouTube Channel
Excel. Power Query. Copilot. ChatGPT. Power BI. PowerPoint.
You use them every day to automate Excel and your work - so why not actually master them?
I’ll show you how to:
✔️Automate the stuff that drives you nuts
✔️ Spend less time on grunt work, more time on wow work
✔️ Build reports that look good AND actually make sense
What You’ll Learn Here:
✔️ Excel, Power BI, PowerPoint, VBA, Google Sheets & more
✔️ AI-powered Excel & the future of work
✔️ Data & finance skills that give you an edge
I don’t just teach this stuff - I use it daily.
My goal? To help you think differently about the tools you already have, so you can work faster, and with confidence.
🎓 My background: MA in economics / Economist / Business Consultant / Accounting Systems Expert / Oracle & SAP implementations (for Finance) / Teacher & Microsoft MVP
💡 400,000+ professionals have taken my courses at XelPlus - because working smarter just makes sense.
Join here 👉 https://www.xelplus.com/courses/