Microsoft Excel Getting Started tutorials
The tips and tools in these free tutorials include little known "backdoor" adjustments for everything from reducing workbook and worksheet frustration to hacking built-in features such as pivot tables, charts, formulas and functions, and even the macro language.
Related Tutorials
Editing an Excel Worksheet Tutorial
This Free Editing an Excel Worksheet Tutorial will help you learn to use the Microsoft Excel 2003 Spreadsheet Program. This is part two of the Free Excel Tutorials and will show you how to edit information in worksheets.
Basics
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks. You can also view the Excel 2003 Video Tutorials as they come on line.
Excel Worksheet Help
This is the thing about spreadsheet programs like Excel - there are just so many tools and features it's hard to keep track of them all. If you've been using Excel for a while you know how to do such things as enter the data and add a formula or function.
Excel 2003 Keyboard Shortcuts
This Excel 2003 Keyboard Shortcuts tutorial lists all of the shortcuts for Excel that can be performed on the keyboard. Learning these will save you lots of time in building Excel spreadsheets.
Excel 2000 Tutorial
Learn the basics of Excel 2000 and more including Customizing Excel.
Microsoft Excel 2003 Help and Tips
Microsoft Excel 2003 tips and tricks for developing spreadsheets (worksheets). Adjusting macro security, tweaking Excel 2003 startup, customizing Excel spreadsheet views, and more.
Multiply
Multiplication is essential in Excel. Luckily it is extremely easy. To multiply numbers or cells in Excel, we must use a basic formula. All Formulas in Excel begin with =
Selecting Cells in Excel
Excel 2003 Video Tutorial explains how to select cells in Excel 2003 spreadsheets.
Getting to know Excel 2007
The Excel 2007 interface has been completely revamped and redesigned compared to the older versions of Excel we are all used to.
Import Data Directly into Excel
This tutorial relies on Excel's ability to perform web queries, so you'll need Excel 97 or higher. Excel's Web Queries tool transforms simple HTML tables into Excel spreadsheets.
Check boxes in Excel
Unknown to many excel users, you can easily set up check boxes in Excel. You can use these check boxes to total a list of data by selecting various boxes. The following Excelbuddy.com video demonstrates what this tutorial will accomplish.
Creating Charts in Excel 2007
A chart (also known as a graph outside Excel circles) is a way to present a table of numbers visually. The visual display allows you, for example, to quickly examine trends or compare the relative contributions of various items. Excel provides you with the tools to create a variety of charts.
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 with colors. Red number for less than 8, blue for 8 and green color for more than 8. Did you know you can make that process automatic in MS Excel? Here's how.
Excel 2007 Data Entry Form
If you ever created a database file in a spreadsheet program like Excel you'll know that it does a great job. Whether you have a contact list for an organization, an inventory of parts, or a library catalog of books or DVDs, Excel has the tools to make the job simple and straightforward .
Working with Excel 2007 Files
This tutorial discover the new Excel interface that provides you with the right tools at the right time. In most Windows programs, you see menus and toolbars from which you select your options.
Printing Workbooks in Excel 2007
This tutorial shows you a number of Excel tools you can use to improve your document layout, including headers, footers, page orientation, and margins.
Financial Calculation Software, a Snap with MS Excel
There is more to Microsoft Excel than simple math. It has more than 50 functions that can be set up, in effect allowing you to do a certain degree of programming. This article explains how to create and use a financial calculator in Excel, and discusses some of those functions. TOC: Financial Calculation Software, a Snap with MS Excel; Calculating the payment on a loan; Usage of function PMT; A simple spread sheet to calculate PMT.
Very big basic tutorial
This is a basic tutorial of Excel. START HERE Specific examples may refer to Excel (but most items discussed should work in other spreadsheets).
How to Create a Simple What If Scenario in Excel MS
A step by step tutorial with screenshots on how to do scenarios with different factors in excel.
Excel Statistical Functions - Countif,Average, Counta, Sum
Learn how to use the basic statistical function in MS Excel. Easy tutorial videos, with many examples and demonstrations,
Load an XML Document ito Excel
If someone sends you an XML file containing data that fits into tables, you don't need to read the text and all its angle brackets. You can load the document into Excel directly, tell Excel how you want to present it, and work with the data through maps.
Address Data by Name
Although cell numbers are at the foundation of everything Excel does, it's much easier to remember names, such as Item Number and Quantity, than it is to remember cell numbers, such as A1:A100. Excel makes this easy. Excel uses the same technique for defining named cells and named ranges: the Name box at the left end of the Formula bar.
Getting Started With Excel
By following the steps outlined in this tutorial, a basic understanding of Microsoft Excel should be achieved allowing basic requirements of reports and course projects assigned by the Department of Finance at The University of Arizona.
Sumif Examples - Help for Excel functions and Formulas
The Sumif function in microsoft Excel is explained with examples and demonstrations, including a tutorial video.
Creating Charts and Graphs in Excel
Tutorial videos teaching you all the basics of how to make a chart in MS Excel, includes: Adding a chart, setting the legend, formatting axis and adding data labels.
Making a Gantt Chart
This Excel 2003 tutorial will show you how to make a Gantt chart in Excel
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 protect their workbooks from being copied or modified.
Formulas in Excel
This tutorial will teaches you how to use Formulas in Excel.
Excel Formulas Simply Explained
Learn the basics of formulas in Excel: how to write and use them, using absolute and relative references, and using the fill handle with formulas.
Filter Texts and Dates in Excel
Learn how to filter in Microsoft Excel 2007. The filter utility is used to extract specific data out of big tables.
Excel 2007 SUMIF
Two of the most useful functions available in Excel are the IF function and the SUM function.
Making Bar and Circle Graphs
This Excel 2003 tutorial will show you how to make bar and circle graphs in Excel
Save To SpreadsheetML And Extracting Data
Since Excel XP, Excel has included an XML export option. SpreadsheetML provides an XML representation of your spreadsheets, complete with formatting and formula information.
Hide Columns in Excel
The Hide Column feature in Excel is a very easy to use and handy trick. From a personal standpoint, I find myself hiding columns quite frequency in order to clean up the spreadsheet.
Basic Bar Graph in Excel
The following tutorial will demonstrate how to construct a basic bar graph in Excel. The documents for this tutorial are available for download.
Microsoft Excel Fundamentals
Microsoft Excel is a spreadsheet application. That is, it is used to create and manage lists of information. To effectively handle list-related assignments, this environment provides many more features than simply dealing with lists.
Excel 2007 RIGHT Function
Another Excel function, similar to the LEFT function, which can be used to remove unwanted characters from imported data, is the RIGHT function.
Some Basics in Excel 2007
This top basics list lays out all the fundamental skills required to successfully use Excel 2007.
Features of MS Excel 2003
In this tuorial you will learn MS excel Features.
Built-In Means Of Password Protection In Microsoft Excel Documents
Recent versions of the program provide users with advanced features for protecting Microsoft Excel documents against unauthorized access of the information stored in them.
 
Categories