Overview

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:

Topics

Advanced

1. Project Forms for Estimating, Costing
• Industry Best Practices for Creating Professional Forms
• Developing “what if” analysis for estimates and project plans
2. File Security
• Locking Cells
• Protecting Worksheets
• Protecting Data
3. Creating Forms (Estimate Sheets, Production Calculations)
4. • Data Validation
   • If Statements
   • Date Functions
   • LookUps (Vlookup, Match, Hlookup, Index)
5. Helping Users
• Comments
• Naming
6. 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

Cost of this course is $470 + applicable taxes for Canadian Customers Only and the course runs from 1:00 p.m. to 4:00 p.m. Eastern Time

Schedule