About Course
Advanced Excel Course in Telugu
- In this course you will learn:
- Excel Basics, Advanced Excel and it includes.
- 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
- Trend lines
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
VBA
- Introduction to VBA
- Recording Macros
- Running Macro
- Simple VBA Scripts
Course Content
Module 1
-
What is Excel?
Student Ratings & Reviews
No Review Yet