Course Information
Schedules
- Anytime
Registration period
Year-round Recruitment
Price
-
Course Level
Study Mode
Duration
3 Hour(s)
Language
English
Location
-
23 views
Course Overview
About the Course
What tools does every Data Analysts need to know in Microsoft Excel? Tables, Power
Query 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.
Who is the Target Audience?
Any excel user beginner or advance
Basic Knowledge:
Basic knowledge of using excel
What You’ll Learn
Course Objective :
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!
