Subscribe
Tutorial search

Excel Tutorials


We hope that you will enjoy our Excel tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel tutorial to our site. Thank you !

Sort by:
Edit a Macro Using Microsoft Visual Basic in Excel
Edit a Macro Using Microsoft Visual Basic in Excel
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 existing macro. Screenshots included.
Difficulty:
Charting Hacks
Charting Hacks
Charts are one of Excel's most popular features, giving spreadsheets visual power beyond mere calculations. Although Excel's chart capabilities are impressive, many times you'll want to go beyond the basic functionality provided by the software's built-in Chart Wizard to create charts that are more responsive to changes in data, or you simply will want to go beyond the range of options Excel most obviously provides. This tutorial enable you to do all of this and more.
Difficulty:
The CONCATENATE function in Excel
The CONCATENATE function in Excel
The Concatenate (or &) can be used to join up the contents of multiple cells into one cell. This text function is extremely useful for generating unique keywords or preparing intelligent reports.
Difficulty:
Calculate IRR in Excel
Calculate IRR in Excel
Calculate the Internal Rate of Return of a series of cash flows
Difficulty:
Charts and Graphics in Excel 2007
Charts and Graphics in Excel 2007
This tutorial takes the first approach and explains how to generate straightforward charts. You'll also learn which chart types are out there, and how to fine-tune your charts for maximum effect.
Difficulty:
Very big basic tutorial
Very big basic tutorial
In this tutorial you get a look into all the required basics. From easy basics of a spreadsheet to charts and graphs.
Difficulty:
Average Function
Average Function
The average function finds the average of the specified data.
Difficulty:
Excel Options {Tutorial for beginners}
Excel Options {Tutorial for beginners}
In this tutorial, you will learn how to configure Excel’s general options.....
Difficulty:
Load an XML Document ito Excel
Load an XML Document ito Excel
If 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.
Difficulty:
Features of MS Excel 2003
Features of MS Excel 2003
Learn the new Features of MS Excel.
Difficulty:
Good Spreadsheet Design Principals
Good Spreadsheet Design Principals
The are some basic aspects of spreadsheets which should be considered. When developing your spreadsheets some upfront thought can be vital. This video clip will show you how to create effective spreadsheets and reduce the risk of errors.
Difficulty:
How to Create a Simple Macro in Excel
How to Create a Simple Macro in Excel
Learn to create a simple macro in Excel using step by step instructions with screenshots.
Difficulty:
Setting column Width and Row Height
Setting column Width and Row Height
The width of column and height of row can be changed very easily to properly accommodate the data in cells.
Difficulty:
Working with data {Tutorial for beginners}
Working with data {Tutorial for beginners}
In this tutorial, you will apply connect with another data source to obtain data.....
Difficulty:
Create Pivot Tables and Reports in Excel
Create Pivot Tables and Reports in Excel
How to create simple pivot tables and reports using excel.
Difficulty:
Total Tutorials in Category: 585