Business Analytics – Advanced Excel

Business Analytics – Advanced Excel, available at $64.99, has an average rating of 4.6, with 32 lectures, 1 quizzes, based on 79 reviews, and has 312 subscribers.

You will learn about Excel Business Analytics This course is ideal for individuals who are Management Students or Interest in Analytics or Business Owners, Working Professionals It is particularly useful for Management Students or Interest in Analytics or Business Owners, Working Professionals.

Enroll now: Business Analytics – Advanced Excel

Summary

Title: Business Analytics – Advanced Excel

Price: $64.99

Average Rating: 4.6

Number of Lectures: 32

Number of Quizzes: 1

Number of Published Lectures: 32

Number of Published Quizzes: 1

Number of Curriculum Items: 33

Number of Published Curriculum Objects: 33

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: ₹2,899

Quality Status: approved

Status: Live

What You Will Learn

Excel
Business Analytics

Who Should Attend

Management Students
Interest in Analytics
Business Owners, Working Professionals

Target Audiences

Management Students
Interest in Analytics
Business Owners, Working Professionals

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

Course Curriculum

Chapter 1: Basic & Advanced Excel Tools

Lecture 1: Overview of Excel

Lecture 2: Cell Referencing

Lecture 3: Excel Formatting and Shortcuts

Lecture 4: Paste Special

Lecture 5: Data Sort

Lecture 6: Data Filter

Lecture 7: Advanced Data Filters

Lecture 8: Conditional Formatting

Lecture 9: Go To Special

Lecture 10: Printing and Protection

Chapter 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

Chapter 3: Visualization Charts & Pivot Tables

Lecture 1: Charts

Lecture 2: Advanced Charts

Lecture 3: Pivot Tables

Chapter 4: Business Simulations & 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

Chapter 5: Automation – Macros & VBA

Lecture 1: Macros – Basics & Recording

Lecture 2: VBA Coding – Basics

Lecture 3: VBA Coding – Advanced

Lecture 4: VBA User Defined Function

Lecture 5: VBA: Creating a User Interface

Chapter 6: ADVANCED EXCEL TEST

Instructors

ForeVision Academy
Investment Banker | Edupreneur

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 11 votes
4 stars: 35 votes
5 stars: 32 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu