Skills Checklist
The following list summarizes skills that students 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; and
- Import data with Power Query.
Shawn May
Trainer, PowerConcepts
Shawn began his career with Xerox, gaining unparalleled experience in the technology space, while also establishing himself as a respected analyst/trainer and leader. A dynamic results-driven services and management professional with a proven record of achievement in cross-functional team leadership, services delivery, client relations, and project management he earned a reputation for utilizing creativity, drive, and sound judgment to respond to challenges with solution-oriented ideas. He is now focused on teaching the MS Office Productivity Suite to both corporate and public clients and is currently working as a Trainer for PowerConcepts and is widely known for providing fun, relevant, and meaningful training, while challenging students to apply what they learn. He currently is proud to call Kelowna home, and spends his spare time paddling, skiing, and walking his two dogs.