Advanced Excel & Financial Modelling

This program objective is to equip students with hands-on experience on the application of basic and advanced MS-Excel, better data management in an organized format.

Students (Graduate & Post graduate)

Beginner
Last Updated Fri, 08-July-2022 English
What Will I Learn?
  • Creating effective spreadsheets
  • Managing large sets of data
  • Mastering the use of some of Excel's most popular and highly sought-after functions (SUM, VLOOKUP, IF, AVERAGE, and many more...)
  • Create dynamic report with Excel PivotTables
  • Automate their day-to-day Excel tasks by mastering the power of Macros and VBA

Course Coordinator Details

Tanveer Kaur, Tanveer.4331@cgc.edu.in

9417837366

Diksha Verma, diksha.4545@cgc.edu.in

9530839675


Link to Register
Click Here to Register for this Course

Curriculum For This Course
Day 1
  • Introduction to MS-Excel
    Basics of Ms-Excel
    USING BASIC FUNCTIONS
    Introduction to Formulas
    Introduction to Formulas
  • CUSTOMIZING EXCEL
    MATHEMATICAL FUNCTIONS
    PROTECTING EXCEL
    TEXT FUNCTIONS
    DATE AND TIME FUNCTIONS
    FORMATTING AND PROOFING
  • ADVANCED PASTE SPECIAL TECHNIQUES
    New in Excel 2013 / 2016 & 365
    Sorting and FILTERING
    DATA VALIDATION
    LOOKUP FUNCTIONS
  • PIVOT TABLES
    Arrays Functions
    CHARTS and slicers
    EXCEL DASHBOARD
    Macro
    If and select statements
    Worksheet copiers
  • Basic Excel Tools
    Financial Modeling Tools
    Formatting and Conditions
    Investment Decision Techniques
Kindly use the following details to deposit your fee.

Name:Chandigarh Group of Colleges

Account No:077206000002

IFSC :CLBL0000077

Bank Name:Capital Small Finance Bank

Address:CGC Campus, Landran, Mohai

Other Related Courses
Education of Children with Special Needs in Inclusive Set up
Updated Fri, 24-Jun-2022
₹500
SOFT SKILLS AND PERSONALITY DEVELOPMENT
Updated Fri, 24-Jun-2022
₹500