Date Time No. of Days Fees (Inclusive Taxes)
24/11/2022 2:00 PM - 5:00 PM 2 5015

Data Analysis using Excel

Introduction

Todays largest and most successful organizations use data to their advantage when making high-impact business decisions.

Data analysis is, at its heart, an attempt to find a pattern within, or correlation between, different data points. Its from these patterns and correlations that insights and conclusions can be drawn.

This workshop will help you to better understand how you can incorporate data analytics into most decision-making processes.

What you will learn : 

  • Learn how to apply data to forecasting, business intelligence, various departments and core strategic goals. 
  • Understand core concepts related to data for decision making such as categories of data, standards, sources, collection, management, and applications. 
  • Identify opportunities to leverage data for your organization and identify the most valuable data types and data sets. 
  • Communicate effectively with senior management and technical staff to apply data-driven strategies within a department 

Course Content 

  • Essential Reporting Requirement Skills

    • Pivot tables and pivot charts
    • Advanced pivot techniques
    • Multiple consolidation ranges
    • Connecting to access databases

    Advanced Data Structuring Techniques

    • Custom and advanced data validation
    • Creating and managing innovative conditional formatting

    Data scenarios summary forecast using what-if analysis 

    Data Analysis & Visualisation 

    • Analyze data and estimate optimal parameter using data analysis tools package and Solver 
    • Numeric data Analysis 
    • Descriptive analysis 
    • Predictive analysis 
    • Categorical data Analysis   
    • Creating dynamic labels
    • Working with formula-driven visualizations
    • Working with sparklines
    • Slicers and timelines
    • Histogram, pareto and Dynamic charts 

    Building Report Solutions

    • Enabling background refresh
    • For m controls data modeling tools
    • Option-button modeling
    • Check-box data models
    • Combo and group-box

     Dashboard and reporting Macros

    • Introduction to Macros
    • Automating reports
    • Dynamic Dashboards using Macros

Resources

Princeton Academy Data Analysis course resources https://princetonacademy.in/resources/

Microsoft 365 – Excel https://www.microsoft.com/en-us/microsoft-365/excel