Tips and Help on Excel and VBA for Excel
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
When is the last time that you have learned something new on Excel?
Enter this site and be amazed
Hundreds of Free useful and powerful tips
To analyse business data
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 TipsExcel
Section
1B: Drop-Down
ListsExcel
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
WizardExcel
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 CalculatorExcel
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 FormExcel
Section 4B: Subtotals
of DataExcel
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 FormattingExcel
Section
7B: Excel HyperlinksExcel
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 ExcelExcel
Macros Section 3B: The Properties Window in the Visual
Basic Editor of ExcelExcel
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
Links
to other websites on Excel and VBA
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
Discover even more
Tips
and Help on Excel and VBA for Excel
