Office Productivity Online Course by Udemy, On Sale Here
Learn how to automate and solve complex challenges in Excel with Advanced Formulas, Macros, and VBA.
An excellent training about Microsoft
Advanced Excel Functions, Macros, and VBA Bundle
*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 youve used Excel a lot, but you know that you could be doing more with it, then this two-part course is for you. Youll 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 formulaSort a dataset using formulas and defined variablesCreate multi-dependent dynamic drop-down listsPerform a 2-way lookupMake decisions with complex logical calculationsExtract parts of a text stringCreate a dynamic chart titleFind the last occurrence of a value in a listLook up information with XLOOKUPFind the closest match to a valueIn the Macros and VBA part of the course you will learn: Examples of Excel MacrosWhat is VBA?How to record your first macroHow to record a macro using relative referencesHow to record a complex, multi-step macro and assign it to a buttonHow to set up the VBA EditorHow to edit Macros in the VBA EditorHow to get started with some basic VBA codeHow to fix issues with macros using debugging toolsHow to write your own macro from scratchHow to create a custom Macro ribbon and add all the Macros youve created4+ hours of video tutorials27 individual video lecturesInstructor files to practice as you learnCertificate of completion
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.