Open to practitioners from any background who have an interest to learn Data Analysis on Excel
There are no pre-requisites to attend this workshop
+65 8303 9150 / +65 9138 9813
INFO@XALTIUS.TECH
Data Analysis with Excel
This is an intermediate Excel course that takes you through the functionalities of Excel for data management and analysis
What you'll learn
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.
About this course
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
Course Duration
1
Hours
1
Days
Have a look
Course Plan
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
Math Functions
Date and Time Functions
Array Functions
Text Functions
Creating Basic Charts
Style Charts with Design Tabs
Fine Tune Chart Elements
Installing Data Analysis Tool
Goal Seeker & Solver
Histogram
Linear Regression
Looking for something else?
Data Analysis with PowerBI
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!
Data Analysis with Tableau
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!
Data Analysis with MicroStrategy
MicroStrategy platform supports interactive dashboards, scorecards, highly formatted reports, ad-hoc queries, thresholds and alerts, and automated report distribution.