- الموقع: Bukit Merah - Central
- مدة الدورة التدريبية: 3 Days
تفاصيل الدورة
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.
تحديث بتاريخ 08 November, 2015نبذة عن معهد 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
عرض الجميع دورات New Horizons Singapore- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoon1,449 درهممدة الدورة التدريبية: Upto 30 Hours
- SQL Database Administrator StudyHub49 درهم
955 درهممدة الدورة التدريبية: Upto 8 Hours - 110 درهم
551 درهممدة الدورة التدريبية: Upto 4 Hours