Stat Modeller

Organizer

Stat Modeller
Email
marketing@statmodeller.com
Register Now

Local Time

  • Timezone: Asia/Kolkata
  • Date: Jan 22 2022 - Feb 27 2022
  • Time: 7:00 pm - 10:00 pm
Category

Date

Jan 22 2022 - Feb 27 2022
Expired!

Time

7:00 pm - 10:00 pm

Cost

INR7,999.00

MS Excel Mastery Course

About this Course

You might be loved to highlight some of your skills with your team and management to shape your career and become more productive.

Shape and align your mind with infinite creativity which can be crafted using Microsoft Excel.

Ultimately, this course will help you to think out of the box to convert your data into decision-making through practising data summarization and visualization skills.

Duration

  • 40+ hours of content including exercises and assignments (6 Weeks)

Schedule

  • Date: Starting from 22nd January 2022 (Every Saturday and Sunday)
  • Saturday – 7:00 PM to 10:00 PM (IST)
  • Sunday – 10:00 AM to 1:00 PM (IST)

Benefits

  • Absolutely Suitable for Beginners
  • Practical Examples for all the concepts
  • Experienced faculty
  • Soft-copy of Material
  • Access to Session Recording for 6 months
  • Email support after training
  • E-Certificate
Register Now

 

Content

  1. Excel Overview
    • Excel History
    • Usages & Benefits of Excel
    • Excel Detail Interface (Customization of Interface)
    • Different File Extensions
    • Different Cell Content
  2. Excel BASICS
    • Understanding Cells & Renaming Cells / Range
    • Basic Formulas (Number, Text, Date, Time)
    • Cell Reference Concept
    • Sorting & Filtering Data (Routine Sorting, Horizontal, Case Sensitive, Custom Sort)
    • Find & Replace (+Advanced Option)
    • Page Layout & Print Setting
  3. Excel Formatting & input controls
    • Tour of Conditional Formatting
    • Formatting Multiple sheets
    • Data Cleaning & Input controls using Data Tools (Text to Columns, Flash Fill, Remove Duplicate, Data Validation)
  4. Live project sharing & self-exercise
    • Live project sharing for hands-on awareness of learned tools.
    • Compulsory self-exercise assignment.
  5. ADVANCED FORMULAS PART – 1
    • Aggregating values with conditions (SUMIF/SUMIFS, COUNTIF/COUNTIFS, AVERAGE/AVERAGEIFS)
    • Logical Testing on data (IF, Nested IF, IFS, AND, OR)
    • Nesting formulas for dynamic result
  6. ADVANCED FORMULAS PART – 2
    • Lookup Functions (Exact / Approximate – Vlookup, Hlookup, Partial Lookup)
    • Advanced Lookup Functions (2 Way Lookup, Index Match Basics)
  7. ADVANCED FORMULAS PART – 3
    • Advanced Lookup Functions – Xlookup, Advance Index Match, Large/Small (Indexing Values), Row/Column (Support Functions for easy reporting)
  8. ADVANCED FORMULAS PART – 4
    • Choose, Switch (Sometimes alternative to IF)
    • N, Transpose, Convert UOM
    • Filter, Sort
  9. SELF EXERCISE – SESSION 2
    • Compulsory self-exercise assignment 2
  10. ADVANCED FORMULAS PART – 5
    • Get PivotTable Data,
    • Indirect (Referring dynamic range)
  11. TIME-SAVING TOOLS
    • Excel Table(s)
    • Converting Raw data into Excel Table
    • Exploring Excel Table
    • Renaming Excel Table
    • Inserting Slicers (Advance Data Filtering Tool)
    • Creating & Summarizing data with Pivot Table
    • Adding fields
    • Modifying Pivot Tables Layouts
    • Altering between different measures
    • Inserting slicers & creating connection(s)
  12. EXCEL CHARTS – BASICS
    • Excel Charts
    • Column Chart, Bar Chart, Pie Chart, Line Graph, Scatter Plot
    • Excel Chart Elements
    • Titles, Data Labels, Design Layout, etc.
  13. EXCEL CHARTS – ADVANCED
    • Excel Charts – Advanced Techniques
    • Adding Total to Stack Column Chart
    • Using Error Bar for better visualization
    • Dynamic Line Chart & Column Chart (Expand & collapse with selection)
    • Conditional Chart + Column Chart for better visualization
  14. PIVOT CHARTS
    • Creating Pivot Charts
    • Line Graph, Column Chart, Bar Graph, Pie Chart
    • Pivot Chart Elements
    • Titles, Data Labels, Design Layout, etc.
  15. DASHBOARD – Theory + Practical
    • 1st Dashboard – Creating Dashboard from scratch (Sales Data)
    • 2nd Dashboard – Creating Dashboard from scratch (Manufacturing Data) Self Practice
    • 3rd Dashboard using Semi-structured Data – Creating Dashboard from scratch (Sales Data – 2 Years)
    • 4th Dashboard – On your Live Data (Self Practice)
Register Now

Video Feedback

YouTube video

YouTube video

Register Now