Gold Seal has accredited this course for 1 Special Industry Credit (SIC)

---

This seminar is delivered in 2 three hours instructor-led webinars covering the following topics:

Overview

Topics

• 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

1. Expense Tracking
2. Analyzing Budgets and Business Metrics
3. Analyzing Data
• Filters
• Subtotals
• Pivot Tables
4. Project Bidding
• Incorporating Excel spreadsheets in other documents
• Linking and Automatic Updates
• Precedents and Dependants
5. Data Analysis (Production Rates, Progress Tracking, Costing)
6. • Consolidating
   • Data Validation
   • If Statements
   • Vlookup
   • Conditional Formulas
   • Conditional Formatting
7. Creating a simple Gantt Chart for a Schedule

Enrollment is limited to 6 persons to ensure that each participant receives individualized attention. This is a hands-on workshop. We will utilize screen sharing software and file sharing software to present the course and exercises. You may share your screen to get personalized assistance with your work.

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





Schedule

Remote Workshop

Apr 24th, 2024 May 1st, 2024 Instructor-Led Webinar Online Register May 29th, 2024 Jun 5th, 2024 Instructor-Led Webinar Online Register