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

CMIT Computer Education Logo

Diploma In Microsoft Office

Diploma in Microsoft Office course is offered by CMIT COmputer Education for all skill level. Our core strength is our team of Expert Trainers / Faculties / Instructors consisting of MCAs/ Engineers / Graduate’s in Computer Science having strong domain knowledge.

by CMIT Computer Education [Claim Listing ]
MCJ Accounting Training Institute Logo

Excel (Basic And Advance)

Learn Excel from top-rated instructors. Best Excel course for every Accounts or HR candidates. Become master in Excel formulas, shortcuts, spreadsheets, and other common usage.

by MCJ Accounting Training Institute
  • Price
  • Start Date
  • Duration
Computer's Galaxy Logo

Office Management

Office Management course is offered by Computer’s Galaxy. We are constantly in the process of updating our software and web designing skills and adopting new technologies that can perform better functions. We believe in integrating our skills with our client’s input to achieve desirable result...

by Computer's Galaxy [Claim Listing ]
IIIT Kottayam Logo

MS Excel (Advance)

MS Excel course is offered by IIIT Kottayam. Our courses offer a good compromise between the continuous assessment favoured by some universities and the emphasis placed on final exams by others.

by IIIT Kottayam [Claim Listing ]
Gautam Buddha Computer Training Institute Logo

Microsoft Excel

Microsoft Excel course is offered by Gautam Buddha Computer Training Institute. Microsoft Excel is a powerful spreadsheet software with a wide range of features and options.

by Gautam Buddha Computer Training Institute [Claim Listing ]

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