Subscribe
Tutorial search

Excel Formatting Tutorials


We hope that you will enjoy our Excel Formatting tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel Formatting tutorial to our site. Thank you !

Sort by:
Excel Conditional Formatting
Excel Conditional Formatting
Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value.
Difficulty:
Find Payments Due this Week
Find Payments Due this Week
Use Excel to find payments due this week. Use an Excel formula in Conditional Formatting to alert you to payments due this week and next week.
Difficulty:
Highlight Birthdays Due this Month in Excel
Highlight Birthdays Due this Month in Excel
Keep track of birthdays using Excel to automatically format the birthdays due this month. Never miss a birthday again.
Difficulty:
Excel 2003 Using Range Names
Excel 2003 Using Range Names
In this tutorial, you find out how to use all three of these procedures to save time in a worksheet that you access and edit on a somewhat regular basis.
Difficulty:
Making Efficient Cell Selections
Making Efficient Cell Selections
Because cell selection is one of the most basic and regularly performed worksheet task, knowing how to efficiently select ranges of cells in the spreadsheet can go a long way toward making you a truly effective worker.
Difficulty:
Sharing Excel Workbooks and Lists with SharePoint Web Site
Sharing Excel Workbooks and Lists with SharePoint Web Site
This tutorial covers how to add Excel workbooks to a SharePoint Web site for review by team members.
Difficulty:
Importing Web Data into the Worksheet
Importing Web Data into the Worksheet
The subject of this tutorial is getting Web data from the Internet or some other source into your Excel worksheets.
Difficulty:
Controlling When Certain Formats Are Used Controlling When Certain Formats Are Used
Controlling When Certain Formats Are Used Controlling When Certain Formats Are Used
This tutorial looks at ways you can use conditional formatting to alert yourself when certain key values change in your spreadsheet (for better or worse).
Difficulty:
Long Data Entries with AutoCorrect
Long Data Entries with AutoCorrect
AutoCorrect is Excel's attempt to save you time when doing data entry in a spreadsheet. It anticipates what you enter and, if necessary, corrects it or converts it into special types of data such as live hyperlinks and smart tags
Difficulty:
Excel Worksheets and Web Pages
Excel Worksheets and Web Pages
The subject of this tutorial is turning your worksheets into Web pages that you can publish to your Web site, either publicly on the World Wide Web or on your company's more private intranet.
Difficulty:
Instant Lists in Excel 2003
Instant Lists in Excel 2003
The Excel list, a new element in version 2003, is one of the most fun features you're likely to encounter in this latest go-round of the program.
Difficulty:
Sharing Workbooks on a Network
Sharing Workbooks on a Network
This technique covers the different ways you can share a workbook so that different people can edit its contents at the same time.
Difficulty:
Sorting Worksheet Data
Sorting Worksheet Data
This technique introduces you to the process of sorting worksheet data. It begins by covering the basic sorting of the records in a data list using one, two, or even three fields in the list.
Difficulty:
Printing Tricks for Reports
Printing Tricks for Reports
This tutorial looks at all the little things you can do to ensure that your printed reports not only contain all the necessary information but also present it in the clearest possible manner.
Difficulty:
Basic Data List Filtering
Basic Data List Filtering
This technique covers how to use AutoFilter to do basic and custom filtering of the data list.
Difficulty:
Total Tutorials in Category: 116