Management
Star icon
Most Popular
Trending Arrow Icon
Trending
Hands on Training icon
Hands On Training
Star icon
Trending Arrow Icon
Hands on Training icon

3 Essential Excel Skills for Data Analysts

Course Cover
compare button icon

Course Features

icon

Duration

3 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Instructor Paced

icon

Video Content

3 hours

Course Description

What tools does every Data Analysts need to know in Microsoft Excel? Tables, PowerQuery and PivotTables! Tables were introduced in 2010 and, has been one of the best things ever to happen to Excel but, bundling them together with Power Query and Power Pivot makes them even better. You will learn how to quickly slice and dice your data to create impactful and useful information. First, we will discuss the key features of tables and learn several tips and tricks on how to manipulate them and then we will take that date and transform it in Power Query where you will see where all the time savings will be made as we combine multiple CSV files, clean up our data, and automate the entire process for when you get new/updated data. Power Query is a tool that can save you a ton of time with your work by aggregating or summarizing data, unpivot data to use for pivot tables, merge(join) data tables together, combining(appending) data tables, sheets, and workbooks. Once this data is transformed, we will take the data and use in PivotTables. You will see the magic instantly happen and you can instantly get those questions answered about all that data. Finally, a quick way to get those true numbers. If getting data out of your information is a part of your work/life this course is for you.

Course Overview

projects-img

Live Class

projects-img

Human Interaction

projects-img

Personlized Teaching

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Basic knowledge of using excel

What You Will Learn

Turn your data into useful information. Learn how to use Tables, Power Query and Pivot Tables together to quickly transform your data and answer those questions that are necessary to answer for your business

These three tools together will save you an enormous amount of time when it comes to slicing and dicing your data

Truly magical, you will never look at your spreadsheets the same and you will save so much time, you will never be overwhelmed with all that data again!

Target Students

Any excel user beginner or advance

Course Cover