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

00:00
Class 3.5 Font Formatting

00:00
Class 3.6 Alignment

00:00
Class 3.7 Number Formatting

00:00
Class 3.8 Borders

00:00
Class 3.9 Conditional Formatting Part 1

00:00
Class 3.10 Conditional Formatting Part 2

00:00
Class 3.11 Conditional Formatting Part 3

00:00
Class 3.12 Format as Tables and Tables

00:00
Class 3.13 Insert and Delete

00:00
Class 3.14 Explore Format

00:00
Class 3.15 How to use clear?

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

00:00

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
Class 7.2 Int Function
Class 7.3 Mod Function
Class 7.4 Randbetween Function
Class 7.5 Round Function
Class 7.6 SUM Function
Class 7.7 ABS Function
Class 7.8 Sign Function
Class 7.9 Max Function
Class 7.10 Min Function
Class 7.11 Large Function
Class 7.12 Small Function
Class 7.13 Rank Function

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

Class 8.1 Concatenate
Class 8.2 Find
Class 8.3 Search
Class 8.4 Left
Class 8.5 Right
Class 8.6 Len
Class 8.7 Lower
Class 8.8 MID
Class 8.9 Proper
Class 8.10 Rept
Class 8.11 Substitute
Class 8.12 Trim
Class 8.13 Upper

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

Class 9.1 Count Function
Class 9.2 CountA
Class 9.3 Countblank
Class 9.4 CountIF
Class 9.5 CountIFS
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
Class 10.2 Month
Class 10.3 Year
Class 10.4 Date
Class 10.5 Second
Class 10.6 Hour
Class 10.7 Minute
Class 10.8 Minute
Class 10.9 Networkdays
Class 10.10 Weekday
Class 10.11 Today
Class 10.12 Now
Class 10.13 Edate
Class 10.14 Emonth

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.7 isErr
Class 11.8 IsLogic
Class 11.9 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

Class 7.3 Mod Function

Class 7.4 Randbetween Function

Class 7.5 Round Function

Class 7.6 SUM Function

Class 7.7 ABS Function

Class 7.8 Sign Function

Class 7.9 Max Function

Class 7.10 Min Function

Class 7.11 Large Function

Class 7.12 Small Function

Class 7.13 Rank Function

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

Class 8.1 Concatenate

Class 8.2 Find

Class 8.3 Search

Class 8.4 Left

Class 8.5 Right

Class 8.6 Len

Class 8.7 Lower

Class 8.8 MID

Class 8.9 Proper

Class 8.10 Rept

Class 8.11 Substitute

Class 8.12 Trim

Class 8.13 Upper

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

Class 9.1 Count Function

Class 9.2 CountA

Class 9.3 Countblank

Class 9.4 CountIF

Class 9.5 CountIFS

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