How It Works
2 CEUs, equivalent to 20 Contact Hours/PDUs
Excel is an integral tool in data analytics and visualization. Dive into everything Excel, from cell input to creating pivot tables.
July 6, 2020
MEET YOUR INSTRUCTOR
Dennis McGrath is an engineer with more than 30 years of experience using data to make better decisions. He received both his Bachelor of Science and Master of Arts degrees from Rutgers University. His career spans multiple sectors including government/military, healthcare, finance, and homeland security. As an engineer for the Naval Air Warfare Center and later with Lockheed Martin, he worked with Navy aircraft and ship-based combat systems. As a researcher at Dartmouth College and Norwich University, he was principle investigator for multiple projects investigating technology for infrastructure protection and disaster response. More recently, he has been a consultant to several New England hospitals using Six Sigma methods to spearhead data-driven process improvements.
To truly analyze and create visual data, a deep understanding of Excel is a must. This course will expand your excel toolbox and give you the skills you need to successfully visualize data.
- Cell formats, formulas, functions, sorting
- Data transformation and normalization
- Comparing data, looking up data in related tables
- Filtering, sorting, basic pivot tables, exporting and sharing data
Who Should Register:
- Adults looking to transition into a career in Data Analytics
- Data Analysts who want to advance their skillset
- Anyone who works in a field that relies heavily on data reporting
We provide a more interactive and visually engaging learning experience than you’ll find in many online course environments.
The format of this class is fully online, instructor-led, pass/no pass, and can be taken as part of the certificate or independently. Certificate courses can be taken in any order unless otherwise noted.
You'll experience optional live sessions with your instructor and other experts and have the opportunity to ask questions and discuss the subject.
Learn content deeply through varied case studies, topical readings, infographics and other visuals, and hands-on exercises.
Build your knowledge repository with weekly quizzes, open group discussions, and even the occasional debate.
WHAT YOU’LL NEED TO SUCCEED
Devote 6-8 hours/week
Apply knowledge to your real life
DO THE EXTRA WORK WHEN YOU CAN
Be prepared to learn from each other