Overview
At Unlock Excel VBA and Excel Macros from Udemy we will take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects.
Students at Unlock Excel VBA and Excel Macros from Udemy will:
- Enhance their current Excel files & automate your work with VBA.
- Directly apply the Excel VBA example files included to your own work.
- Reduce manual routine tasks to the click of a button.
- Create simple solutions to complex problems by levering Excel functionality with Macros.
- Formulas & Excel core functionality can't do everything. Use VBA when you reach a limitation.
- Easily adjust VBA code you find online to fit your purpose.
Programme Structure
Courses include:
- Your First Macro
- The Object Model
- Referencing Ranges, Worksheets & Workbooks with VBA
- Working with Variables
- Looping through Collections & Making Decisions
- Useful Built-in Functions
- Debugging, Error Handling & Procedure Scope
- Main Project #1: Create a to Automate Table of Contents
- Looping in VBA (Controlling the Flow of Code)
Key information
Duration
- Part-time
- 3 days
Start dates & application deadlines
Language
Delivered
Campus Location
- San Francisco, United States
Disciplines
Information Systems View 33 other Short Courses in Information Systems in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
Who this course is for:
- Business Professionals who'd like to simplify & automate work flow.
- Data analysts.
- You currently use Excel and like to improve your skills.
Technological requirements
- Familiarity with Microsoft Excel.
- Demonstration is done with Excel 2016 but the techniques work with any version of Excel.
- Excel on Windows (some techniques might work on mac, but I will not be able to support you).
Tuition Fees
-
International Applies to you
Applies to youNon-residents200 USD / full≈ 200 USD / full - Out-of-State200 USD / full≈ 200 USD / full
-
Domestic
Applies to youIn-State200 USD / full≈ 200 USD / full