Excel Formatting

Excel Formatting

Author: Chuck Durante

The Objective of this tutorial is to show how you can change formatting or how data appears on a spreadsheet.   This is necessary to solve business problems.  You will want the users to be able to look at a spreadsheet and immediately know that they are viewing currency or date or numbers information.  By knowing how to use formatting you can change the way data appears, change the number of decimals that are being displayed or put some values in different colors so that they stand out.  

Formatting is a key part of knowing and understanding Excel!


Knowing how to format numbers, words and cells is an important part of knowing and understanding Excel. 

See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.


Excel Formats

This will allow you to see how to format data in an Excel Spreadsheet.

Excel Functions

This video will show you how to use several popular functions

Excel Filtering Advanced Set Up

This video will show you how to set up the advanced filter process

After you see this video be sure to watch the next video!