Get $1 credit for every $25 spent!

The Ultimate Excel VBA Certification Bundle + Microsoft Office Professional Plus 2021 for Windows: Lifetime License

Ending In:
Add to Cart - $79
Add to Cart ($79)
$609
87% off
wishlist

What's Included

Product Details

Microsoft Office Professional 2021 for Windows

By nerdused | in Apps + Software

Everything a pro needs, all in one suite — that’s Microsoft Office 2021 Professional.

Microsoft Office 2021 Professional is the perfect choice for any professional who needs to handle data and documents. It comes with many new features that will make you more productive in every stage of development, whether it’s processing paperwork or creating presentations from scratch – whatever your needs are!

The tools within this suite have been redesigned so they can be used equally by designers looking for inspiration on how best to present their work, as well as data analysts working with large sets of data for their company reports; there really isn’t anything left out when using these applications.

The ribbon-based user interface provides quick access to all its available features, tools, and customizations. Users can easily customize font, layout, indentation size of type in documents as well as many other details. Make more aesthetically pleasing documents without sacrificing functionality for work-related needs like formatting emails or creating presentations.

  • Lifetime license for MS Word, Excel, PowerPoint, Outlook, Teams, OneNote, Publisher, & Access
  • One-time purchase installed on 1 Windows PC for use at home or work
  • Instant Delivery & Download – access your software license keys and download links instantly
  • Free customer service – only the best support!


Office Professional 2021 includes:
  • Microsoft Office Word
  • Microsoft Office Excel
  • Microsoft Office PowerPoint
  • Microsoft Office Outlook
  • Microsoft Office Teams
  • Microsoft Office OneNote
  • Microsoft Office Publisher
  • Microsoft Office Access

System Requirements

  • Windows 10, 11
  • Recommended 1 GB of RAM
  • 4 GB available of hard disk formatting such as HFS + (also known as Windows OS Extended or HFS Plus)
  • A monitor with 1280×800 resolution or higher

Important Details

  • ONE-TIME PURCHASE FOR 1 PC
  • Redemption deadline: redeem your code within 30 days of purchase
  • Access options: desktop
  • No subscriptions – no monthly/annual fees
  • Version: 2021
  • All languages supported
  • Updates included
  • Have questions on how digital purchases work? Learn more here



Access
Lifetime
Content
3.0 hours
Lessons
37

Excel VBA 101: Range & Cells

Master the CELLS & RANGE Objects in Multiple Scenarios

By Daniel Strong | in Online Courses

This course will be guiding you through the basics of how to create your first macro from scratch and read & write to cells. It will go in-depth about all the properties and methods you need in order to manipulate one or more cells. You can change the font size, color, bold or italic, but also set formulas or format cells easily using VBA! Explore the differences and similarities between accessing a cell through the Range object and the new Cells object, which can now access cells using row, column coordinates! This is useful when utilizing numeric loops and variables. It will also cover different ways to run your macros, including making a cool-looking button to trigger your macro.

4.6/5 average rating: ★ ★ ★ ★

  • Access 37 lectures & 3 hours of content 24/7
  • Learn how to Record, Modify or Write Macros from scratch
  • Master the Cells & Range objects in multiple scenarios
  • Learn to tweak recorded macros & how to read the code
  • Know how to Step Through & Debug a subprocedure the right way
  • Learn how to manipulate cell properties using VBA
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
5.0 hours
Lessons
65

Excel VBA Web Automation: Advanced Browser Control & WebScraping

Learn Advanced WebScraping & Browser Control Using Excel for Increased Efficiency

By Daniel Strong | in Online Courses

Learn to evaluate whether elements are hidden, enabled or disabled, visible, selected, checked or unchecked, and you'll learn how to completely control mouse and keyboard commands and positioning. In this course, you'll review how and when to trigger macros with precision using "Timeouts and Waits"! In addition to basic navigation, you'll be able to Open, Access, and Toggle multiple tab Windows. Resize, reposition, and auto-scroll your browser window as well as use login techniques with set credentials. You'll be able to deal with pop-ups, alerts, notifications, and Frames like an expert.

This course will show you the secrets of controlling the clipboard, saving screenshots to your Excel file, or even taking all or parts of online tables into your spreadsheets automatically. Finally, you'll learn about drop-down menus and working with list boxes to complete your WebDriver mastery.

4.3/5 average rating: ★ ★ ★ ★

  • Access 65 lectures & 5 hours of content 24/7
  • Use multiple tabs & navigate complex pages with Frames
  • Learn to change attributes of a web element such as visibility, size, or color
  • Be confident using web tables & scraping data or images into excel or the clipboard
  • Be able to programmatically wait for an element to appear, become ready or change state
  • Understand pagination & navigate multiple search results dynamically
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
5.0 hours
Lessons
82

Excel VBA Web Automation: Intro to Web Elements

Stop Wasting Your Time with Tedious Online Tasks & Automate Your Online Workflow

By Daniel Strong | in Online Courses

In this course, you'll learn the basics of opening your favorite web browser using Excel and completely controlling its actions as if a human being were clicking, typing, and analyzing data. After learning to open the browser, you'll learn to locate and interact with any element on a webpage using a variety of strategies, from basic text & attribute searches to Advanced strategies such as XPath, CSS Selectors, and Regular Expression (RegEx) functionalities. You'll learn how to fill out web forms dynamically, navigate web pages intuitively, and extract and manipulate data to increase efficiency. You do not need to be a web developer or even VBA master to learn this easy strategy.

4.3/5 average rating: ★ ★ ★ ★

  • Access 82 lectures & 5 hours of content 24/7
  • Learn to install SeleniumBasic & open a web driver of your choice
  • Know how to navigate to any web page & simulate keystrokes in a textbox
  • Learn how to find a specific web element or group of elements
  • Improve your ability to find hard-to-get elements with advanced XPath, CSS, & RegEx techniques
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
6.0 hours
Lessons
40

Excel VBA: Excel Userforms: Part II

Set Up an Amazing Search Tool with Custom Criteria & Editing Abilities for Your Data

By Daniel Strong | in Online Courses

Study advanced Userform skills to amaze your co-workers, end-users, and even your boss! Follow along as we build a real-life error-proof data entry form with multiple tabs to track our employee's table. You'll learn to create ADD, SAVE, and EDIT buttons with different procedures for each step. You'll see how to set up an amazing search tool with custom criteria and editing abilities for your data! You'll learn special tricks to bring up the employee's picture in an image control when their record is selected and work on custom reports triggered by Userforms with reporting options. We'll even read/write data to a hidden worksheet that end-users can't unhide!

  • Access 40 lectures & 6 hours of content 24/7
  • Enhance your ability to style Userforms using pro image tips
  • Create & manage a Userform that runs one of several reports and has filter options
  • Be proficient in data-entry Userforms that can read & write to your data sets
  • Learn advanced report generation tricks on Aesthetics, Headers, Footers, Repeat Rows, & more
  • Build an advanced EEOC report based on sample employee data
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
2.5 hours
Lessons
17

Excel VBA: Excel Userforms: Part I

Take Your Excel Programs to the Next Level, Giving You a New Profound Amount of Control

By Daniel Strong | in Online Courses

In this course, you'll learn the basics of one of Excel's least-known magic tricks - the Userform. This under-utilized yet extremely powerful tool can take your Excel programs to the next level, giving you a new profound amount of control. Make a login form pop-up that can call up other forms, control all procedures and bring up reports. Create Data-Entry Forms with dropdowns, images, text boxes, date-pickers, and a host of other controls that help you manage, manipulate, update or append new data.

  • Access 17 lectures & 2.5 hours of content 24/7
  • Learn to create & design a Userform that can popup, hide, or be closed
  • Review controls on a Userform & their functions compared to worksheet controls
  • Learn to build a Login form that appears when your file opens
  • Create a Temperature Conversion tool that emulates Google's converter
  • Learn to control Userform events that fire when the userform opens, closes, is clicked, & more
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
7.0 hours
Lessons
54

Excel VBA: ActiveX & Worksheet Form Controls

Bring Sheets & Forms to Life Using the Power of Events That are Built Into Most Controls

By Daniel Strong | in Online Courses

Learn how adding professional controls like Buttons, Dropdowns (called ComboBoxes), ListBoxes, etc. can really make your program POP! You'll be able to bring sheets and forms to life using the power of Events that are built into most controls. You'll learn how to use form controls and ActiveX controls in different computer environments. Learn to manipulate Event Triggers, such as Selecting ALL the text in a textbox when you click into it or automatically Disabling certain controls when conditions aren't met, or even setting up data entry & calculations to occur when a button is clicked (but only submitting after conditions are met). Meet your new best friend. ActiveX and Form Controls.

4.6/5 average rating: ★ ★ ★ ★

  • Access 54 lectures & 7 hours of content 24/7
  • Learn the key differences between ActiveX Controls & Form Controls and when to use them
  • Explore a whole new world of events inside each control
  • Trigger macros when your mouse hovers or clicks a control
  • Control keyboard actions that can calculate totals as you type or prevent certain characters
  • Be proficient in Buttons, Dropdowns, Checkboxes, Option buttons, Listboxes, Multipage, Scroll Bars, Tabstrip, and more
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
1.5 hours
Lessons
21

Excel VBA: WorkBook-Level Events

Improve User Experience & Add Interactivity to Excel Workbooks

By Daniel Strong | in Online Courses

This course will focus on Workbook Level Events - macros that are triggered at the Workbook level. First, you'll see how to set up macros to run when a workbook opens. Then, you'll practice by setting a macro to invisibly log a user’s logged-in name, date, and time whenever the workbook is opened. Then, you'll explore other amazing workbook events, like interrupting, preventing, or enhancing print operations, saving the workbook, or even making custom actions occur before the workbook closes. Make a special pop-up message box appear on certain or all sheet changes. Challenge yourself through exploration and the Excel challenge exercise.

4.6/5 average rating: ★ ★ ★ ★

  • Access 21 lectures & 1.5 hours of content 24/7
  • Control workbook-wide events for the end-user
  • Perform special actions when the workbook opens - such as a Login form or resetting sheets
  • Know how to prevent the user from printing or saving until conditions are met
  • Create custom actions that happen before the workbook closes
  • Sharpen your skills with an engaging challenge exercise & review the solutions video
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
2.0 hours
Lessons
22

Excel VBA: Worksheet Events Made Easy

Learn Special Ways to Trigger a Macro on a Sheet

By Daniel Strong | in Online Courses

Learn all about Worksheet Events – triggers made from within a specific worksheet. You can trigger a macro to run when a certain cell or group of cells are clicked, double-clicked, right-clicked, and many more triggers. Learn to Auto-hide a sheet when it's de-selected or prevent users from adding a new sheet or clicking in certain areas and much more! Featuring 2 new Excel challenge exercises to sharpen your skills!

4.6/5 average rating: ★ ★ ★ ★

  • Access 22 lectures & 2 hours of content 24/7
  • Learn to trigger code from a number of different methods - from Clicking on a cell - to De-Selecting a worksheet
  • Understand the difference, pros, & cons of the selection change event vs the change event
  • Be able to track link clicks in a workbook
  • Learn how to create custom right-click menu buttons or disable right-click features
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
3.0 hours
Lessons
29

Excel VBA: Loops & Custom Report Writing Basics

Build Reports That Look Any Way You Want, Not Just Cookie-Cut Pivot Reports

By Daniel Strong | in Online Courses

Learn how to loop through a data set to go way beyond the scope of a simple VLookup type search. You'll learn how to dynamically explore a set of data - using the last row and last column to search, make custom changes to a data set, and more. Use advanced criteria to build reports that look any way you want, not just cookie-cutter Pivot Reports that have little customization. Learn which loops to use for every occasion.

  • Access 29 lectures & 3 hours of content 24/7
  • Enhance your ability to generate customized reports that can be printed
  • Understand how to add filters to report menus to narrow the results
  • Learn how to choose the right Loop for each task
  • Practice using an InputBox to let the end-user run a custom report for a specific employee or amount
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
3.0 hours
Lessons
38

Excel VBA: Essential Tools & Advanced Conditional Logic

Set the Foundation for Custom Report Development & Easier Data Entry

By Daniel Strong | in Online Courses

This course covers all the tools you’ll need to begin automating and really setting your programs in motion. Enjoy deliciously exciting experiments into IF/THEN statements to create a fork in your procedures based on custom conditions. We'll learn how to get the last row or column (setting the foundation for custom report development). This also sets the stage for data entry as we will also be able to dynamically find the next row for new data. With 2 engaging Excel challenge exercises and solutions, we also explore foundations of Conditional Logic where Excel learns to make decisions and interact with the end-user!

4.6/5 average rating: ★ ★ ★ ★

  • Access 38 Lectures & 3 hours of content 24/7
  • Learn 3 methods of accessing a Worksheet using Code
  • Be able to interact with the end-user with MessageBoxes & InputBoxes
  • Be proficient in Conditional Logic (IF/THEN, CASE STATEMENTS) to make decisions
  • Practice Code Slimming & Efficiency Techniques
  • Know how to create custom Functions to be used In VBA or in a Cell!
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
2.0 hours
Lessons
19

Excel VBA: Variables

Explore the Importance of Variables & Make Calculations Way Easy

By Daniel Strong | in Online Courses

Discover how to use variables to store data, perform calculations and write efficient code. Variables open up the possibilities in any programming language. Learn to store temporary information in system memory invisibly rather than storing everything in worksheet cells. Learn how and when to store dates, strings of text, or even numbers inside of these special ‘nicknames’ within Excel. You'll explore the scope and lifetime of various variable types as well as an engaging Excel challenge exercise to help you practice.

4.6/5 average rating: ★ ★ ★ ★

  • Access 19 lectures & 2 hours of content 24/7
  • Learn to create multiple Variable styles to match your need
  • Use Beginning to Advanced Math with Variables and Learn Proper Use, Declaration & Scope
  • Learn String Functions, Concatenation, & How to Control Case-Sensitivity with VBA Functions
  • Understand multiple variable types: Constants, Static, Module-Level, Public, Private, 'Option Private Module', etc
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
1.0 hours
Lessons
6

Excel VBA: Complete Toolbars, Menus & VBE Training

Explore Little-Known Tricks as Well as Keyboard Shortcuts to Speed Up Your Work

By Daniel Strong | in Online Courses

In this course, you'll learn the best and most efficient ways to tackle everyday development in the VBE (Visual Basic Editor) and explore little-known tricks as well as keyboard shortcuts to speed up your work. You’re no better than your tools, we're going to take a deeper look at Debugging Tools, Special Windows & Menus, and all the wonderful things you can do once you know how to use them!

  • Access 6 lectures & 1 hour of content 24/7
  • Learn to customize your VBA Editor & understand all the Toolbars and options
  • Practice debugging & troubleshooting code with expert tools
  • Know the time-saving features & windows built into VBA!
  • Be able to call one macro from another & pass information between them
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac

Access
Lifetime
Content
1.0 hours
Lessons
8

Image & Background Hacks In Excel VBA (Mini Course)

Be Confident Using JPG, GIF, PNG, & Other Image Types in Excel

By Daniel Strong | in Online Courses

Learn the best-kept secrets for getting your images to look professional and correctly sized for worksheet backgrounds, Userforms as well as special controls. You'll be able to choose the correct control for each occasion and learn the best image types for buttons, image controls, frames, labels, and more. Explore a huge collection of background images to follow along with.

  • Access 8 lectures & 1 hour of content 24/7
  • Be confident using jpg, gif, png & other image types in Excel
  • See & understand transparent type files vs solid
  • Know which control to use and how to style it effectively
  • Use patterns, textures, tiling, & multiple zoom techniques
  • Expand your knowledge of image conversion & manipulation
Daniel Strong | Excel Instructor/Programmer
4.5/5 Instructor Rating: ★ ★ ★ ★

After studying Excel VBA on his own, Daniel Strong has started a YouTube channel, mostly for himself as a reference tool, but people started to bite. People flooded his inbox with questions and comments that he was literally changing their lives for the better. His passion is and always has been teaching, and he's turned thousands of people into Excel programmers.

Now, with his courses, Daniel's going to teach the good stuff - the stuff he kept secret; the Advanced and "not-so-Advanced-but-Awesome" Excel VBA. The things that make people hire you - that make you irresistible and irreplaceable. Building REAL Programs, Advanced Reporting, and Data Analysis. Dashboards and live data. Automation. His main focus is to create an online community of professional Excel VBA developers and beginners who create Real Programs, solve Real Problems, and change Real Lives.

Important Details

  • Length of time users can access this course: lifetime
  • Access options: desktop & mobile
  • Redemption deadline: redeem your code within 30 days of purchase
  • Experience level required: all levels
  • Have questions on how digital purchases work? Learn more here

Requirements

  • Any version of Excel; Windows or Mac


Terms

  • Unredeemed licenses can be returned for store credit within 30 days of purchase. Once your license is redeemed, all sales are final.