MS Excel Expert - Part 3

Description

Creating a Dashboard

 

Turn complex data into clear, interactive visuals with this focused course on dashboard creation. Participants will learn to connect Pivot Charts, slicers, and multiple datasets to design dynamic dashboards that update automatically. You’ll also explore formatting best practices, sharing options, and export techniques to make your reports both functional and visually compelling.

By the end of this two-hour session, you’ll have a professional-quality dashboard ready to share with colleagues or clients—enhancing communication, insight, and decision-making across your organization.

 

• Creating Pivot Charts
• Connecting slicers to multiple data sets
• Create and configure a dashboard
• Formatting the Dashboard
• Share dashboards with your organization
• Print and export dashboards and reports

 

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.

 

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