Working with Objects
Many of your VBA procedures will perform calculations using simple combinations of numbers, operators, and the host application's built-in functions. Read more...
MS-Excel Tutorials
Subcategoreis
Excel 2003 Functions and Formula General Formatting Getting Started
Building VBA Expressions
This tutorial takes you through some expression basics and shows you a number of techniques for building powerful expressions using not only variables, but also VBA's built-in functions. Read more...
Understanding Program Variables
This tutorial explains this important topic and shows you how to use variables in your VBA procedures. Read more...
Writing Your Own Macros
This tutorial introduces you to the basics of writing simple procedures and functions, as well as how to get around in the Visual Basic Editor, which is the tool that VBA provides for writing macros by hand. Read more...
Excel Graphics, Shapes WordArt and Text Boxes
Excel has extensive tools for drawing graphic objects. Graphic objects can be functional: You can assign a macro to a graphic object and run the macro by clicking the object. Read more...
The Excel Options Dialog
Microsoft has completely redesigned the Excel Options dialog for Excel 2007 (as it has the Options dialogs for the rest of Office 2007). Read more...
Excel Formula & Functions Basics
Here we are going to learn some basics of MS-Excel Formula and Functions. When you copy a formula, Excel adjusts the formula's cell references when you paste it to a different location. Read more...
Excel Tables
In this tutorial, you'll learn more about what, exactly, a structured table is, how to create one, and how to make use of all its features. Read more...
Excel Formula Tips
In this section, we are going to show you a few tips for formulas. Read more...
Using Ranges names for formulas
Range names are extremely useful not only for documenting the function of the formulas in your worksheet, but also for finding and selecting cell ranges quickly and easily. Read more...
Digital Signature to a Macro
In this lesson I am going to show you how to create a digital signature to a macro and how to assign a digital signature to a macro. Read more...
Excel Relative or Absolute Macro
When recording your actions, Excel normally records absolute references to cells. (This is the default recording mode.) Read more...
Excel Macros
In this tutorial, you get a chance to practice recording, testing, and playing back macros that you use to automate repetitive tasks required when building and using your Excel worksheets and charts. Read more...
Operators in MS-Excel Formulas
An operators is the basic element of a formula. An operator is a symbol that represents an operation. Read more...
Excel 2007 Template
Templates are predesigned and formatted spreadsheets, the provide consistency of layout's structure and save time and repetition of work. Read more...