Articles Index
Calculate Your Current Age with the Excel DATEDIF Function
The NETWORKDAYS function can be used to calculate the number of whole working days between two dates in Excel. This tutorial includes a step by step example of how to calculate the number of days between two dates in Excel using the NETWORKDAYS function.
Calculate the Difference Between Two Dates in Excel
The NETWORKDAYS function can be used to calculate the number of whole working days between two dates in Excel. This tutorial includes a step by step example of how to calculate the number of days between two dates in Excel using the NETWORKDAYS function.
Step by Step Excel 2003 Bar Graph Tutorial
This tutorial covers creating a bar graph in Microsoft Excel. This tutorial covers all the steps necessary for creating a bar graph using the Chart Wizard. The tutorial begins by discussing the best practices for entering the data and then walks you through each of the four screens of the Chart Wizard.
Excel Hi-Lo-Close Stock Market Chart Tutorial
This tutorial covers creating a Hi-Lo-Close stock market chart in Microsoft Excel. The tutorial includes a step by step example of creating a Hi-Lo-Close stock market chart in the latest version of Excel.
Excel 2010 Sparklines Tutorial
This tutorial covers how to create sparklines in Excel. The tutorial includes a step by step example of how to create sparklines in Excel.
Excel Sparklines Overview
What are sparklines? This overview covers the different types of sparklines in Excel. Links to a step by step tutorial of how to create sparklines in Excel.
Save in Excel Using Shortcut Keys
This Excel shortcut covers how to save an Excel file using a keyboard shortcut. This tutorial includes instructions on how to save an Excel file using a keyboard shortcut.
Microsoft Excel 2007 / 2010 Step by Step Database Tutorial
This tutorial covers how to create a database in Microsoft Excel 2007. The step by step tutorial includes an example for you to work along with.
Excel 2003 Step by Step Database Tutorial
This step by step tutorial shows you how to create a database in Excel 2003. The tutorial covers entering data, creating the database, and using the built in sorting and filter tools.
Excel IF Function Step by Step Tutorial
Excel’s IF function can be used to determine if a specified condition is true or false. The function will return different data depending on the answer. This tutorial includes a step by step example of how to use Excel's IF function.
Basic Excel Formulas Tutorial
This tutorial covers creating a basic spreadsheet in Excel 2010. The topics covered include how to enter data, add rows and creating and using formulas and functions.
Parts of the Excel 2007 Screen
This labeled picture shows the main parts of the Micorosft Excel 2007 screen. Components include the Office button, ribbons, active cell, name box, column letter, row number, formula bar and sheet tabs.
Parts of the Microsoft Excel 2003 Screen
This labeled picture shows the main parts of the Microsoft Excel 2003 spreadsheet work area. Components include the active cell, name box, column letter, row number, formula bar and sheet tabs.
Parts of the Excel 2010 Screen
This labeled picture shows the main parts of the Microsoft Excel screen. Descriptions of each of the screen parts is included.
Add Hyperlinks and Bookmarks in Excel
This tutorial covers how to add a hyperlink to separate Excel files. The tutorial includes a step by step example of how to add a hyperlink to separate Excel files.
Sum Data in Excel Using Shortcut Keys
This Excel shortcut covers how to save an Excel file using a keyboard shortcut. This tutorial includes instructions on how to save an Excel file using a keyboard shortcut.
Selecting Non-Adjacent Cells in Excel Using Shortcut Keys
This Excel keyboard shortcut covers how to select non-adjacent cells in Excel using just the keyboard
Calculate a Project End Date in Excel
Use Excel's WORKDAY.INTL function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example of how to find the start or end date of a project given a set number of work days using the WORKDAY.INTL function.
Find the Start or End Date of a Project in Excel
Use Excel's WORKDAY function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example of how to find the start or end date of a project given a set number of work days using the WORKDAY function.
SUM and AutoSUM Step by Step Tutorial
The Excel SUM function is probably the most often used function in Excel spreadsheets. A short cut to using the SUM function is the Auto SUM button. This step by step tutorial walks through how to use Excel's SUM function and the Auto SUM feature to perform spreadsheet calculations.
Excel 2010 WORKDAY.INTL Function Quick Tutorial
Use Excel's WORKDAY.INTL function to find the start or end date of a project given a set number of work days. This tutorial includes a step by step example of how to find the start or end date of a project given a set number of work days using the WORKDAY.INTL function.
Calculate a Project End Date in Excel
The NETWORKDAYS.INTL function can be used to calculate the number of days between two dates in Excel 2010. This tutorial includes a step by step example of how to calculate the number of days between two dates in Excel using the NETWORKDAYS function.
Remove Duplicate Data Records in Excel Part 1
This tutorial shows you how to remove rows of duplicate data or records from an Excel database. The tutorial also includes a step by step example of how to remove duplicate data records in Excel.
Basic Excel Ecourse Tutorial Step 13
Shading alternate rows in Excel using Conditional Formatting. This step by step tutorial includes a step by step example showing how to use conditional formatting for shading alternate rows in Excel.
Calculate a Project End Date in Excel
The NETWORKDAYS.INTL function can be used to calculate the number of days between two dates in Excel 2010. This tutorial includes a step by step example of how to calculate the number of days between two dates in Excel using the NETWORKDAYS function.