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

---

Overview

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:

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

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

Remote Workshop

Aug 21st, 2024 Aug 28th, 2024 Instructor-Led Webinar Online Register Sep 11th, 2024 Sep 18th, 2024 Instructor-Led Webinar Online Register