Udemy - Advanced Excel and VBA 2021-22

seeders: 7
leechers: 10
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ TutPig.com ] Udemy - Advanced Excel and VBA 2021-22
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1. Introduction to Excel
    • 1. Introduction to spreadsheets.mp4 (42.3 MB)
    • 1. Introduction to spreadsheets.srt (8.9 KB)
    • 2. Conditional Formatting.mp4 (70.7 MB)
    • 2. Conditional Formatting.srt (13.2 KB)
    • 3. Data Validation.mp4 (34.2 MB)
    • 3. Data Validation.srt (6.8 KB)
    • 4. Advanced Filtering.mp4 (45.1 MB)
    • 4. Advanced Filtering.srt (7.6 KB)
    • 5. Vlookup and Hlookup.mp4 (35.7 MB)
    • 5. Vlookup and Hlookup.srt (6.6 KB)
    • 6. Functions.mp4 (64.3 MB)
    • 6. Functions.srt (11.3 KB)
    • 7. Dashboard.mp4 (123.8 MB)
    • 7. Dashboard.srt (14.0 KB)
    2. Introduction to VBA and Macros
    • 1. Introducton to VBA.mp4 (33.0 MB)
    • 1. Introducton to VBA.srt (8.2 KB)
    • 2. Interface of VBA.mp4 (33.7 MB)
    • 2. Interface of VBA.srt (7.3 KB)
    • 3. Using Range Property.mp4 (55.7 MB)
    • 3. Using Range Property.srt (12.0 KB)
    • 4. Using Rows Property.mp4 (52.7 MB)
    • 4. Using Rows Property.srt (9.8 KB)
    • 5. Using Columns Property.mp4 (37.4 MB)
    • 5. Using Columns Property.srt (9.4 KB)
    3. Using Variables in VBA
    • 1. Introduction to Variables.mp4 (55.5 MB)
    • 1. Introduction to Variables.srt (10.9 KB)
    • 2. If Statement in VBA.mp4 (34.2 MB)
    • 2. If Statement in VBA.srt (7.2 KB)
    • 3. For Loop in VBA.mp4 (44.4 MB)
    • 3. For Loop in VBA.srt (9.9 KB)
    • 4. Combination of Loops and Decision Statement.mp4 (29.0 MB)
    • 4. Combination of Loops and Decision Statement.srt (6.2 KB)
    • 5. User Defined Function.mp4 (39.8 MB)
    • 5. User Defined Function.srt (9.6 KB)
    4. Application on MIS Data
    • 1. Finding unique values.mp4 (54.2 MB)
    • 1. Finding unique values.srt (9.2 KB)
    • 2. Creating new worksheets based on unique values.mp4 (63.9 MB)
    • 2. Creating new worksheets based on unique values.srt (10.2 KB)
    • 3. Creating new workbooks based on unique values.mp4 (53.8 MB)
    • 3. Creating new workbooks based on unique values.srt (8.0 KB)
    5. UserForm and its Application
    • 1. Designing the UserForm.mp4 (24.4 MB)
    • 1. Designing the UserForm.srt (4.7 KB)
    • 2. Populating ComboBox.mp4 (74.9 MB)
    • 2. Populating ComboBox.srt (7.1 KB)
    • 3. Data Validation in UserForm.mp4 (16.5 MB)
    • 3. Data Validation in UserForm.srt (2.8 KB)
    • 4. Reading the Data through UserForm and Submitting it.mp4 (90.7 MB)
    • 4. Reading the Data through UserForm and Submitting it.srt (14.7 KB)
    • 5. Clearing the Form.mp4 (20.3 MB)
    • 5. Clearing the Form.srt (4.3 KB)
    • 6. Cancelling the form.mp4 (36.9 MB)
    • 6. Cancelling the form.srt (6.0 KB)
    • Bonus Resources.txt (0.3 KB)

Description

Advanced Excel and VBA 2021-22



https://TutPig.com

Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.23 GB | Duration: 2h 56m
A complete guide to Excel learning wherein you can have hands on experience and working knowledge on Excel.
What you'll learn
This course is all about learning VBA Macros and Adanced Excel in a practical way with the help of real time working examples.
This course has been made in length keeping in mind the various options and features of VBA Macros and Aavanced Excel.
Most professionals opting for only this module generally are looking at automation techniques and applications for some daily work they are doing.
The entire course has been broken down into 5 Sections comprising of 26 tutorial videos giving a clear picture on the various functions of Excel

Description
Enroll now to go through a deep dive of the most popular spreadsheet tool on the market, Microsoft Excel.

As you participate in each of the 4 sections you will master Excel tools that will clear away the pain of stumbling through your daily tasks. You will start with the basics, building a solid foundation that will give you further knowledge as you progress into intermediate and advanced level topics.

At completion of this course you will have mastered the most popular Excel tools and come out with confidence to complete any Excel tasks with efficiency and grace. Below are just a few of the topics that you will master:



Download torrent
1.2 GB
seeders:7
leechers:10
Udemy - Advanced Excel and VBA 2021-22
Loading...