Advanced Excel Functions, Macros, and VBA Bundle | Udemy


Advanced Excel Functions, Macros, and VBA Bundle | Udemy
English | Size: 1.95 GB
Genre: eLearning

What you’ll learn
Learn to unlock advanced Excel formulas
Filter a dataset using a formula
Create multi-dependent dynamic drop-down lists in Excel
Perform a 2-way lookup in Excel
Automate repetitive tasks in Excel using Macros
How to edit Macros in the VBA Editor
How to record a macro using relative references
How to record a complex, multi-step macro and assign it to a button
How to write your own macro from scratch

**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.

nitroflare.com/view/2E7A5F1E782C674/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part1.rar
nitroflare.com/view/F3C425BDDE02051/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part2.rar
nitroflare.com/view/898D37BC3B71C7B/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part3.rar
nitroflare.com/view/1043821163D0981/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part4.rar
nitroflare.com/view/8B35B171835931F/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part5.rar

rapidgator.net/file/f6afc72798d4f58eacfe472845ceb7fa/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part1.rar.html
rapidgator.net/file/5d240c57b467f49baede0e7184c1dca2/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part2.rar.html
rapidgator.net/file/cce91ae7511999cc26efe99ab2711125/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part3.rar.html
rapidgator.net/file/971f5dbd6c1b02c0e7371cd7ee9ffcc4/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part4.rar.html
rapidgator.net/file/3943b890ae67df397e20cc5a93385525/UD-Advanced-Excel-Functions-Macros-and-VBA-Bundle.16.2.part5.rar.html

If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.