Watch this video to learn how to combine the offset function with a combo box. This will make it easy to retrieve the desired value from your data.
Post Category → Videos
Video 00028 OFFSET function introduction
Learn how to retrieve a value or several values using Microsoft Excel’s offset function. Offset is one of my favorite functions due to it’s flexibility. Continue reading
Video 00026 Financial Functions_FUTURE VALUE part 2
What’s the difference between Compound Interest and Simple Interest?
I know that there’s a difference but I often forget the details so I created this video for you and for me! Continue reading
Video 00025 Financial Functions_FUTURE VALUE
Calculate the future value of your money in Microsoft Excel using the Future Value function. Continue reading
Video 00019 Pivot Table: How to Group Dates
Learn how to group a column of dates by Year & Month and sum another field.
Excel’s pivot table ‘Group’ feature only takes a few clicks of the mouse and can save so much time! Continue reading
Video 00015 Pivot Table: How to use a PIVOT FILTER
Learn how to exclude data from a pivot by using a report filter. Continue reading
Video 00020 Use a FILTER to hide rows
Learn how to hide rows using Excel’s FILTER feature. Continue reading
Video 00027 COUNT functions in Excel
Learn how to use Excel’s various count functions to count numbers, blanks, non blanks and how to conditionally count (count if a condition is met). Continue reading
Video 00024 Intro_Working with DATE and TIME_in Excel
Watch this video to learn how Microsoft Excel handles dates and times.
Also, learn how to find errors in your date values. Continue reading
Video 00023 TEXT TO COLUMNS to parse data
Data in each cell should represent 1 thing (i.e. one ‘City Name’ or one ‘Country’).
If various fields are pushed into 1 cell then learning Excel’s -Text To Columns- feature will save you many hours of work! Continue reading