- Guaranteed To Run
- All Courses
- ALL MICROSOFT COURSES
- FUNDED COURSES
- SG ENABLE (FUNDED)
- About Us
- Insights
- Rewards Account Login
This course is specially designed for existing users of Microsoft Excel who want to import, manage, and transform data from single or multiple sources and create reports in Excel with Office Excel 365.
Information workers using Microsoft Excel focusing on data management, analysis and reporting.
Participants will gain an understanding of the importance of managing the quality of data that they are working with. They will learn skills on cleaning and transforming data to remove noise. They will also be able to work with data relationships to link multiple datasets together for use later. They will be able to create reports using PivotTables or any other visualization tools. They will then load and present the analysis into the Excel worksheet.
Module 1: Introduction to the Modern Data Analysis Tools in Excel
Module 2: Connect Data from Multiple Sources
Module 3: Transform and Shape Data with Power Query
Module 4: Loading Data
Module 5: Modeling Data with PowerPivot
Module 6: Building Interactive Report Visualizations
Avantus Training began from the need to develop a skilled pool of technology talent for the community; keeping abreast of the constantly evolving IT landscape. Since, we have been recognized for our ability to be a life-long training partner and mentor for every individual.