Advance Excel

Home

Courses

/Advanced Microsoft Excel Course (Live Session)

Advanced Microsoft Excel Course (Live Session)

Learn with Mohammad Kashif

16 modules

Englis & Hindi

Lifetime access

Unlock the full potential of Excel with advanced techniques for data analysis and manipulation.

Overview

Advance Excel is a comprehensive course designed to enhance your Excel skills and take your data analysis to the next level. This course covers advanced Excel functions, formulas, and techniques that will allow you to manipulate and analyze data with ease. From complex formulas to advanced data visualization, this course will equip you with the necessary skills to become an Excel power user.

Key Highlights

Master advanced Excel functions

Manipulate and analyze complex data sets

Create dynamic charts and graphs

Perform data modeling and analysis

Learn time-saving tips and tricks

What you will learn



Master advanced Excel functions

Learn how to leverage advanced functions like VLOOKUP, INDEX-MATCH, SUMPRODUCT, and more to solve complex problems and streamline your data analysis workflow.



Manipulate and analyze complex data sets

Discover techniques for cleaning, transforming, and structuring large datasets using Excel's powerful data manipulation tools. Learn how to work with PivotTables, Power Query, and data validation to automate tasks and gain valuable insights.



Create dynamic charts and graphs

Explore the advanced charting capabilities of Excel and learn how to create interactive and dynamic visualizations. Discover techniques for customizing graph elements, adding trendlines, and presenting data in an impactful way.



Perform data modeling and analysis

Gain a deep understanding of Excel's data modeling features, such as What-If Analysis, Scenario Manager, and Solver. Learn how to perform complex data analysis tasks, such as regression analysis and goal-seeking, to make informed business decisions.



Learn time-saving tips and tricks

Discover hidden features, shortcuts, and productivity hacks that will significantly speed up your Excel workflow. From keyboard shortcuts to automating repetitive tasks, this course will help you become more efficient and proficient in Excel.

Modules

Introduction & Overview of Excel (Basic)

14 attachments • 1 mins

Lecture 1.1 About excel (Intro)

Lecture 1.2 Setting up column and row / Dragging cells in Excel.

Lecture 1.3 Basic mathematical calculations

Lecture 1.4 Paste special and format painter

Lecture 1.5 Custom formatting and alignment

Lecture 1.6 All numbers formatting

Lecture 1.7 Conditional formatting

Lecture 1.8 Sorting / Custom sorting

Lecture 1.9 Data filtering (Basic / Advance)

Class 1

Class 1A

Basic Excel Class 1

CLASS 2 Basic Excel

Class 3 Basic Excel

Pivot In Depth with 15+ Examples

9 attachments • 1 mins

Lecture 1.1 Pivot Intro

Lecture 1.2 Use of Rows fields, Column fields & Report Filters

Lecture 1.3 Use of Value Field Setting in Pivot

Lecture 1.4 Arranging Date Field in Pivot

Lecture 1.5 Grouping in Pivot

Lecture 1.6 Report Layouts in Pivot

Lecture 1.7 Making Pivot Range Dynamic

Lecture 1.8 Calculated Fields in Pivot

Lecture 1.9 Introduction about Power Pivot

Data Analysis in Pivot

6 attachments • 1 mins

Lecture 1.1 Use of Percent of Grand Total

Lecture 1.2 Use of Row & Column Total

Lecture 1.3 Difference from & Percent Difference From

Lecture 1.4 Use of Percent of

Lecture 1.5 Ranking in Pivot

Lecture 1.6 Running Total ( Cumulative Frequency )

Data Visualization - Pivot Chart | Slicer | Dashboard

6 attachments

Lecture 1.1 Use of Slicer in Pivot

Lecture 1.2 Pivot Connections with Slicer

Lecture 1.3 Use of Timeline

Lecture 1.4 Making Pivot Charts

Lecture 1.5 Use of Legends in Pivot Charts

Lecture 1.6 Dashboard Using Slicer and Pivot Charts

Charts in Depth 10+ Examples

6 attachments

Lecture 1.1 Column, Line, Pie, Bar, Area, Scatter Charts

Lecture 1.2 Different Methods of Making Charts

Lecture 1.3 Difference between Clustered & Staked Charts

Lecture 1.4 Charts Elements Setting

Lecture 1.5 Linear & Linear Forecast Trend Lines

Lecture 1.6 Overview of Deep Settings

Link & Page Setup

8 attachments • 25.2 mins

Lecture 1.1 Hyperlinking Websites, E-mail, and Files

Lecture 1.2 Hyperlinking Sheet Cells

Lecture 1.3 Header And Footer

Lecture 1.4 Page Setup (Margins, Size, Printing Area)

Lecture 1.5 Print Titles (Top & Left)

Lecture 1.6 Content Printing Solutions

Hyperlink

Hyperlink File 2024

Logical Formulas 10+ Examples

11 attachments

Lecture 1.1 Formulas Intro (Concept & Operators)

Lecture 1.2 If Function with Logical Arguments

Lecture 1.3 Nesting with if

Lecture 1.4 And + Or Formulas in Excel

Lecture 1.5 Nesting with If + And + Or

Lecture 1.6 If Error Implementation

Class 1 IF Formula

Class 2 IF Formula

Class 3 if Formula

Formula Class 1 (IF)

Formula Class 2 (Or + And)

Text Formulas with 10+ Examples

11 attachments • 1 hrs

Lecture 1.1 Concatenate

Lecture 1.2 Upper, Lower, Proper & Trim

Lecture 1.3 Len & Rept

Lecture 1.4 Find & Search

Lecture 1.5 Replace & Substitute

Lecture 1.6 All above formulas and its Implementation on Real Corporate Data.

Text Class 2

Text Formulas Class 1

Text Formulas Class 2

Text Formulas Class 3

Data & Time

8 attachments • 6.46 mins

Lecture 1.1 Date & Time Formula

Lecture 1.2 DateValue & TimeValue

Lecture 1.3 Day, Month, Year Formulas

Lecture 1.4 Edate, EOMonth

Lecture 1.5 Networkdays & Networkdays.INTL

Lecture 1.6 All above formulas and its Implementation on Real Corporate Data.

Date & Time

Date _ Time Task Sheet

Lookup Formulas 15+ Examples

11 attachments • 1 hrs

Lecture 1.1 Relative & Absolute References

Lecture 1.2 Vlookup Intro (Concept & Arguments)

Lecture 1.3 Use of Vlookup with Different Scenarios

Lecture 1.4 Vlookup With Match

Lecture 1.5 Approximate Match & Exact Match in Vlookup

Lecture 1.6 Vlookup on Large Corporate Data

Lecture 1.7 Hlookup Formula

Lecture 1.8 Index & Match Formulas

Lecture 1.9 All above formulas and its Implementation on Real Corporate Data.

VLookup & HLookup and Array Basic

Vlookup+HLookup With Match

Statistical Functions

11 attachments • 1 mins

Lecture 1.1 Sumif & Countif

Lecture 1.2 Sumifs & Countifs

Lecture 1.3 Averageif & AverageIfs

Lecture 1.4 Count Blank & CountA

Lecture 1.5 Dynamic Data Update With Above Functions

Lecture 1.6 Implementation on Real Corporate Data.

Class 1 Statistical Functions

Class 2 Statistical Functions

All Sum Formulas - Sumifs to DSum

All Count Formulas - Count to DCount A

All Average Formulas - Average to D Average 2

Formulas & Data Tab

11 attachments

Lecture 1.1 Name manager & Auditing formals

Lecture 1.2 Getting external data (Access, SQL)

Lecture 1.3 Advance filter

Lecture 1.4 Text to column wizard

Lecture 1.5 Remove duplicates

Lecture 1.6 Setting up data validations (with creating drop down list)

Lecture 1.7 Consolidation & Scenario manager

Lecture 1.8 Goal seek and data table

Lecture 1.9 Recording & Assign Macros

Lecture 1.10 Advance conditional formatting

Lecture 1.11 Course Revision & Doubt Clearing Session

Mathematics & Info formulas

5 attachments

Lecture 1.1 Abs Formulas

Lecture 1.2 Round / RoundUp /RoudnDown

Lecture 1.3 Small & Large

Lecture 1.4 Rand + RandBetween

Lecture 1.5 IsText, Is Number, IsBlank, IsError

Data Manipulation and Analysis with Power Query

6 attachments • 5 mins

Introduction to Power Query

Importing & Transforming Data with Power Query

Merging and Appending Data Tables

Cleaning and Shaping Data using Power Query

Using Power Query to Connect External Data Sources

Advanced Data Transformation Techniques with Power Query

New Office 365 Formulas

7 attachments

Lecture 1.1 Import Data with Filter Formulas in Excel 365

Lecture 1.2 Sort in Excel 365

Lecture 1.3 Unique in Excel 365

Lecture 1.4 Sequence in Excel 365

Lecture 1.5 Text Join & Text Split in Excel 365

Lecture 1.6 Dynamic Array Concept in Excel 365

Lecture 1.7 X-Lookup in Excel 365

Live Class for V-Lookup, H-Lookup, X-Lookup

14 attachments • 2 hrs

Vlookup & H Lookup Basic Class 1

Vlookup & Hlookup Basic IMHRA

Vlookup & HLookup Basic Notes

V-Lookup & Hlookup HR Data Task sheet -IMHRA

Vlookup with Different File

Vlookup and HLookup with Match Class 2

VLOOKUP HLOOKUP With Match Class 2

Reverse VLookup Class 3

Reverse Vlookup IMHR Academy

Project on Vlookup & Match

X-Lookup Class 4

Xlookup -Class 4

Index + Match Class 5

Index and Match

FAQs

How can I enrol in a course?

Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.

Can I access the course materials on any device?

Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.

How can I access the course materials?

Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.

Can I interact with the instructor during the course?

Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.

About the creator

Learn with Mohammad Kashif

Welcome to our HR Generalist Course, where we take you on an exciting journey through the multifaceted world of Human Resources.He has managed the full spectrum of HR functions, from Recruitment to Labour Compliance, Compensation & Benefits, Performance Management, and Employee Engagement.

As an HR trainer, sharing his extensive 12 Years of practical knowledge and real-world experiences with the next generation of HR professionals to drive positive change and elevate your HR initiatives.

Rate this Course

Advanced Microsoft Excel Course (Live Session)

Learn with Mohammad Kashif

16 modules

Englis & Hindi

Lifetime access

₹ 3500.00

₹0

₹ 3500.00

₹5000