Advertisment

Formatting Text

Spreadsheets can be pretty dry, so we need some tools to dress them up a little. We can use most of the tricks in our word processor to do the...

Views: 1451 | | by Mathew
MS Excel - Formatting

Formatting Numbers

We often need to format the numbers to display the appropriate number of decimals, dollar signs, percentage, red (for negative dollars), etc. It is...

Views: 1372 | | by Amy
MS Excel - Formatting

Column Width

A question that everyone (who has ever worked on a spreadsheet) has asked at one time or another is, 'Where did all my numbers go?' or...

Views: 1474 | | by Simon
MS Excel - Formatting

Work with Pivot Tables in Excel

PivotTables are one of the wildest but most powerful features of Excel. We use PivotTables a lot when we develop spreadsheets for our clients. Once...

Views: 919 | | by Tutorial
MS Excel - Formatting

Create Pivot Tables by Using VBA

A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet and VBA (Visual Basic for...

Views: 1009 | | by Troy
MS Excel - Formatting

Conditional color formatting in Excel

Let's say you are making an Excel table where you shall input how many hours did you work for everyday. And you would like to make designation...

Views: 984 | | by Tutorial
MS Excel - Formatting

Setting column Width and Row Height

The width of column and height of row can be changed very easily to properly accommodate the data in cells.

Views: 998 | | by Amy
MS Excel - Formatting

Excel Options {Tutorial for beginners}

In this tutorial, you will learn how to configure Excel’s general options.....

Views: 878 | | by Nick
MS Excel - Formatting

Formatting cells and sheets {Tutorial for beginners}

In this tutorial, you will apply formatting options to cells and prepare the sheet for printing....

Views: 821 | | by Jarry
MS Excel - Formatting

How To Format A Number To A Decimal In Excel

This video tuorial shows how to format numbers to decimals in Excel.

Views: 898 | | by Sarah
MS Excel - Formatting

How To Create Cell Borders

This video tutorial shows how to create cell borders in Excel.

Views: 893 | | by Adam
MS Excel - Formatting

How To Change The Cell Color Fill

This video tutorial shows how to change the color fill of a cell in Excel.

Views: 893 | | by Daniel
MS Excel - Formatting

How To Set Conditional Formatting

This video tutorial shows how to set conditional formatting in Excel.

Views: 909 | | by Tutorial
MS Excel - Formatting

How To Use The Format Painter

This video tutorial shows how to use the formatting painter in Excel.

Views: 912 | | by Steve
MS Excel - Formatting

How to Input the Same Data into Individual Worksheets at the Same Time

Don't waste time copy and pasting, learn to work with the same data within multiple sheets.

Views: 867 | | by Stephen
MS Excel - Formatting

Printing Workbooks in Excel 2007

This tutorial will show you how to printing workbooks in MS-Excel 2007.

Views: 864 | | by Colin
MS Excel - Formatting

Protecting Excel 2007 Data

The concept of 'protection' gets a lot of attention in the Excel newsgroups and forums. It seems that many users want to learn how to...

Views: 961 | | by Sarah
MS Excel - Formatting

Excel Shortcut Keys

Many users have discovered that using their keyboard can often be much more efficient than using their mouse. The following lists the most useful...

Views: 1020 | | by Source
MS Excel - Formatting

How to Merge Columns in Excel

You're probably used to merging cells , but did you know that merging or concatenating columns for combining data is just as easy and useful.

Views: 1013 | | by Tutorial
MS Excel - Formatting