Table of Contents
Advance Excel Mastery ................................................................................................. 4
COURSE MODULES ........................................................................................................ 5
MODULE INFORMATION ................................................................................................... 6
MODULE INFORMATION ................................................................................................. 10
Advance Power Query Mastery .................................................................................... 19
MODULE INFORMATION ................................................................................................. 20
Power BI Mastery .......................................................................................................... 24
MODULE INFORMATION ................................................................................................. 25
MODULE INFORMATION ................................................................................................. 32
Python Developer Mastery ........................................................................................... 37
CONTENT STRUCTURE .................................................................................................... 38
Statistics Mastery ........................................................................................................ 43
Module Information ..................................................................................................... 44
What you will learn in this Course.
Advance Excel Mastery
Excel Basics to Advanced: Module 1
Excel Data Management Tools: Module 2
Excel Advanced Data Tools: Module 3
Mastering Pivot Tables: Module 4
Excel Lookup Formulas Simplified: Module 5
Excel Formulas for Analysis: Module 6
Excel End-to-End Dashboard Project: Module 7
Back
COURSE MODULES
Additional Content
Excel Introduction: Module 1
Excel most useful option & Formulas: Module 2
Excel Data Tab: Module 3
Excel Pivot: Module 4
Excel Insert Tab & Chart: Module 5
Excel Page Layout and Formulas Tab: Module 6
Excel Review & View Tab | Vlookup: Module 7
Excel Statistical & Lookup Formula: Module 8
Excel Text, Financial & Date Formula: Module 9
Excel Advance Excel Topics: Module 10
Excel 2019 & 365 New Formula: Module 11
Excel Real Job Problem: Module 12
Excel Hidden Feature & Practical Problem: Module 13
Excel Complex Problem: Module 14
Excel Assignment & Interview: Module 15
Back
Content
MODULE INFORMATION
All Courses have Modules. Modules represent a block of content.
Excel Basics to Advanced: Module 1 Back
1 Microsoft Excel Introduction
2 Data Entry in Excel
3 Basic Formulas in Excel
4 Conditional Formatting
5 Advance Conditional Formatting
6 IF Condition Formulas
7 Data Formatting Options
8 Sheet Options of Excel
9 Assignment on IF Formula
Excel Data Management Tools: Module 2 Back
1 Sorting Data in Excel
2 Filtering Data in Excel
3 Advance Filter
4 Paste Special in Excel
5 Goto Special in Excel
6 Find and Replace in Excel
Excel Advanced Data Tools: Module 3 Back
1 Flash Fill
2 Text to Columns and Remove Duplicates & Consolidate
3 Data Validation
4 What if Analysis - Scenario Manager, Goal Seek, Data Table
5 Group, Ungroup and Subtotal
6 Assignment related Subtotal, Data table
Mastering Pivot Tables: Module 4 Back
1 Introduction of Pivot Table
2 Pivot Chart and Design
3 Slicer in Pivot table
4 Timeline in Pivot table
5 Top Bottom analysis
6 Pivot Table analyse Options
7 Calculated Field
8 Dynamic Range
9 Auto refresh
10 Pivot on Multiple Sheet
11 Show Values as in Pivot Table
12 Recommended Pivot Table
13 Pivot Table Assignment
Excel Lookup Formulas Simplified: Module 5 Back
1 Vlookup Formula Introduction
2 Fetching info from Large Data
3 Vlookup with Match
4 Use of Approx Match
5 Vlookup Formula - Find Matching
6 Double Vlookup
7 Match and Index
8 Assignment on Vlookup Formula
9 Xlooukp Formula Mastery
Excel Formulas for Analysis: Module 6 Back
1 Count, CountA, CountIF Formulas
2 SumIF and SumIFS Formulas
3 AverageIF, MAXIFS, MINIFS
4 Formulas for Insights - SORT, FILTER, TAKE
5 Assignment on - SORT, FILTER, TAKE
6 Useful Text Formulas
7 Date formulas for Analysis
8 Financial formulas for Analysis
Excel End-to-End Dashboard Project: Module 7 Back
1 Excel Project -End to End Dashboard
Content
MODULE INFORMATION
All Courses have Modules. Modules represent a block of content
ADDITIONAL CONTENT
Excel Introduction: Module 1 Back
1 Microsoft Excel Introduction
2 Learn Basic Formulas
3 IF Formula in Excel
4 IF And, IF OR Formula
5 Nested IF Formula in Excel
6 Nested if Calculate Discount
7 Salary Sheet Basic Formula
8 Salary Sheet Nested If
9 Attendance Sheet
Excel most useful option & Formulas: Module 2 Back
1 Sorting Data in Excel
2 Sort, Custom Sort & Filter
3 Conditional Formatting Basic
4 Conditional Formatting Advance
5 C F Highlight Alt Rows
6 Advance Filter
Excel Data Tab: Module 3 Back
1 Advance Filter Macro
2 Auto Sort Macro
3 Text to Columns
4 Flash Fill in Excel
5 Remove Duplicates and Consolidate
6 3D Formula
7 Data Validation
8 Scenario Manager
9 Goal Seek
10 Data Table
Excel Pivot: Module 4 Back
1 Home Tab 1
2 Home Tab 2
3 Home Tab 3
4 Home Tab 4
5 Find and Replace
6 Go to Special
7 Paste Special
8 Introduction to Pivot Table
9 Pivot Table Filter User
10 Pivot Table Options
Excel Insert Tab & Chart: Module 5 Back
1 Slicer and Timeline
2 Pivot Chart in Excel
3 Auto Refresh Pivot Table
4 Table in Excel
5 Insert Tab 1
6 Insert Tab 2
7 Excel Chart
8 Excel Chart and Formatting
9 Excel Sparkline Chart
10 Hyperlink in Excel
Excel Page Layout and Formulas Tab: Module 6 Back
1 Insert Tab 3
2 Watermark in Excel
3 Page Layout Tab: Themes and Margins
4 Page Layout Tab: Print Settings
5 Page Layout Tab 2
6 Page Layout Tab 3
7 Formula Tab: Name Manager
8 Formula Tab: Formula Auditing
9 Data Tab: Get External Data
10 Data Tab: Subtotal
Excel Review & View Tab | Vlookup: Module 7 Back
1 Data Tab: Solver Add-Ins
2 Review Tab
3 View Tab
4 Macro Recording
5 Create Your Own Tab
6 Vlookup 1: Introduction
7 Vlookup 2: Use of Range Lookup
8 Vlookup 3: Double Vlookup
9 Vlookup 4: Nested Vlookup
10 Vlookup 5: Vlookup Project
11 Vlookup 6- Unique Example Of Vlookup
Excel Statistical & Lookup Formula: Module 8 Back
1 Counta and Count Blank Formula
2 Countif Formula
3 Countifs Formula
4 Sumif and Sumifs
5 Averageif and Averageifs
6 Frequency Formula
7 Index and Match
8 Lookup Formula
9 Sumproduct, Left, and Find Formula
Excel Text, Financial & Date Formula: Module 9 Back
1 Right and Find
2 Mid and Find Formula
3 Repeat and Substitute Formula
4 Pmt, Pv, Fv Formula
5 Ipmt and Ppmt
6 Vlookup with Match
7 Text Formulas
8 Date in Quarter
9 Datedif Formula
10 Date Formula
Excel Advance Excel Topics: Module 10 Back
1 Switch Date
2 More Date Formulas
3 Ranking Formula
4 Concatenate and Vlookup
5 Sheet Tips
6 Excel to PowerPoint
7 Change Excel Icon
8 Number to Word
9 Custom Cells Tips
10 Picture Lookup
Excel 2019 & 365 New Formula: Module 11 Back
1 Picture Game
2 Data Entry Form
3 Field Menu
4 Excel Settings
5 Short Formulas
6 Database Function: DGET Formula in Excel
7 DSUM Formula in Excel
8 DAVERAGE Formula
9 DCOUNT and DCOUNTA Formula
10 DMAX Formula, DMIN Formula, DPRODUCT Formula
Excel Real Job Problem: Module 12 Back
1 Vlookup on Multiple Tables
2 Introduction to Offset Formula
3 Offset Formula: Calculate Sum of Last 6 Days
4 Real Job Use of Offset Formula
5 Practical Use of Sumifs, Index, Match
6 Practical Use of Isblank and Istext Formula
7 Excel Interview Question: Counting Words
8 Build Login in Excel Formula
9 Create Dynamic List Using Index, Match Formula
10 Conditional Formatting with Text and OR Formula
Excel Hidden Feature & Practical Problem: Module 13 Back
1 Unique Example of Conditional Formatting
2 Auto Sort Data Using Countif, Match, and Index Formula
3 Condition Inside Rank Using Countifs Formula
4 Camera, Autofilter, Form: 3 Hidden Features
5 Max If and Min If Formula Using Array
6 Choose Formula in Excel
7 Swap Range in Excel
8 Reverse Lookup Using Choose Formula
9 Reverse Lookup Using Match and Index
10 Find & Vlookup: Real Job Query
Excel Complex Problem: Module 14 Back
1 Vlookup Duplicate Names Issue
2 Vlookup with Choose Formula and Array
3 Text Join Formula in Excel 2019
4 Ifs Formula in Excel 2019
5 Maxifs and Minifs in Excel 2019
Excel Assignment & Interview: Module 15 Back
1 Excel Interview Questions - 1
2 Excel Interview Questions - 2
3 Excel Interview Questions - 3
4 Excel Interview Questions - Mode Function
5 Excel Interview Questions – Goto and Conditional Formatting
What you will learn in this Course.
Advance Power Query Mastery
02
Installation and Connection in Power Query: Module 1
Advanced Pivot Table Techniques: Module 2
Data Transformation and Management: Module 3
Advanced Data Manipulation Techniques: Module 4
Pivot and Unpivot: Module 5
Back
Content
MODULE INFORMATION
All Courses have Modules. Modules represent a block of content.
Installation and Connection In Power Query: Module 1 Back
1 Introduction and Installation
2 Create Connections with Excel Table
3 Create Connections with Text file and Access Database
4 Reconnect Data in Power Query
Advanced Pivot Table Techniques: Module 2 Back
1 Create Pivot table on Text file data
2 Merge Multiple Sheets Using M-Language
3 Create Pivot table on Multiple Sheets
4 Close and Load to Explain - Home tab - Query Group
Data Transformation and Management: Module 3 Back
1 Home Tab - Manage Column And Rows Group
2 Home Tab - Split Column into rows and columns
3 Home Tab - Group by using Basic and Advance Option
4 Home Tab - Data type - Replace Values
5 Transform data Vertically
6 Combine 1000+ Tables with 1 Function
7 Alter options of Vlookup inside Power Query
Advanced Data Manipulation Techniques: Module 4 Back
1 Multiple Columns Lookup
2 Remove Weekends and Holidays
3 Calculate Age with simple Method
4 Calculate Task Timings
5 Power Query - Add Column Date Options in Detail
6 Time and Duration Options in Details
7 Transform Raw Data - Real Job Query
8 Few Clicks To Get Trim, Proper Case And Merge Data
9 Merge Workbooks And Create Pivot
10 Merge Workbooks With File Name As Column
11 Raw Data to Pivot
12 Merge Vs Append
13 Custom Calendar
14 Merge Data Dynamically
Pivot and Unpivot: Module 5 Back
1 Pivot and Unpivot
2 Pivot Magic: Excel Power Query Pivot Tables on Multiple Sheets
What you will learn in this Course.
Power BI Mastery
03 Power BI Mastery
Microsoft Power BI Introduction & ELT: Module 1
Visualizing Data – Basics: Module 2
Advanced Visualizations: Module 3
Power BI Service and Reporting: Module 4
Advanced Dashboard Creation: Module 5
Understanding Data Model: Module 6
DAX Functions and Formula: Module 7
Additional Topics and Tips: Module 8
Power BI Pro Tips: Module 9
Back
Back
Back
Content
MODULE INFORMATION
All Courses have Modules. Modules represent a block of content.
Microsoft Power BI Introduction & ELT: Module 1 Back
1 Power BI Introduction
2 How to Load Data in Power BI
3 Transform Data
4 Canvas & Page Settings
Visualizing Data – Basics: Module 2 Back
1 Let's Start Visualization
2 Format Visuals
3 Format Visuals - General
Advanced Visualizations: Module 3 Back
1 Line, Area, and Ribbon Chart
2 View and Save Visuals as PDF
3 Water and Funnel Chart
4 Scatter Chart
5 Pie, Donut, and Tree Map Chart
6 Map, Filled Map, Shape Map
7 Azure Map
8 Gauge Chart
9 Card & Multi-Row Card
10 KPI - Key Performance Indicator
11 Table Visual
12 Matrix Visual
13 Decomposition Tree
14 Key Influencer and Smart Narrative
15 Conditional Formatting
Power BI Service and Reporting: Module 4 Back
1 How to Publish Report on Power BI Service
2 Filter Options in Power BI
3 Drill Through in Power BI
4 Drill Through with Button
5 Edit Interaction in Power BI
6 Use Cards as Text Cards
7 Bookmarks Pane
8 Sync Slicer & Performance Analyzer
Advanced Dashboard Creation: Module 5 Back
1 Creating Dashboard Using Visualization
2 Creating Table Relationship in Power BI
3 Creating Measures in Power BI
4 Measure with IF Condition
5 Basic Measure in Power BI
6 Measure with Emoji
Understanding Data Model: Module 6 Back
1 What is DATA Model
2 Data Concepts - Data Normalization
3 Managing Relationships
4 Filter Flow & 2-Way Filter
5 Properties in Model
DAX Functions and Formula: Module 7 Back
1 DAX Functions Introduction
2 Implicit Vs. Explicit Measures
3 Ways to Adding Columns and Measures
4 Quick Measures and Suggestions
5 DAX Syntax
6 DAX Operators
7 DAX - Date & Time Functions
8 Logical and Conditional Functions
9 Text Functions
10 Calculate DAX Formula
11 Sum Vs SUMX
12 RANX DAX In Power BI
13 Difference Between CountX and CountAX
14 Create Own Calendar using Formula
15 MTD, QTD, YTD Functions
16 Same Period Last Year DAX Function
17 Previous Month, Quarter, Year DAX
18 DateADD DAX Function
19 DATESBETWEEN and DATESINPERIOD DAX
20 DAX Function - Related
21 HAS ONE VALUE - DAX Function
22 Selected Value and Switch DAX
23 What are Variables in DAX
24 Practical Use of Variables
25 Calendar DAX Formula in Power BI
Additional Topics and Tips: Module 8 Back
1 How to use Power BI free for two Months
2 How to Publish Report on Web
3 New Slicer in Power BI
4 How to connect SQL Server data to Power BI
5 Export Data into excel from Power BI file
Power BI Pro Tips: Module 9 Back
1 Create unique layout
2 Add image without Image visual
3 Add image as tooltip
What you will learn in this Course.
Advance SQL Mastery
Introduction to SQL: Module 1
Database and Table Management: Module 2
Data Manipulation: Module 3
Advanced Table Operations: Module 4
SQL Queries and Operators: Module 5
Date Functions in SQL: Module 6
Join Functions in SQL: Module 7
Sub Query in SQL: Module 8
Window Functions in SQL: Module 9
SQL Case Statements Simplified: Module 10
Back
Content
MODULE INFORMATION
All Courses have Modules. Modules represent a block of content.
Introduction to SQL: Module 1 Back
1 Introduction Of SQL
2 Installation Of SQL
3 Interface of pgAdmin IDE
4 Types of Commands In SQL
Database and Table Management: Module 2 Back
1 Create Database And Table
2 Simple Way To Create Table
3 Data Types & Constraints in SQL
4 Use of Alter Command in SQL
5 Inserting Data into Table
6 Deleting Data From Table
Data Manipulation: Module 3 Back
1 Update Data Into Table
2 Update data without Commands
3 Query Toolbar
4 Difference Between Delete, Truncate and Drop
Advanced Table Operations: Module 4 Back
1 Auto Assigned ID Using Identity Constraint
2 Import data from CSV to SQL Direct Method
3 With Command Import data from CSV to SQL
SQL Queries and Operators: Module 5 Back
1 Basic SQL Queries 1
2 Basic SQL Queries 2
3 Basic SQL Queries 3
4 Basic SQL Queries 4
5 Practice SQL Queries with new Data
6 Logical Operators and Detail use
7 Use of not null and Not in
8 Use of Union Operator
9 Group By and Having in SQL
Date Functions in SQL: Module 6 Back
1 Basic Date Functions in SQL
2 Date Functions in SQL – Part 2
3 Use of Age Function
4 String Functions in SQL
Join Functions in SQL: Module 7 Back
1 Joins in SQL
2 Left Join in SQL
3 Right and Full Join in SQL
4 Joins Overview
5 Self Join in SQL
6 Union and Union All
Sub Query in SQL: Module 8 Back
1 Sub Query in SQL
2 Sub Query with IN Operator
3 Assignment on Sub Query
Window Functions in SQL: Module 9 Back
1 Aggregate Window Functions
2 Analytic Window Functions
3 Ranking Window Functions
4 Assignment on Window Functions
SQL Case Statements Simplified: Module 10 Back
1 Case Statement in SQL
2 Case Statement - Multiple Statement
3 Case with Where Clause
4 Case with Values only
Course Instructor: MD SADDAM HUSSAIN ANSARI
What you will learn in this Course.
Python Developer Mastery
Chapter 1: Introduction to Python
Chapter 2: Operators
Chapter 3: String
Chapter 4: Conditional Statements
Chapter 5: Looping Statements
Chapter 6: Container Data Types
Chapter 7: Functions
Chapter 8: Modules/Library
Chapter 9: File Handling
Chapter 10: Exception Handling
Chapter 11: Projects
Chapter 12: Data Analytics
Back
Content
CONTENT STRUCTURE
Chapters represent a structured block of learning content.
Chapter 1: Introduction to Python Back
1 Introduction & Installation of Python
2 Variables & First Program
3 Comment & Data Types
Chapter 2: Operators Back
1 Operators and its Precedence
2 Type Casting
3 Calculator App ( Basic & Advance Both)
Chapter 3: String Back
1 What is String
2 String Slicing
3 String Methods
Chapter 4: Conditional Statements Back
1 If Statement
2 If else Statement
3 Nested If else Statement
4 Palindrome Program & Grade System program
Chapter 5: Looping Statements Back
1 Introduction of Loop, & For Loop Statement
2 While Loop Statement
3 Use of Range() Function
4 Use of Break Statement in Loop
5 Use of Continue Statement in Loop
Chapter 6: Container Data Types Back
1 Introduction of List
2 List Methods
3 Introduction of Tuple
4 Tuple Methods
5 Introduction of Set
6 Set Methods
7 Introduction of Dictionary
8 Dictionary Methods
Chapter 7: Functions Back
1 Introduction of Function / Methods
2 Function with Parameter
3 Function With Default Parameter
4 Use of *args & **kwargs
5 Marksheet Management System using *args & **kwargs
6 Return Statement
7 Pass Statement
8 Variable Scope
9 Lambda Function (Anonymous Function)
10 Recursion
Chapter 8: Modules/Library Back
1 Introduction of Modules
2 User Defined Modules
Chapter 9: File Handling Back
1 Introduction of File Handling
2 CSV File Reading
3 CSV File Writing
Chapter 10: Exception Handling Back
1 Introduction of Exception Handling
2 Custom (User Defined) Exception Handling
Chapter 11: Projects Back
1 YouTube Video Caption Downloader
2 YouTube Video Downloader
3 QR Code Generator
4 Barcode Generator
Chapter 12: Data Analytics Back
1 NumPy
2 Pandas
3 Matplotlib
Mastery
Course Instructor: MS. AYUSHI MISHRA
What you will learn in this Course.
Statistics Mastery
Introduction to Statistics: Module 1
Descriptive Statistics: Module 2
Probability: Module 3
Inferential Statistics: Module 4
Back
Content
Module Information
All Courses have Modules. Modules represent a block of content.
Introduction to Statistics: Module 1 Back
1 What is statistics?
2 Types of statistics
3 Types of data
4 Types of variables
5 Population and sample
6 Sampling techniques
7 Statistical Analysis
Descriptive Statistics: Module 2 Back
1 Measures of Central Tendency
2 Measures of dispersion
3 Frequency
4 Graphical Visualization
5 Outliers
6 Covariance and Correlation
Probability: Module 3 Back
1 Introduction to probability
2 Types of events
3 Conditional Probability
4 Bayes Theorem
5 Probability Distribution
6 Discrete Distribution
7 Continuous Distribution
8 Standardization and Normalization
9 Empirical Rule
Inferential Statistics: Module 4 Back
1 Inferential statistics
2 Confidence Interval
3 Hypothesis Testing
4 Types of Errors
5 One Tailed and Two Tailed test
6 Student's T distribution
7 Z Test
8 T Test
9 ANOVA Test
10 Chi Square Test
11 Stats Outro
Appearance
What you will learn in this Course.
Online Appearance
Online Appearance: Module 1
Resume Projects: Module 2
Interview Cracking: Module 3
GitHub: Module 4
Job Search Essentials Learn How to Navigate Top Portals
Back
Content
MODULE INFORMATION
All Courses have Modules. Modules represent a block of content.
Online Appearance: Module 1 Back
1 What is LinkedIn
2 Create your Account
3 Add Profile Photo and Background Photo
4 Add About us and Skills
5 Add Profile Headline and Experience
6 More Profile Options
7 Privacy and Settings
8 Profile URL and Connecting People
9 How to Search & Apply for Job
10 Asking for Referral
Resume Project: Module 2 Back
1 Resume Project 1: Power BI - Food App Orders Dashboard
2 Resume Project 2: Power BI - Grocery Stores Data Dashboard
Competence
Interview Cracking: Module 3 Back
1 Introduction Of Interview Cracking Course
2 Crafting Resumes That Pass the ATS: A Step-by-Step Guide
3 Optimize Your Resume for ATS: Proven Tips & Tricks
4 Building an ATS-Friendly Resume: Best Practices Unveiled
5 Crafting a Standout Cover Letter: A Complete Guide
6 Reading Job Descriptions and Applying for Jobs
7 Personal Branding on Professional Platforms
8 Building a Strong Online Presence
9 Networking and Professional Development
10 Introducing Yourself in Interviews
11 Navigating Different Interview Rounds
12 Essential Interview Topics
13 Salary Negotiation Techniques
14 Making Insights-Driven Decisions
15 Emotional Intelligence (EQ) in the Workplace
16 Remote Work Skills
17 Developing a Growth Mindset
18 Time Management and Productivity
19 Reviewing Offer Letters and Legal Documents
20 Industry-Specific Knowledge and Trends
21 Ethical Considerations in Data Handling
22 Cultural and Diversity in the Workplace
23 Handling Rejections and Building Resilience
24 Conclusion
GitHub: Module 4 Back
1 Mastery From Basic to Adv.
Job Search Essentials Learn How to Navigate Top Portals Back
1 [Link] Tutorial Login, Create Profile, and Find Your Dream Job
2 [Link] Simplified A Complete Guide for Job Seekers
3 Glassdoor Simplified How to Explore Reviews, Salaries, and Job
Opportunities
4 Indeed, Uncovered Job Searching, Applications, and Career Insights
5 Times Jobs Made Easy Create Profiles, Search Jobs, and Boost Your
Career