Introduction to MS Excel

Description

No matter what line of work you are in, Excel will be one of the primary tools you will need to use almost everyday. This Introductory course will acquaint you with all the fundamentals of understanding how to use this powerful program including managing the workbooks, navigation, understanding how data should be entered and laid out, key formatting and printing skills.

 

• Understand the screen, Screen Tips and Ribbon
• Managing the Workbook
- Create, edit, save, open and close workbooks
• Managing the worksheet
- Insert or delete rows, columns, or cells
- Rename, insert, delete, copy, or move worksheets
• Entering Data
- Select cells for further action such as formatting, deleting, copying, and pasting
-Using Autofill to copy or fill data or set up a series of data
• Create and edit formulas
• Apply text and numeric formatting
• Formatting the worksheet
• Printing
- Preview and print worksheets and workbooks
- Set headers and footers for a worksheet
- Change margins, orientation, or layouts

 

Delivery Methods: Virtual with Zoom Meetings or In-Person/Classroom delivery available.
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 may 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.

 

 

Similar courses

BC Housing: 2 CPD Points

More Information

BC Housing: 2 CPD Points

More Information

BC Housing: 2 CPD Points

More Information

BC Housing: 2 CPD Points

More Information

BC Housing: 2 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 6.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 6.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7.5 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 4 CPD Points

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credits

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credits * BC Housing: 7 CPD Points

More Information

Gold Seal: 1 Credit

More Information

Gold Seal: 2 Credits

More Information

Customized Managing and Reporting on Multiple Projects

More Information

Gold Seal: 1 Credit

More Information

An introductory course on using Revit MEP to design intelligent building mechanical systems in the context of a Building Information Model.

More Information

Understand foundational concepts and see AI in everyday life

More Information

Explore how AI systems learn, and what automation really means

More Information

See how AI can save time and improve common business tasks

More Information

Getting Started: How to Choose, Use, and Stay Safe

More Information

Gold Seal: 5 Credits

More Information

Tables, Charts & Functions

More Information

*BC Housing: 7 CPD Points

More Information

BC Housing: 7 CPD Points

More Information

This hands-on session is built to close the gap between having Copilot and getting real value from it

More Information

Gold Seal: 1 Credit

More Information

In this course, Excel 365 Essentials, you will learn foundational knowledge of the Excel interface and settings. First, you will learn how to work with the Ribbon interface and Backstage View. Next, you will discover how to work with worksheets, cells, columns and rows. Finally, you will explore how to use formatting and Auto options, as well as how to save your file. When you’re finished with this course, you will have the skills needed to begin creating your own professional spreadsheets.

More Information

In this course, Excel 365 Power Users, you will take your Excel knowledge to the next level. First, you will learn how to format cells with borders, styles, shapes and more. Next, you’ll learn how to work with workbooks, worksheets and data. Then you’ll learn more about printing workbooks (in whole or parts). Finally, you’ll learn about tables and a few advanced functions. When you’re finished with this course, you will have the skills to format and manage more advanced spreadsheets.

More Information

In this course, Excel 365 Pro, you will take your Excel knowledge to the ultimate level. First, you will learn how to format and work with data. Then you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros and form controls. When you’re finished with this course, you will have the skills needed to feel fully complete in creating professional spreadsheets (and complete preparation for the Office exams).

More Information

In this course, Teams Essentials, we will explore the primary aspects of this modern workplace solution from Microsoft. Note: Lessons in this course are meant to be an update of lessons in the current Microsoft Teams course in the library under the Teams channel.

More Information

In this course, Teams Meetings, we will explore the basics of engaging with your team through the meeting feature in Teams. Learn how to schedule a meeting, join a meeting, configure meeting options and more.

More Information

In this course, Copilot for Microsoft 365, you will learn the basics and beyond with Microsoft's virtual AI assistant in Word, Excel, PowerPoint, Outlook, and OneNote.

More Information

In this course, The Fundamentals of Microsoft Copilot, you begin your journey into the world of Microsoft's generative AI (Gen-AI) solution called Microsoft Copilot. You will learn how to "converse" with Copilot and begin using this new tool to help you find, create, design and more.

More Information

In this course, Copilot Prompts for Your Job Role, we dive into the use of Copilot prompts, the Notebook, and individual job roles. We hope this course will help you to excel in your job role using Copilot.

More Information