Online College Courses for Credit

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
Fast, Free College Credit

Developing Effective Teams

Let's Ride
*No strings attached. This college course is 100% free and is worth 1 semester credit.

29 Sophia partners guarantee credit transfer.

314 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 27 of Sophia’s online courses. Many different 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!