There are no items in your cart
Add More
Add More
Item Details | Price |
---|
Become an Excel expert and automate tasks with VBA macros
Instructor: Deepthi Reddy
Language: English
Validity Period: Lifetime
Description:
This comprehensive course is designed for individuals who want to become Excel experts and master VBA macros. Starting from the basics, you will learn advanced techniques and functionalities of Microsoft Excel to efficiently manage and analyze data. The course will also guide you through the fundamentals to advance of VBA macros, enabling you to automate tasks and create custom functions in Excel. By the end of this course, you will be equipped with the knowledge and skills to confidently navigate and utilize Excel for complex data manipulation and analysis.
Key Highlights:
What you will learn:
Excel | Basic Excel | |||
Basic Excel | |||
Structure Of Excel Application 36:00 | Preview | ||
Structure Of Excel Application | Preview | ||
Versions 19:00 | Preview | ||
Versions File | Preview | ||
Shortcut Keys 35:00 | Preview | ||
ShortcutKeys | Preview | ||
Reference Concept 14:00 | |||
Reference Concept | |||
Hierarchy Dropdown | |||
Hierarchy Dropdowns | |||
Define Name 16:00 | |||
Define Name | |||
Errors 7:00 | |||
Errors | |||
Excel | Date & Time Functions | |||
Date & Time Functions - 1 | |||
Date & Time Functions - 2 | |||
Date and Time | |||
Practice File 1 | |||
Excel | Logical Functions | |||
Logical Functions | |||
Logical Function | |||
Practice File-2 | |||
Excel | Arithmetic Functions | |||
Arithmetic Functions | |||
Arithmetic Functions | |||
Practice File | |||
Excel | Lookup & Reference Functions | |||
Match | |||
Match | |||
Choose | |||
Choose | |||
VLookup | |||
Vlookup | |||
Hlookup | |||
Hlookup | |||
Index | |||
Index | |||
Wildcard and Indirect | |||
Wildcard and Indirect | |||
Offset | |||
Offset | |||
XLookup | |||
Xlookup | |||
Excel | Text Functions | |||
Text Functions | |||
Text Functions | |||
Excel | Charts | |||
Charts | |||
charts | |||
Excel | Advanced Charts | |||
Advanced Chart | |||
Advanced Chart | |||
Excel | Pivots | |||
Pivots | |||
pivots | |||
Excel | Tabs | |||
Home Tab | |||
Home Tab | |||
Data Tab - I | |||
Data Tab - II | |||
Data Tab | |||
Review Tab | |||
Review Tab | |||
View Tab | |||
View Tab | |||
Page Layout | |||
Page Layout | |||
VBA | Visual Basic Editor Window | |||
Visual Basic Editor Window | Preview | ||
VBA(Macros) | Preview | ||
VBA | Types of Code windows | |||
Types of Code windows | Preview | ||
VBA(Macros) | Preview | ||
VBA | Procedures and Conditions | |||
Procedures and Conditions | Preview | ||
VBA(Macros) | Preview | ||
VBA | Object_Properties_Methods | |||
Object_Properties_Methods | |||
VBA(Macros) | |||
VBA | Cell_reference | |||
Cell_reference | |||
VBA(Macros) | |||
VBA | Assign_Macro | |||
Assign_Macro | |||
VBA(Macros) | |||
VBA | Cell_Properties | |||
Cell_Properties | |||
VBA(Macros) | |||
VBA | Cell_Methods | |||
Cell_Methods | |||
VBA(Macros) | |||
VBA | Sheet_Reference | |||
Sheet_Reference | |||
VBA(Macros) | |||
VBA | Sheet_Methods | |||
Sheet_Methods | |||
VBA(Macros) | |||
VBA | WB_References | |||
WB_References | |||
VBA(Macros) | |||
VBA | WB_Methods | |||
WB_Methods | |||
VBA(Macros) | |||
VBA | Create_Delete_Folder | |||
Create_Delete_Folder | |||
VBA(Macros) | |||
VBA | Basic_Act | |||
Basic_Act | |||
VBA(Macros) | |||
VBA | Variable_Declaration | |||
Variable_Declaration | |||
VBA(Macros) | |||
VBA | Levels of Declaration | |||
Levels of Declaration | |||
VBA(Macros) | |||
VBA | Input_Msgbox | |||
Input_Msgbox | |||
VBA(Macros) | |||
VBA | For_Next_Loop | |||
For_Next_Loop | |||
VBA(Macros) | |||
VBA | Color_Index | |||
Color_Index | |||
VBA(Macros) | |||
VBA | Creating_Table | |||
Creating_Table | |||
VBA(Macros) | |||
VBA | Mutliple_Sheets | |||
Mutliple_Sheets | |||
VBA(Macros) | |||
VBA | Multiple_Workbooks | |||
Multiple_Workbooks | |||
VBA(Macros) | |||
VBA | Multi_Loop | |||
Multi_Loop | |||
VBA(Macros) | |||
VBA | Insert_Rows | |||
Insert_Rows | |||
VBA(Macros) | |||
VBA | Last_Row_Column | |||
Last_Row_Column | |||
VBA(Macros) | |||
VBA | Delete_Rows_Columns | |||
Delete_Rows_Columns | |||
VBA(Macros) | |||
VBA | For_Act | |||
For_Act | |||
VBA(Macros) | |||
VBA | If_Statement | |||
If_Statement | |||
VBA(Macros) | |||
VBA | If_Statement Activities | |||
If_Statement Activities | |||
VBA(Macros) | |||
VBA | If_And_Statement | |||
If_And_Statement | |||
VBA(Macros) | |||
VBA | If_Or_Statement | |||
If_Or_Statement | |||
VBA(Macros) | |||
VBA | If_And_Or | |||
If_And_Or | |||
VBA(Macros) | |||
VBA | Case_Stmnt | |||
Case_Stmnt | |||
VBA(Macros) | |||
VBA | Last_Row_Column | |||
Last_Row_Column | |||
VBA(Macros) | |||
VBA | Above_Below_Activity_1 | |||
Above_Below_Activity_1 | |||
VBA(Macros) | |||
VBA | Above_Below_Filters_Act_2 | |||
Above_Below_Filters_Act_2 | |||
VBA(Macros) | |||
VBA | Data_Segregation_Sheets | |||
Data_Segregation_Sheets | |||
VBA Segregation _ Consolidation File | |||
VBA | Data_Consolidation_Sheets | |||
Data_Consolidation_Sheets | |||
VBA Segregation _ Consolidation File | |||
VBA | VBA_Functions | |||
VBA_Functions | |||
VBA(Macros) | |||
VBA | GoTo Command | |||
GoTo Command | |||
VBA(Macros) | |||
VBA | Worksheet_functions | |||
Worksheet_functions | |||
VBA(Macros) | |||
VBA | Vlookup_Index_Match | |||
Vlookup_Index_Match | |||
VBA(Macros) | |||
VBA | Error_Handling_Methods | |||
Error_Handling_Methods | |||
VBA(Macros) | |||
VBA | Do_While | |||
Do_While | |||
VBA(Macros) | |||
VBA | Do_Until | |||
Do_Until | |||
VBA(Macros) | |||
VBA | Do_While_Act | |||
Do_While_Act | |||
VBA(Macros) | |||
VBA | For_Each_Loop | |||
For_Each_Loop | |||
VBA(Macros) | |||
VBA | Record_Macro | |||
Record_Macro | |||
VBA(Macros) | |||
VBA | For_Each_Loop_2 | |||
For_Each_Loop_2 | |||
VBA(Macros) | |||
VBA | File_Picker | |||
File_Picker | |||
VBA(Macros) | |||
VBA | Folder_Picker | |||
Folder_Picker | |||
VBA(Macros) | |||
VBA | Folder_Picker_Act | |||
Folder_Picker_Act | |||
VBA(Macros) | |||
VBA | Folder_Picker_Act_2 | |||
Folder_Picker_Act_2 | |||
VBA(Macros) | |||
VBA | Data_Segregation_Workbooks | |||
Data_Segregation_Workbooks | |||
VBA Segregation _ Consolidation File | |||
VBA | Consolidation_Workbook | |||
Consolidation_Workbook | |||
VBA Segregation _ Consolidation File | |||
VBA | User_Defined_Functions | |||
User_Defined_Functions | |||
VBA(Macros) | |||
VBA | Extract_Numbers_Text | |||
Extract_Numbers_Text | |||
VBA(Macros) | |||
VBA | Userform1 | |||
Userform1 | |||
VBA(Macros) | |||
VBA | UserForm II | |||
UserForm II | |||
VBA(Macros) | |||
VBA | UserForm III | |||
Userform III | |||
VBA(Macros) | |||
VBA | Complete VBA Code Files | |||
VBA(Macros) |
After successful purchase, this item would be added to your Library.
You can access the library in the following ways :