Tutorialspoint

April Learning Carnival is here, Use code FEST10 for an extra 10% off

Advanced Excel A-Z (With VBA) in Telugu

person icon Vijay Kumar Parvatha Reddy

4

Advanced Excel A-Z (With VBA) in Telugu

Micro Soft Excel A-Z ( Basics to Advanced with VBA) in Telugu

updated on icon Updated on Apr, 2024

language icon Language - Telugu

person icon Vijay Kumar Parvatha Reddy

category icon Office Productivity,Excel,VBA

Lectures -93

Resources -27

Duration -10.5 hours

4

price-loader

30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.

Course Description

This course was created to aiming at the students from beginners to Experts. All who are having Ms-Office 2007,2010,2013,2016 in their systems can easily understand and can apply. The course was designed by an expert having more than 20 years 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 student can learn how write programming using VBA to manage data in excel.


Goals

What will you learn in this course:

  • 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
Advanced Excel A-Z (With VBA) in Telugu

Curriculum

Check out the detailed breakdown of what’s inside the course

Getting Started
6 Lectures
  • play icon Welcome 03:02 03:02
  • play icon Main uses of Excel 05:04 05:04
  • play icon Excel Interface 11:56 11:56
  • play icon How to select commands 09:36 09:36
  • play icon Back stage view 07:42 07:42
  • play icon File compatibility in excel 09:48 09:48
Worksheet Basics
5 Lectures
Tutorialspoint
Excel formula basics
9 Lectures
Tutorialspoint
Essential Formatting
6 Lectures
Tutorialspoint
Advanced Formatting
4 Lectures
Tutorialspoint
Printing Preparation
3 Lectures
Tutorialspoint
Large Excel Projects
7 Lectures
Tutorialspoint
Collaborating with Others
5 Lectures
Tutorialspoint
Exploring Excel's Database Features
6 Lectures
Tutorialspoint
Analyzing data
5 Lectures
Tutorialspoint
Advanced Analysis with PivotTables
3 Lectures
Tutorialspoint
Creating and Using Charts
3 Lectures
Tutorialspoint
Creating and Using Macros
2 Lectures
Tutorialspoint
Customizing Excel
3 Lectures
Tutorialspoint
Introducing Visual Basic for Applications (VBA)
8 Lectures
Tutorialspoint
Defining Variables,Constants & Calculations
3 Lectures
Tutorialspoint
Adding Logic to Your VBA Code
5 Lectures
Tutorialspoint
Debugging Your VBA Code
3 Lectures
Tutorialspoint
Managing Workbook Elements & Data in VBA
4 Lectures
Tutorialspoint
Using Excel Events in Your VBA Code
2 Lectures
Tutorialspoint

Instructor Details

Vijay Kumar Parvatha Reddy

Vijay Kumar Parvatha Reddy

Course Certificate

Use your certificate to make a career change or to advance in your current career.

sample Tutorialspoint certificate

Our students work
with the Best

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
Annual Membership

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
Online Certifications

Talk to us

1800-202-0515