Best seller!
Best seller!
$21.99
$19.99
Excel VBA Complete Guide Certification Video Training Course
The complete solution to prepare for for your exam with Excel VBA Complete Guide certification video training course. The Excel VBA Complete Guide certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Programming Languages Courses Excel VBA Complete Guide exam dumps, study guide & practice test questions and answers.
117 Students Enrolled
10:25:00 Hours
Excel VBA Complete Guide Certification Video Training Course Exam Curriculum
1
The Range Object
13 Lectures
Time 00:22:00
2
Range Properties
9 Lectures
Time 00:18:00
3
The Cells Object
5 Lectures
Time 00:10:00
4
Variables
7 Lectures
Time 00:23:00
5
Toolbars and Menus
8 Lectures
Time 00:28:00
6
Super Important Tools and Excel Logic
21 Lectures
Time 01:00:00
7
Loops and Report Writing Basics
23 Lectures
Time 01:32:00
8
EVENTS: Worksheet Events made Easy
13 Lectures
Time 00:32:00
9
WorkBook Events
17 Lectures
Time 00:44:00
10
Activex Controls on Worksheets
38 Lectures
Time 02:47:00
11
Userforms - the best thing. EVER.
17 Lectures
Time 01:51:00
12
BONUS Section - VBA Functions
4 Lectures
Time 00:18:00
The Range Object
-
4:00
1. Intro and Course Workbooks download
-
1:00
2. Get the Developer Tab and Intro to Developer Tab
-
1:00
3. Getting started with Range object
-
1:00
4. Quick Tip - Project Explorer and Properties Window!
-
2:00
5. Creating Your First Macro From Scratch
-
1:00
6. Adding a Secondary Command. . .
-
1:00
7. Debugging in Excel VBA
-
1:00
8. Saving a Macro-Enabled Workbook (.xlsm)
-
3:00
9. Before You Begin The Exercises...
-
1:00
10. Several Ways to trigger your Macro
-
2:00
11. Affecting Multiple Cells with One Range Command - 2 Methods
-
2:00
12. Adding Strings of Text to a Cell
-
2:00
13. Using a Named Range with the Range Object
Range Properties
-
2:00
1. .VALUE Property
-
1:00
2. .TEXT Property
-
1:00
3. .ROW and .COLUMN Properties
-
1:00
4. .SELECT Property
-
2:00
5. .COUNT Property
-
2:00
6. .ADDRESS Property
-
4:00
7. .FORMULA Property
-
2:00
8. .NUMBERFORMAT Property
-
3:00
9. FONT.BOLD, UNDERLINE or ITALIC Properties
The Cells Object
-
2:00
1. The Cells Object
-
1:00
2. Using Column Letters instead of Numbers
-
2:00
3. Using Cells Positionally within a Range
-
2:00
4. Affecting ALL Cells in a Worksheet
-
3:00
5. Using Range Object with Cells Object
Variables
-
2:00
1. Intro to Variables
-
3:00
2. Declaring Variables - Variable Types
-
4:00
3. Declaring Variables - Types Demo
-
2:00
4. Calling a Procedure from Another
-
3:00
5. Public and Private Variables
-
2:00
6. Using Constants
-
7:00
7. BONUS! Passing Variables to Another Procedure - ByVal and ByRef
Toolbars and Menus
-
2:00
1. File Menu walkthrough
-
5:00
2. Edit Menu walkthrough
-
2:00
3. View Menu walkthrough
-
8:00
4. View Menu2 - Watch Window, Locals Window and Immediate Window
-
3:00
5. Watch Window Wonders!
-
1:00
6. Insert and Format Menus
-
5:00
7. Debug Menu (Important!)
-
2:00
8. Run and Tools Menus
Super Important Tools and Excel Logic
-
3:00
1. Determining the Last Row in your Data Set
-
2:00
2. Determining the Last Column in your Data Set
-
1:00
3. Determining the Next Row in your Data Set
-
4:00
4. Recording a Macro
-
6:00
5. BONUS! - Dynamic Sorting!
-
4:00
6. Absolute vs Relative References
-
4:00
7. Using With and End With
-
1:00
8. Comparison Operators in Excel VBA
-
2:00
9. If Then Statement
-
1:00
10. Using Is Not Equal To (<>)
-
1:00
11. Logical Operator, NOT
-
1:00
12. If, Then, Else Statement
-
2:00
13. If, Then, ElseIF Statement. . .
-
3:00
14. Comparitive Operators with Text and Numbers!
-
2:00
15. Use If Then Statements in a One-Liner of code
-
2:00
16. Using GOTO and Labels
-
2:00
17. Select Case as Alternative to IF THEN Statements
-
6:00
18. Message Box with Yes and No Buttons
-
4:00
19. Relative Positioning using Offset
-
5:00
20. BONUS - User Defined Functions 101
-
4:00
21. BONUS - UDF Lesson 2
Loops and Report Writing Basics
-
3:00
1. Intro to Loops; the For Next Loop
-
4:00
2. Fun with our For Next Loop
-
6:00
3. Beginning our first Report using Loops
-
3:00
4. Using an InputBox
-
3:00
5. Adding InputBox to Our First Report to make it Dynamic
-
2:00
6. Add a Button to Open Our Report
-
2:00
7. Add a Cool Looking Button or Image to Open Report
-
5:00
8. Our First Printable Report part 1 - Declaring and Setting the Sheets
-
7:00
9. Printable Report Part 2 - Getting Items On Report Sheet
-
3:00
10. Printable Report Part 3 - Clearing Last Report
-
4:00
11. Printable Report Part 4 - Ensuring Visibility and Autoselect Report Sheet
-
1:00
12. Exercise 07a - Question
-
11:00
13. Exercise 07a - Answer
-
1:00
14. Using PrintPreview Automatically
-
2:00
15. Using PrintOut to Send Directly to Default Printer
-
2:00
16. Handling Debug Error When Cancelling InputBox
-
3:00
17. For Loop Going Backwards using STEP
-
5:00
18. The FOR EACH Loop
-
4:00
19. FOR EACH Loop - Practical Examples
-
1:00
20. Exercise 07b - Question
-
8:00
21. Exercise 07b - Answer
-
3:00
22. Intro to DO LOOPS
-
2:00
23. DO Until
EVENTS: Worksheet Events made Easy
-
4:00
1. Intro to Worksheet Events and Selection_Change
-
1:00
2. Worksheet Activate Event
-
2:00
3. Worksheet Deactivate Event
-
1:00
4. BeforeDelete Event - for Worksheet Deletion
-
3:00
5. BeforeDoubleClick Event - Trigger a Macro when Double Clicking
-
2:00
6. BeforeRightClick Event - Trigger a Macro when Right-Clicking
-
3:00
7. Calculate Event
-
2:00
8. How to Disable Events on the Workbook
-
1:00
9. Intro to Change Event
-
5:00
10. Change Event with EnableEvents toggle - Avoid endless loop!
-
3:00
11. Change Event Triggered with Custom Range Using Intersect
-
3:00
12. FollowHyperlinks Event
-
2:00
13. Final Thoughts on Worksheet Events and Review Other Events
WorkBook Events
-
5:00
1. Workbook Open
-
2:00
2. Workbook Activate
-
2:00
3. Before Save
-
2:00
4. After Save
-
4:00
5. Before Close
-
1:00
6. Before Print
-
1:00
7. Deactivate
-
3:00
8. NewChart
-
2:00
9. NewSheet
-
1:00
10. Exercise 09 - Question
-
5:00
11. Exercise 09 - Answer
-
2:00
12. Sheet Activate
-
5:00
13. Delete, DoubleClick, RightClick, Calculate, Change
-
3:00
14. SheetDeactivate
-
1:00
15. Follow Hyperlink
-
1:00
16. SheetSelectionChange
-
1:00
17. WindowActivate
Activex Controls on Worksheets
-
4:00
1. Activex Controls vs Forms Controls
-
4:00
2. Button Click - Wage Calculator
-
4:00
3. Keydown Event
-
3:00
4. BONUS: Capturing Shift, Alt, Ctrl or some combination using the Shift variable
-
3:00
5. KeyPress Event
-
2:00
6. MouseMove Event
-
4:00
7. MouseMove Event with Application.Statusbar - fun and useful
-
6:00
8. MouseUp and MouseDown Events - Left, Middle, & Rightclick, Shift, Alt & Ctrl
-
1:00
9. GotFocus and LostFocus Events
-
3:00
10. Use a Checkbox for its VALUE
-
2:00
11. Checkbox Event Without a Button
-
2:00
12. LinkedCell Property with a Checkbox
-
3:00
13. Option Buttons Intro - What is an Option Button and Grouping
-
3:00
14. Grouping, Alignment and Aesthetics for Controls
-
5:00
15. Homemade Quiz using Option Buttons and a Command Button
-
4:00
16. Compliance Checker for your Forms or Quizzes Part 1
-
10:00
17. Compliance check part 2
-
4:00
18. SpinButton with Cell A1
-
6:00
19. SpinButtons with Textboxes and Numbers
-
4:00
20. SpinButton BONUS - Move Textbox Position with SpinButton
-
4:00
21. SpinButton with Dates in a Textbox
-
4:00
22. Activex "Label" Control - Basics
-
4:00
23. ComboBox - Fill with ListFillRange
-
5:00
24. Creating a Dynamic Range
-
3:00
25. ComboBox - How to use Multiple Columns
-
9:00
26. Using .ADDITEM to Get Specific items in your Combobox List
-
6:00
27. Noteworthy Properties of a Combobox
-
7:00
28. Multiple Columns in Combobox with.ADDITEM and List, ListCount etc
-
8:00
29. ListBox Basics using Dynamic Range
-
3:00
30. Listbox Click event and Dynamic Options
-
6:00
31. BONUS - Manipulating and Using Multiselect Items in a Listbox
-
4:00
32. ListBox - Referencing Column 0 and 1 in a cell Dynamically!
-
10:00
33. Dynamic ListBoxes Using .ADDITEM and More
-
4:00
34. Make and Utilize INVISIBLE Columns - Special Trick!
-
3:00
35. Using a Scroll Bar on a worksheet
-
6:00
36. Pictures on a Worksheet, plus using FollowHyperlink Method
-
2:00
37. Toggle Button
-
2:00
38. A Brief Note on Alternate, 3rd Party Controls
Userforms - the best thing. EVER.
-
5:00
1. Userform - Hide, Show and Unload
-
6:00
2. Sample Database and Creating a Data Entry Form
-
4:00
3. Fill Status combobox with Rowsource when Userform starts - 2 methods
-
9:00
4. New Employee Data Entry Form!
-
3:00
5. Format Textbox Numbers as Numerals, Clearing out Form upon Submission
-
2:00
6. Set the Tab Order for Userform Controls
-
2:00
7. Set Default Values to Make Data Entry Easier
-
13:00
8. Avoid Duplicate Employee ID and other Fun Automation Tricks
-
11:00
9. Edit Mode for Employee Database - Part 1
-
8:00
10. Edit Mode for Employee Database - Part 2
-
16:00
11. Edit Mode Pt 3 - Adding Automation and Save Button
-
11:00
12. Userform Report with Filters - Part 1
-
6:00
13. Userform Report with Filters - Part 2
-
3:00
14. Applying the Dynamic Filters to Reports
-
3:00
15. Clear out Last Report
-
6:00
16. Report Generation and Aesthetics, Headers, Footers, Repeat Rows etc.
-
3:00
17. Concluding Thoughts. . .
BONUS Section - VBA Functions
-
7:00
1. InStr Function - Search for Text Within Other Text
-
6:00
2. The EVALUATE Function - Mac-Daddy of all functions
-
3:00
3. Sum Function in Excel VBA - EASY!
-
2:00
4. Count Function in VBA
About Excel VBA Complete Guide Certification Video Training Course
Excel VBA Complete Guide certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Prepaway's Excel VBA Complete Guide video training course for passing certification exams is the only solution which you need.
Pass Programming Languages Courses Excel VBA Complete Guide Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
Student Feedback
4.4
Good
Only Registered Members
Can View Online Video Courses
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Log into your Prepaway Account
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
IT Certification Tutorials
- Top-Level Project Management Certifications that Increase Your Career Value
- Will Python Be the Leading Language in 2019?
- List of the Most Important AWS Security Tools for Your Success
- What Opportunities Offered to The IT World by IBM Could Be Taken Advantage of in 2022
- ISACA COBIT 2019 - Business Case
- AI-102 Microsoft Azure AI - Implement Natural Language Processing Solutions
- PMI PMP Project Management Professional - Introducing Project Schedule Management Part 2
- DA-100 Microsoft Power BI - Part 4 Section 6 - Create and manage workspaces
- DA-100 Microsoft Power BI - Part 1 Level 8: Other Visualization Items for the DA-100 exam Part 2
- CompTIA CASP+ CAS-004 - Chapter 03 - Implementing Advanced Authentication and Cryptographic Techniques Part 4
- IIBA ECBA - Business Analysis and Requirements Life Cycle Management Part 3
- PMI PgMP - The Program Governance Domain
- Salesforce Certified Platform App Builder - 5 - Business Logic and Process Automation Part 7
- Amazon AWS Certified Data Analytics Specialty - Domain 4: Analysis Part 5
- Salesforce Admin ADM-211 - Process Automation : Overview
