Individual Part Course

Course Description

This one-hour course introduces table functions in Excel® and Power BI with specific focus on common formulas,functions and pitfalls in formula implementation. Users will work alongside the instructor to perform exercises as they apply and utilize named ranges and naming conventions to data. 

Learning Objectives

• Understand the applicable Excel® skills that will be required in making the transition to data analyst
• Apply formulas to existing data and debug errors 
• Understand and apply the basics of data cleaning
• Understand the importance of naming conventions in Excel® tables
• Understand the basic formula language and implementation guidance, and apply that guidance to common formulas used in data analytics

Course Description

In this one-hour course you will apply Excel® and Power BI tools and skills directly to tables in Excel®. Work alongside the instructor to create named tables, structure references, enter formulas and prepare the tables for input into Power Query. Then, learn about preparation of descriptive statistics, with emphasis on mean, median and standard errors.

Learning Objectives

• Understandapplicable Excel® skills required in transitioning to data analyst
• Apply these skills to create and structure tables
• Determine the appropriate descriptive statistics to present, and present them in a structured format
• Create structured references and understand their relation to formula creation
• Create formulas and apply troubleshooting techniques to formulas created

Course Description

This one-hour course provides hands-on practice using PivotTables in Excel®. Learn and apply skills to create, structure and analyze data using this powerful tool, including discussing its benefits and limitations.  You will also be introduced to Power Pivot its Online Analytics Processing feature.

Learning Objectives

• Understand the applicable Excel® skills required in making the transition to data analyst
• Understand the uses, benefits and limitations of PivotTables in Excel®
• Apply Excel® skills to create, structure and operate PivotTables using predefined data
• Learn to perform sorting, filtering and calculations within PivotTables
• Understand Online Analytical Processing and when it’s used in Power Pivot

Course Description

This one-hour course focuses primarily on Microsoft® Excel®’s  Power Query, Power Pivot and VLOOKUP feature sets. Users will learn how to join tables using various techniques and add-ons in Excel®, while maintaining data integrity. The majority of the course focuses on hands-on data exercises, as users apply skills like creating relationships and analyzing data with Power Query.

Learning Objectives

• Understand the applicable Excel® skills =required in making the transition to data analyst
• Understand types of data relationships (linear, normal, etc.)
• Learn to apply VLOOKUP and index match formulas in Excel®
• Learn to append and merge multiple data sets
• Create relationships in Power Pivot