Excel made easy, 1 tip at a time
I make a lot of Excel videos but I will also be adding written tips. I will be giving you a variety of quick formulas and longer posts about many different aspects of Microsoft Excel.
Get detailed Microsoft Excel educational hints and tips on my blog page here >>
[divider_ribbed]
Formulas
- Video 00002 SUMPRODUCT_function Part1
- Video 00009 FIND-and-SEARCH Excel functions
- Video 00010 SUMPRODUCT_Intro_Part2
- Video 00011 SUMPRODUCT_Part3 How it really works!
- Video 00012 SUMPRODUCT_Part4 this OR that
- Video 00016 VLOOKUP introduction
- Video 00017 VLOOKUP Introduction Part2
- Video 00027 COUNT functions in Excel
- Video 00025 Financial Functions_FUTURE VALUE
- Video 00026 Financial Functions_FUTURE VALUE part 2
- Video 00028 OFFSET function introduction
- Video 00029 OFFSET function with combo box
- Video 00030 Create a HYPERLINK in Microsoft Excel
- Video 00037 Formulas_Adding numbers in Excel
- Video 00042 Why would I need an array formula?
- Video 00043 Formulas_Array Formulas_Example1_LEN_function
- Video 00044 Array Formulas_Example2_EXACT LEFT_functions
- Video 00057 Find the Monday before the oldest date
- Video 00058 Filter Out Number (digits in any order)
- Video 00070 Use array formula to solve an algebra equation
- Video 00081 Count and find different types of Excel errors
- Video 00172 Unique Values for Data Validation Drop Down
- CAGR in Microsoft Excel
- How many unique List 1 names found in List 2?
- aggregating text part 2
- Calculate Hours from Messy Text
- Flirting with Volatility
- CELL Function Adventure
- DSUM gymnastics
- Rounding with a twist
- Word Game in Excel