microsoft excel

Video Tutorial: How to Hide Zero Values in Excel 2010

In this video tutorial, I show you two ways to hide zero values in Excel 2010. In my example, I have a worksheet with formulas to add two amounts that I will be adding to throughout the year. Since I don’t want the zeros to appear in my worksheet, I try two different methods to hide them.

The first is by using Advanced Excel Options (File – Options – Advanced – Display Options for this Worksheet) and un-checking the “Show a zero in cells that have zero value” box.

The second method is by selecting the part or all of the worksheet to apply the formatting to and using Conditional Formatting (Home – Conditional Formatting – Highlight Cells Rules – Equal To) and formatting cells that are equal to 0 with custom formatting. In custom formatting, I change the font color to white. This changes all zero values to white so they are hidden from view and from printing.

This video was created using Cam Studio (http://camstudio.org).

Advertisements

Video Tutorial: Automating Data in Cells in Microsoft Excel

This quick tutorial shows how you can easily automate data to fill in Excel. This example shows how to automate months and numbers to fill cells in Excel as well as how to expand an equation to fill cells by dragging data.

Download Excel Now

This is something that will save you so much time if you ever need to fill consecutive information or multiples of information.

This tutorial was done in Microsoft Excel 2010 but will be similar in any recent version of Excel.

Video created using Cam Studio (http://camstudio.org)

Learn Everything There is to Know About Microsoft Excel

Video Tutorial: How to Use the Left & Upper Functions in Microsoft Excel

This video tutorial demonstrates how to use the LEFT and UPPER functions in excel.

Download Microsoft Excel

In this example, we have a fictional address list in which part of the data is in all caps and the rest is in sentence case. Additionally, some zip codes have the additional 4 digits and for this example, we only want to use 5-digit zip codes.

We use the UPPER function to change all the text to uppercase and the LEFT function to choose only the first 5 digits of the zip code. Also shown is paste values.

Video recorded using Cam Studio (www.camstudio.org)

Also be sure to check out my additional video tutorials on my YouTube channel.

Thanks for watching, I hope this was helpful to you!

Become Amazing at Excel: Recommended Reading

Video Tutorial: How to Use Format Cell, Auto Sum & Equations in Excel

This is a sample fictional budget to demonstrate how to use the format cell function, auto sum and simple equations in Excel. I demonstrate how to calculate a budget of monthly bills and extend the calculation to determine the cost of bills per year.

Download Microsoft Excel Now

These are standard formulas and functions everyone should know to make using Excel more efficient.

Tutorial was done in Excel 2010 but alternative options were shown for previous versions of Excel.

Video created using Cam Studio (http://camstudio.org)

Learn Everything There is to Know About Microsoft Excel

Video Tutorial: How to use the Concatenate Formula in Excel to String Data Together

This video tutorial shows how to use the concatenate function in Microsoft Excel to string text together and be more efficient.

Download Excel Now

Tutorial was done in Microsoft Excel 2010 but should be the same for all recent versions of Excel.

Here’s a super quick version demonstrating the concatenate function.

Video created using Cam Studio (http://camstudio.org)

Learn Everything There is to Know About Microsoft Excel

Video Tutorial: How to Create a Drop Down List in Excel Using Data Validation

This tutorial demonstrates how to create a drown-down list in Excel using data validation.

Download Microsoft Excel Now

In this video, we are creating a simple HR employee hire form and limiting the user to selecting numeric months and years from a drop-down list on a separate tab. The tab can be hidden from the workbook once the form is complete so the user cannot alter the data.

The tutorial was done in Microsoft Excel 2010, but the function will be similar in previous versions.

Video was made using Cam Studio (http://camstudio.org).

Learn Everything There is to Know About Microsoft Excel

Video Tutorial: How to use the vlookup function in Excel

Here’s a video tutorial I created to demonstrate how to use the vlookup function in Excel.  Excel 2010 was used, however this function works very similarly in most versions of Excel.

Download Microsoft Excel Now

The vlookup function allows a user to find data that matches a field in a spreadsheet. In this example, we look up fictional employee numbers based upon employee first and last name.

Also shown is two ways to copy the formula to several other cells by dragging or copy and pasting.

Video created using Cam Studio (http://camstudio.org)

Learn Everything There is to Know About Microsoft Excel