MS Excel Mastery Course

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

 

Sudeep Mathur, Sr. GM (Mfg.) UPL Ltd.

It was really a wonderful experience of enrichment of the Skill & the members have started applying the knowledge gained in converting the huge volumes of DCS data, merging files, data cleaning, doing Analytics & presenting Graphical representation of findings. I would like to thank Hiren for the efforts taken & for meeting our requirements. I would say he exceeded my expectations as he had carried the job perfectly to train us which has helped us to work more efficiently with Big data. My best wishes to Stat Modeller.

Ramesh Dham, ex-Lead-Industry 4.0 UPL Ltd.

First of all I really appreciate for providing very informative training on R as per our need. You have tailored the content for all three weeks by understanding the need of our business and delivered everything in within time line. The course was very informative, really made me think about possible scenarios, particularly in the workplace.

I would also like to mention that you have a strong grip on the subject and have very innovative ideas to deliver the content as per individual’s need.

Dr. Bhavesh Lakhani, Associate Professor. Gujarat Arts and Commerce College, Ahmedabad

This Five day online certification course on “Data Visualization through Power BI” provides me with a learning experience to teach me the proper techniques of using data in a presented mode that will result in meaningful reports, he also taught me how to learn independently. Course materials were good, the mentoring approach was good, and working with other people via the Internet was good. Hiren sir did a good job of communicating skills and making it a more comfortable environment while learning. I learned a lot. I would like to thank you for your support. Your course was a little challenging for me as I am from a commerce background, but you were always there supporting me and ready to help. Your approach towards learners was very humble and the best part is that you always enjoying to answers to silly questions too without being irritated. I enjoyed your class tremendously. I am also thankful to STATMODELLER for providing knowledge about POWER BI. I look forward to taking another class with you.

Poonam Parmar, MBA IIM Rohtak

The team of Stat Modeller has made immense efforts in making participants learn and understand the course in a much easy way. Having attended the session, they not only explain the functions and usage of the tools, but they also explain when and how these tools can be used in managerial decision-making processes. Looking forward to more such enriching sessions.

Prof. Kanchan Jain – Punjab University

I have been a participant in courses on R, Python and Six Sigma Green Belt Certification since lockdown happened. It has been a wonderful experience to update myself from these courses. Mr. Kakkad is a great instructor with a lot of patience providing each and every participant enough time for hands on practice. I wish ‘Stat Modeller’ an immense growth in future.

Richa Yadav, HR Business Partner UPL Ltd.

Being into Human Resources, I aspire to venture into HR Analytics and I was seeking a good start in the direction.

Stat Modeller has helped me embark on this aspirational journey through their R Coding training. I must commend their pedagogical approach that made even non-programmers grasp the subject so easily.

Shivam Mittal, ex-Business Excellence Engineer UPL Ltd.

Data in the 21st Century is like Oil in the 18th Century: an immensely, untapped valuable asset. Analyzing this huge amount of data for generating useful insights is the need of an hour.

I am thankful to Stat Modeller (Mr. Hiren Kakkad) who customized the course of R-Coding as per our business requirement and trained our whole team on handling the process data. The training helped us in understanding the R-Coding environment from the scratch and handling our data so conveniently.

Shobhit Ninoria, Sr. Executive UPL Ltd.

It was one of the best learning experiences. During our 6 days of training on customized R tutorials, Mr Hiren Kakkad and his team have delivered excellent training. In a short duration of time, he covered all our requirements. I am highly satisfied with the training content and training faculty. Overall experience is very good. The guidelines given by trainers were excellent.

Dr. Kandarp Joshi, Dean, T&P Pacific School of Engineering, Surat

The data analysis is crucial part for the research. And in most case, researchers are expert in own domain not in statistical analysis. I was lucky enough to get the reference of Stat Modeller (Mr. Hiren Kakkad) for my PhD related work.

After intense search, I meet them, make aware with my requirement. I gave data in required format and got complete solution in a one day…!! It was Hypothesis Testing with 10 case studies related to Quality Management. I got solution by ANOVA and Turkey Simulation Test. The various diagrams like Interval plot, Box plot, and Individual plot made results easy to understand. Further I got point to point comparative analysis of productivity related data.

Bhagwat Patel – Partner – Siddhi Group

Your knowledge and skills are best for training service. We are benefitted by your association with us. We wish the best of success.