Advanced Excel Course in Telugu -

Advanced Excel and Excel Basics Course:
This course teaches you Excel in different Modules.
Each module contains multiple videos and I covered the content from basic to Advanced.
You will learn:
Concept of Excel
What is Excel?
Welcome to Excel world
Explore the each Ribbon
Know the different tools separated into various Groups
Learn with Real time Examples
Ribbon and Tabs
Quick Access Toolbar
Entering Text, Numbers and Dates
Editing Data
Auto Fill and Flash Fill
Selecting Ranges
Freeze Panes
Clipboard
Paste Special
Font Formatting
Alignment
Number Formatting
Borders
Conditional Formatting
Tables
Insert and Delete
Basics Formulas, Clear and Themes
Formula Basics
Cell Reference
Relative and Absolute Reference
Arithmetic Operators
Sorting
Filtering
Data Validation
Remove Duplicates
Text to Columns
Named Ranges
Text Cleaning
Column Chats
Bar Charts
Pie Charts
Spark Lines
Line Graphs
Chart Formatting
Trendlines
Advanced Excel Formulas:
Mathematical Functions
Date and Time Functions
Text Functions
Information Functions
Logical & Reference Functions
Other Functions
Pivot Tables
Pivot Charts
Slicers
Dashboard Basics
Interactive Reports
Introduction to VBA
Recording Macros
Running Macro
Simple VBA Scripts

Course Content

Module 1
In this Module you will learn What is Excel? Explore Excel options

What is Excel?

Module 2
In this Module you will learn: Ribbon and tabs Quick Access Toolbar Entering text, numbers, and dates Editing data AutoFill and Flash Fill Selecting ranges Freeze panes

Module 3
In this Module you will learn Font Formatting Cell Styles Alignment Borders and Color Conditional Formatting Row height and Column width Number Formatting Themes

Class 3.1 What is Cut, Copy, Paste? Format Painter

10:00
Class 3.2 Paste Special Part 1

10:37
Class 3.3 Paste Special Part 2

12:36
Class 3.4 Paste Special Part -3

07:19
Class 3.5 Font Formatting

11:05
Class 3.6 Alignment

15:59
Class 3.7 Number Formatting

21:06
Class 3.8 Borders

09:40
Class 3.9 Conditional Formatting Part 1

17:50
Class 3.10 Conditional Formatting Part 2

16:16
Class 3.11 Conditional Formatting Part 3

16:03
Class 3.12 Format as Tables and Tables

14:37
Class 3.13 Insert and Delete

14:55
Class 3.14 Explore Format

25:36
Class 3.15 How to use clear?

08:00
Class 3.17 Understand how Themes can change the formatting options

10:50

Module 4
In this Module you will learn Formula Basics Cell Reference Relative and Absolute Reference SUM Average Min/Max Count Round

Module 5
In this Module you will learn What is Sorting and how and when you apply sorting? Filtering and its need Data Validation Remove Duplicates Text to Columns Find and Replace Named Ranges

Module 6
In this Module you will learn Column Chart Pie Chart Line graphs Bar charts Spark Lines Chart Formatting Trendlines

Module 7
In this Module you will learn Mathematical Functions

Class 7.1 Average Function

25:38
Class 7.2 Int Function with realtime examples

00:00
Class 7.3 What is MOD Function? Highlighting alternate rows and using it with other functions

36:22
Class 7.4 What is Randbetween Function? Generate practice data

00:00
Class 7.5 Round Function and its rules

00:00
Class 7.6 SUM Formula and using it with other functions

00:00
Class 7.7 What is ABS Function? How to convert negative values into possitive values

00:00
Class 7.8 Learn Sign Function and how to use it with other function

00:00
Class 7.9 Max Function and MAXIFS and using it other functions

00:00
Class 7.10 What is MIN Function? How to use it with other functions

00:00
Class 7.11 What is Large Function and how to use it with other examples

00:00
Class 7.12 Learn SMALL Function with real time examples

00:00
Class 7.13 Rank Function, Rank with realtime examples, Rank with other functions

00:00

Module 8
In this Module you will learn Concatenate Find Search Left Right Len Lower MID Proper Rept Substitute Trim Upper

Class 8.1 What is Concat and Concatenate? How to combine text strings

00:00
Class 8.2 What is FIND function and how to find text strings

00:00
Class 8.3 SEARCH function with other functions (Left, Right Function)

00:00
Class 8.4 Left Function

00:00
Class 8.5 Right Function

00:00
Class 8.6 LEN function

00:00
Class 8.7 Lower Function

00:00
Class 8.8 MID Function

00:00
Class 8.9 Proper Function

00:00
Class 8.10 Rept Function

00:00
Class 8.11 Substitute Function

00:00
Class 8.12 Trim Function! Learn to Clean

00:00
Class 8.13 Upper Function

00:00

Module 9
In this Module you will learn Logical and Reference Functions

Class 9.1 Count Function

00:00
Class 9.2 CountA Function

00:00
Class 9.3 Countblank Function

00:00
Class 9.4 CountIF Function

00:00
Class 9.5 CountIFS Function

00:00
Class 9.6 AND
Class 9.7 OR
Class 9.8 IF
Class 9.9 SUMIF
Class 9.10 SUMIFS
Class 9.11 Index
Class 9.12 Match

Module 10
In this Module you will learn Date and Time Functions

Class 10.1 Day Function with other functions

00:00
Class 10.2 What is Month Function and how to use it with other functions

00:00
Class 10.3 All about Year Function

00:00
Class 10.4 How to create a Date and using it with other functions

00:00
Class 10.5 What is Second Function? How to use it with other functions

00:00
Class 10.6 What is Hour Function? Using it with other functions

00:00
Class 10.7 Master class of Minute function

00:00
Class 10.9 Master class of Networkdays function

00:00
Class 10.10 what is Weekday function? using it with other functions | Complete guide

00:00
Class 10.11 Master Today function? Explore the function with other functions

00:00
Class 10.12 Master class of NOW function

00:00
Class 10.13 Edate

00:00
Class 10.14 EOMONTH Masterclass

00:00

Module 11
In this Module you will learn Information Functions

Class 11.1 Column Function
Class 11.2 Row
Class 11.3 ISBlank
Class 11.4 Iserror
Class 11.5 isnumber
Class 11.6 istext
Class 11.7 isNA
Class 11.8 isErr
Class 11.9 IsLogic
Class 11.10 IsNontext

What Will You Learn?

Course Content

Module 1 In this Module you will learn What is Excel? Explore Excel options

What is Excel?

Module 2 In this Module you will learn: Ribbon and tabs Quick Access Toolbar Entering text, numbers, and dates Editing data AutoFill and Flash Fill Selecting ranges Freeze panes

Lesson 2.1 Ribbon and Tabs, Quick Access Toolbar, Entering Text, Numbers and Dates

Lesson 2.2 Auto Fill

Lesson 2.3 Flash Fill

Lesson 2.4 How do you Select Ranges?

Lesson 2.5 Freeze Panes

Module 3 In this Module you will learn Font Formatting Cell Styles Alignment Borders and Color Conditional Formatting Row height and Column width Number Formatting Themes

Class 3.1 What is Cut, Copy, Paste? Format Painter

Class 3.2 Paste Special Part 1

Class 3.3 Paste Special Part 2

Class 3.4 Paste Special Part -3

Class 3.5 Font Formatting

Class 3.6 Alignment

Class 3.7 Number Formatting

Class 3.8 Borders

Class 3.9 Conditional Formatting Part 1

Class 3.10 Conditional Formatting Part 2

Class 3.11 Conditional Formatting Part 3

Class 3.12 Format as Tables and Tables

Class 3.13 Insert and Delete

Class 3.14 Explore Format

Class 3.15 How to use clear?

Class 3.17 Understand how Themes can change the formatting options

Module 4 In this Module you will learn Formula Basics Cell Reference Relative and Absolute Reference SUM Average Min/Max Count Round

Class 4.1 Lets understand Formula Basics, Reference, Relative and Absolute Reference and Arithmetic symbols

Class 4.2 Start writing formulas SUM, Average, Count, Min and Max with practical examples

Module 5 In this Module you will learn What is Sorting and how and when you apply sorting? Filtering and its need Data Validation Remove Duplicates Text to Columns Find and Replace Named Ranges

Class 5.1 What is sort? When you can use Sorting?

Class 5.2 What is Filter and how to use it? learn with practical examples

Class 5.3 What is Data Validation? Types of Data validation? Learn it with Practical Examples

Class 5.4 Remove Duplicates (Data Clean)

Class 5.5 What is Text to Column? When to use it? (Data Cleaning)

Class 5.6 Find and Replace | Know about Find and Replace? Data Cleaning

Class 5.7 What is Name Range? How to create a Name Range, Editing and using it in Reports

Module 6 In this Module you will learn Column Chart Pie Chart Line graphs Bar charts Spark Lines Chart Formatting Trendlines

Class 6.1 Column Chart Part – 1 What is a Chart and Column Chart? Charts Formatting

Class 6.2 Column Chart Part – 2 Highlighting a Highest value and other examples

Class 6.3 What is Pie Chart and when you can use it.

Class 6.4 What is Line Chart and its benefits?

Class 6.5 Learn Bar Charts

Class 6.6 Sparkline Charts – Line Column Winloss

Module 7 In this Module you will learn Mathematical Functions

Class 7.1 Average Function

Class 7.2 Int Function with realtime examples

Class 7.3 What is MOD Function? Highlighting alternate rows and using it with other functions

Class 7.4 What is Randbetween Function? Generate practice data

Class 7.5 Round Function and its rules

Class 7.6 SUM Formula and using it with other functions

Class 7.7 What is ABS Function? How to convert negative values into possitive values

Class 7.8 Learn Sign Function and how to use it with other function

Class 7.9 Max Function and MAXIFS and using it other functions

Class 7.10 What is MIN Function? How to use it with other functions

Class 7.11 What is Large Function and how to use it with other examples

Class 7.12 Learn SMALL Function with real time examples

Class 7.13 Rank Function, Rank with realtime examples, Rank with other functions

Module 8 In this Module you will learn Concatenate Find Search Left Right Len Lower MID Proper Rept Substitute Trim Upper

Class 8.1 What is Concat and Concatenate? How to combine text strings

Class 8.2 What is FIND function and how to find text strings

Class 8.3 SEARCH function with other functions (Left, Right Function)

Class 8.4 Left Function

Class 8.5 Right Function

Class 8.6 LEN function

Class 8.7 Lower Function

Class 8.8 MID Function

Class 8.9 Proper Function

Class 8.10 Rept Function

Class 8.11 Substitute Function

Class 8.12 Trim Function! Learn to Clean

Class 8.13 Upper Function

Module 9 In this Module you will learn Logical and Reference Functions

Class 9.1 Count Function

Class 9.2 CountA Function

Class 9.3 Countblank Function

Class 9.4 CountIF Function

Class 9.5 CountIFS Function

Class 9.6 AND

Module 1
In this Module you will learn What is Excel? Explore Excel options

Module 2
In this Module you will learn: Ribbon and tabs Quick Access Toolbar Entering text, numbers, and dates Editing data AutoFill and Flash Fill Selecting ranges Freeze panes

Module 3
In this Module you will learn Font Formatting Cell Styles Alignment Borders and Color Conditional Formatting Row height and Column width Number Formatting Themes

Module 4
In this Module you will learn Formula Basics Cell Reference Relative and Absolute Reference SUM Average Min/Max Count Round

Module 5
In this Module you will learn What is Sorting and how and when you apply sorting? Filtering and its need Data Validation Remove Duplicates Text to Columns Find and Replace Named Ranges

Module 6
In this Module you will learn Column Chart Pie Chart Line graphs Bar charts Spark Lines Chart Formatting Trendlines

Module 7
In this Module you will learn Mathematical Functions

Module 8
In this Module you will learn Concatenate Find Search Left Right Len Lower MID Proper Rept Substitute Trim Upper

Module 9
In this Module you will learn Logical and Reference Functions

Module 10
In this Module you will learn Date and Time Functions

Module 11
In this Module you will learn Information Functions

Module 12 Other Functions
In this Module you will learn Lookup Vlookup Hlookup Xlookup DFunction Excel Errors

Module 13
In this Module you will learn Pivot Tables Pivot Charts Slicers Dashboard Basics Interactive Reports

Module 14
In this Module you will learn Introduction to VBA Recording macros Running Macros Simple VBA Scripts Automation Basics