Microsoft Excel Expert Part 2 - Database Management

David Poitras
Microsoft Master Instructor
PowerConcepts

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!

Through this workshop, you will learn how to use Excel to capture potential data errors and minimize input errors, and then how to automate the updating of datasets into Excel tables, and finally, creating and using Pivot Tables and Pivot Charts. You will 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 how to analyze with Pivot Tables; how to create dashboards for visually displaying data and using slicers to quickly filter and change graphical reports; and how to use the new Excel’s Business Intelligence (BI) Tools to make updating and analyzing data a breeze.

Skills Checklist

The following list summarizes skills that students will be comfortable with after this course:

• Creating tables and learning to sort, filter, and report on data with a few clicks;
• Adding data validation, including using pick lists;
• Removing duplicate data and circling invalid data;
• Using data analysis tool;
• Creating and modifying Pivot Tables;
• Creating and modifying Pivot Charts;
• Adding calculations and custom functions within a Pivot Table;
• Using slicers and filters with Pivot Tables; and
• Importing data with Power Query.

Instructor Bio

David Poitras 

Microsft Master Instructor, PowerConcepts 

David was born and raised in Kelowna. He graduated from Okanagan College in 1992 with a diploma in Computer Informative Systems. Afterwards, he worked in information technology as a programmer for Okanagan College for 5 years and taught various Microsoft programs in Continuing Studies at Okanagan College. He also had his own software development company for 25 years. He built custom Microsoft software solutions for small to midsized companies in the Okanagan and Lower Mainland. He has been teaching at PowerConcepts for many years and has expert knowledge in all Microsoft Applications.