Course curriculum

  • 1

    Basic & Advanced Excel Tools

    • 1 Introduction to Excel

    • 2 Cell Referencing

    • 3 Formatting & Shortcuts

    • 4 Paste Special

    • 6 Data Filter

    • 5 Data Filter

    • 7 Advanced Data Filters

    • 8 Conditional Formatting

    • 9 Go To Special

    • 10 Printing & Protection

  • 2

    Basic & Advanced Formulas

    • 11 Basic Formulas

    • 12 Logical - IF

    • 13 Logical - IF AND

    • 14 Logical - NESTEDIF

    • 15 Statistical Formulas

    • 16 Date & Text Formulas

    • 17 Financal Formulas

    • 18 Lookup Formulas

    • 19 Dynamic Lookups

    • 20 Advanced Conditional Formatting

  • 3

    Visualization Charts & Pivot Tables

    • 21 Charts

    • 22 Advanced Charts

    • 23 Pivot Tables

  • 4

    Business Simulations & Management Dashboards

    • 24 What If Analysis

    • 25 Scenario Manager

    • 26 Solver

    • 27 Management Dashboards

  • 5

    Automation – Macros & VBA

    • 28 Macros - Basics & Recording

    • 29 VBA Coding - Basics

    • 30 VBA Coding - Advanced

    • 31 VBA User Defined Function

    • 32 VBA Creating a User Interface

What you'll learn

✔ Advance Excel

✔ Business Analytics

Course Description

Excel Overview

Excel is one of the most widely used tool in corporates across sectors and across functions

It has always been user friendly and feature rich and now has been expanded to provide an even wider array of tools helping businesses right from simple work to complex problem solving and decision making

Excel has become an integral part of everyday operations, making it a necessity for continuous flow of business


•Excel Overview & Basic Excel tools

•Basic & Advanced Excel Formulae

•Nested & Dynamic Formulas

•Charts – Basic, Multi Axis, Advanced & Dynamic

•Pivot Table, Pivot Charts & Pivot Dashboards

•Business Simulations – Sensitivity Analysis / Scenario Manager / Solver

•Management Dashboards

•Macro Recording, Macro Objects & VBA Coding

•Shortcut techniques for easy working

•Case Study based extensive hands on learning

•Wide range of managerial examples

Who this course is for:
  • Management Students
  • Interest in Analytics
  • Business Owners, Working Professionals

Instructor

Senior Instructor

ForeVision Academy

ForeVision is a Mumbai, India based company offering its expertise in Learning & Business Solutions. We conduct Knowledge & Skill Building Training for individuals & organizations providing practical, relevant & hands on learning experience. We have trained 12000+ Students and Working Professional in Advanced Microsoft Excel, Equity Research & Financial Modeling, Capital Markets, Data Analytics, Digital Marketing, FMCG Sales and Managerial Soft Skills. These trainings have helped them in enhancing productivity & accelerating career growth. ForeVision Academy is a platform which shall help making learning very effective in a seamless manner.

What people say

Excellent Course

Raj

The content and flow of the course was very good but the programming part at the last section was very challenging for non computer background students but was explained very well.

Very Good Course for Beginners

Jaydeep

The course was very useful and gave me a lot of information. A lot of topics were covered and the trainer had lot of knowledge in business analytics and advance excel techniques

How to purchase this course

Stripe: All purchases made using Stripe require a credit / debit card. You get immediate access to the course on purchase.

Buy now at ₹ 2880 with  


Razorpay: Razorpay supports multiple payment methods including credit / debit cards, Net banking, UPI. You get course access within 24 hours of purchase.

Buy now at ₹ 2880 with