Excel And Basic Statistics
Excel And Basic Statistics Syllabus
Unlock the power of Excel for data analysis, business insights, and statistical calculations. This course is designed for beginners and professionals looking to enhance their Excel skills for real-world applications. You’ll learn everything from basic formulas to advanced analytics, data visualization, and automation.
- Getting Familiar With Excel
- Formulas
- Formula Behavior
- Tables
- Charts
- Other Essential Features
- Practice Exercise: Personal Expense Tracker
- Intro to Movies Dataset
- Cleaning Bad Data
- Combining Data From Two Tables (VLOOKUP)
- Combining Data From Two Tables (INDEXMATCH)
- Combining Data From Two Tables (XLOOKUP)
- Basic Maths to Business Metrics
- Commonly Used Business Metrics (P&L)
- Commonly Used Statistic Concepts (Mean, Median, Mode)
- Used Statistic Concepts (Variance, Standard Deviation)
- Commonly Used Statistic Concepts (Correlation)
- Solve a Real-Time Problem
- What is Power Query
- Cleaning Data In Power Query
- Merging Data in Power Query
- Adding New Columns in Power Query
- Loading Power Query Data to Excel
- Pivot Table Introduction
- Pivot Table For Movie Analytics
- Create Report Using Pivot Table
- Pivot Table Options & Formatting
- Power Pivot & DAX For Powerful Business Reports
- Adding Targets Using Data Modelling in Power Pivot
- Breaking Down Complex Problems
- More Business Metrics and Conditional Formatting
- VBA Basics
- ETL (Extract, Transform and Load Data) in Excel I
- ETL (Extract, Transform and Load Data) in Excel II
- Business Report: Solution Design Thought Process
- Connections Among Tables Using Data Modelling
- Adding a Date Table Using Power Query
- Functional Knowledge: Sales
- Sales Analytics: Creating Customer Performance Report
- User Empathetic Report Design
- Creating Market Performance vs Targets Reported
- Understanding P & L
- Functional Knowledge: Finance
- Adding the Finance Data to the Data Model
- Finance Analytics: P & L by Year Report
- Fine Tuning P & L By Year Report
- Adding Months & Quarters in Data Model
- Finance Analytics: P & L by Months Report
- Fine Tuning P & L By Month Report
- Prioritize Projects
- Create a Project Priority Matrix
- Creates a Scenario Planning Tool
Contact Us
What You’ll Learn
- Excel essentials : Formulas, tables, charts, and core functions
- Data cleaning and transformation using Power Query
- Business mathematics and key statistical concepts
- Creating dynamic reports with Pivot Tables and Power Pivot
- Advanced business analytics in sales and finance
- Real-world applications for decision-making
