Advanced Excel A-Z in Telugu
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Excel A-Z in Telugu to your Wishlist.

Add to Wishlist

Advanced Excel A-Z in Telugu

Micro Soft Excel A-Z ( Basics to Advanced with VBA) in telugu
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
0 students enrolled
Created by Vijay Kumar
Last updated 6/2017
Telugu
Price: $30
30-Day Money-Back Guarantee
Includes:
  • 11 hours on-demand video
  • 30 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
Requirements
  • Ms-Office 2013 ( But 95% of features will work in Ms-office 2007,2010,2016)
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.


Who is the target audience?
  • Who wants to Learn Ms-excel from basics to Advanced including VBA programming
Students Who Viewed This Course Also Viewed
Curriculum For This Course
94 Lectures
11:02:38
+
Getting Started
6 Lectures 47:09



How to select commands
09:36

Back stage view
07:42

File compatability in excel
09:48
+
Worksheet Basics
5 Lectures 37:23
Starting work in a sheet
09:30

Copy Paste technics
07:25

Auto fill while data entry
06:21

Selecting data to do modifications
07:41

Changing worksheet structure by inserting and deleting rows and columns
06:26
+
Excel formula basics
9 Lectures 55:36
Formulas and functions basics
08:05

Some data entry technics
04:54

Adding numbers in excel using manual and sum and autosum
07:35

More functions on numbers
05:23

Absolute reference to prevent errors
06:38

Date and times placement
03:09

If function
06:41

Sumif and averageif functions
06:13

Naming range of cells
06:58
+
Essential Formatting
6 Lectures 41:47
Formatting Numbers and Dates
08:22

Applying Fonts , Colors & Borders
05:38

Adjesting Columns,Rows & Text
07:54

Conditional Formatting
05:52

Custom Conditional Formatting
06:49

Adding Pictures and Shapes
07:12
+
Advanced Formatting
4 Lectures 23:16
Applying Themes
05:01

Applying Styles
03:58

Creating Custom styles
07:42

Creating & Applying Templates
06:35
+
Printing Preparation
3 Lectures 17:22
Setting Page size, margins & orientation
08:26

Headers & Hooter settings
04:15

Printing & Creating PDF
04:41
+
Large Excel Projects
7 Lectures 42:06
Finding & Replacind Data
04:22

Freezing Panes
03:12

Heading Rows Repeating
06:31

Custom views Creation
05:44

Hiding or grouping columns & rows
07:44

Managing Worksheets
07:53

Calculating Formulas across worksheets
06:40
+
Collaborating with Others
5 Lectures 40:34
Importing & Exporting Data in excel
10:45

Setting security permissions
13:17

Inserting & Editing comments
09:20

Sharing Workbook
02:04

Tracking Changes
05:08
+
Exploring Excel's Database Features
6 Lectures 33:38
Splitting a cell data into multiple cells
04:46

Joining data from multiple cells
03:50

Sorting and filtering data
06:50

Creating tables to sort,filter and remove duplicates
04:11

Sub totals group wise
05:26

VLookup & Hlookup functions to query the values
08:35
+
Analyzing data
5 Lectures 30:28
Auditing formulas in data
07:06

Formulas Evaluation in data
04:15

Working with Goal-seek tool
07:22

Using data tables in formulas
06:16

Using scenarios in formulas
05:29
10 More Sections
About the Instructor
Vijay Kumar
4.0 Average rating
1 Review
3 Students
19 Courses
Passionate teacher

Vijay Kumar is a passionate teacher with a strong focus on pragmatism and simplicity. He started teaching programming 25 years ago when the first set of general use computers were just reaching the shores of India. He is known for his teaching style with strong emphasis on bringing clarity to the learners right from basics till advanced features.