Bestbuy eBooks - Business Data Analysis With 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

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 ...

Click here for full Business Data Analysis With Excel. details!