Excel 2007 Advanced Course

Free Spreadsheets & Templates » SpreadsheetsDescriptionDownload Share Trade Tracker A Share Portfolio tracking spreads...

Free Excel Timesheet Record Spreadsheet » This sample spreadsheet can be used as a basic and effective Time recording system for business. Sim...

Excel Bond Calculator » This simple to use template is designed for tracking and reporting Bond portfolios. Perfect for tho...

Free Excel Quote Template » The Free Quote Template provides a simple and effective method to generate quotations for your custo...

Excel Sales Reporting Spreadsheet » This sample demonstrates how useful Excel Pivot Tables and Charts can be for business. It uses sampl...

Free Excel Invoice Template » The Free Invoice Template provides a simple and effective method to generate invoices for your custo...

Free Excel Mortgage Calculator » The Mortgage Calculator is designed to provide a simple yet effective tool for our customers to dete...

Excel Quote Generator » Quote Generator is an Excel Quote Template that provides a simple and effective business tool to cre...

Free Excel Share Trade Tracker » The Free Share Trade Tracker Spreadsheet will help you track the performance of your Share Portfolio...

Free Excel To Do List » The Free Excel To Do List Template will list all the activities in your business and personal life i...

Automating Business Through Excel Soloutions

Share Trade Tracker Pro

Share Trade Tracker Pro is the latest New Product Release from XLAutomation. A simple, easy and effective tool to track and assess the performance of your Share Portfolio.

To find out more about Share Trade Tracker Pro. Click Here

Special Offer !! - For a limited time we are offering a 25% discount off the Share Trade Tracker Pro purchase price. Simply include this coupon code (CPN27416456580) during your checkout and the discount will be applied.

Excel Training

Excel 2007 Advanced Course

USING ONE-INPUT OR TWO-INPUT DATA TABLES / WHAT-IF TABLES

Using a one input Data Table command
Using a two input data table command

A FIRST LOOK AT PIVOT TABLES

Creating a PivotTable
Dropping data into the Pivot Table
Modifying data and refreshing the Pivot Table
Grouping data within a Pivot table

SCENARIOS

Scenario Manager - an example
Showing a scenario
Viewing an alternative scenario
Create a scenario summary

AUDITING

Tracing precedent cells
Tracing the dependants of a cell
Displaying all formulas within a worksheet
Adding comments
Displaying comments
Removing comments
Editing comments

MACROS

Displaying the Developer tab
Recording and running macros
Lowering your macro security level
Customizing the Quick Access Toolbar
Changing the Quick Toolbar Macro icon
Removing a macro icon from the quick access toolbar
Raising your macro security level