EXCEL EXPERT


 Rating
         
 Duration
7 Hrs 30 Mins
 Eligible For
CA, MBA, B.E., CFA, BCA
Course Price at
 5000

Introduction


FinXL Advance MS Excel program empowers the participant with a never before seen depth in almost all of Excel's powerful Features with a focus on becoming an Expert, by 'Mastering' each of the mentioned categories.


Course Features


Course Details

    Excel 2007 & 2010 Quick Overview
  • Difference between Excel 2003, 2007 and 2010, Use of Excel, its boundaries & features

    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 PivotTable
  • Creating/Modifying a PivotChart

    LOGICAL FUNCTIONS
  • IFs and Nested IF Functions
  • Using AND/OR/NOT Functions

    STATISTICAL FUNCITIONS

    Using The SUMIF/COUNTIF Functions

  • Using The AVERAGE/COUNT/LARGER/SMALLER Functions

    Pivot Tables – Advance
  • Adding new calculated Fields / Items
  • Changing the Summary Function
  • Consolidate Pivot table

    LOOKUP Functions – Advance
  • MATCH with VLOOKUP Functions
  • INDEX & MATCH Functions
  • OFFSET/ INDIRECT functions

    Logical Functions - Advance
  • If Loop and Nested IF Loop Functions
  • Using IF/ISERROR Functions

    Chart Data Techniques
  • The Chart Wizard
  • Chart Types
  • Adding Title/Legends/Lables
  • Printing Charts
  • Adding Data to a Chart
  • Formatting/Renaming/Deleting Data Series
  • Changing the Order of Data Series

    Date/Time Functions
  • Using the Today
  • Now & Date Functions
  • Using theDatedif/ Networkdays/ Eomonth Functions
  • Using theWeeknum Functions
  • Using theEdate/ Networkdays.Intl/ Weekdays.Intl Functions.

    Text Functions Using
  • The Mid/ Search/ Left/ Right Functions
  • Using the Trim/ Clean/ Upper/ Lower Functions
  • Using theSubsitute/ Text Functions
  • Using the Trim/ Clean/ Proper/ Dollar Function

    Validations
  • Input Messages / Error Alerts/ Drop-Down Lists
  • Conditional Formatting

    Advanced Filters
  • Extracting Records with Advanced Filter
  • Using Formulas In Criteria

    Advanced Sorting
  • Sorting by Top to Bottom / Left to Right
  • Creating / Deleting Custom List
  • Sort by using Custom List

Hyper / Data Linking
  • Hyper linking data, within sheet / workbook
  • Linking & Updating links between workbooks & application

Math & Trigonometry Functions
  • Using SUMPRODUCT Functions
  • Using FLOOR/ CEILING/ MROUND/ MOD/ QUOTIENT Functions

Statistical Analysis
  • Conduct sensitivity and ‘What if Analysis’, Scenario Analysis, Dashboards, Interactive Financial Models, Monte Carlo Simulation

Financial Functions
  • Loan Amortization Schedule and functions like PV, FV, PMT, Rate, Nper, IPMT, CUMPMT, etc

Summarizing Data
  • Creating Subtotals/Nested Subtotals
  • SUBTOTALS Formula

Outlining
  • Creating/Working with an Automatic/Manual Outline
  • Grouping / Ungrouping

Consolidation
  • Consolidating Data with Identical/Different Layout

Using Auditing Tools
  • Displaying/Removing Dependent & Precedent Arrows
  • Evaluate Formula - Step IN/ Step Out

Custom Views
  • Creating Custom Views
  • Displaying Custom Views
  • Deleting Custom Views

Sharing and Protecting Workbooks
  • Sharing Workbooks & Tracking Changes
  • Protecting sheets / workbooks / Files

Importing & Exporting Data
  • Importing Data from Database/ Text Files/ Web
  • Exporting Data
  • Changing External Data Range

Dashboard Preparation-
  • Dashboard for MIS, Analysis, different dashboards for different business types and business segments, will include a self-assignment (formulas like offset, advance formatting, macros, hyperlink, etc.)

Advance Pivot
  • Formatting, grouping, computing %, Summarizing Values, Auto report Generation –100s with a click, Calculated Fields, Connecting Multiple Sources of data, Use of Slicer and Report Filter to create quick dashboard, Pivot charts, Power pivot and Power View –Introduction, and other Advance features, Consolidating data across multiple tables

Advance Charts
  • Thermometer, Speedometer, Sparklinesand easy formatting techniques Customizing Ribbon
  • Have your own ribbon like File, View with your designed Functions to perform repetitive tasks, automation and extremely useful time saving technique. Macros
  • Run, record, use, save and work with them

VBA Code Snippets
  • To be able to use free VBA code snippets available online and use them to perform certain tasks like convert a number in word form

Pre-Requisites

  • Does basic knowledge of Finance / Accounting needed? Not required as we start from basics
  • Does basic knowledge of Excel needed? Not required as we start from basics
  • Does any Finance degree or Finance background required? Previous finance knowledge will help but not compulsory

Target Audience

  • Professionals: Finxl Excel expert is best of the class course designed specifically for Professional like CA, CFA, FRM, MBA, Financial Analyst, Accountant, Tax consultants, Financial Planners, Sales & Marketing, Data Analyst for their day to day use at job.
  • Students: If you are perusing CA, CFA, FRM, MBA, B. Com, M. Com, B.E., Graduate, Under Graduate courses and willing to work in Finance, advance excel is must do course for you. Once you do this Advance Excel Training, you don't need to go through any additional material to learn advanced excel. This is the best hands on experience course to make you expert in excel.


Research Companies

REVEL ANALYTICS, SG ANALYTICS, KPMG, GOLDMEN SACHES


Placement Assistance

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.


Course Content

 Introduction to Expert Exam

 KEY BOARD ACCELERATORS

 FORMATTING

 CONDITIONAL FORMATTING

Recommended Courses


FINANCIAL PLANNING & ANALYSIS (FP&A)



1298
1033

FINANCIAL PLANNING & ANALYSIS (FP&A)

DURATION : 9 Hrs 28 Mins
ACCESS : Lifetime
ELIGIBLE FOR : certificate + SHRM & HRCI
COURSE FEE : 2000/-

Read More


EXCEL EXPERT



971
745

EXCEL EXPERT

DURATION : 30
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 5000/-

Read More


PROFESSIONAL POWER POINT



1366
1272

PROFESSIONAL POWER POINT

DURATION : 11 sessions
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E.
COURSE FEE : 5000/-

Read More


INVESTMENT BANKING (IB)



1362
1211

INVESTMENT BANKING (IB)

DURATION : 4 months
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 30000/-

Read More


CREDIT RESEARCH



861
660

CREDIT RESEARCH

DURATION : 2 MONTHS
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 30000/-

Read More


FINANCIAL MODELING



1462
1127

FINANCIAL MODELING

DURATION : 4 MONTHS
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 40000/-

Read More


HR Analytics



1020
842

HR Analytics

DURATION : 3 Months
ACCESS : Lifetime
ELIGIBLE FOR : Any Graduate
COURSE FEE : 20000/-

Read More


EQUITY RESEARCH



1200
1044

EQUITY RESEARCH

DURATION : 3 MONTHS
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 25000/-

Read More


FINANCIAL BUDGETING



821
422

FINANCIAL BUDGETING

DURATION : 2 MONTHS
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 10000/-

Read More


FINANCIAL PLANNING



958
825

FINANCIAL PLANNING

DURATION : 2 MONTHS
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 15000/-

Read More


KEY PERFORMANCE INDICATORS (KPI)



1192
991

KEY PERFORMANCE INDICATORS (KPI)

DURATION : 1 MONTH
ACCESS : Lifetime
ELIGIBLE FOR : 1 MONTH
COURSE FEE : 7000/-

Read More


FINANCIAL REPORTING



1219
1024

FINANCIAL REPORTING

DURATION : 1 MONTH
ACCESS : Lifetime
ELIGIBLE FOR : CA, MBA, B.E., CFA, BCA
COURSE FEE : 10000/-

Read More

 Enquiry