#excel 2016 tutorials

In this Excel 2016 Tutorial video, you will learn to find and remove only the empty cells, columns and rows within from your worksheet. This short command can help you sometimes, when your only concern is finding and removing empty cells from the given data range.

We are using Go To Special - Blanks command for this scenario and later we will use Delete Sheet Rows and Delete Sheet Columns commands to remove the selected empty cells.

Information also applies to the following versions of Microsoft Excel : Excel 2003 Excel 2007 Excel 2010 Excel 2013

Subscribe Us http://www.youtube.com/theteacher

Circle Us on Google Plus http://www.google.com/+theteacher

Visit Us http://www.theteacherpoint.blogspot.com

Follow Us on Facebook http://www.facebook.com/bemyteacher

How to Display Numbers as Currency in Microsoft Excel?

In this Excel 2016 Tutorial Video, you will learn that how you can format numbers as currency. You will also learn to configure various default number and currency settings, so that you don't have to reconfigure everything from scratch for every new excel worksheet.

First, we will configure currency settings using Excel Format Cells settings and then we will take help of Windows - Control Panel - Region options to configure default number settings.

Information also applies to the following versions of Microsoft Excel : Excel 2003 Excel 2007 Excel 2010 Excel 2013

Subscribe Us http://www.youtube.com/theteacher

Circle Us on Google Plus http://www.google.com/+theteacher

Visit Us http://www.theteacherpoint.blogspot.com

Follow Us on Facebook http://www.facebook.com/bemyteacher