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

 

EXCELLENT
15 reviews on
Mohammad Rahil
Mohammad Rahil
2022-04-07
Trustindex verifies that the original source of the review is Google.
Akash Gupta
Akash Gupta
2022-04-07
Trustindex verifies that the original source of the review is Google.
Mihir Gosalia
Mihir Gosalia
2021-11-30
Trustindex verifies that the original source of the review is Google.
Attended virtual training programme on creating interactive dashboard using MS excel. It was really a wonderful experience. Everything about the training programme right from registration to payment to end deliverables / objective of the programme, training material, etc...was so beautifully managed, infact it was so flawless that am amazed by the experience of it. Wonderful use of technology by Mr. Hiren Kakkad and his team in enhancing the overall participant experience for this training programme. I look forward to attending many more such programmes by them in the near future as part of one's continuous professional development (CPD)
Madhu Mohan
Madhu Mohan
2021-11-06
Trustindex verifies that the original source of the review is Google.
Abhay Kakkad
Abhay Kakkad
2021-08-30
Trustindex verifies that the original source of the review is Google.
It is place where you find perfect data analysis..... Good work Keep it up....
Harsh Kakkad
Harsh Kakkad
2021-08-30
Trustindex verifies that the original source of the review is Google.
One of the best training company in the field of data science and operational excellence .
Nirav Tailor
Nirav Tailor
2021-08-29
Trustindex verifies that the original source of the review is Google.
Mihir Mistry
Mihir Mistry
2021-08-29
Trustindex verifies that the original source of the review is Google.
jignesh patel
jignesh patel
2021-08-28
Trustindex verifies that the original source of the review is Google.
keval naik
keval naik
2021-08-28
Trustindex verifies that the original source of the review is Google.