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:
Excel Error Checking to Your Needs
Excel Error Checking to Your Needs
Anyone with any experience building Excel worksheets knows that formula errors, the bane of all spreadsheets, are inevitable. Whenever Excel cannot successfully calculate one of your formulas according to its internal rules.
Difficulty:
Set your Spreadsheet Workspace
Set your Spreadsheet Workspace
An Excel workspace (sometimes known as an arranged workspace) is really just a special file that keeps a record of all the workbooks open at the time you save the workspace.
Difficulty:
Saving Your Worksheets So You Can Find Them
Saving Your Worksheets So You Can Find Them
This technique concentrates on ways you can minimize the annoyance of not knowing where you saved a new workbook file.
Difficulty:
Streamlining Excel Program Startup
Streamlining Excel Program Startup
Quick-and-easy ways to launch the Excel program. Although the procedures outlined in this technique may seem really simple.
Difficulty:
Excel Editing Settings
Excel Editing Settings
This technique begins by covering how and when to change the direction in which the cell pointer moves when you press Enter and then gives you the lowdown on why you might want to disable the AutoComplete feature.
Difficulty:
Saving Time with Excel Add-ins
Saving Time with Excel Add-ins
Excel add-in programs provide a quick-and-easy way to extend the basic features of Excel. Most of the add-in programs created for Excel offer you some kind of specialized function or group of functions that extend Excel's computational abilities.
Difficulty:
Refining Excel Worksheet
Refining Excel Worksheet
This tutorial describes how to move, delete, and rename worksheets, as well as protect them from being edited or altered.
Difficulty:
Creating Excel Custom Controls
Creating Excel Custom Controls
The rest of this tutorial takes you through the three most common control types supported by the Ribbon interface: buttons, menus, and split buttons. You'll learn the RibbonX XML code required to add and configure each control, as well as the VBA code nee
Difficulty:
MS-Excel Formulas
MS-Excel Formulas
Excel can manipulate your data by using formulas. Formulas can be as simple as adding two or more numbers together or as complicated as determining the calculation of a second-order differential equation.
Difficulty:
Customizing the Office 2007 Ribbon
Customizing the Office 2007 Ribbon
This tutorial presents some techniques for making your macros more accessible. Learn how to enable your users to use familiar tools-namely, the Office 2007 Ribbon and its tabs, groups, and various buttons to run your macros.
Difficulty:
Prevent Case Sensitivity in VBA Code
Prevent Case Sensitivity in VBA Code
By default, Excel VBA code is case sensitive and uses what is known as binary comparisons. This means that it sees Cat and cat as two different words.
Difficulty:
Display AutoFilter Criteria
Display AutoFilter Criteria
Use a custom function to display the criteria used for any column in a table with an AutoFilter applied.
Difficulty:
Force Text to Upper- or Proper Case
Force Text to Upper- or Proper Case
Restrict all future entries in a spreadsheet or range of cells to uppercase or proper case only.
Difficulty:
Change Text to Upper- or Proper Case
Change Text to Upper- or Proper Case
When using a built-in Excel function is impractical, you can use a custom macro to change any existing text to uppercase or proper case.
Difficulty:
Track and Report Changes in Excel
Track and Report Changes in Excel
To overcome the limitations of the Track Changes feature, you can employ some help from Excel VBA and Excel's Change Events feature.
Difficulty:
Total Tutorials in Category: 585