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

Ducat IT Training School Logo

Advanced Microsoft Excel

Are you Looking Best Institute for Advanced Excel Training Course in Noida / Greater Noida? DUCAT offers Advanced Excel training classes with live projects by the expert trainer in Noida.

by Ducat IT Training School
Infocampus Logo

Office 365 Administrator

Office 365 Administrator course is offered by Infocampus. The Office 365 Enterprise Administrator takes part in evaluating, planning, migrating, deploying, and managing Office 365 services.

by Infocampus [Claim Listing ]
Sunrise Classes Logo

Advance Excel

Advance Excel course is offered by Sunrise Classes. All courses are designed in a perfect way to help meet the students unique needs to achieve their career objectives.

by Sunrise Classes [Claim Listing ]
Young Tech It Solution And Training Institute Logo

MS Office Course

MS Office course is offered by Young Tech It Solution And Training Institute. Our mission is quality training with an affordable fee structure. Our uniquely designed curriculum makes our students employable and future ready.

by Young Tech It Solution And Training Institute [Claim Listing ]
The British Institutes Logo

MS Excel Course

MS Excel course is offered by The British Institutes for all skill level. The British Institutes is one of India's leading educators, with focus on diverse segments of education, and across learners of multiple age-groups. 

by The British Institutes [Claim Listing ]

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