My Spreadsheet Lab

The site is about Microsoft Excel.

  • Home
  • Templates
  • Excel Blog
  • About Me
  • Contact Kevin

Post Category → Features

Video 00151 Custom Formats, VBA, and Nerds!

posted in Features, Macros (vba) on July 24, 2016 by Kevin Lehrbass 0 Comments

I doubt that you have ever seen custom formats presented like this before! Selecting a name from a drop down list changes the custom format and also displays a nerd! Continue reading →

Video 00073 Helping Dean Pelton with his menu in Excel

posted in Features on January 13, 2014 by Kevin Lehrbass 3 Comments

Dean Pelton has a problem.

His menu is alphabetical and has too many meatball recipes.

Watch as Bill Jelen (aka Mr Excel) helps Dean:  Mr Excel helps Dean Pelton

 

But how can I help Dean?

Continue reading →

Video 00031 DATA VALIDATION restrict values entered into a cell

posted in Features on April 7, 2013 by Kevin Lehrbass 0 Comments

Use Excel’s data validation feature to restrict values that can be entered into cells. 

Data validation can save you hours of data cleanup work! Continue reading →

Video 00020 Use a FILTER to hide rows

posted in Features on April 7, 2013 by Kevin Lehrbass 0 Comments

Learn how to hide rows using Excel’s FILTER feature. Continue reading →

Video 00023 TEXT TO COLUMNS to parse data

posted in Features on April 6, 2013 by Kevin Lehrbass 0 Comments

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

posted in Features on April 6, 2013 by Kevin Lehrbass 0 Comments

Learn how to sort data in Microsoft Excel using the sort command. Continue reading →

Video 00008 Features_Basic_FIND

posted in Features on February 10, 2013 by Kevin Lehrbass 0 Comments

Watch this video to learn how to use Excel’s powerful FIND feature.  You will save so much time once you learn how to use this feature! Continue reading →