Microsoft Excel Advanced 2: Database Management and Analysis

Microsoft Excel Advanced 2: Database Management and Analysis

Gold Seal: 1 Credit

Live online events

Discount

2 days, 08:30 AM PST - 12:30 PM PST

Online

Presented by David Poitras
  • Member Rate $275.00 excl. GST
  • $299.00 excl. GST

Description

This interactive, live instructor-led online training course will cover the same content as the in-person course.  All live online courses will be recorded, and participants will have access to the recorded session for 3 months. 

 

Need to do time tracking of various staff on various projects? Need to download reams of data from an online data source? Now you need to make sense of it all! Learn how Excel will capture potential data errors, minimize input errors and then automate the updating of datasets into Excel table and then into Pivot Tables and Pivot Charts. Also learn strategies for collecting and validating data with tables. Understand how to automate the collection and cleaning up of data using Power Query and then how to analyze with Pivot Tables. You’ll also learn how to create dashboards for visually displaying data and using slicers to quickly filter and change graphical reports. Learn to use the new Excel’s Business Intelligence (BI) Tools that can make updating and analyzing data a breeze. 

 

The following list summarizes skills that participants will be comfortable with after this course. 

 

  • Create tables and learn to sort, filter and report on data with a few clicks. 

  • Add data validation, including using pick lists. 

  • Remove duplicate data, circle invalid data. 

  • Use data analysis tool. 

  • Create and modify Pivot Tables. 

  • Create and modify Pivot Charts. 

  • Add calculations and custom functions within a Pivot Table. 

  • Use slicers and filters with Pivot Tables. 

  • Import data with Power Query. 

 

This hands-on course is taught by a certified Microsoft Master Instructor. 

You will need to have Excel 2016 (or newer) program downloaded and installed on computer. The course assumes that students have completed the Microsoft Office Basics course or have equivalent knowledge. The web version will not be suitable.  

 

In order to participate in this course, you will require either two monitors or a second device (tablet) or computer so that you are able to watch the instructor while at the same time practicing and applying the new skills.  

 

Delivery Method: Virtual Session – MS Teams 

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. 

Prerequisites

While there are no official prerequisites for this session, this course assumes that students have completed the Microsoft Excel for Business course or have equivalent basic knowledge of how to use Excel. 

Who Should Attend

This course is ideal for any individuals that are looking to elevate their knowledge to an expert level with working with Excel.

What Previous Participants Have Said

“The course was great. I have already implemented a few things I have learned from the class. Highly recommend for anyone who uses Excel day to day.” 

Technical Requirements

  1. Computer or laptop 

    • This course will involve on-screen interaction with your instructor and classmates, reading/viewing on-screen content (slides or videos), and interacting via typing with questions or responses. For this reason, cell phones will not be adequate.   

    • Windows 10 or Mac iOS  

  2. Software/Programs - Excel 2016 (or newer) program downloaded and installed on the computer. The course assumes that students have completed the Microsoft Office Basics course or have equivalent knowledge. The web version will not be suitable.

  3. Webcam(Mandatory)– in order to engage and collaborate, participants will be expected to have their webcams on for the duration of the class  

  4. Microphone(Mandatory)   

  5. Internet connection - For best results, you will want to ensure you have an internet connection with an upload/download speed of 3-5 Mbps. You can test your internet speed here. The minimum recommended speed is 1.5 Mbps, but anything below 3 Mbps may result in loss of quality or buffering. Ideally hardwired connection versus wireless for stability - connect your computer directly to your router using an ethernet cable, rather than using your home wi-fi.  

  6. A quiet space with minimal distractions - The microphone will be engaged for interactive sessions. Please plan to be fully engaged in the class and clear your work schedule just as you would for the in-class program.    

  7. Comfortable chair