Excel made easy, 1 tip at a time
Here you’ll find quick formula posts and longer posts about Excel (no videos)
Visit my blog to see all posts including videos >>
- Auditing & Editing M code (Power Query)
- Subtotal helper column
- 3 Newly Added Charts in Excel 2019 You Must Learn to Create
- Partial Match Count with a Condition
- Sorted Data Validation List
- Weighted Average
- Countifs confirms Vlookup
- Why and How to Unpivot Data
- Rearranging Data
- Concatenate Values to Create a Key
- Dynamic Charts
- Let Excel’s Solver do the heavy math!
- Allocating costs
- Excel-Picture-Link
- 2018 World Cup and Excel !
- Overlap of Binning and Rounding in Excel
- Dependent Drop Down List in Excel
- Excel data concept taught backwards
- Create Your First Pivot Table in 5 Minutes
- Who Won the 2018 Winter Olympics?
- Rank within Groups in Excel
- Reverse Partial Match Lookup to Filter for a List
- Liam Bastick from sumproduct.com
- Extracting Data That Could Be Anywhere In Any Sheet
- Re-arrange, Rotate, Transpose, Twist, Cascade the data!
- Otis Can’t Find a Date!
- Hiding in Plain Site
- Index of Ignorance
- IFERROR post from www.MBAexcel.com
- True Vlookup Tragedy
- Video 00047 Formulas_Add 20 minutes to TIME value
Learn Excel the Easy Way!!
If you would like to learn more about Microsoft Excel then this ‘Excel How To‘ website is for you! I create step by step video tutorials about key concepts in Excel. You can learn all about using MS Excel Spreadsheets in my easy steps videos online.
” A properly designed spreadsheet can save thousands of hours of manual work.”
~ Kevin Lehrbass, Your Excel Coach
Get Free Excel Templates >>
See Excel Video Lessons >>
Get Custom Templates >>
