Last updated: 8/2008

Tips and Help on Excel and VBA for Excel (Macros)

Home Page
Excel is the most powerful business data analysis and reporting program

Hundreds of FREE Tips on Excel
Table of Contents
Hundreds of FREE Tips on Macros
Table of Contents
Excel and VBA Consulting
Contacts

Come talk about Excel on dbforums

Help and Tips on Excel: The Table of contents

Help and Tips on Excel: Search by Keyword

Help and Tips on VBA for Excel (macros): The Table of contents

Help and Tips on VBA for Excel (macros): Search by Keyword

Don't leave this website empty handed
5 easy and very helpful Excel tips

The Google Adwords Entry Page

Help and Tips on Excel
Table of Contents

Help and Tips on Excel
Excel Functionalities
Excel Section 1: Introduction and General Tips on Excel

What do you really need to know in Excel?

Excel Section 1A: General Tips
Excel Section 1B: Drop-Down Lists
Excel Section 1C: CTRL, ALT and Functions Keys

Excel Section 2: External Data

You can key it in, copy/paste it from all kinds of sources and you can import all kinds of data from all kinds of other file types, programs and databases in Excel.

Excel Section 2A: The Import Wizard
Excel Section 2B: Importing Data

Help and Tips on Excel
Analyzing Data
Excel Section 3: Analysing Data Dynamically

Once the data is within the Excel workbook the adventure begins. You begin by validating the data and then you start analyzing it.

Excel Section 3A: The Calculator
Excel Section 3B: Comparative Analyses

Excel Section 4: Database Functionalities

When Excel recognizes your set of data as a database you get access to powerful functionalities to validate, organize and analyse your data dynamically. Excel is a very interesting database application that doesn't require you to go through an extensive training.

Excel Section 4A: Database Form
Excel Section 4B: Subtotals of Data
Excel Section 4C: Pivot Tables

Excel Section 5: Sorting Data

A very basic yet powerful tool to analyse the data

Excel Section 6: Filtering Data

Extracting segments of data at the click of a button.

Help and Tips on Excel
Reporting with Excel
Excel Section 7: Reporting with Excel

Excel is the MOST USER FRIENDLY, the MOST CUSTOMIZABLE reporting application. With Excel you can develop extremely powerful analyses and have AUTOMATED reports refer to them. To enhance the presentation of your reports, to make the surfing easier...to make things sexier here are 3 interesting tools:
Excel Section 7A: Excel Conditional Formatting
Excel Section 7B: Excel Hyperlinks
Excel Section 7C: Excel Text Boxes

Plus more than 20 sections on Excel Functions and Formulas

Excel Functions and Formulas Section 8: Introduction and General Tips on Functions and Formulas, Excel Functions and Formulas Section 8A: General Tips, Excel Functions and Formulas Section 8B: Naming Fields, Excel Functions and Formulas Section 9: Signs and Formulas, Excel Functions and Formulas Excel 10: IF/ISERROR Formulas , Excel Functions and Formulas Section 11: Dollar Sign ($), Excel Functions and Formulas Section 12: SUBTOTAL Function, Excel Functions and Formulas Section 13: SUMPRODUCT Function, Excel Functions and Formulas Section 14: INDEX/MATCH Formulas, Excel Functions and Formulas Section 15: Date and Time Formulas, Excel Functions and Formulas Section 16: Financial Formulas, Excel Functions and Formulas Section 17: Information Formulas, Excel Functions and Formulas Section 18: Logical Formulas, Excel Functions and Formulas Section 19: LookUp and Reference Formulas, Excel Lesson 19A - Excel HLOOKUP Function, Excel Lesson 19B - Excel LOOKUP Function, Excel Lesson 19C - Excel VLOOKUP Function, Excel Functions and Formulas Section 20: Math and Trig Formulas, Excel Lesson 20A - Excel SUMIF Function, Excel Functions and Formulas Section 21: Statistical Formulas, Excel Section 21A - Excel COUNTIF Function, Excel Functions and Formulas Section 22: Text Formulas, Excel Functions and Formulas Section 23: Array Formulas

Help and Tips on VBA for Excel (Macros)
Table of Contents

VBA for Excel Tutorial: Introduction
Excel Macros Section 1: Introduction

Elements of history to tell you where VBA comes from, who should learn VB or VBA and why.

Excel Macros Section 2: Excel Macros Vocabulary

In English you have nouns, verbs, adjectives...in VBA you have objects, properties, methods and events. Learning about these terms helps you understand how VBA works.

VBA for Excel Tutorial: The Programming Tools
Excel Macros Section 3: Visual Basic Editor (VBE)

The most user friendly programming environment. You will create your procedures (macros) and userforms in the VBE. You will modify and test these components and even make changes while you are testing your procedures step by step.

Excel Macros Section 3A: The Project Window in the Visual Basic Editor of Excel
Excel Macros Section 3B: The Properties Window in the Visual Basic Editor of Excel
Excel Macros Section 3C: The Code Window in the Visual Basic Editor of Excel

Excel Macros Section 4: Creating Macros in the VBE

You are becoming so good that you don't need the macro recorder sometimes. Here is how you create a new VBA procedure from scratch.

Excel Macros Section 5: Testing Macros in the VBE

Split your screen, use the F8* key and see what you procedure does in Excel step by step. Back up, correct and re-test.

Excel Macros Section 6: Modifying Macros in the VBE

The macro recorder is a great helper and teacher but sometimes it makes things complicated. Here is a recorded macro simplified.

Excel Macros Section 7: VBA Security and Protection

Protect you code, your sheets and your computer.

Excel Macros Section 8: Excel Macro Recorder

You can use the recorder to develop macros rapidly. If you want to do more the Macro Recorder is the best teacher and will be a great assistant even when you become an expert at programming in VBA. It WRITES the code for you. In this chapter you will learn about and try the Macro Recorder. You will run the macro that you have recorded.

Excel Macros Section 9: VBA Events

For a procedure to start it must be triggered, you click on a button, you close a workbook, the value of a cell changes...find the right event.

Plus more than 20 sections on VBA Code and Forms

Excel Macros Section 10: Code in VBA for Excel, Excel Macros Section 11: Code for Errors, Excel Macros Section 12: Code for the Application, Excel Macros Section 13: Code for the Workbooks, Excel Macros Section 14: Code for the Worksheets, Excel Macros Section 15: Code for the Cells and Ranges, Excel Macros Section 16: Code for Message and Input Boxes, Excel Macros Section 17: Code for Excel Database and Filters, Excel Macros Section 18: Code for Variables, Excel Macros Section 19: Code for Statements, Excel Macros Section 20: Code for Functions, Excel Macros Section 21: Code for SQL, Excel Macros Section 22: Code for API, Excel Macros Section 23: Creating Userforms and Adding Controls, Excel Macros Section 23A: Userforms Properties and VBA Code, Excel Macros Section 24: Excel VBA Controls' Properties and VBA Code, VBA Section 24A of 24: Properties and VBA code for Command Buttons, VBA Section 24B of 24: Properties and VBA code for Labels, VBA Section 24C of 24: Properties and VBA code for Text Boxes, VBA Section 24D of 24: Properties and VBA code for Combo Boxes, VBA Section 24E of 24: Properties and VBA code for List Boxes, VBA Section 24F of 24: Properties and VBA code for Check Boxes, Option Buttons and Frames, VBA Section 24G of 24: Properties and VBA code for Spin Buttons, VBA Section 24H of 24: Properties and VBA code for Multi Pages

Ideas and reflexions on working with business data

Excel or Access
Database 101
Excel as Database
Excel and Database
Excel and Money