Best Tutorials website
Latest tutorials

Advertisment

Formatting Text

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: 1300 | Rating star | by Mathew
MS Excel - Formatting

Formatting Numbers

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: 1229 | Rating star | by Amy
MS Excel - Formatting

Column Width

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: 1332 | Rating star | by Simon
MS Excel - Formatting

Work with Pivot Tables in Excel

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: 789 | Rating star | by Tutorial
MS Excel - Formatting

Create Pivot Tables by Using VBA

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: 888 | Rating star | by Troy
MS Excel - Formatting

Conditional color formatting in Excel

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: 843 | Rating star | by Tutorial
MS Excel - Formatting

Setting column Width and Row Height

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: 875 | Rating star | by Amy
MS Excel - Formatting

Excel Options {Tutorial for beginners}

Excel Options {Tutorial for beginners}

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


Views: 780 | Rating star | by Nick
MS Excel - Formatting

Formatting cells and sheets {Tutorial for beginners}

Formatting cells and sheets {Tutorial for beginners}

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


Views: 729 | Rating star | by Jarry
MS Excel - Formatting

How To Format A Number To A Decimal In Excel

How To Format A Number To A Decimal In Excel

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


Views: 777 | Rating star | by Sarah
MS Excel - Formatting

How To Create Cell Borders

How To Create Cell Borders

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


Views: 783 | Rating star | by Adam
MS Excel - Formatting

How To Change The Cell Color Fill

How To Change The Cell Color Fill

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


Views: 779 | Rating star | by Daniel
MS Excel - Formatting

How To Set Conditional Formatting

How To Set Conditional Formatting

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


Views: 788 | Rating star | by Tutorial
MS Excel - Formatting

How To Use The Format Painter

How To Use The Format Painter

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


Views: 796 | Rating star | by Steve
MS Excel - Formatting

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

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: 765 | Rating star | by Stephen
MS Excel - Formatting

Printing Workbooks in Excel 2007

Printing Workbooks in Excel 2007

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


Views: 734 | Rating star | by Colin
MS Excel - Formatting

Protecting Excel 2007 Data

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: 841 | Rating star | by Sarah
MS Excel - Formatting

Excel Shortcut Keys

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: 895 | Rating star | by Source
MS Excel - Formatting

How to Merge Columns in Excel

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: 890 | Rating star | by Tutorial
MS Excel - Formatting