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

Thasor Infotech Logo

MS Office

MS Office course is offered by Thasor Infotech. We offer a wide range of online and offline services for low to high-level education across the globe.

by Thasor Infotech [Claim Listing ]
Inspire Training Academy Logo

Microsoft Word

Microsoft Word course is offered by Inspire Training Academy. Inspire Training Academy is one of the premier professional training institutes in India, Nepal, and Doha, Qatar with a state of the art training facility.

by Inspire Training Academy [Claim Listing ]
Swati Computer Logo

MS Office

Microsoft Office stands as a cornerstone desktop application, streamlining the organization, management, and presentation of information. Despite substantial investments in licensing by companies, many users fail to fully harness its myriad features due to a lack of awareness.

by Swati Computer [Claim Listing ]
BIIT (Bartakke Institute of Information Technology) Logo

Office Automation ( MS Office, Internet, etc.)

Office Automation course is offered by BIIT (Bartakke Institute of Information Technology). BIIT’s well-qualified, experienced certified instructors train the participants step by step with easy-to-use training material by keeping with the pace of learners and providing individual attention.

by BIIT (Bartakke Institute of Information Technology) [Claim Listing ]
Advanced Computer and Design Solutions Logo

Microsoft Excel

Microsoft Excel course training is offered by Advance Computer and Design Solutions for all skill level. We are leading Software Training Institute in Bhopal assure quality training.

by Advanced Computer and Design Solutions [Claim Listing ]

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