Home Submit Sources Feeds
Microsoft Excel Getting Started tutorials
The Camera tool allows you to select a range of cells and literally insert a live picture into a spreadsheet. Any change to the range of cells will automatically update the image.
Related Tutorials
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.
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.
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.
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.
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 =
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.
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.
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.
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 .
Selecting Cells in Excel
Excel 2003 Video Tutorial explains how to select cells in Excel 2003 spreadsheets.
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.
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.
Excel 2007 Pivot Table Tutorial
A pivot table is a great tool for sorting and summarizing the data in a spreadsheet or database file.
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.
Function Wizard
In Excel there is a help tool for functions called the Function Wizard.
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.
Ten Common Spreadsheet Terms
Here is a quick list of 10 of the most common Spreadsheet terms: A handy tool for those new to using a spreadsheet program like Excel or Microsoft Works.
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.
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,
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.
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.
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.
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.
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).
Sumif Examples - Help for Excel functions and Formulas
The Sumif function in microsoft Excel is explained with examples and demonstrations, including a tutorial video.
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.
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.
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.
Some Basics in Excel 2007
This top basics list lays out all the fundamental skills required to successfully use Excel 2007.
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.
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.
Excel Shortcut Keys
Many users have discovered that using their keyboard can often be much more efficient than using their mouse. The following lists the most useful shortcut keys available in Excel.
 
Categories