MS-Excel Tutorials

Subcategoreis

subcategoryExcel 2003
subcategoryFunctions and Formula
subcategoryGeneral Formatting
subcategoryGetting Started

Using Built-in Functions

This tutorial demonstrates what functions are, what they do, and how to use them. Along the way, you'll meet some of the key functions built into VBA - including functions that convert data from one data type to another. Read more...

Data Entry Tricks

he tips in this tutorial are designed to take some of the drudgery out of doing data entry by helping you work more efficiently and, at the same time, more accurately. Read more...

Creating Custom Functions to Use in Worksheets

Although Excel comes stocked with a wide variety of built-in functions, some of which are pretty specialized, they don't begin to cover all the types of specific computations you need to perform. Read more...

Excel Numerical Entry Express

Spreadsheets are full of them, and because they don't get there by magic, it behooves you to know all the tricks of the trade for entering them as efficiently as possible. Read more...

Customizing the Excel Screen Display

Here you find out how to max out the worksheet display so that you access as many cells and as much of your spreadsheet data as possible. Read more...

Automating Repetitive Tasks with Macros

Excel's macro feature records all the commands and keystrokes that you make in a language called Visual Basic for Applications (VBA). Read more...

Entering Data and Issuing Commands by Voice

Find out how you can speak your spreadsheet data entries as well as voice your Excel commands (it feels really good to tell a computer where to go!). Read more...

Using Hyperlinks to Make Jumps in Workbooks

This tutorial covers the creating and editing of all these types of hyperlinks. Read more...

Doing Automated Table Lookups

How to automate lookups in a worksheet table. The magic of being able to retrieve values from long boring schedules of numbers for use in other formulas without having to actually find the cell reference myself was quite thrilling. Read more...

Verifying Entries with Text to Speech

Excel includes a powerful feature known as Text to Speech that can help you through the drudgery of checking and verifying the accuracy of your data entries. Read more...

Adding and Editing Data Lists with the Data Form

This tutorial covers how to use the data form that Excel automatically creates for any data list you generate to add, edit, and find the information you need to maintain. Read more...

Eliminating Errors with Error Tracing in Formulas

Despite your best efforts, it's almost impossible to prevent all formula errors from cropping up. Possibly the worst thing about this is that the errors often tend to spread far and wide, given the web of formula interdependencies in a spreadsheet. Read more...

Data Entries with Data Validation

This tutorial acquaints you with a very versatile and, in the long run, great timesaving feature that Excel calls data validation. Read more...

Speeding Up Data Entry with AutoFill

With AutoFill, you can fill out a sequential series of entries (such as months of the year or days of the week) across a row or up or down a column simply by entering the first entry in the series and then dragging the cell pointer by its Fill handle. Read more...

Controlling When Certain Formats Are Used

This tutorial looks at ways you can use conditional formatting to alert yourself when certain key values change in your spreadsheet (for better or worse). Read more...

(174 Tutorials) Page 1 of 12 123 Next