Course details
In this course, students will learn how to simplify their work in the Excel environment by automating many of the repetitive tasks that are part of spreadsheet development.
What will I learn?
Lesson 1: Some Essential Background
- Excel 2010: Where It Came From
- Excel in a Nutshell.
- Formula Tricks and Techniques.
- Understanding Excel Files
Lesson 2: Excel Application Development
- What Is a Spreadsheet Application?
- Essentials of Spreadsheet Application Development
Lesson 3: Understanding Visual Basic for Applications
- Introducing Visual Basic for Applications
- VBA Programming Fundamentals
- Working with VBA Sub Procedures
- Creating Function Procedures
- VBA Programming Examples and Techniques
Lesson 4: Working with UserForms
- Custom Dialog Box Alternatives
- Introducing UserForms
- UserForm Examples
- Advanced UserForm Techniques
Lesson 5: Advanced Programming Techniques
- Developing Excel Utilities with VBA
- Working with Pivot Tables
- Working with Charts
- Understanding Excel’s Events
- Interacting with Other Applications
- Creating and Using Add-Ins
Lesson 6: Developing Applications
- Working with the Ribbon
- Working with Shortcut Menus
- Providing Help for Your Applications
- Developing User-Oriented Applications
Lesson 7: Other Topics
- Compatibility Issues
- Manipulating Files with VBA
- Manipulating Visual Basic Components
- Understanding Class Modules Working with Colors
- Frequently Asked Questions about Excel Programming
Requirements
Prospective students will require intermediate skills in Microsoft Excel 2010. It is recommended that students complete Excel 2010 Level 3 before sitting for this program.
Updated on 08 November, 2015Course Location
About New Horizons Singapore
Whether the training is for one individual or several hundred employees in multiple locations across the globe, New Horizons has a training program to fit any company or any individual need. We deliver a full range of technical, application and business skills training solutions. Our training ranges from basic application and desktop productivity tools (i.e., Project, Excel, PowerPoint) to complex and integrated business systems (i.e., information security, ITIL, Microsoft, Cisco and Novell). New Horizons offers classroom, mentored and distance learning options for virtually every desktop application used in the world of business
See all New Horizons Singapore courses- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at LaimoonAED 1,449Duration: Upto 30 Hours
- Visual Merchandising Diploma Academy for Health & FitnessSGD 17Duration: Upto 3 Hours
- Big Data: Data Science, Analytics, Visualisation NextGen LearningSGD 73Duration: Upto 20 Hours
