Excel Expert
4 MONTHS
Bcom, BBA, BE, CA, CFA, MBA
Get a Globally Accepted Certification
Our course is thoughfully designed in such a way that learner gets the Real Time Investment banking & Equity Research exposure. Learner is not necessarily be from finance background, as our course ensures that Basic finance & account concepts are covered in detail with real time examples.
It is 80% practical with industry used case studies.
Our assessment & presentation evaluations are similar to top investment banks & equity research firms Our expert trainers are on hand to help answer any questions you might have along the way.
Course Features
EXPERT SUPPORT
Online support from our team for all your queries based on ticket based tracking system
CERTIFICATION
Get 3 certifcations inone course financial modeling, equity research and advance excel. You can show them seperately in resume.
REAL TIME CASE STUDIES
Live case studies for each financial topics to ensure that learner can understand it thoroughly.
RESUME PREPARATION
Our expert will assist you in resume building and job portal updation.
LIFETIME ACCESS
You get lifetime access to the FINXL LMS which includes videos, excel spreadsheets, presentations, ebooks, quizzes and case studies.
FORUM
Our career square forum is ths most dynamic platform to connect with expert across the globe.
Introduction
Excel Expert
Course Details
Course duration: Intensive 4 MONTHS
COURSE HIGHLIGHTS
Basic Formula
Formulae that Add/Subtract/Multiply/Divide
BODMAS / Formula Error Checking
The Sum Function
Absolute Referencing
Problems with Absolute/Relative Cell Referencing, Creating Absolute/Mixed References
LOOKUP Functions
The VLOOKUP/HLOOKUP Functions
PIVOT Tables
Creating, Formatting Simple PivotTables
Page Field in a PivotTable
Formatting a Pivot Table
Creating/Modifying a Pivot Chart
LOGICAL FUNCTIONS
IFs and Nested IF Functions
Using AND/OR/NOT Functions
STATISTICAL FUNCTIONS
Using The SUMIF/COUNTIF Functions
Using The AVERAGE/COUNT/LARGER/SMALLER Functions