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

Fatema Training Institute Logo

MS Office

MS Office course is offered by Fatema Training Institute. All courses are held in the care of women. Separate classes for women are taken. Thus the Institute is run for all ages, the elderly, children, and women are considered.

by Fatema Training Institute [Claim Listing ]
Get IT Project Computer Centre Logo

MS Excel

MS Excel course is offered by Get IT Project Computer Centre. The Get IT Project Computer Centre is a MCA (Govt. Of India) Registered & ISO Registered Firm deals in sales and service of all Information Technology and Communication related equipments and services.

by Get IT Project Computer Centre [Claim Listing ]
Computer Institute Logo

MS PowerPoint

MS PowerPoint course is offered by Computer Institute for all skill level. We know it's easier to be a successful learner when you're equipped with what you need. This is why we have invested heavily in key equipment to give you the best experience while you train with us.

by Computer Institute [Claim Listing ]
CITM (Coastal Institute Of Technology And Management) Logo

MS Excel

MS Excel course is offered by CITM (Coastal Institute Of Technology And Management). CITM is a pioneer in the field of Diploma and ITI Courses in Mangalore. The institute is affiliated to ISO Certified (ISO 9001:2015), registered under Govt. of India – Ministry of Corporate Affairs Organization.

by CITM (Coastal Institute Of Technology And Management) [Claim Listing ]
Alma Academy Logo

M.S.Office

Application software that assist users in regular office jobs like creating, updating and maintaining documents, handling large amounts of data, creating presentations, scheduling, etc.

by Alma Academy [Claim Listing ]

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