Oops! It appears that you have disabled your Javascript. In order for you to see this page as it is meant to appear, we ask that you please re-enable your Javascript!
  • No products in the cart.

  • LOGIN

Login

MS Excel certification is the most sought after skill in majority of the industries due to its universal appeal. It is a powerful tool which helps professionals in tackling data. Excel formals and tools help in Presenting, Analyzing, Summarizing and Sorting (PASS) data like none other. Professionals in all streams use this tool to enhance their application and analysis skills of the information at their disposal. With the increasing amount of data being used by companies, use of tools like Excel has become mandatory for all professionals to be effective and efficient.

The videos explain from basics of Excel, functions, use of charts and tables, formatting, Pivot tables etc. These videos help understand the concept and make sure to help you learn their application in crunch situations. They enhance the users’ capability to use shortcuts to save time while working on this tool. This course basically bridges a wide gap between the knowledge we have and its application in the corporate world.

All finance professionals and students who want to learn from the best institute for online excel training. Every person who wants to run a business efficiently, work at the biggest companies in the most effective and professional manner must have immense knowledge of this splendid tool at our disposal.

  • FRM Certified Course
  • Downloadable Videos gives you 24/7 offline access
  • Downloadable PDFs for Lifetime
  • Prepared by Corporate trainers
  • Designed according to the starters in Excel and takes you upto the most advanced topics in a systematic manner
  • 100% Placement Assistance provided
  • Course Completion Certificate will be provided

Level 1
  • Lecture 1.1 : Excel Basics
  • Lecture 1.2 : Excel as a Calculator
  • Lecture 1.3 : Error
  • Lecture 1.4 : Sort and Filter
  • Lecture 1.5 : Charts
  • Lecture 1.6 : Formatting
Level 2
  • Lecture 2.1 : Aggregate
  • Lecture 2.2 : Function Wizard
  • Lecture 2.3 : Cell Referencing
  • Lecture 2.4 : Logical Functions
  • Lecture 2.5 : Lookup Functions
  • Lecture 2.6 : Index Match Function
  • Lecture 2.7 : Date Time text functions
  • Lecture 2.8 : Nested Functions
  • Lecture 2.9 : Annotating Formulae
  • Lecture 2.10 : Conditional Formatting
  • Lecture 2.11 : Custom Number Formatting
  • Lecture 2.12 : Hyperlink
Level 3
  • Lecture 3.1 : Auto Filter
  • Lecture 3.2 : Subtotal
  • Lecture 3.3 : Data Consolidation
  • Lecture 3.4 : Data Validation
  • Lecture 3.5 : Age Calculator
  • Lecture 3.6 : Nested IF
  • Lecture 3.7 : Pivot Tables and Charts
  • Lecture 3.8 : Goal Seek
  • Lecture 3.9 : What If – Scenario Manager
  • Lecture 3.10 : Password Protection
  • Lecture 3.11 : Import Export Data
  • Lecture 3.12 : Amortization of Loan
  • Lecture 3.13 : Sparkline, Trendline, Candlestick Charts
  • Lecture 3.14 : Macros
  • Lecture 3.15 : VBA
  • Lecture 3.16 : SUMIF COUNTIF Functions

Supported Desktop Browsers
  • Internet Explorer (IE9)(IE10)(IE11)
  • Microsoft Edge
  • Mozilla Firefox
  • Google Chrome
  • Safari
  • opera
Supported Operating Systems
  • Microsoft Windows 7 (or higher)
  • OSX (Last two major releases)
  • Most Linux Distributions
Supported Mobile Operating Systems
  • iOS 9 (or higher)
  • Android 6.0 (or higher)
Supported Mobile Browsers
  • iOS : Default browsers in version 9 and above
  • Android : Default browser in version 6.0 and above
Browser settings
  • JavaScript must be enabled.
  • Cookies must be enabled.
  • Local Storage must be enabled.

Click ‘TAKE  THIS COURSE’ button on this page. Give your details on Checkout Page and confirm payment.

Course Curriculum

MS Excel
MS Excel 08:00:00
TAKE THIS COURSE
  • $75.00 $30.00
  • 45 Days

Instructors

1 STUDENTS ENROLLED