Advanced Excel

by OJD Computer Education Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

OJD Computer Education Logo

img Duration

1 Month

Course Details

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.

The main formulas & functions covered in this training course include:

Syllabus:

  • Overview of the Basics of Excel
  • Working with Functions (AND, OR, NOT, VLOOKUP, HLOOKUP, MATCH, INDEX)
  • Data Validations
  • Working with Templates - standardization
  • Sorting and Filtering Data (AutoFilter)
  • Working with Reports - Pivot tables
  • More Functions- Date and time, Text, Database, CountIf, CountIFS, SumIF, SumIfS
  • Formatting
  • Relative & Absolute Macros
  • What If Analysis - Goal Seek, Data Tables, Scenario Manager
  • Charts
  • New Features Of Excel - Sparkline, Inline Charts, data Charts
  • Lucknow Branch

    C-411, 2nd Floor, Sahara Plaza, Patrakarpuram, Gomti Nagar, Lucknow
  • Delhi Branch

    A-15, OJD Tower, Sainik Farms, NR Tinu Public School, Delhi

Check out more MS Excel courses in India

CADDONE Learning Centre (CADDTC) Logo

Microsoft Office Specialist (MOS) Excel Associate

Microsoft Office Specialist (MOS) Excel Associate course is offered by CADDONE Learning Centre (CADDTC). At CADDTC we are focused on offering quality training to make sure that. Our Centre offers excellent training delivery we focus.

by CADDONE Learning Centre (CADDTC) [Claim Listing ]
Compufield Logo

Advanced Excel Course

This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analyzing data, creating MIS reports.

by Compufield [Claim Listing ]
  • Price
  • Start Date
  • Duration
Credo Systemz Logo

Advanced Excel Training

Our Advanced Excel training is framed to cover all the advanced features of excel application which help to enhance and improve your analyzing and reporting skills.

by Credo Systemz [Claim Listing ]
iFuture Technologies Logo

Microsoft Access

As the Data is spread everywhere. Most IT Professionals' roles today involve some form of data management. Virtually Corporate Businesses is affected in some way by the need to manage data.

by iFuture Technologies [Claim Listing ]
Infonet Logo

Advanced Excel

Advanced Excel is a skill that is high demand Advanced Excel Functions (macros, index, conditional list arrays pivots lookups). Advanced Excel Formulas using for we can crunch analyze data and solve complex questions in an efficient manner. without formula, excel would just seem like a data-keeping

by Infonet [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy