WorkshopIn personPHP 1888.77

Data Analysis using MS Excel

OCT10
08:00
  • This workshop teaches participants how to use Microsoft Excel for data analysis across descriptive, statistical, and predictive techniques.
  • It is designed for professionals and analysts who work with operational or performance data and want to improve their data handling and reporting skills.
  • Attendees will gain practical skills in Excel tools to support business decision-making with real-world datasets.

About this event

This training program positions Microsoft Excel as a practical and powerful data analysis tool for business and operational decision-making. Participants progress from understanding the data analytics process to performing descriptive, statistical, and predictive analysis using built-in Excel tools such as PivotTables, Power Query, Power Pivot, Analysis Toolpak, What-If Analysis, and forecasting functions. The course emphasizes hands-on analysis , proper interpretation of results, and confidence in handling real-world datasets across multiple Excel versions.

Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Office 365, Microsoft 365

By the end of this training, participants will be able to:
Understand the end-to-end data analytics process and distinguish between descriptive, statistical, and predictive analytics
Analyze and summarize large datasets efficiently using advanced PivotTable techniques
Prepare and model data using Power Query and Power Pivot for scalable analysis
Perform statistical analysis using Excel’s Analysis Toolpak and interpret results correctly
Apply forecasting and predictive techniques to identify trends, relationships, and future outcomes
Present analytical results clearly to support business decisions

Who This Course Is For
Professionals involved in reporting, analysis, and decision support
Analysts, supervisors, and managers working with operational or performance data
Excel users who want to move beyond formulas into structured analytics
Teams preparing for advanced reporting, forecasting, or dashboard development

Methodologies
Hands-on analytical exercises using realistic datasets to reinforce concepts in PivotTables, statistics, and forecasting.
Guided interpretation and validation sessions to ensure participants understand results, assumptions, and limitations of each analytical method.

INCLUSIONS
F or onsite:
printed handout
printed certificate
AM and PM snacks
fastfood lunch
candies and coffee
WIFI access
Bring own lapto

More upcoming events in Quezon City

SEPT
18

Root Cause Analysis Fundamentals

Mpower Learning Manila, Quezon City, Philippines
In person
  • This workshop teaches employees and supervisors how to apply root cause analysis to solve workplace problems systematically.
  • Participants learn to identify underlying causes, validate them with data, and develop preventive solutions to avoid recurrence.
  • The workshop is for operational staff and leaders aiming to improve problem-solving through structured methods.
Operators
08:00 · PHP 2098.75 · WorkshopDetails →
SEPT
19

Advanced MS Excel with Copilot Training

Mpower Learning Manila, Quezon City, Philippines
In person
  • This workshop teaches professionals how to improve their Excel skills from basic to advanced levels, including the integration of Microsoft Copilot for enhanced productivity.
  • It is designed for office workers, analysts, and managers who handle data and want to work faster and more confidently.
  • Attendees will learn hands-on techniques to clean, analyze, and visualize data using Excel tools and Copilot features.
AI & Machine LearningHands-OnOperators
08:00 · PHP 1888.77 · WorkshopDetails →
SEPT
25

MS Project Fundamentals

Mpower Learning Manila, Quezon City, Philippines
In person
  • This workshop teaches beginners how to effectively use Microsoft Project for scheduling, resource management, and project monitoring.
  • It is designed for project coordinators, team leaders, administrative staff, and engineers who want practical skills in project planning.
  • Participants learn to create schedules, assign resources, track progress, and generate reports to improve project visibility and decision making.
Hands-OnFirst-Time FoundersOperators
08:00 · PHP 2413.72 · WorkshopDetails →
SEPT
26

Intermediate-Advanced MS Power BI

Mpower Learning Manila, Quezon City, Philippines
In person
  • This workshop enhances Power BI skills beyond the basics by teaching advanced data modeling, DAX calculations, and interactive dashboard design.
  • It is intended for data analysts, business users, and decision-makers who want to improve their report building and visualization capabilities.
  • Participants learn practical techniques to create scalable, insight-driven reports for better business decisions.
SaaS & EnterpriseHands-On
08:00 · PHP 1888.77 · WorkshopDetails →
SEPT
29

Data Visualization and Storytelling

Mpower Learning Manila, Quezon City, Philippines
In person
  • This workshop teaches participants how to create effective data visualizations and tell compelling data stories to support decision-making.
  • It is designed for data analysts, managers, and professionals who need to communicate insights through charts and dashboards.
  • Attendees will learn practical techniques using Excel and PowerPoint to enhance clarity and impact in business presentations.
08:00 · PHP 1888.77 · WorkshopDetails →
OCT
03

PyWorks October 2026: Data and AI w/ RELX

Reed Elsevier Shared Services, Quezon City, Philippines
In person

Hey Pythonistas! Level up your Data & AI game at PyWorks October 2026. This is a full-day workshop designed to level up your Python skills where we ditch the slides and get straight to coding—covering everything from data wrangling to AI-powered automation. Join us on October 3, 2026 at RELX Reed Elsevier, UP Technohub, Quezon City. Whether you're into wrangling data or building AI-powered apps, we've got two parallel tracks lined up just for you: Track 1: Data & Analytics Data-Engineered Analytics: Building Schema-Driven Event Pipelines in Python by Alysson Alvaran – Learn how to transform messy, unstructured JSON logs into clean, query-ready tables using Python, Pydantic, and DuckDB. Weather-Weather Lang: What Can Data Tell Us? by Vanessa Althea Bermudez – Explore a practical machine learning workflow using real-world weather data—from data prep to model evaluation. Track 2: AI & Automation Generative AI and Prompt Engineering by Lee Mark Chavez – Go beyond basic prompts and learn a structured approach that works at scale, with options for both Python and no-code tracks. Intro to Context Engineering: From Strategic Prompting to Building Apps with Low-Code AI by Daniel Caparro – Learn how to turn strategic prompting into functional applications using low-code and generative AI platforms. What to expect: Code-first sessions – This is a workshop, not a lecture. You'll be writing actual Python code throughout the day. Two parallel tracks – Choose the path that fits your interest, whether it's data or AI. Beginner-to-intermediate friendly – Designed for Python users who are ready to take the next step. No prior ML or AI experience required. Logistics: What to bring: Laptop with a power cable (we'll provide WiFi and electricity). Food: Snacks and refreshments will be served. Slots: Limited to ensure an optimal hands-on experience for everyone.

12:00 · Free · WorkshopDetails →
Share this event