| |
| Format Cell Text in Excel 2007
Posted in MS Excel > Formatting by tutorialgrub on May 09, 2011
Text entered directly into cells needs to be formatted so it can look its best and direct users in the right direction to see the data you are directing them to. |
| |
| Quickly Finding the Workbook
Posted in MS Excel > Formatting by tutorialgrub on Apr 28, 2011
This technique covers ways to quickly and easily find the workbook file you want. |
| |
| Find Payments Due this Week
Posted in MS Excel > Formatting by tutorialgrub on Apr 26, 2011
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. |
| |
| Sorting Worksheet Data
Posted in MS Excel > Formatting by tutorialgrub on Apr 24, 2011
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. |
| |
| Sending Workbooks Out for Review
Posted in MS Excel > Formatting by tutorialgrub on Apr 22, 2011
Excel makes it easy to send out spreadsheets for review by clients, coworkers, and managers who need to give you their input or approval after reviewing their contents. |
| |
| Managing Worksheet Windows
Posted in MS Excel > Formatting by tutorialgrub on Apr 22, 2011
This tutorial covers ways you can use worksheet windows to compare data, copy and move it between different regions of the same (or different) worksheets, and even move it from one workbook file to another. |
| |
| Conditonal Formatting - Shading Alternate Rows
Posted in MS Excel > Formatting by tutorialgrub on Apr 20, 2011
This Excel function is very useful when dealing with long lists of data. However, it is extremely easy to use once you know the simple formula. |
| |
| Consolidating Data from Different Worksheets
Posted in MS Excel > Formatting by tutorialgrub on Apr 18, 2011
Excel's Consolidation feature makes short work of combining numerical data in tables stored on several different worksheets or even different workbook files. |
| |
| Basic Data List Filtering
Posted in MS Excel > Formatting by tutorialgrub on Apr 18, 2011
This technique covers how to use AutoFilter to do basic and custom filtering of the data list. |
| |
| Spreadsheet Security
Posted in MS Excel > Formatting by tutorialgrub on Apr 17, 2011
This tutorial looks at all three aspects of spreadsheet security, giving you pointers on the best ways to preserve the integrity of your spreadsheet as well as guard against its more sensitive information from falling into the wrong hands. |
1 2 >> |
