Microsoft Excel Tips

Microsoft Excel Spreadsheets

Microsoft Excel Tips

Free Excel
Spreadsheets Tips

Free Excel
VBA (macros) Tips

Excel & Macros
Tutorials

Contacts and Consulting

 

IMPORTANT IMPORTANT IMPORTANT
This is the NON-MEMBERS site
All links points toward a new introductory site

  

Record and test your first macro
A step by step exercise

  

Free Microsoft Excel Tips
Table of Contents

General Microsoft Excel Tips

 

Things you need to learn about Microsoft Excel to work faster and better.

Excel Functions and Formulas (14 pages)

 

What Microsoft Excel is all about. Work with numbers, text (strings) and dates. Assemble functions and create formulas.

External Data

 

How to bring external data within Microsoft Excel and reformat them to make them usable. How to use Excel to reformat data and uplooad them into your central database or application (accounting, manufacturing, sales, finance, etc...)

It is not how much you know about Excel that is important
It is how well you know Excel

Reporting with Microsoft Excel

 

Data is to the enterprise what weapons are for the army, if you supply only the generals and not the soldiers, you lose the war.

Microsoft Excel as a Database

 

Excel can be great database but its strenght resides in its power to transform data from any database into efficient and automated reports even without macros (VBA).

The Database Functions in Microsoft Excel

 

Sort, Filter (Auto filter and Advance Filters), the Form and the Subtotals.

Charts

 

A few tips on charts.

Pivot Tables

 

They are not for everybody but they can be very useful. First, learn about SUMPRODUCT and INDEX/MATCH formulas and database filters.

 

Microsoft Excel Spreadsheets

Microsoft Excel Tips

Free Excel
Spreadsheets Tips

Free Excel
VBA (macros) Tips

Excel & Macros
Tutorials

Contacts and Consulting

Other Resources on Excel and Macros