Advanced Excel Functions, Macros, and VBA Bundle

Advanced Excel Functions, Macros, and VBA Bundle

Other
Size
2 GB
Seeders
8
Leechers
0
Files
91
Category
Other
Added
02/22/21 at 4:42pm GMT+1
Infohash
60dfa922f56a82749195a82eb75eaa507f748265

Description


Description



**Includes downloadable follow-along files**



In this two-course bundle, we take you through how to perform a number of tasks in Excel by utilizing advanced functions and formulas, before moving onto how to use Macros and VBA to automate and supercharge your spreadsheets!



If you’ve used Excel a lot, but you know that you could be doing more with it, then this two-part course is for you. You’ll learn skills that will help you clean data, perform analysis, set up spreadsheets to collect data, and create amazing looking charts that auto-update.



This course includes follow-along instructor files so you can immediately practice what you learn. This class is not for Excel beginners. You will need an intermediate knowledge of Excel to get the most from these videos.



In the Advanced Functions and Formulas part of the course you will learn how to:



   Filter a dataset using a formula

   Sort a dataset using formulas and defined variables

   Create multi-dependent dynamic drop-down lists

   Perform a 2-way lookup

   Make decisions with complex logical calculations

   Extract parts of a text string

   Create a dynamic chart title

   Find the last occurrence of a value in a list

   Look up information with XLOOKUP

   Find the closest match to a value



In the Macros and VBA part of the course you will learn:



   Examples of Excel Macros

   What is VBA?

   How to record your first macro

   How to record a macro using relative references

   How to record a complex, multi-step macro and assign it to a button

   How to set up the VBA Editor

   How to edit Macros in the VBA Editor

   How to get started with some basic VBA code

   How to fix issues with macros using debugging tools

   How to write your own macro from scratch

   How to create a custom Macro ribbon and add all the Macros you’ve created



   4+ hours of video tutorials

   27 individual video lectures

   Instructor files to practice as you learn

   Certificate of completion



Who this course is for:



   Those wanting to automate Excel task or procedures.

   Users with basic knowledge of Excel 2019/365 and those upgrading from previous software versions

   Users who have a foundation of Microsoft Excel and seeking to advance their Excel 2019/365 knowledge.



Requirements



   Microsoft Excel for Windows. The course was created using Excel 2019/365 for Windows. All of the code used in this course except for one property is compatible for Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019.

   Intermediate knowledge of Microsoft Excel.



Last Updated 2/2021

File list
  • Advanced Excel Functions, Macros, and VBA Bundle
  • .pad/0 68.3 KB
  • .pad/1 37.9 KB
  • .pad/10 20.8 KB
  • .pad/11 317.4 KB
  • .pad/12 485.1 KB
  • .pad/13 235.1 KB
  • .pad/14 232.1 KB
  • .pad/15 130.4 KB
  • .pad/16 119.3 KB
  • .pad/17 157.6 KB
  • .pad/18 112.2 KB
  • .pad/19 93.4 KB
  • .pad/2 260.6 KB
  • .pad/20 370.6 KB
  • .pad/21 91.4 KB
  • .pad/22 438.4 KB
  • .pad/23 95.7 KB
  • .pad/24 279.7 KB
  • .pad/25 433.7 KB
  • .pad/26 510.3 KB
  • .pad/3 395.7 KB
  • .pad/4 351.3 KB
  • .pad/5 325.1 KB
  • .pad/6 383.3 KB
  • .pad/7 395.1 KB
  • .pad/8 254.5 KB
  • .pad/9 170.8 KB
  • TutsNode.com.txt 63 B
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/1. Introduction.mp4 13.2 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/1. Introduction.srt 2.2 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/2. READ ME Essential Information for a Successful Training Experience.html 2.6 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/3. DOWNLOAD ME Course Files.html 824 B
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/3.1 Macro and VBA Course Files.zip 456.6 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/4. Using Macros to Automate Repetitive Tasks.mp4 77.3 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/4. Using Macros to Automate Repetitive Tasks.srt 11.7 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/5. VBA Explained.mp4 61.9 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/5. VBA Explained.srt 11.2 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/6. Section Quiz.html 159 B
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/1. Recording, Saving and Running a Macro.mp4 54.8 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/1. Recording, Saving and Running a Macro.srt 16 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/2. Recording a Macro with Relative Referencing.mp4 39.1 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/2. Recording a Macro with Relative Referencing.srt 10.2 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/3. Complex Macros.mp4 125.6 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/3. Complex Macros.srt 17.5 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/4. Recording a Macro to Sort and Filter Data.mp4 104.8 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/4. Recording a Macro to Sort and Filter Data.srt 16.2 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/5. Protecting cells with a Macro.mp4 53.9 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/5. Protecting cells with a Macro.srt 12.2 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/6. Section Quiz.html 159 B
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/1. The VBA Editor.mp4 55.4 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/1. The VBA Editor.srt 10.9 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/2. Understanding VBA Code.mp4 122.5 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/2. Understanding VBA Code.srt 18.4 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/3. Editing Macros.mp4 88.2 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/3. Editing Macros.srt 11.8 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/4. Debugging Macros.mp4 109.2 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/4. Debugging Macros.srt 14.4 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/5. Creating a Macro from Scratch.mp4 44.4 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/5. Creating a Macro from Scratch.srt 9.3 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/6. Section Quiz.html 159 B
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/4. Custom Macro Ribbon/1. Creating a Macro Custom Ribbon.mp4 44.6 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/4. Custom Macro Ribbon/1. Creating a Macro Custom Ribbon.srt 9.1 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/5. Course Close/1. Course Close.mp4 13.1 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/5. Course Close/1. Course Close.srt 1.9 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/6. Intro to Advanced Formulas in Excel/1. Introduction.mp4 16.4 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/6. Intro to Advanced Formulas in Excel/1. Introduction.srt 3.3 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/6. Intro to Advanced Formulas in Excel/2. DOWNLOAD ME Course Files.html 843 B
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/6. Intro to Advanced Formulas in Excel/2.1 Advanced Formulas in Excel Course Files.zip 980.1 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/1. Filter a Dataset Using a Formula.mp4 77.8 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/1. Filter a Dataset Using a Formula.srt 11.2 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/10. Find the Closest Match to a Value.mp4 52.9 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/10. Find the Closest Match to a Value.srt 11.3 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/11. Section Quiz.html 159 B
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/2. Sort a Dataset Using a Formula and Defined Variables.mp4 115.7 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/2. Sort a Dataset Using a Formula and Defined Variables.srt 19 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/3. Multiple Dependent Dynamic Drop-down Lists.mp4 108.1 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/3. Multiple Dependent Dynamic Drop-down Lists.srt 14.6 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/4. Perform a 2-way Lookup.mp4 112.7 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/4. Perform a 2-way Lookup.srt 16.7 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/5. Make Decisions with Complex Logical Calculations.mp4 114.6 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/5. Make Decisions with Complex Logical Calculations.srt 21 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/6. Extracting Parts of a Text String.mp4 105.6 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/6. Extracting Parts of a Text String.srt 23.3 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/7. Creating a Dynamic Chart Title.mp4 101.5 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/7. Creating a Dynamic Chart Title.srt 20 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/8. Finding the Last Occurrence of a Value in a List.mp4 104.3 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/8. Finding the Last Occurrence of a Value in a List.srt 20.6 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/9. Looking Up Information with XLOOKUP.mp4 85 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/9. Looking Up Information with XLOOKUP.srt 15.4 KB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/8. Course Close/1. Course Close.mp4 12.5 MB
  • [TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/8. Course Close/1. Course Close.srt 1.8 KB

Rating
Not rated yet
Log in to rate

Comments

No comments yet.


Similar torrents
NameSizeDate
7 MB07/16/262189014597
15 MB07/15/262187614605
43 MB07/15/262186414568
41 MB07/16/262181814530
27 MB07/14/262179714544
15 MB07/15/262174514476
24 MB07/15/262173714484
9 MB07/15/262163414418
37 MB07/15/262162014431
50 MB07/15/262161914421
18 MB07/15/262161514420
12 MB07/15/262159914393
16 MB07/14/262159614393
15 MB07/15/262155214358
50 MB07/14/262148714331