Business Analytics - Advanced Excel

Basics, Formulas, Charts, Pivots, Dashboard, Macros, Business Simuation

Instructed by ForeVision Academy

  • Includes all Standard Features
  • Get Unlimited access to all the courses
  • No Contract. Cancel Anytime
Starting in just $19 / mo see all plans
Subscribe Now
$ 299
Annual Subscription
  • One year Unlimited Access
  • Access to all courses
    You will be able to access all the courses from any category on the platform.
  • Learning paths access
  • Access Assignments & Projects
  • Access on Mobile, PC and Tablet
  • Pause & Resume Courses Anytime
  • Offline viewing
  • Instructor Support
  • Course Completion Certificates
  • Cancel Anytime
Subscribe Now
  • Excel
  • Business Analytics

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 

  • No
  • All
View More...

Section 1 : Basics & Advanced Excel Tools

  • Lecture 1 :
  • Lecture 2 :
  • Cell Referencing
  • Lecture 3 :
  • Excel Formatting & Shortcuts
  • Lecture 4 :
  • Paste Special
  • Lecture 5 :
  • Data Sort
  • Lecture 6 :
  • Data Filter
  • Lecture 7 :
  • Advanced Data Filter
  • Lecture 8 :
  • Conditional Formatting
  • Lecture 9 :
  • Go To Special
  • Lecture 10 :
  • Printing & Protection
  • Lecture 11 :
  • Excel Working File

Section 2 : Basic & Advanced Formula

  • Lecture 1 :
  • Basic Formulas
  • Lecture 2 :
  • Logical Formulas - IF
  • Lecture 3 :
  • Logical Formulas - IF AND OR
  • Lecture 4 :
  • Logical Formulas - NESTED IF
  • Lecture 5 :
  • Statistical Formulas
  • Lecture 6 :
  • Date & Text Formulas
  • Lecture 7 :
  • Financial Formulas
  • Lecture 8 :
  • Lookup Formulas
  • Lecture 9 :
  • Dynamic Lookups
  • Lecture 10 :
  • Advanced Conditional Formatting

Section 3 : Visualization Charts & Pivot Tables

  • Lecture 1 :
  • Charts
  • Lecture 2 :
  • Advanced Charts
  • Lecture 3 :
  • Pivot Tables

Section 4 : Business Simulation & Management Dashboards

  • Lecture 1 :
  • What if Analysis - Goal Seek & Data Tables
  • Lecture 2 :
  • Scenario Manager
  • Lecture 3 :
  • Solver (Excel Add-in)
  • Lecture 4 :
  • Management Dashboards

Section 5 : Automation - Macros & VBA

  • Lecture 1 :
  • Macros - Basics & Recording
  • Lecture 2 :
  • VBA Coding - Basics

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 11000+ Students and Working Professional in Advanced Microsoft Excel, Equity Research & Financial Modeling, Data Analytics, Digital Marketing and Managerial Soft Skills. These trainings have helped them in enhancing productivity & accelerating career growth. ForeVision Academy is the platform which shall help making learning very effective in a seamless manner.
View More...
vba-web-connect-ms-office-to-the-web

VBA WEB - Connect MS Office to the ...

By : Daniele Protti

Lecture 223

excel-vba-from-beginner-to-expert

Excel VBA from Beginner to Expert

By : Daniele Protti

Lecture 66

excel-tips-and-tricks

Excel tips and Tricks

By : Muhammad Ali Yasin

Lecture 16

microsoft-powerpoint-2016-self-publishing-ebook-book-covers

Microsoft PowerPoint 2016 Self-publ...

By : Brian Jackson

Lecture 34

powerpoint-2013-2016-beginner-to-advanced-with-animation

PowerPoint 2013/2016 Beginner to Ad...

By : Brian Jackson

Lecture 114

Sign up and start learning
By signing up. you agree to our Terms of Use and Privacy Policy
Forget Password