Fundamentals of Data Analytics

This course provides an introduction to the fundamental concepts of data analytics using Excel. Participants will learn how to manipulate and analyze data to make informed decisions. This course is ideal for beginners with little to no experience in data analytics.

Before the analytics content, we provide an Excel Primer that is often requested and much needed by many. We review Excel basics like understanding workbooks, worksheets and navigating the ribbon. We discuss common formulas and functions and applying the very popular Excel Keyboard tricks, tips and shortcuts.

Then, we introduce our approach to data analytics that can be scaled up or down, based on the project scope. We take a deeper dive into all the popular introductory topics such as creating tables, sorting and filtering. We include discussions and activities around other popular topics such as VLOOKUP, Pivot tables, data visualizations (charting) and many other interesting topics.

Key Learning Objectives

• Provide an important overview (refresher) on Excel basics
• Introduce a practical, effective approach to Data Analytics
• Share comprehensive coverage on key, introductory topics
• Show how concepts can be used for data-driven decisions
• Demonstrate how to apply concepts to real-world problems
• Reinforce concepts with discussions, labs (individual and group)

About the Instructor, Delores Cephus:

• Associated with Korn Ferry and affiliates for about 20 years
• Performed in the role of instructor, coach, SME, facilitator
• Curriculums: Information Technology, Data Modeling, Inter-personal skills, Leadership, Agile, Lean and many others
• B. S. Degree in Computer Science; minor in Mathematics
• Professional certifications: Data Modeling, Data Analytics, Coaching, Facilitation and Training, Process Improvement, Quality Improvement and many others.
• President of Michigan-based training company