Curated Library
Comprehensive Microsoft Excel and VBA Programming in Telugu
Master Microsoft Excel from fundamental spreadsheet operations to advanced data analysis and automation. This course covers core formulas, lookup functions, PivotTables, and what-if analysis before diving into Visual Basic for Applications (VBA) macro development.
Lessons by Edusoft Learning Systems - Learning Simplified on YouTubeCurated by YodaHut. These lessons are hosted on YouTube and produced by their original creators, who are not affiliated with YodaHut. You still earn YodaCoins, keep your streak and track progress here.
What You'll Learn
- Navigate worksheets, format datasets, and apply conditional formatting rules
- Use essential formulas and lookup functions including IF, SUMIF, AVERAGEIF, VLOOKUP, and HLOOKUP
- Perform data analysis using PivotTables, PivotCharts, Goal Seek, Scenarios, and Data Tables
- Protect workbooks, audit formula errors, and manage sheet-level security permissions
- Write and debug VBA macros using loops, conditional statements, arrays, and event handlers
Prerequisites
- No prior experience needed
Course Curriculum
- 1Main Uses of Excel5:05
- 2Excel Starting Interface11:57
- 3How to Select Commands in Excel9:37
- 4Backstage View and File Tab7:43
- 5File Compatibility in Excel9:49
- 6Starting Work in a Sheet9:31
- 7Copy and Paste Techniques7:26
- 8Data Entry with AutoFill6:22
- 9Selecting Data to Modify7:42
- 10Modifying Worksheet Structure: Inserting and Deleting Rows and Columns6:27
- 11Formulas and Functions Basics8:06
- 12Data Entry Techniques4:55
- 13Adding Numbers Using Manual Formulas, SUM, and AutoSum7:36
- 14Numeric Functions in Excel5:24
- 15Absolute Cell References to Prevent Errors6:39
- 16Date and Time Formats and Placement3:10
- 17Logical IF Function6:42
- 18SUMIF and AVERAGEIF Functions6:14
- 19Naming Cell Ranges6:59
- 20Formatting Numbers and Dates8:23
- 21Applying Fonts, Colors, and Borders5:39
- 22Adjusting Columns, Rows, and Text7:55
- 23Conditional Formatting Basics5:53
- 24Custom Conditional Formatting Rules6:50
- 25Inserting Pictures and Shapes7:13
- 26Applying Themes5:02
- 27Applying Cell Styles3:59
- 28Creating Custom Cell Styles7:43
- 29Creating and Applying Templates6:36
- 30Setting Page Sizes, Margins, and Orientation8:27
- 31Header and Footer Settings4:16
- 32Printing Worksheets and Creating PDFs4:42
- 33Finding and Replacing Data4:23
- 34Freezing Panes3:13
- 35Repeating Header Rows6:32
- 36Creating Custom Views5:45
- 37Hiding and Grouping Rows and Columns7:45
- 38Managing Multiple Worksheets7:54
- 39Calculating Formulas Across Worksheets6:41
- 40Importing and Exporting Data10:46
- 41Setting Security and Permissions13:18
- 42Inserting and Editing Comments9:21
- 43Sharing Workbooks2:05
- 44Tracking Changes5:09
- 45Splitting Cell Data into Multiple Columns4:47
- 46Joining Data Across Cells3:51
- 47Sorting and Filtering Data6:51
- 48Creating Tables, Filtering, and Removing Duplicates4:12
- 49Calculating Group Subtotals5:27
- 50VLOOKUP and HLOOKUP Functions8:36
- 51Auditing Formulas in Worksheets7:07
- 52Formula Evaluation Tool4:16
- 53Working with Goal Seek7:23
- 54Using Data Tables in Formulas6:17
- 55Using Scenario Manager5:30
- 56Creating PivotTables6:10
- 57Modifying PivotTables5:29
- 58Creating PivotCharts4:55
- 59Working with Sparkline Charts5:26
- 60Creating and Customizing Column Charts7:45
- 61Creating and Customizing Pie Charts9:11
- 62Recording and Running Macros13:58
- 63Editing Recorded Macros7:26
- 64Customizing the Quick Access Toolbar4:55
- 65Customizing the Ribbon Bar8:03
- 66Configuring Excel Options7:42
- 67Introduction to Object-Oriented Programming Concepts8:24
- 68Working in the Visual Basic Editor (VBE)10:49
- 69Setting VBA Project Properties6:56
- 70Creating, Exporting, and Deleting Code Modules10:42
- 71Creating Subroutines and Functions7:42
- 72Controlling Procedure Scope and Visibility8:34
- 73Commenting and Executing VBA Code7:40
- 74Analyzing Recorded Macro Code4:48
- 75VBA Data Types and Variable Declarations11:14
- 76Variable Scope, Static Variables, and Constants8:44
- 77Object Variables and With Statements12:21
- 78Applying IF Conditions in VBA10:36
- 79Select Case Statements in VBA4:40
- 80Do While and Do Until Loops8:09
- 81For Loops in VBA5:23
- 82Working with Arrays in VBA14:29
- 83Iterating Arrays with For Each Loops5:03
- 84Error Handling with On Error Statements9:53
- 85Debugging Step-by-Step with Breakpoints8:07
- 86Using the Immediate and Watch Windows4:37
- 87Writing Values to Cells via VBA9:01
- 88Cutting, Copying, and Pasting Cell Data in VBA6:01
- 89Finding Cell Values and Addresses Programmatically4:46
- 90String Concatenation in VBA6:32
- 91String Manipulation and Substring Extraction6:43
- 92Workbook Open, Close, and Save Events6:56
- 93Worksheet Change Event Procedures4:06
About the Instructor
Edusoft Learning Systems - Learning Simplified
YouTube creator
93 lessons here 11h 1m
The lessons in this course were produced by Edusoft Learning Systems - Learning Simplified and are published on YouTube. YodaHut selected and sequenced them into this course; we did not make them, and Edusoft Learning Systems - Learning Simplified is not affiliated with YodaHut.
Visit the channel on YouTube
- 93 lessons
- 11h 1m of video
- Earns YodaCoins & streaks
- Timestamped notes
- Free — hosted on YouTube
No certificate is issued for Library courses.