SigmaWay's Advanced Excel Course

Name: SigmaWay's Advanced Excel Course
Rating: 4.4 (12 reviews)

Teaching intermediate to complex level Excel in an easy to follow way

Created byNitin Sinha, Amrita Arora, Jatin Nagpal

Last updated 8/2021

English

What you'll learn

MS- Excel
Pivot Tables
Pivot Charts
VBA
Macros
Lookup Function- Vlookup and Hlookup
Index and Match Function
Advanced MS- Excel with Case based Application
Goal Seek
Excel Solver
Buttons with Macros

Course content

4 sections • 15 lectures • 3h 0m total length

Introduction to Sigmaway and the Course3:25
The following topics will be covered in this module:-
Introduction to Advanced Excel
Course Contents & Methodology
System Requirements
Dataset Usage
Introduction to the case study5:14
The following topics will be covered in this module:-
1) The Case
Facile Solutions Ltd. Case
The Teams
Revenue Generation
Costs & Penalties
2) The Case Objective
The Issues
The Goals
Dataset for the case study3:48
The following topics will be covered in this module:-
Explained in details
Planned and actual date of each stage of service provided
The Sales Info Team

Understanding the Count Functions: Case Study - Issue 1:8:44
The following topics will be covered in this module:-
Using the COUNTIF and COUNTIFS Function
Percentage Calculations
Autofill Feature
Count Funtions Quiz
Case Study - Understanding the different functions in Excel - Issue 220:14
The following topics will be covered in this module:-
1) On-boarding Process
2) How to calculate the total planned and actual process days?
Possible Conditions
Formula for Planned and Actual Process
Calculation of extra time
Interpreting Results
Case Study - Finding the missing documents - Issue 313:20
The following topics will be covered in this module:-
Application of Filter and Copy Functions
Calculation of Extra Time
Finding Percentage of Total Extra Time
Interpreting Results
Case Study - Understating Pivot Table and VLOOKUP Functions - Issue 428:47
How to use VLOOKUP and HLOOKUP Functions
Application of INDEX and MATCH Functions
Creating Pivot Tables and Charts
Interpreting Results
Understanding Pivot Table and Vlookup
Case Study - Improving the situation - Issue 510:29
We will cover the following topics in this module:-
1) How to solve problem of Service B and C
Using COUNTIF AND COUNTIFS Function
Calculating Percentages
Interpreting Results
Improving the situation

Case Study - Calculating the annualized profit - Goal 120:41
We will cover the following topics in this module:-

Find annualized profits
Interpreting Results
Calculating annualized profits
Case Study - Solving the problem with VLOOKUP - Goal 216:11
We will cover the following topics in this module:-

Calculate Average cycle time using VLOOKUP
Solving the problem through Solver Function
Interpreting results
Solving problem with VLookup
Case Study - Solving the problem with Goal Seek Function - Goal 36:10
We will cover the following modules in this module:-

Estimate the target revenue for earning 10% more profit.
Calculating Month wise Revenue and Expenses for Facile Solutions using goal seek
Interpreting results
Solving problem with Goal Seek
Case Study - Creating Possible scenarios using Scenario Manager - Goal 412:10
We will cover the following topics in this module:-

Calculating profits for the first quarter in best, most likely and worst scenarios.
Calculating profits using Scenario Manager
Interpreting results
Creating Possible scenarios using Scenario Manager

Understanding Macros- An Introduction7:23
We will cover the following topics in this module:-
Understanding Macros
Installing the Developer Tab
Creating a Macro
Testing a Macro
Quiz: Understanding Macros- An Introduction
Basics of VBA- Your First VBA Code14:23
We will cover the following topics in this module:-
1) Description of VBA
2) VBE User Interface Explanation
3) Building and Testing your own VBA Course
Using Macros in the Facile Solutions Case9:29
We will cover the following topics in this module:-
USing VBA to Export a file
How to publish an Excel Sheet as a PDF using VBA
Setting Parameters of the Published File
How to make Macro Triggering Buttons in Excel
How to Link Macros to a Button

Requirements

Basic Excel Knowledge is Preferable but not Required

Description

Microsoft Excel is a spreadsheet application where we can do graphs, charts, and many other important day to day functions.

But, there are many things in excel which we do not explore.

SigmaWay is here to help you explore the full potential of Microsoft Excel, by teaching you Advanced Excel. Learning the skills of advanced excel can make you stand out in a big crowd.

If you are an employee, researcher, student, or entrepreneur, learning these advanced excel skills will make you a valuable resource in your team. Thinking on these terms, SigmaWay created its Advanced Excel Training, to help everyone unlock the full potential of this common tool and stand out in the crowd.

With Sigmaway's Advanced Excel Training, you will be able to master Core Concepts that will help you solve business problems and help you learn to manage data more efficiently.

The topics covered include.

Advanced Functions and Formulas Like :-

LOOKUP Functions (VLOOKUP/ HLOOKUP)
INDEX and MATCH functions
Goal Seek and Solver
Excel VBA
Excel Macros

This course is taught through an Industry Case Example, curated to teach students how to:-

Analyze business problems
Understand how data is manipulated and Cleaned
Application of techniques to find insights from data
Visualize Data
Set Up Auto-Updating Features using Macros
And More..

Please take your time and enjoy learning with us @ SigmaWay!!

Who this course is for:

Management Consultants
Analysts
Students
Business Students
Professionals
Freshers
Those wanting to Upskill

SigmaWay's Advanced Excel Course

What you'll learn

Explore related topics

Course content

Introduction to Sigmaway and the Course3 lectures • 12min

The Issues: Facile Solutions and Solving their Business Problems5 lectures • 1hr 22min

The Goals: Facile Solutions and their Business Goals4 lectures • 55min

Macros and VBA3 lectures • 31min

Requirements

Description

Who this course is for: