Advertisment
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...
Learn how to protect cells from accidental or deliberate changes or deletion.
A step by step tutorial with screenshots on how to do scenarios with different factors in excel.
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...
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...
Provides free step-by-step how-to articles, tips and techniques, keyboard shortcuts, templates and clip arts for Microsoft Excel
Using macros you will be able to create a sophisticated interface to show of your sales report.
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...
Learn how to create a Table of Contents that will access other pages within your spreadsheet.
Views: 662 | | by Stephen
MS Excel - Basics
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...
In conditional formatting, you have to specify a condition or criteria for formatting.
The common error values that could appear when creating a formula are described below:
There are many pre-defined functions in Excel but the most important predefined functions
A border is a line drawn on any side of cell, around a cell or around a group of cells.
Views: 666 | | by Stephen
MS Excel - Basics
The width of column and height of row can be changed very easily to properly accommodate the data in cells.
In this tutorial, you will learn how to use the formulas........
In this tutorial, you will learn how to work with consolidated data....
Graphs offer a visual representation of the data. Instead of having to analyze columns of values of spreadsheet, it can interpret the meaning of...
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: 544 | | by Stephen
MS Excel - Basics
In this tutorial, you will learn how to configure Excel’s general options.....