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

A Decade and Eight of Janeisha Angela
Sat Jul 06 2024 at 12:00 am A Decade and Eight of Janeisha Angela

Camelot Hotel, Mother Ignacia St, Quezon City

Emerald: Emerging Trends in Renal Diseases
Sat Jul 06 2024 at 08:00 am Emerald: Emerging Trends in Renal Diseases

Seda Vertis North, Quezon City

WORKSHOPS
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
Creative Thinking Workshop: Harnessing Creativity and Innovation in the Workplace
Sat Jul 06 2024 at 08:00 am Creative Thinking Workshop: Harnessing Creativity and Innovation in the Workplace

The Symphony Towers at Timog QC

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
Baking and Bakery Shop Operation Seminar
Sat Jul 06 2024 at 10:00 am Baking and Bakery Shop Operation Seminar

Golden Treasure Skills and Development Program

WORKSHOPS
F2F Class: Understanding Strengths & Challenges for Kids
Sat Jul 06 2024 at 10:00 am F2F Class: Understanding Strengths & Challenges for Kids

NBS College

KIDS 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