Discover how to capture and link data from different files, track changes, and create simple macros. Become educated in auditing and tracking data and data validation. Understand about file security. These features save hours of manual effort and help keep numbers confidential.

Gain a better comprehension of consolidating data from disparate reports and master the ability to create, analyze, and compare budget scenarios electronically. Discover the capacity to manipulate and analyze databases via pivot tables and to create management analysis reports. Microsoft Excel is an essential tool to learn for anyone tracking data.

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

The course covers the following topics:

Project Forms for Estimating, Costing

Industry Best Practices for Creating Professional Forms
Developing “what if” analysis for estimates and project plans

File Security

Locking Cells
Protecting Worksheets
Protecting Data

Creating Forms (Estimate Sheets, Production Calculations)

Data Validation
If Statements
Date Functions
LookUps (Vlookup, Match, Hlookup, Index)

Helping Users

Comments
Naming

Project Bidding

Incorporating Excel spreadsheets in other documents
Linking and Automatic Updates
Precedents and dependents
Auditing/Verifying information

Macros

How to write a macro and the Developer Tab
Absolute vs Relative references when recording Macros
Storing and Organizing Macros
Editing recorded macros with VBA
VBA code fundamentals

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.