TGx:Udemy - Advanced Excel Functions, Macros, and VBA Bundle

Hot Picks

First Cam

New Movies

1080p x265

New TV

Misc

Torrent details for "Udemy - Advanced Excel Functions, Macros, and VBA Bundle" Log in to bookmark

Quicknav > Description Read comments 0 Post guest comment

Torrent details

Name:

Udemy - Advanced Excel Functions, Macros, and VBA Bundle

Controls:

Report Torrent

Torrent verified by tutsnode

Category:

Other > Training

Language:

English

Total Size:

1.98 GB

Info Hash:

60dfa922f56a82749195a82eb75eaa507f748265

Added By:

tutsnode

Added:

22-02-2021 15:35

Views:

632

Update stats Post guest comment 0

Health:

Seeds:

Leechers:

Completed:

File	Size
.pad/0	68.30 kB
.pad/1	37.95 kB
.pad/10	20.81 kB
.pad/11	317.41 kB
.pad/12	485.14 kB
.pad/13	235.11 kB
.pad/14	232.15 kB
.pad/15	130.41 kB
.pad/16	119.30 kB
.pad/17	157.62 kB
.pad/18	112.23 kB
.pad/19	93.42 kB
.pad/2	260.58 kB
.pad/20	370.58 kB
.pad/21	91.43 kB
.pad/22	438.40 kB
.pad/23	95.73 kB
.pad/24	279.75 kB
.pad/25	433.74 kB
.pad/26	510.27 kB
.pad/3	395.68 kB
.pad/4	351.25 kB
.pad/5	325.13 kB
.pad/6	383.34 kB
.pad/7	395.11 kB
.pad/8	254.52 kB
.pad/9	170.82 kB
TutsNode.com.txt	63.00 B
[TGx]Downloaded from torrentgalaxy.to .txt	585.00 B
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/1. Introduction.mp4	13.23 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/1. Introduction.srt	2.23 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.65 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/3. DOWNLOAD ME Course Files.html	824.00 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.63 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.27 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.66 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/5. VBA Explained.mp4	61.87 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/5. VBA Explained.srt	11.24 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/1. Macros and VBA Course Introduction/6. Section Quiz.html	159.00 B
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/1. Recording, Saving and Running a Macro.mp4	54.85 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/1. Recording, Saving and Running a Macro.srt	15.95 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/2. Recording a Macro with Relative Referencing.mp4	39.07 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/2. Recording a Macro with Relative Referencing.srt	10.16 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/3. Complex Macros.mp4	125.58 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/3. Complex Macros.srt	17.55 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/4. Recording a Macro to Sort and Filter Data.mp4	104.75 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/4. Recording a Macro to Sort and Filter Data.srt	16.17 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/5. Protecting cells with a Macro.mp4	53.89 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/5. Protecting cells with a Macro.srt	12.22 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/2. Creating Macros/6. Section Quiz.html	159.00 B
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/1. The VBA Editor.mp4	55.38 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/1. The VBA Editor.srt	10.85 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/2. Understanding VBA Code.mp4	122.46 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/2. Understanding VBA Code.srt	18.37 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/3. Editing Macros.mp4	88.19 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/3. Editing Macros.srt	11.84 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/4. Debugging Macros.mp4	109.18 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/4. Debugging Macros.srt	14.38 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/5. Creating a Macro from Scratch.mp4	44.41 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/5. Creating a Macro from Scratch.srt	9.34 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/3. Editing Macros with VBA/6. Section Quiz.html	159.00 B
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/4. Custom Macro Ribbon/1. Creating a Macro Custom Ribbon.mp4	44.64 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/4. Custom Macro Ribbon/1. Creating a Macro Custom Ribbon.srt	9.12 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/5. Course Close/1. Course Close.mp4	13.08 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/5. Course Close/1. Course Close.srt	1.95 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/6. Intro to Advanced Formulas in Excel/1. Introduction.mp4	16.41 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/6. Intro to Advanced Formulas in Excel/1. Introduction.srt	3.34 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/6. Intro to Advanced Formulas in Excel/2. DOWNLOAD ME Course Files.html	843.00 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.08 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/1. Filter a Dataset Using a Formula.mp4	77.77 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/1. Filter a Dataset Using a Formula.srt	11.17 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/10. Find the Closest Match to a Value.mp4	52.91 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/10. Find the Closest Match to a Value.srt	11.28 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/11. Section Quiz.html	159.00 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.75 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/2. Sort a Dataset Using a Formula and Defined Variables.srt	18.98 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/3. Multiple Dependent Dynamic Drop-down Lists.mp4	108.13 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/3. Multiple Dependent Dynamic Drop-down Lists.srt	14.63 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/4. Perform a 2-way Lookup.mp4	112.66 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/4. Perform a 2-way Lookup.srt	16.69 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/5. Make Decisions with Complex Logical Calculations.mp4	114.61 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/5. Make Decisions with Complex Logical Calculations.srt	20.99 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/6. Extracting Parts of a Text String.mp4	105.61 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/6. Extracting Parts of a Text String.srt	23.28 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/7. Creating a Dynamic Chart Title.mp4	101.53 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/7. Creating a Dynamic Chart Title.srt	20.02 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.33 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.62 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/9. Looking Up Information with XLOOKUP.mp4	85.03 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/7. Advanced Formulas/9. Looking Up Information with XLOOKUP.srt	15.37 kB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/8. Course Close/1. Course Close.mp4	12.50 MB
[TutsNode.com] - Advanced Excel Functions, Macros, and VBA Bundle/8. Course Close/1. Course Close.srt	1.79 kB

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