Advertisment

Paste Special in Excel

The Paste Special command has a number of useful tools built into it. Besides allowing you to Paste values, it also allows you to transpose lists...

Views: 684 | | by Sean
MS Excel - Functions

Protect Cells within an Excel Spreadsheet

Learn how to protect cells from accidental or deliberate changes or deletion.

Views: 745 | | by Marry
MS Excel - Functions

How to Create a Simple What If Scenario in Excel

A step by step tutorial with screenshots on how to do scenarios with different factors in excel.

Views: 688 | | by Source
MS Excel - Functions

Using Excel to Calculate the Area of a Circle

The video I created below shows you how to use Excel to calculate the Area of a Circle. Now, many may consider this exercise to be pointless, but...

Views: 683 | | by Colin
MS Excel - Functions

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: 983 | | by Tutorial
MS Excel - Formatting

MS Excel - Step-by-step guides

Provides free step-by-step how-to articles, tips and techniques, keyboard shortcuts, templates and clip arts for Microsoft Excel

Views: 725 | | by Mathew
MS Excel - Basics

Creating a Menu using Macros in Excel

Using macros you will be able to create a sophisticated interface to show of your sales report.

Views: 980 | | by Jason
MS Excel - Macros

Edit a Macro Using Microsoft Visual Basic in Excel

Learn how to easily edit a macro using visual basic in Excel. Instead of creating a macro for everything you want to automate, just edit an...

Views: 978 | | by Sarah
MS Excel - Macros

Make a Table of Contents in Excel

Learn how to create a Table of Contents that will access other pages within your spreadsheet.

Views: 681 | | by Stephen
MS Excel - Basics

Create a toolbar button for an existing macro

Step by step instructions with screenshots on how to create a toolbar button for an existing macro in excel. This a great little time saver when...

Views: 872 | | by Marry
MS Excel - Macros

How Conditional Formatting is applied in Excel?

In conditional formatting, you have to specify a condition or criteria for formatting.

Views: 691 | | by Donald
MS Excel - Functions

Formula mistake may occur in Excel

The common error values that could appear when creating a formula are described below:

Views: 715 | | by Tutorial
MS Excel - Functions

Main Functions and Formula used in Excel.

There are many pre-defined functions in Excel but the most important pre­defined functions

Views: 720 | | by Sean
MS Excel - Functions

Applying and Removing Borders to Cells

A border is a line drawn on any side of cell, around a cell or around a group of cells.

Views: 682 | | by Stephen
MS Excel - Basics

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: 996 | | by Amy
MS Excel - Formatting

Advanced Formulas {Tutorial for beginners}

In this tutorial, you will learn how to use the formulas........

Views: 658 | | by Slicer
MS Excel - Functions

Consolidate Data {Tutorial for beginners}

In this tutorial, you will learn how to work with consolidated data....

Views: 565 | | by Sean
MS Excel - Basics

Create Charts {Tutorial for beginners}

Graphs offer a visual representation of the data. Instead of having to analyze columns of values of spreadsheet, it can interpret the meaning of...

Views: 884 | | by Sarah
MS Excel - Charts and Graphs

Create Excel 2007 Files {Tutorial for beginners}

Microsoft Office Excel 2007 is an effective tool that can use to create and to apply format to spreadsheets, and to analyze and to share...

Views: 555 | | by Stephen
MS Excel - Basics

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