• Classroom Training   • Online Training   • Corporate Training  • Live Projects & Guidance 

Advanced Excel

Advanced Excel Courses Information

In this Advanced Excel , you will learn all the tips, tricks, shortcuts, functions and formulas you need to be an Excel power user. This Advanced Excel course is designed specifically for spreadsheet users who are already performing professional financial analysis and financial modeling or are looking to prep for a wall street career.

This Advanced Excel Training Institute in Thane Mumbai starts with the Excel basics and quickly progresses to a more advanced level where even experts will learn something new. We believe it is important to start at the bottom and build a solid base, which is why we review all the foundational skills you need before building more advanced spreadsheets. In this course, you will learn to leave behind the mouse and use keyboard shortcuts to dramatically improve and speed up your spreadsheet building skills.

In this course you will learn everything you need to know about Excel spreadsheets for a career in corporate finance and investment banking

This course is perfect for beginners, intermediate, and even advanced users. This course starts off with the very basics, and then you will also learn advanced topic so even power users will learn something new and have a great refresher.

Curriculum
Module 1 – Getting to Know Excel
  • The Ribbon
  • The Work Surface
  • Navigation
  • Formatting
Module 2 – Essential Formula Knowledge - I
  • Formula Anatomy
  • Cell Referencing
  • Function Anatomy
Module 3 – Essentials Formula Knowledge - II
  • Logic Functions
  • Conditional Math
  • Temporal Function(EOMONTH)
  • Function Anatom
Module 4 – Functions
  • Math Functions
  • Text Functions
  • Understanding Dates
  • Understanding Time
Module 5 – Search Functions
  • VLOOKUP
  • Other Lookup Method (Index & Match )
  • HLOOKUP
Module 6 – Optimizing Data
  • Sorting
  • Filtering
  • Naming Ranges
Module 7 – Data Analysis
  • Creating PivotTables
  • Formatting PivotTables
  • Calculated Fields in PivotTables
Module 8 – Getting and Transforming Data
  • Importing Data from a Text File
  • Contiguous Data
Module 9 – Presenting and Reporting with Formats
  • Conditional Formats with Built-In Rules
  • Cell Formatting
  • Conditional Formats with Custom Rules
Module 10 – Presenting and Reporting with Charts
  • Building Column Charts
  • Building Bar Chart
  • Building Pie Charts
  • Building Line Charts
Module 11 – Validating and Updating
  • Data Validation
  • Comments & Notes
  • Apply built-in number styles
Module 12 – Preparing to Deploy
  • Custom Views
  • Security Considerations
  • Page Setup Options

Trending Courses