MS Excel Tutorials

Excel Charts - Learn how to Create and Format

In: MS Excel / Charts and Graphs

Tutorial videos teaching you step by step how to create and format charts in Excel 2007. Also teaches about the chart's legend, …

Vlookup Function in Excel

In: MS Excel / Functions

Learn what the vlookup function is all about, and how to use it with its 2 variations: to retrieve a value from an exact match …

Conditional Formatting

In: MS Excel / Formatting

Excel 2007 offers a new wide range of conditional formatting options without the need of typing formulas and functions. Here are…

Excel Formulas Tutorial and Examples

In: MS Excel / Basics

Learn the basics of formulas in Excel, what they are and how to use them. Includes video tutorials and many examples and demonstrations…

Copying Forumulas: Fill Right

In: MS Excel / Basics

We can also fill right. We must select the original cell (and the cells to the right) and select from the Edit menu - Fill and …

Copying Forumulas: Absolute Positioning

In: MS Excel / Basics

Sometimes it is necessary to keep a certain position that is not relative to the new cell location. This is possible by inserting…

Add a Character to Each or All Cells

In: MS Excel / Macros

If you have a Microsoft Excel sheet with over 100 cells filled with 001-100. And you need to add "A" or other characters…

How to Create a Simple Macro in Excel

In: MS Excel / Macros

Learn to create a simple macro in Excel using step by step instructions with screen shots. Having this knowledge adds your reputation…

Create Pivot Tables and Reports in Excel

In: MS Excel / Charts and Graphs

How to create simple pivot tables and reports using excel…

How to Create Simple Pie Charts Using Excel

In: MS Excel / Charts and Graphs

Create two different type of financial pie charts using Microsoft Excel…