Description
Building a Budget
Take your Excel skills to the next level with this practical, construction-focused intermediate course. Designed for professionals who already understand the basics, this session focuses on customizing Excel for your workflow, working with tables, and applying key tools that improve accuracy and efficiency. Participants will learn how to use powerful features such as Flash Fill, Absolute and Relative References, and smart formatting to build clear, reliable budgets. By the end of the course, you’ll have created a fully functional budget worksheet while learning the time-saving techniques and formatting principles that help ensure consistency and clarity in every project report.
• Customize Excel options and views
- Set up Set up the Quick Access Toolbar
- Using the new Focus Cell feature
- Using the new navigation features
• Building basic functions
• Tables
- Create and manipulate tables
- Adding, Sorting, Shifting Columns and Rows
- Using Autofill and understanding options
- Using Flashfill
- Filter and sort data
• Building a Budget
- Understanding key principles in set up
- Applying Flash fill
- Building basic functions
- Understanding Absolute and relative References
• Formatting
- Applying formats and colors
- Selecting tips
- Using Go To Command
• Understanding printing options
- Repeat rows and columns across pages
- Setting the print area
- Adding custom headers and footers
Delivery Method: Virtual Session – Zoom Meetings
Course Fee Includes: Access to the course, course materials, and a digital certificate upon completion.
This course is delivered in partnership with local and provincial construction associations across Canada. You will be participating with a group of industry peers from multiple regions.
Sharing a single registration between two or more individuals is not permitted. Please register each person that will be in attendance.
For support or inquiries, please email [email protected] or call 604-293-2339.
| Ticket | Price | ||||||||
| Fees |
|
|
9:00am - 1:00pm
|
Course
|
Refund Policy
COURSE REGISTRATION CANCELLATIONS, TRANSFERS & REFUNDS:
Cancellations received at least 14 business days prior to the course will result in a full refund.
Cancellations received less than 14 business days but more than 7 full business days prior to the course are subject to an administration fee of $100 per day for full and half-day seminars, or $25 for breakfast sessions.
Registrants who do not show up for a course, and/or who do not notify CITN at least 7 full business days prior to the course date will be assessed the full cost of the course. There will be no refunds or credits in this case.
Substitution of attendees is permitted up to and including the day of the course.
COURSE CANCELLATION BY CITN:
CITN may have to postpone or cancel courses due to insufficient enrolment, in which case CITN’s liability will be limited to a refund of the registration fee.