Advanced Business Analytics with Microsoft Excel

Advanced Business Analytics with Advanced Microsoft Excel Learn the most advanced formulas, functions and types of financial analysis to be an Excel power user. This advanced Excel training course builds on our free Excel Crash Course and is designed specifically for spreadsheet users who are already proficient and looking to take their skills to an advanced level.

This advanced tutorial will help you become a world-class financial analyst for careers in investment banking, private equity, corporate development, equity research and FP&A. By watching the instructor build all the formulas and functions right on your screen, you can easily pause, rewatch, and repeat exercises until you've mastered them.

Why Kinverg

  • Kinverg is offering project management trainings workshops globally since 2011
  • Kinverg has educated more than 800 professionals in project management from diverse industries
  • Our focus is to equip professionals with practical project management knowledge and tools which can be used right after attending our programs

Participants will be able to:

  • To use advanced functions of excel 2013 to improve productivity,enhance spreadsheets with charts and graphs, formulas and streamline their operational work.
  • To apply visual elements like graphs, charts, pivot tables and advanced formulas to a worksheet to display data in various formats.
  • To apply advanced analysis techniques to more complex data sets, collaborate on worksheet with others, and
  • To leverage on excel's advanced functionality to simplify and streamline their day-to-day work.
The training program is aligned with kinverg Advanced Excel Body of knowledge™

Summing Technique

  • Doing SUM through impressive shortcut
  • 3D Summing
  • Data Consolidation
  • QAT(Quick Analysis Tool)

Power Functions/Formulas

  • SumIF, SumIFS
  • Average, Average IFS
  • Count,CountA,CountIF,CountIFS
  • Creating Dynamic Reports using Power Functions
  • Array Formulas

Formula Refrencing

  • Absolute and Relative Referencing
  • Problems with Relative Formulas
  • Creating Absolute References

Text Options

  • Text to Columns
  • Using Left, Right & Upper Formula
  • Using TEXT Formula

Conditional Formatting

  • Formatting Cells Conatining Values
  • Clearing Conditional Formatting
  • More Cell Formatting Options
  • Top and Bottom Tem Items
  • Working With Data Bars
  • Working With Colors Scales
  • Working With Icon Sets

Dynamic Table

  • Converting data into Table
  • Automated calculation in Table
  • Converting Table to normal range
  • Multiple Filters in Table

Data Validation

  • Drop-down List
  • Restricted Values in a Cell
  • Error messages in case of wrong entry
  • Dependent List

How to Register

  • Register by (enter program title in subject)
  • Register by online contact form: Contact online 
  • Register by WhatsApp/ Call: Pakistan:+92-3344362100|GCC:+971-50-215-1358
    • How to make Payment

      • You can make the payment by writing cross check in favor of KINVERG
      • You will be issued Payment Invoice by Kinverg once the check has been received.
      • You can make online bank transfer to our following bank account

      KINVERG| HBL | IBAN: PK71 HABB 0005457901143903 | NTN # 308-6014-8