Here is a listing of my 21 Excel Video Lessons that are rated “5-Stars” on YouTube.
I hvae organized the videos by category. The First Hyperlink will take you to to the videos on this site. The “indented” Hyperlink will take you to the videos on my YouTube site – DannyRocksExcels.
I hope that you find a few tips to save you time or answer a question. I welcome your feedback. Enjoy!
Pivot Tables
“What-if” Analysis
Consolidation and SubTotals
Filter & Sort Lists in Excel
Financial Functions in Excel
Logical & Lookup Functions in Excel
- The =SUMIF() Function in Excel
- Use =VLOOKUP() to create an invoice
- When to use Excel’s =IF() Function
Text Functions
- Text Functions help you to combine “Text Strings”
- Use Excel’s LEFT(), MID() and RIGHT() Functions to extract “Text Strings”
Formula Auditing
- 4 Reasons to use “Formula Auditing” tools in Excel workbooks
- 3 reasons to use “Named Cell References” in your Formulas
Formatting and Conditional Formatting
- Excel’s Conditional Formatting Dynamically Highlights Data
- Solve your Zip Code problems when preparing mailing lists