What Will You Learn:

  • Master Microsoft Excel from Beginner to Advanced
  • Build a solid understanding on the Basics of Microsoft Excel
  • Learn the most common Excel functions used in the Office
  • Harness the full power of Microsoft Excel by automating your day to day tasks through Macros and VBA
  • Maintain large sets of Excel data in a list or table
  • Create dynamic reports by mastering one of the most popular tools, PivotTables
  • Wow your boss by unlocking dynamic formulas with IF, VLOOKUP, INDEX, MATCH functions and many more

Course Curriculum

  • 1

    Introduction to MS Excel

    • Basic Skills

    • Addition into Excel

    • Substraction into Excel

    • Percantage into Excel
  • 2

    Formatting in Excel

    • Conditional Formatting

    • Conditional Formatting with Top Bottom Rules

    • Number Formatting

    • Paste Special
  • 3

    Creating Charts

    • Column Chart

    • Bar Chart
  • 4

    Excel Essential Formulas

    • Date Formula

    • Average Formula

    • Sum Formula

    • Sum as running total

    • Transpose Formula

    • IF Formula

    • Counta Formula

    • CountBlank Formula

    • Concatenate Formula to Join Text

    • PivotTables

About Trading Institute

Subject Matter Expert

Trading Institute

Trading Institute is a professional training institute set up with an objective to bridge the skills gap between academia and theindustry by offering industry relevant training and certifications andempowering young and dynamic individuals with skills required topursue careers in the areas of capital markets and financialservices. Our mission is to equip aspiring financial markets learnerswith the right education and training they need to pursue a careerwith leading financial institutions or become an independent or aprofessional trader and a sound investor.