Data Analysis using MS Excel

Schedule

Sat Jul 06 2024 at 09:00 am to 04:00 pm

UTC+08:00

Location

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH | Quezon City, MM

Advertisement
Use MS Excel as a tool for data analysis. This training focuses on performing descriptive, statistical, and predictive analysis.
This training aims to use MS Excel as a tool for data analysis. This training focuses on performing descriptive analysis, statistical analysis, and predictive analysis using tools such as Forecast, What If Analysis, Analysis Toolpak, and Power Pivot.
VENUE
-Mpower Training Center
-222 Vivaldi Residences, EDSA cor Aurora Blvd.., Cubao, Quezon City
-Bring own laptop
INCLUSIONS
F or onsite:
-printed handout
-printed certificate
-AM and PM snacks
-fastfood lunch
-candies and coffee
-WIFI access
F or via Zoom:
-PDF handout
-PDF certificate
O UTLINE
Part 1. Fundamentals of Data Analytics •Data Analytics Process Flow and Cycle •Types of Data Analytics •Descriptive Analytics •Statistical Analytics •Predictive Analytics Part 2. Deep Dive on PivotTables •Review of Basic Pivot Table Features • Grouping Dates and Text Data • Formatting Numbers • Creating Slicers and Timelines • Changing Data Presentation • Show Values as • Changing Calculation • Creating Formulas: Calculated Fields and Items • Adding Texts in the Pivot Table Value Area Part 3. Data Modeling using Power Query and PowerPivot • Importing Data to Power Pivot • Introduction to Power Query • Choosing Only Needed Columns • Basic Data Wrangling in Power Query • Modifying Text Data • Creating Conditional Columns • Creating PivotTables from PowerPivot • Creating Calculated Columns in a Power Pivot Table • Introduction to DAX Formulas Part 4. Performing Statistical Analysis •. Using the Analysis Toolpak • Descriptive Statistics • Understanding Standard Deviation • Understanding the Empirical Rule (68-95-99.7 Rule) •. Visualizing Data Distribution using Histogram •. Using Skewness and Kurtosis to Analyze Data • Analyzing Variance • Understanding Variance and Formulating the Null Hypothesis • ANOVA Test • Performing F-Test Part 5. Forecasting or Predictive Analysis • Using What If Analysis Tools • Goal Seek and Solver • Scenario Manager • Forecasting Tools in. MS Excel • Types of Forecast: Regression Analysis and Exponential Smoothing • Analyzing Trend using Excel Functions (FORECAST.LINEAR, CORREL, etc.) • Regression Analysis using Analysis Toolpak • Identifying the R-Square ​ • P-Value • Calculating Trend Manually • Presenting Regression using Scatter Chart • Creating a Forecast Sheet (Exponential Smoothing)
Advertisement

Where is it happening?

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH, Philippines

Event Location & Nearby Stays:

Mpower Learning

Host or Publisher Mpower Learning

It's more fun with friends. Share with friends

Discover More Events in Quezon City

AVMOTO Free Suspension Tuning Seminar
Sat Jul 06 2024 at 08:00 am AVMOTO Free Suspension Tuning Seminar

Occupational Safety And Health Center (OSHC), Quezon City

WORKSHOPS
The Komikinang Faire
Sat Jul 06 2024 at 10:00 am The Komikinang Faire

Gt Toyota Asian Center UP Diliman

FESTIVALS
Patrons of the Arts: Originals
Sat Jul 06 2024 at 10:00 am Patrons of the Arts: Originals

Centris Elements

ART
SAM SHOAF LIVE\ud83c\udfa4
Sat Jul 06 2024 at 07:00 pm SAM SHOAF LIVE🎤

Viva Cafe PH

Tampisaww 2024
Sun Jul 07 2024 at 10:00 am Tampisaww 2024

Amoranto Sports Complex

DOG PARADES
Youth Camp 2024: Built Different
Mon Jul 08 2024 at 07:00 am Youth Camp 2024: Built Different

Jesus the Lord of Lords Victorious Church Int'l, 4900 Boac, Philippines

Face to Face Launching at Lipa
Mon Jul 08 2024 at 01:00 pm Face to Face Launching at Lipa

Quezon City, National Capital Region, Philippines, Quezon City, Philippines

Basics of MS Excel
Tue Jun 25 2024 at 08:00 am Basics of MS Excel

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH

WORKSHOPS
Data Analysis using MS Excel
Sat Jul 06 2024 at 09:00 am Data Analysis using MS Excel

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH

PERFORMANCES WORKSHOPS
MS Excel Macros and VBA Programming
Wed Jul 17 2024 at 09:00 am MS Excel Macros and VBA Programming

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH

IT WORKSHOPS
Advanced MS Excel Training
Wed Jul 24 2024 at 09:00 am Advanced MS Excel Training

222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd,Quezon City,1109,PH

WORKSHOPS

What's Happening Next in Quezon City?

Discover Quezon City Events