Advanced Excel A-Z (With VBA) in Telugu
Created by Vijay Kumar Parvatha Reddy, Last Updated 31-Aug-2020, Language:Tegulu
Advanced Excel A-Z (With VBA) in Telugu
Micro Soft Excel A-Z ( Basics to Advanced with VBA) in Telugu
Created by Vijay Kumar Parvatha Reddy, Last Updated 31-Aug-2020, Language:Tegulu
What Will I Get ?
- 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
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.
Course Content
-
Getting Started
6 Lectures 00:47:08-
Welcome
00:03:02 -
Main uses of Excel
00:05:04 -
Excel Interface
Preview00:11:56 -
How to select commands
00:09:36 -
Back stage view
00:07:42 -
File compatibility in excel
00:09:48
-
-
Worksheet Basics
5 Lectures 00:37:23-
Starting work in a sheet
Preview00:09:30 -
Copy Paste Technics
Preview00:07:25 -
Auto fill while data entry
Preview00:06:21 -
Selecting data to do modifications
Preview00:07:41 -
Changing worksheet structure by inserting and deleting rows and columns
00:06:26
-
-
Excel formula basics
9 Lectures 00:55:36-
Formulas and functions basics
00:08:05 -
Some data entry Technics
Preview00:04:54 -
Adding numbers in excel using manual and sum and autosum
00:07:35 -
More functions on numbers
00:05:23 -
Absolute reference to prevent errors
00:06:38 -
Date and times placement
00:03:09 -
If function
00:06:41 -
Sumif and averageif functions
00:06:13 -
Naming range of cells
00:06:58
-
-
Essential Formatting
6 Lectures 00:41:47-
Formatting Numbers and Dates
00:08:22 -
Applying Fonts , Colors & Borders
00:05:38 -
Adjusting Columns,Rows & Text
00:07:54 -
Conditional Formatting
00:05:52 -
Custom Conditional Formatting
00:06:49 -
Adding Pictures and Shapes
00:07:12
-
-
Advanced Formatting
4 Lectures 00:23:16-
Applying Themes
00:05:01 -
Applying Styles
00:03:58 -
Creating Custom styles
00:07:42 -
Creating & Applying Templates
00:06:35
-
-
Printing Preparation
3 Lectures 00:17:22-
Setting Page size, margins & orientation
Preview00:08:26 -
Headers & Hooter settings
00:04:15 -
Printing & Creating PDF
00:04:41
-
-
Large Excel Projects
7 Lectures 00:42:06-
Finding & Replacing Data
Preview00:04:22 -
Freezing Panes
00:03:12 -
Heading Rows Repeating
00:06:31 -
Custom views Creation
00:05:44 -
Hiding or grouping columns & rows
00:07:44 -
Managing Worksheets
00:07:53 -
Calculating Formulas across worksheets
00:06:40
-
-
Collaborating with Others
5 Lectures 00:40:34-
Importing & Exporting Data in excel
00:10:45 -
Setting security permissions
00:13:17 -
Inserting & Editing comments
00:09:20 -
Sharing Workbook
00:02:04 -
Tracking Changes
00:05:08
-
-
Exploring Excel's Database Features
6 Lectures 00:33:38-
Splitting a cell data into multiple cells
00:04:46 -
Joining data from multiple cells
00:03:50 -
Sorting and filtering data
00:06:50 -
Creating tables to sort,filter and remove duplicates
00:04:11 -
Sub totals group wise
00:05:26 -
VLookup & Hlookup functions to query the values
00:08:35
-
-
Analyzing data
5 Lectures 00:30:28-
Auditing formulas in data
00:07:06 -
Formulas Evaluation in data
00:04:15 -
Working with Goal-seek tool
00:07:22 -
Using data tables in formulas
00:06:16 -
Using scenarios in formulas
00:05:29
-
-
Advanced Analysis with PivotTables
3 Lectures 00:16:31-
Creating PivotTable
00:06:09 -
Altering PivotTable
00:05:28 -
Creating Pivot Chart
00:04:54
-
-
Creating and Using Charts
3 Lectures 00:22:19-
About Charts & Creating Sparkline Chart
00:05:25 -
Creating & Modifying Column Charts
00:07:44 -
Creating & Modifying Pie Charts
00:09:10
-
-
Creating and Using Macros
2 Lectures 00:21:22-
Creating Macros
00:13:57 -
Editing Macros
00:07:25
-
-
Customizing Excel
3 Lectures 00:20:37-
Customizing Quick Access Tool Bar
00:04:54 -
Customizing Ribbon Bar
00:08:02 -
Setting Excel Options
00:07:41
-
-
Introducing Visual Basic for Applications (VBA)
8 Lectures 01:05:27-
Introduction to Object Oriented Programming
00:08:23 -
Working in VB Editor
Preview00:10:48 -
Setting VBA Project Properties
Preview00:06:55 -
Creating, Exporting & Deleting Code Modules
Preview00:10:41 -
Creating Subroutine or Function
00:07:41 -
Controlling Procedure Scope & Visibility
00:08:33 -
Adding Comments & Different ways to run VBA code
00:07:39 -
Coding Macro You Recorded
00:04:47
-
-
Defining Variables,Constants & Calculations
3 Lectures 00:32:16-
Data Types in VBA & Variables declaration
00:11:13 -
Scope of variables and Static, Constant Variables
00:08:43 -
Defining & using object variables. How to use With Statement
00:12:20
-
-
Adding Logic to Your VBA Code
5 Lectures 00:43:35-
How to apply If condition
Preview00:10:35 -
How to apply Do, While & Until loops
00:08:08 -
How to apply For loop
00:05:22 -
Arrays
00:14:28 -
Arrays & ForEach loop
00:05:02
-
-
Debugging Your VBA Code
3 Lectures 00:22:34-
Error Handling using On Error Statements
00:09:52 -
Debugging Step by Step and Break points
00:08:06 -
Using Immediate & Watch windows
00:04:36
-
-
Managing Workbook Elements & Data in VBA
4 Lectures 00:26:58-
Writing values to cell using program
00:09:00 -
Finding values & address of cells
00:04:45 -
String Concatenation
00:06:31 -
Returning Part of a String
00:06:42
-
-
Using Excel Events in Your VBA Code
2 Lectures 00:11:00-
Raising Event Procedure when open, close or save a file
00:06:55 -
Raising Event Procedure When Changing Data in cells
00:04:05
-