Learn how to exclude data from a pivot by using a report filter. Continue reading
Video 00015 Pivot Table: How to use a PIVOT FILTER
Author Archives → Kevin Lehrbass
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
Video 00018 SORT_DATA in Excel
Learn how to sort data in Microsoft Excel using the sort command. Continue reading
Video 00017 VLOOKUP Introduction Part2
This video reviews two parameters of Excel’s vlookup function (‘col_index_num’ and ‘table_array’). Continue reading
Video 00016 VLOOKUP introduction
Excel’s vlookup function is the most common lookup function. It’s often used in job interviews as bare minimum proof of Excel knowledge.
Are you using vlookup correctly?
Continue reading
Video 00014 Pivot Table: Extend the data range
If you’ve created a pivot table and later added more data then you’ll need to expand the pivot’s data range. Continue reading
Video 00012 SUMPRODUCT_Part4 this OR that
Advanced uses of the SUMPRODUCT function including how to incorporate “this or that” logic. Continue reading