Do you work with numerical data? Are you interested in reducing the time it takes to produce reports based on that data? If you answered yes to either of these questions, then you will find great benefit in taking this engaging course.

During this course you will learn the tools to help you to better understand your business performance, examine profitability of various jobs and business areas, plan budgets and examine business scenarios all through the use of Microsoft Excel. We will show you how you can simplify the presentation and analysis of complex data.

The course is delivered as a 2- three-hour instructor-led webinar or as a 1-day onsite course. Please contact us if you interested in an onsite course.

This seminar covering the following topics:

Basic - Part 1

Structuring a basic estimate table
Formulas
Filling a series with formulas
Sum totals
Formatting
Simple Graphics
Linking to Word/PowerPoint
Print Layouts
Templating
Recovering Unsaved Files
Duplicating Sheets
Internal linking
Date Functions And Scheduling
Custom Lists
Data Aggregation With Filters/Subtotals/Sumif
Advanced Formulas
Conditional Logic and IF statements

Basic – Part 2

Expense Tracking
Analyzing Budgets and Business Metrics

Analyzing Data
Filters
Subtotals
Pivot Tables

Project Bidding
Incorporating Excel spreadsheets in other documents
Linking and Automatic Updates
Precedents and Dependants

Data Analysis (Production Rates, Progress Tracking, Costing)
Consolidating
Data Validation
If Statements
Vlookup
Conditional Formulas
Conditional Formatting

Creating a simple Gantt Chart for a Schedule

Gold Seal accredited for 2 Special Industry Credit (SIC)                                                                                                                                                                                                                                                                                         

Cancellation Policy

Cancellations will be accepted up to 48 hours before the scheduled start time of the course for a full refund, unless otherwise indicated. Refunds will not be issued once a course has commenced.