Advanced Excel A-Z (With VBA) in Telugu
Micro Soft Excel A-Z ( Basics to Advanced with VBA) in Telugu
Updated on Jun, 2025
Language - Telugu
Office Productivity,Microsoft,Excel
Lectures -93
Resources -27
Duration -10.5 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
This course was created to aim at the students from beginners to experts. All who have Ms-Office 2007, 2010, 2013, or 2016 in their systems can easily understand and can apply. The course was designed by an expert having more than 20 years of experience in software training. Students will learn basic to advanced functions and formulas, including creating and using range names and logical, lookup, date and time, and common text functions. Students will analyze large amounts of data by creating, manipulating, and modifying PivotTables, PivotCharts, and Excel’s table features. At the end, students can learn how to write programming using VBA to manage data in Excel.
Goals
- Basics of MS Excel
- Data maintenance in Excel
- How to use formulas & functions
- How to maintain data tables & charts
- How to create & maintain macros
- How to write VBA programs to control data in Excel
Curriculum
Check out the detailed breakdown of what’s inside the course
Getting Started
6 Lectures
-
Welcome
03:02
03:02
-
Main uses of Excel
05:04
05:04
-
Excel Interface
11:56
11:56
-
How to select commands
09:36
09:36
-
Back stage view
07:42
07:42
-
File compatibility in excel
09:48
09:48
Worksheet Basics
5 Lectures
Excel formula basics
9 Lectures
Essential Formatting
6 Lectures
Advanced Formatting
4 Lectures
Printing Preparation
3 Lectures
Large Excel Projects
7 Lectures
Collaborating with Others
5 Lectures
Exploring Excel's Database Features
6 Lectures
Analyzing data
5 Lectures
Advanced Analysis with PivotTables
3 Lectures
Creating and Using Charts
3 Lectures
Creating and Using Macros
2 Lectures
Customizing Excel
3 Lectures
Introducing Visual Basic for Applications (VBA)
8 Lectures
Defining Variables,Constants & Calculations
3 Lectures
Adding Logic to Your VBA Code
5 Lectures
Debugging Your VBA Code
3 Lectures
Managing Workbook Elements & Data in VBA
4 Lectures
Using Excel Events in Your VBA Code
2 Lectures
Instructor Details
Vijay Kumar Parvatha Reddy
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now