Advanced Excel A-Z (With VBA) in Telugu

person icon Vijay Kumar Parvatha Reddy

4.2 ★★★★ ★

Buy Now

Advanced Excel A-Z (With VBA) in Telugu

Name: Advanced Excel A-Z (With VBA) in Telugu
Rating: 4.2 (398 reviews)
Author: Vijay Kumar Parvatha Reddy

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.2 ★★★★ ★

Add to Cart Buy Now

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

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.