Microsoft Excel 365 Basics | Live, ONLINE

Learn how to use the basic features and functions of Excel to create and edit basic spreadsheets.

Description

This course is intended for anyone who wants to gain a foundational understanding of Microsoft Excel. In this course, you will learn how to use the basic features and functions of Excel to create and edit basic spreadsheets.

Participants should have a basic knowledge of and experience with Windows, including being able to start programs, switch between programs, locate saved files, and close programs.

To successfully attend this course, students will need a two-screen computer set-up and the desktop version (the web-based version is not suitable) of Microsoft Excel 2016 or newer installed and ready to use.

Course Outline

  • Foundations
    • Getting to know Excel
    • Ribbon/Quick Access Toolbar
    • Getting Help
    • Create a workbook
    • Templates
    • Themes and variants
  • Basic Navigation and Formatting
    • Navigating a workbook
    • Adding worksheets
    • Basic cell formatting
  • Basic Formulas and Functions
    • Order of Operations
    • Using the formula bar
    • Autosum
    • Function wizard
  • Printing Workbooks
    • Page layouts
    • Using page break preview
    • Headers & Footers

Course Format

  • Live, Online, Instructor-led training
  • This workshop is hosted by the instructor on the GotoTraining platform. Access information and any course materials will be provided to you by the instructor via email in advance of the training.
  • This course is delivered in partnership with local construction associations across Canada. You will be participating with a cohort of industry peers from multiple regions.

Course Requirements (Technology & Participation)

In order to attend, you’ll must make sure you have the following:

  • Desktop version of Microsoft Excel 2016 or newer installed and ready to use (web-based version of Excel is not suitable)
  • 2-screen set-up: either two monitors or a second device (tablet or laptop) so you are able to watch the instructor while at the same time practicing skills.
  • Computer or laptop with webcam: This course will involve on-screen interaction with your instructor and classmates, reading/viewing on-screen content like slides or videos, and interacting via typing with questions or responses. For this reason, you must have a full computer/laptop, and we do not permit students to attend using a tablet or cell phone.
  • A quiet space with minimal distractions: Please plan to be fully engaged in the class, and clear your work schedule just as you would for attendance in an in-class program.

Similar events

This course has something for everyone – whether you have years of experience or are new to the industry. Don't be misled by the '101' - over 30% of our course attendees have 10+ years of industry experience! Perfect for procurement professionals and buyers, developing leaders, as well as operations and administrative staff. This course is the industry knowledge boot camp that will support your team's success.

More Information

This short workshop will teach you the basics of construction drawings. You’ll learn about the different types of drawings and how to interpret the different symbols, scales, and notes used in various plans. Perfect for beginners!

More Information

Improve your understanding of construction contracts and contract law in this introductory course. Accessible on desktop, tablet, and mobile devices.

More Information

Learn how to successfully plan, manage, and administer projects from start to finish in this introductory course. Accessible on desktop, tablet, and mobile devices.

More Information

Gain the knowledge and skills required to visualize the scope and magnitude of a construction project and produce accurate and reliable estimates in this introductory course. Accessible on desktop, tablet, and mobile devices.

More Information

Created for the Canadian construction industry. Learn the core principles of ethical behaviour and gain the skills to evaluate situations and make decisions using an ethical framework. Mandatory course for those pursuing Gold Seal Certification.

More Information

Created for the Canadian construction industry. Learn the core principles of ethical behaviour and gain the skills to evaluate situations and make decisions using an ethical framework. Mandatory course for those pursuing Gold Seal Certification.

More Information

Gain the knowledge and skills to create, edit, markup, and collaborate on AEC documents using Bluebeam Revu.

More Information

Improve your efficiency and learn how to create more meaningful and clearer takeoffs using Bluebeam Revu. Not an introductory course, please review Mandatory Prerequisites section before registering.

More Information

Improve your skills in communication and negotiation on construction projects.

More Information

Learn the basics of bonding and insurance in construction.

More Information

Learn how to produce estimates more quickly and accurately by harnessing the power of Microsoft Excel. Appropriate for both novice and experienced Excel users.

More Information

Designed for experienced users as well as newbies – this course will improve your baseline understanding of Bluebeam Revu. You’ll learn interface navigation, keyboard shortcuts and much more! Walk away with tips and tricks to increase your speed and accuracy.

More Information

Build on knowledge gained in Bitesize Bluebeam 1: Baseline Basics. Learn how to turn your highlighters into a data-rich takeoff tool! This session will cover standard measurement tools and settings, various customization options, and the results in the Markups List. *Mandatory Pre-requisite, Bitesize Bluebeam 1: Baseline Basics

More Information

Build on knowledge from Bitesize Bluebeam courses 1 & 2. In this advanced Bluebeam Revu course, you’ll learn custom estimating tools, rich data collection, and how to report and export your data. *Mandatory Pre-requisites, Bitesize Bluebeam 1: Baseline Basics & Bitesize Bluebeam 2: Basic Material Takeoffs & Estimates

More Information

Build on knowledge gained in Bitesize Bluebeam 1: Baseline Basics. Are your drawings a mess with random page labels, no hyperlinks, sheets out of order and all combined in a bloated document? This course will teach you a quick workflow that will fix all these pain points and improve your consistency and accuracy in document management. *Mandatory Pre-requisite, Bitesize Bluebeam 1: Baseline Basics

More Information

Build on knowledge gained in Bitesize Bluebeam 1: Baseline Basics. This course is for design and construction professionals in both the office and jobsite looking for ways to build consistency, speed, and accuracy of data collection. Learn to create and place custom punch symbols, quickly embed images or videos, and create summary reports. *Mandatory Pre-requisite, Bitesize Bluebeam 1: Baseline Basics

More Information

Yes, there are tools in Bluebeam Revu for Civil Designers and Engineers! In this course you will learn navigation and markups, workflows like Calibrating Plan & Profile drawings with different X-Y scales, ideas for Cut & Fill calculations, combining several PDFs into one large area map, and adding images. We’ll also look at ideas for bidding and tracking field survey projects.

More Information

Administrative teams have unique document workflows that demand a different set of tools compared to design and construction teams. A typical Bluebeam class concentrates on design markups, estimating and collecting field data, but this class is very different! In just two hours you’ll be ready to combine documents, mark for redaction, apply digital signatures and several other important administrative tasks.

More Information

Learn the fundamentals of interpreting construction specifications. This course covers the basics of reading and interpreting both general and technical specifications.

More Information

Building on skills learned in Bluebeam Revu: Estimating Level 1, this course is a deeper dive into using Bluebeam Revu for estimating at a more advanced level. Please review Mandatory Prerequisites section before registering.

More Information

This course will give you a deep dive into using Bluebeam Revu as a digital document tool. Built specifically for individuals that have a solid foundation of Revu, this course expands on that knowledge to help you identify changes more easily and create easy to navigate documents with hyperlinks. Please review Recommended Prerequisites & Course Requirements sections before registering.

More Information

This course will give you a deep dive into using Bluebeam Revu as a digital document tool. Built specifically for individuals that have a solid foundation of Revu, this course expands on that knowledge to help you improve your workflow efficiency by utilizing Spaces, Stamps, Digital Signatures, and PDF Forms. Please review Recommended Prerequisites & Course Requirements sections before registering.

More Information

Join us for this free info session on the Bitesize Bluebeam series with our instructor, Troy DeGroot, Bluebeam Certified Consultant, Bluebeam Certified Instructor, and Implementation Specialist. Don't miss this opportunity for a personal introduction to each course and learning objectives. Get your questions answered and help to select the best course for your skillset and workflows.

More Information

Learn how to create and manage project schedules using Microsoft Project 2016.

More Information

Follow-up course to “MS Project 365 Basics.” This is an in-depth course on the features of Microsoft Project and how to use it as a project management tool.

More Information

Due to the complexity of modern-day construction, many projects encounter issues that lead to claims and disputes between the parties. Almost none go according to plan. Knowing how to best prepare for potential claims and disputes; before, during and after the construction phase of a project, is crucial to maximizing the likelihood of recovering damages.

More Information

Are you ready to elevate your career in construction site management? Gain the skills and knowledge you need to excel as a construction site supervisor with our comprehensive course designed specifically for professionals like you. As the backbone of any successful construction project, a competent site supervisor plays a crucial role in ensuring that projects are completed safely, on time, and within budget.

More Information

This 2-part online program is for entry-level architectural or engineering designers, apprentices, entry-level tradespersons, project coordinators, assistant project managers, new project managers, estimators, specialty sales representatives, or anyone in career transition looking for a refresher.

More Information

Unraveling Risk is an exploration of risk management within the landscape of construction contracts and the often-overlooked world of Supplementary Conditions (SCs) in standard contracts such as CCDC and CCA 1.

More Information

How much do you actually know about Indigenous Peoples and issues? Would you like to build a better understanding of some of the issues you hear in the news? If the answer is "yes!" then Indigenous Awareness training can be a helpful way to get off on the right foot. Indigenous Awareness training provided by Indigenous Corporate Training Inc.

More Information

Are you and your team struggling to develop a new set of leaders in today’s challenging talent market? Moving from being an individual contributor to a team leader - whether that’s a site supervisor or project manager - isn’t easy. You need strong communication, delegation, and time management skills, as well as a clear sense of direction. This group coaching course combines management tools and a leadership mindset to equip project managers and people leaders with the skills they need to thrive.

More Information

This course is intended for anyone who wants to gain a foundational understanding of Microsoft Excel. Participants will learn how to use the basic features and functions of Excel to create and edit basic spreadsheets.

More Information