Here is what you will find in the

Tutorial Package on Excel Functions and Formulas

The package includes a set of 38 lessons that you can surf and search easily on your own computer.

It also includes 20 Excel Spreadsheets with useful examples and templates. You can use the spreadsheets or copy/paste everything from them to your own spreadsheets. Nothings is hidden, nothing is protected. You will find simple solutions even to complex problems.

The tutorial itself is divided in three sections and is easily searchable.

Section 1: Excel Functionalities to Import and Analyze Data

This section is divided in 13 lessons.

First let's review the all automated ways to import data into your Excel spreadsheet. Then we rediscover the very powerful and simple tools to analyse the data including the database functionalities that allow you to filter and sort the data. Discover the calculator and how to look at the data from two programs, 2 spreadsheets and even two sheets from a single spreadsheet on the same screen. Compare the data and copy/paste some on the single screen.

The ten lessons in section 1: General Excel Tips - CTRL, ALT Function Keys - External Data - Importing External Data in Excel - Import Wizard - Calculator - Comparative Analysis - Excel Databases - Sorting Data - Filtering Data - Database - Database Subtotals and Outlines - Database Form - Pivot Tables

Section 2: Reporting with Excel

This section is divided in 7 lessons.

The report is the ultimate communication tool to show the results of your analysis. They need to be automated and the layout needs to be perfect for your readers. No compromise. Discover hyperlinks, text boxes, conditional formatting, the drop-down lists to create dynamic reports, the charts and the camera that allows you to take pictures of different reports and assemble them on a single sheet (Dashboards).

The seven lessons in section 2: General Reporting Tips - Drop-Down Lists - Conditional Formatting - Hyperlinks - Text Boxes - Charts - Camera and Dashboards

Section 3: Excel Functions and Formulas

This section is divided in 18 lessons.

Functions and formulas to extract information from the data. The most powerful of them all being SUMPRODUCT. What Microsoft Excel's help tells you about it is a very small fraction of what can be achieved with it. Rediscover the 40 functions that are really useful (out of 328).

The seven lessons in section 3: General Excel Tips Functions and Formulas - Naming Fields - Signs and Formulas - Absolute and Relative References - ISERROR Function - SUBTOTAL Function - SUMPRODUCT Function - INDEX/MATCH Formulas - Date & Time Functions and Formulas - Financial Functions and Formulas - Information Functions and Formulas - Logical Functions and Formulas - LookUp & Reference Functions and Formulas - Math & Trig Functions and Formulas - Statistical Functions and Formulas - Text Functions and Formulas - Array Formulas - Obsolete Functions