Stat Modeller

Organizer

Stat Modeller
Email
marketing@statmodeller.com
Register Now

Local Time

  • Timezone: America/New_York
  • Date: Jun 26 - 29 2020
  • Time: 9:30 am - 11:00 am
Category

Date

Jun 26 - 29 2020
Expired!

Time

7:00 pm - 8:30 pm

Cost

INR499.00

Advance Excel for Data Analytics

Excel is a program which is used widely by the industries, universities, academic institution and many more. Excel is having very powerful functions that can be easily used in our routine life like pivot table, lookup, conditional formatting, data visualizations and many more. It also can be used for data entry, data cleaning, data restructuring etc.

Schedule

  • Date: 26th Jun 2020 to 29th Jun 2020 (4 Days)
  • Timing: 7:00 PM to 8:30 PM

Benefits

  • Suitable for beginner, intermediate level
  • Experienced faculty
  • Hands-on experience
  • Email support after training
  • E-Certificate

Register Now

Content

  • Introduction to Excel
    • Overview of Excel & It’s History
    • Uses of Excel
    • Advantages 
    • File extension
  • Getting Started with Excel
    • Opening of Excel
    • Understanding File Menu
  • Understanding of Excel Interface
    • Quick Access Bar
    • Ribbon
    • Row, Column, Cell & Cell Address & Cell Content
    • Formula Bar
    • Worksheet Options (Rename/Hide/Unhide/Protect etc.)
    • Window Options (View Tab)
  • Basic Formulas & Functions
    • Mathematical Operations using Formulas
    • Basic Formulas (Text, Date & Time) 
    • Creating Functions (Sum, Average, Count, Max, Min Etc.)
    • Functions Library
  • Relative and Absolute Cell References
    • Concept of Relative and Absolute Ref.
    • Create and copy a formula using relative references
    • Create and copy a formula using absolute references
  • Advance Formulas & Functions
    • IF Statement, Nested IF Statement,
    • Vlookup,
    • Hlookup,
    • Index Match
  • Data Validation
    • What is data validation
    • When to use data validation
    • Applying Validation criteria
  • Conditional Formatting
    • Applying & modifying built-in options
    • Create & manage custom rule
    • Applying Data bar, Color Scale & Icon
  • Data Analysis Tool
    • For What Analysis tool is.
    • How to active it.
    • What is Histogram & How to create via D.A.T & Interpret it.
    • What is Pareto Chart & How to create it in Excel.
    • What is Descriptive Statistics & How to generate & interpret it.
  • Excel Table & Excel Chart
    • Converting raw data into Excel Table Format
    • Benefits of converting raw data into Excel Table Format
    • Inserting & Modifying Excel Charts
  • Pivot Table, Pivot Chart, Slicers & Timeline
    • Converting Table data into Pivot Table
    • Pivot Table Fields
    • Adding, modifying Data into Pivot Table
    • Creating Pivot Chart
    • Inserting slicers & Timeline
    • Inserting Sparkline (Line, Column, Win/Loss)
  • Dashboard
    • What is Dashboard
    • Types of Dashboard
    • Things to be consider
    • How to create dashboard in Excel
  • Q&A Session
  • Quiz

Register Now

Leave a Reply