M1 - Analyst Basics

  • Interactive Classes

    Online Sessions, Highly Interactive Classes with Experienced Faculty,Engaging students through interactive learning activities promotes independent thinking skills. To maximise the learning experience, teachers need to stimulate students to be active learners through questioning, enquiring, responding and critically analysing a variety of questions and situations.

  • Experienced Faculty

    Learn from Highly Qualified & Experienced Industry Practitioners,Every Faculty is committed to providing excellent service .A unique and effective pedagogy with industry matched curriculum, highly interactive classes taken by corporate faculty, virtual labs to practice in real time and help by experts round the clock to ensures you grasp the most out of your training.

  • Help by Experts

    Expert Guidance when you get stuck, one to one communication provided by the faculties, every Q&A solved instantly by the expert in their technology.

Course curriculum

  • 01
    Starting with Spreadsheet
    Show details
    • First Spreadsheet
    • BAX-A1#1 FREE PREVIEW
    • Dragging
    • BAX-A1#2
    • Formatting-1
    • BAX-A1#3
    • Formatting-2
    • BAX-A1#4
    • Basic Charting
    • BAX-A1#5
  • 02
    Formula
    Show details
    • Formulas-1
    • BAX-A2#1
    • Formulas-2
    • BAX-A2#2
    • Formulas-3
    • BAX-A2#3
  • 03
    Cell Lock
    Show details
    • Cell Lock-1A
    • BAX-A3#1
    • Cell Lock-1B
    • BAX-A3#2
    • Cell Lock-1C
    • BAX-A3#3
    • Cell Lock-1D
    • BAX-A3#4
    • Cell Lock-2A
    • BAX-A4#1
    • Cell Lock-2B
    • BAX-A4#2
    • Cell Lock-2C
    • BAX-A4#3
  • 04
    Basic Functions
    Show details
    • Sum
    • BAX-A5#1
    • Average, Count, CountA
    • BAX-A5#2
    • Round
    • BAX-A5#3
    • SumIf
    • BAX-A5#4
    • CountIf, AverageIf
    • BAX-A5#5
    • BAX-A5#5A
    • BAX-A5#5B
    • BAX-A5#5C
    • BAX-A5#5D
    • Linking Tabs / Sheets
    • BAX-A5#6
    • BAX-A5#6A
  • 05
    Logic + If
    Show details
    • Logical Operators
    • BAX-A6#1
    • Conditional Formating-1
    • BAX-A6#2
    • Conditional Formating-2
    • BAX-A6#3
    • If
    • BAX-A6#4
    • Ifs
    • BAX-A6#5
    • BAX-A6#5A
    • Dropdowns and Data Validation
    • BAX-A6#5B
    • Freeze
    • BAX-A6#6
    • BAX-A6#6A
    • BAX-A6#6B
    • BAX-A6#6C
  • 06
    Text Functions
    Show details
    • Text Fns - 1
    • BAX-A7#1
    • Text Fns - 2
    • BAX-A7#2
    • Text Fns - 3
    • BAX-A7#3
    • BAX-A7#4
    • BAX-A7#5
  • 07
    Charts
    Show details
    • Starting with Charts
    • BAX-A8#1
    • Starting with Charts-2
    • BAX-A8#2
    • Customizing Charts
    • BAX-A8#3
    • Customizing Charts-2
    • BAX-A8#4
  • 08
    Sort, Paste
    Show details
    • Sorting-1
    • BAX-A9#1
    • Sorting-2
    • BAX-A9#2
    • Paste-1
    • BAX-A9#3
    • Paste-2
    • BAX-A9#4
    • Paste-3
    • BAX-A9#5
    • BAX-A9#5A
    • Paste - 4
    • BAX-A9#6
  • 09
    Date, Filter
    Show details
    • Date-1
    • BAX-A10#1
    • Date-2
    • BAX-A10#2
    • BAX-A10#3
    • Filter
    • BAX-A10#4
    • Shortcuts
    • BAX-A10#5
  • 10
    VLOOKUP
    Show details
    • Starting with VLOOKUP
    • BAX-B1#1
    • IFERROR
    • BAX-B1#2
    • BAX-B1#2A
    • Type Mismatch
    • BAX-B1#3
    • Approx Match, Is Sorted
    • BAX-B1#4
    • Merging Data
    • BAX-B1#5
    • BAX-B1#5A
    • HLOOKUP
    • BAX-B1#6
  • 11
    Pivot Tables
    Show details
    • Pivot Tables-1
    • BAX-B2#1
    • Pivot Tables-2
    • BAX-B2#2
    • More Fns
    • BAX-B2#3
    • Calculated Field
    • BAX-B2#4
  • 12
    Cleaning
    Show details
    • Clean Data
    • BAX-B3#1
    • BAX-B3#1A
    • Timesheet 1
    • Timesheet2
    • BAX-B3#2
    • BAX-B3#3
    • BAX-B3#4
    • BAX-B3#5
  • 13
    SQL
    Show details
    • SQL-1#1
    • SQL-1#2
    • SQL-1#3
    • SQL-1#4
    • SQL-2#1
    • SQL-2#2
    • SQL-2#3
    • SQL-2#4
    • SQL-2#5
    • SQL S1#1
    • SQL S1#2
    • SQL-2#6
  • 14
    More Info
    Show details
    • Details

Pricing