The objective of the workshop is to familiarize the participants with the fundamentals of how to manage, transform and analyze data using the various functions and the power of Microsoft Excel. Excel is a very widely used tool with many organizations and departments and being able to produce a quick analysis is an asset. Participants will learn how to use Excel as a data source and a tool to manipulate data.
With the basic knowledge of computers and a love for analysis, learn how Excel can help you build data analytics systems for your organization.
Learn In No Time
Creating Pivot Tables
Sorting and Filtering Pivot Tables
Formatting Pivot Tables
Creating Pivot Charts
IF and Related Functions
Lookup and Reference Functions
Power Functions, Statistical Functions
Date and Time Functions
Creating Basic Charts
Style Charts with Design Tabs
Fine Tune Chart Elements
Installing Data Analysis Tool
Goal Seeker & Solver
Depicting the insights from your data in the best possible manner is very important to any organization. This course provides an intensive hands on training on PowerBI for storytelling and analytics!
Depicting the insights from your data in the best possible manner is very important to any organization. This course provides an intensive hands on training on Tableau for storytelling and analytics!
It's time to upskill for the Industry 4.0