Tutorial search

Excel Tutorials
Tutorials
Stuff
Affiliates

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 tutorials to our site. Thank you !

Sort by:
Insert Data from Excel to SQL Server
Insert Data from Excel to SQL Server
Shows how to read data from an Excel spreadsheet and insert it into a SQL Server database using VBA and ADODB.
Category: Excel tutorials > Macros - Difficulty:
How to record and use a Macro in Excel
How to record and use a Macro in Excel
This is a video tutorial which teaches you how to use and record macros with the macro recorder in excel. The main website is : http://www.ExcelisHell.com
Category: Excel tutorials > Macros - Difficulty:
Excel VBA-Creating Procedure
Excel VBA-Creating Procedure
There are two types of procedures you can create in Excel VBA: a Sub procedure and a Function procedure. What’s the difference between the two types of procedures? It’s whether or not the procedure returns a value you can use elsewhere in the program. A procedure defined as Sub can not pass its result to any other procedure in the program while a procedure defined as Function has the capability to return a value or result.
Category: Excel tutorials > Macros - Difficulty:
Excel VBA - Control the Program Flow
Excel VBA - Control the Program Flow
While executing the program the flow generally goes top to bottom, it means from first line of the program to the last line. But some times we need interrupt the flow of the program. For this purpose we have several statements to achieve this task.
Category: Excel tutorials > Macros - Difficulty:
Using the Countif Function in Excel
Using the Countif Function in Excel
A simple tutorial video teaching how to use the countif function in Microsoft Office Excel.
Category: Excel tutorials > Functions - Difficulty:
Freeze Panes in Excel 2007
Freeze Panes in Excel 2007
Freeze panes in Excel 2007 to freeze certain rows and columns in your Excel spreadsheet that you would like to remain in view while you are working within the workbook.
Category: Excel tutorials > Basics - Difficulty:
Advanced Charts
Advanced Charts
Its easy to chart and list that contains two columns you want to graph one with text labels and one with numeric data. But in real life, you'll need to deal with many different types of data that occupy many different configurations on your worksheet
Category: Excel tutorials > Graphs - Difficulty:
Chart Printing
Chart Printing
Depends on the type of chart you've created. You can print embedded charts either with worksheet data or on their own. Standalone charts, which occupy separate worksheets, always print on separate pages.
Category: Excel tutorials > Graphs - Difficulty:
Basic Tasks with Charts
Basic Tasks with Charts
Charts float above your data, locked inside special box-like containers. To take advantage of these chart boxes, you need to understand a little more about how they work.
Category: Excel tutorials > Graphs - Difficulty:
What Is a Chart?
What Is a Chart?
A chart is a visual representation of numeric values. Charts (also known as graphs) have been an integral part of spreadsheets since the early days of Lotus 1-2-3.
Category: Excel tutorials > Graphs - Difficulty:
Formulas and Functions
Formulas and Functions
Formulas and worksheet functions are essential to manipulating data and obtaining useful information from the Excel workbooks. This tutorial present a wide variety of formula examples that uses many of Excel's functions.
Category: Excel tutorials > Functions - Difficulty:
Style Formatting
Style Formatting
MS Office styles are pre-selected combination of colors, fonts, and effects that you can apply to a workbook. Use styles to give your work a particular look: professional, playful, or creative.
Category: Excel tutorials > Formatting - Difficulty:
Whats New in Excel 2007
Whats New in Excel 2007
This tutorial is for you if you've used a previous version of Excel. Here you'll find an overview of what's new and what's changed in Excel 2007.
Category: Excel tutorials > Basics - Difficulty:
Customizing the Excel Menus and Toolbars
Customizing the Excel Menus and Toolbars
Customizing the Excel toolbars and pulldown menus. Taking the time to get the Excel toolbars and the pull-down menus the way you want them saves your valuable time when creating and editing your spreadsheets.
Category: Excel tutorials > Basics - Difficulty:
Worksheet Basics
Worksheet Basics
Learn what Excel is used for, parts of Excel's window, Ribbon user interface, shortcut menus, dialog boxes and how to navigate Excel worksheets.
Category: Excel tutorials > Basics - Difficulty:
Total Tutorials in Category: 216