The Carbon Footprint Management course is designed to enhance the knowledge, skills, and abilities of individuals seeking to identify, analyze, and prioritize carbon footprint reduction initiatives.
This course provides an in-depth understanding of carbon footprint hot spots and their potential for carbon footprint reduction. It also delves into the utilization of ISO:14001 standards, environmental management systems, carbon footprint calculators, and advanced carbon reduction technologies.
Through this course, learners will not only acquire comprehensive knowledge but also develop the practical skills needed to implement effective carbon footprint reduction plans.
Lesson 1: Software Design With Macros
TOPIC A: Getting to Know Excel Macros
- Visual Basic for Applications
- Macros
- Object-Oriented Programming
- Macro Options
- Activity: Getting to Know Macros
TOPIC B: Creating a Macro in Microsoft Excel
- The Macro Recorder
- Personal Macro Workbooks
- How to Create a Macro Using the Macro Recorder
- Activity: Creating a Macro Using the Macro Recorder
TOPIC C: Editing an Excel Macro
- The Visual Basic Editor
- Projects
- Modules
- The Modules Folder
- Objects
- Properties
- Methods
- VBA Comments
- How to Edit a Macro
- Activity: Editing a Macro
TOPIC D: Debugging a Macro in Excel
- The Debugging Process
- Debugging Tools
- How to Debug a Macro
- Activity: Debugging a Macro
TOPIC E: Customizing the Quick Access Toolbar and Hotkeys
- Add a Button to the Quick Access Toolbar to Run a Macro
- Assign a Keyboard Shortcut to a Macro
- Activity: Customizing the Quick Access Toolbar and Hotkeys
TOPIC F: Setting Macro Security in Excel
- Digital Certificates
- Digital Signatures
- Macro Security Settings
- Activity: Setting Macro Security
Review Questions
Lesson 2: Formatting Worksheets Using Macros
TOPIC A: Inserting Text With Excel Macros
- The Selection Property
- The ActiveSheet Property
- The Name Property
- The Value Property
- Concatenation
- How to Insert Text
- Activity: Inserting Text
TOPIC B: Formatting Text with Macros in Excel
- How to Format Text
- Activity: Formatting Text
TOPIC C: Sorting Data within Excel
- The Range Object
- The Select Method
- The CurrentRegion Property
- How to Sort Data
- Activity: Sorting Data
TOPIC D: How To Duplicate Data With Excel Macros
- Data Types
- Variables
- Variable Naming Rules
- Operators
- The Assignment Operator
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- The For Next Loop
- Do Loops
- The Worksheets Object
- The Count Property
- The Offset Property
- The Copy Method
- The Paste Method
- How to Duplicate Data
- Activity: Duplicating Data
TOPIC E: Generate a Report in Excel Using Macros
- The Columns Property
- The AutoFit Method
- The Address Property
- The Call Statement
- The Font Property
- The End Property
- How to Generate a Report
- Activity: Generating a Report
Review Questions
Lesson 3: Creating an Interactive Worksheet with Excel Macros
TOPIC A: Determining the Dialog Box Type
- Message Boxes
- Input Boxes
- Activity: Determining the Dialog Box Type
TOPIC B: Capturing User Input With Macros
- The InputBox Function
- Constants
- The MsgBox Function
- The Code Continuation Character
- The vbCrLf Constant
- Decision Structures
- The Select Case Statement
- The If Then Structure
- The Else Clause
- How to Capture User Input
- Activity: Capturing User Input
Review Questions
Lesson 4: Working with Multiple Worksheets
TOPIC A: Insert, Copy, and Delete Worksheets With Excel Macros Methods
- The Add Method
- The Copy Method
- The Delete Method
- How to Insert, Copy, and Delete Worksheets
- Activity: Inserting and Deleting Worksheets
TOPIC B: Renaming Worksheets Within Excel
- Expressions
- The DateSerial Function
- The Format Function
- How to Rename Worksheets
- Activity: Renaming Worksheets
TOPIC C: Modify the Order of Worksheets Easily With Excel Macros
- The Move Method
- How to Modify the Order of Worksheets
- Activity: Moving Worksheets within a Workbook
- TOPIC D: Print Worksheets
- The PrintPreview Method
- The PrintOut Method
- How to Print Worksheets
- Activity: Printing a Workbook
Review Questions
Lesson 5: Performing Calculations With Excel Macro Code
TOPIC A: Create User-Defined Functions inside Excel
- User-Defined Functions
- Types of Functions
- Arguments
- How to Create User-Defined Functions
- Activity: Creating and Applying a User-Defined Function
TOPIC B: Automate SUM Functions
- Declared Range Objects
- The Set Statement
- Range Object Cell Addressing
- The Rows Property
- The Formula Property
- The Columns Property
- Address Property Cell Reference Settings
- How to Automate SUM Functions
- Activity: Automating SUM Functions
Our Excel VBA (Visual Basic for Applications) training course aims to teach individuals how to use VBA programming language to automate tasks and develop custom solutions within Microsoft Office applications, such as Excel.
The course typically covers VBA syntax and structure, data types and variables, programming constructs such as loops and conditional statements, functions and subroutines, working with arrays and collections, and interacting within the Excel application.
With this Excel VBA knowledge, you will be able to:
- Combine & consolidate multiple Excel files into a single file,
- Clean data faster, Create Pivot Tables with VBA,
- Create Forms,
- Append data from External files, and
- Learn to use Range, Objects, Properties & Methods in VBA to automate routine tasks.
The goal of the course is to provide individuals with the skills and knowledge they need to create powerful macros, automate repetitive tasks, and develop custom solutions that can help them work more efficiently and effectively with Microsoft Office applications.
Additionally, the training will include best practices for debugging, testing, and maintaining VBA code and tips for optimizing performance and writing efficient code.
The prerequisites for joining our VBA macro programming workshop are:
- Basic knowledge of Excel: Participants should have a good understanding of Excel’s features, such as creating and formatting worksheets, entering data, and using basic formulas and functions.
- Access to Excel: Participants should have access to a version of Excel that supports VBA programming, such as Excel 2013 or later.
- Willingness to learn: Participants should be motivated and willing to learn new skills and concepts related to VBA programming.
The target audience for an Excel VBA macro programming class includes individuals who want to automate tasks, streamline workflows, and create custom solutions using Excel. This can include:
- Business professionals: Individuals who work with Excel regularly, such as financial analysts, project managers, or administrative assistants, can benefit from learning VBA to automate repetitive tasks and create customized reports.
- Programmers and developers: Individuals who have experience with programming languages such as Java or Python can use VBA to extend the functionality of Excel and create custom add-ins that interact with other applications.
- Students: Students who are studying business, finance, or data analysis can benefit from learning VBA as it is a valuable skill in many industries and can help them stand out in the job market.
- Excel power users: Individuals who already have advanced knowledge of Excel and want to take their skills to the next level can benefit from learning VBA to create more complex solutions and automate advanced tasks.
Overall, anyone who uses Excel frequently and wants to increase their productivity, efficiency, and accuracy can benefit from learning VBA macro programming.
Post-Course Support
- We provide free consultation related to the subject matter after the course.
- Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.
Venue:
All courses are conducted at Intellisoft Training Rooms at 190 Middle Road, 10-08 Fortune Centre, Singapore 188979.
Short walk from Bencoolen MRT, Bugis, Rochor, Bras Basah MRT stations. The venue is disabled-friendly. For directions, click Contact Us.
Our Excel VBA (Visual Basic for Applications) training course aims to teach individuals how to use VBA programming language to automate tasks and develop custom solutions within Microsoft Office applications, such as Excel.
The course typically covers VBA syntax and structure, data types and variables, programming constructs such as loops and conditional statements, functions and subroutines, working with arrays and collections, and interacting within the Excel application.
With this Excel VBA knowledge, you will be able to:
- Combine & consolidate multiple Excel files into a single file,
- Clean data faster, Create Pivot Tables with VBA,
- Create Forms,
- Append data from External files, and
- Learn to use Range, Objects, Properties & Methods in VBA to automate routine tasks.
The goal of the course is to provide individuals with the skills and knowledge they need to create powerful macros, automate repetitive tasks, and develop custom solutions that can help them work more efficiently and effectively with Microsoft Office applications.
Additionally, the training will include best practices for debugging, testing, and maintaining VBA code and tips for optimizing performance and writing efficient code.
The target audience for an Excel VBA macro programming class includes individuals who want to automate tasks, streamline workflows, and create custom solutions using Excel. This can include:
- Business professionals: Individuals who work with Excel regularly, such as financial analysts, project managers, or administrative assistants, can benefit from learning VBA to automate repetitive tasks and create customized reports.
- Programmers and developers: Individuals who have experience with programming languages such as Java or Python can use VBA to extend the functionality of Excel and create custom add-ins that interact with other applications.
- Students: Students who are studying business, finance, or data analysis can benefit from learning VBA as it is a valuable skill in many industries and can help them stand out in the job market.
- Excel power users: Individuals who already have advanced knowledge of Excel and want to take their skills to the next level can benefit from learning VBA to create more complex solutions and automate advanced tasks.
Overall, anyone who uses Excel frequently and wants to increase their productivity, efficiency, and accuracy can benefit from learning VBA macro programming.
Lesson 1: Software Design With Macros
TOPIC A: Getting to Know Excel Macros
- Visual Basic for Applications
- Macros
- Object-Oriented Programming
- Macro Options
- Activity: Getting to Know Macros
TOPIC B: Creating a Macro in Microsoft Excel
- The Macro Recorder
- Personal Macro Workbooks
- How to Create a Macro Using the Macro Recorder
- Activity: Creating a Macro Using the Macro Recorder
TOPIC C: Editing an Excel Macro
- The Visual Basic Editor
- Projects
- Modules
- The Modules Folder
- Objects
- Properties
- Methods
- VBA Comments
- How to Edit a Macro
- Activity: Editing a Macro
TOPIC D: Debugging a Macro in Excel
- The Debugging Process
- Debugging Tools
- How to Debug a Macro
- Activity: Debugging a Macro
TOPIC E: Customizing the Quick Access Toolbar and Hotkeys
- Add a Button to the Quick Access Toolbar to Run a Macro
- Assign a Keyboard Shortcut to a Macro
- Activity: Customizing the Quick Access Toolbar and Hotkeys
TOPIC F: Setting Macro Security in Excel
- Digital Certificates
- Digital Signatures
- Macro Security Settings
- Activity: Setting Macro Security
Review Questions
Lesson 2: Formatting Worksheets Using Macros
TOPIC A: Inserting Text With Excel Macros
- The Selection Property
- The ActiveSheet Property
- The Name Property
- The Value Property
- Concatenation
- How to Insert Text
- Activity: Inserting Text
TOPIC B: Formatting Text with Macros in Excel
- How to Format Text
- Activity: Formatting Text
TOPIC C: Sorting Data within Excel
- The Range Object
- The Select Method
- The CurrentRegion Property
- How to Sort Data
- Activity: Sorting Data
TOPIC D: How To Duplicate Data With Excel Macros
- Data Types
- Variables
- Variable Naming Rules
- Operators
- The Assignment Operator
- Arithmetic Operators
- Comparison Operators
- Logical Operators
- The For Next Loop
- Do Loops
- The Worksheets Object
- The Count Property
- The Offset Property
- The Copy Method
- The Paste Method
- How to Duplicate Data
- Activity: Duplicating Data
TOPIC E: Generate a Report in Excel Using Macros
- The Columns Property
- The AutoFit Method
- The Address Property
- The Call Statement
- The Font Property
- The End Property
- How to Generate a Report
- Activity: Generating a Report
Review Questions
Lesson 3: Creating an Interactive Worksheet with Excel Macros
TOPIC A: Determining the Dialog Box Type
- Message Boxes
- Input Boxes
- Activity: Determining the Dialog Box Type
TOPIC B: Capturing User Input With Macros
- The InputBox Function
- Constants
- The MsgBox Function
- The Code Continuation Character
- The vbCrLf Constant
- Decision Structures
- The Select Case Statement
- The If Then Structure
- The Else Clause
- How to Capture User Input
- Activity: Capturing User Input
Review Questions
Lesson 4: Working with Multiple Worksheets
TOPIC A: Insert, Copy, and Delete Worksheets With Excel Macros Methods
- The Add Method
- The Copy Method
- The Delete Method
- How to Insert, Copy, and Delete Worksheets
- Activity: Inserting and Deleting Worksheets
TOPIC B: Renaming Worksheets Within Excel
- Expressions
- The DateSerial Function
- The Format Function
- How to Rename Worksheets
- Activity: Renaming Worksheets
TOPIC C: Modify the Order of Worksheets Easily With Excel Macros
- The Move Method
- How to Modify the Order of Worksheets
- Activity: Moving Worksheets within a Workbook
- TOPIC D: Print Worksheets
- The PrintPreview Method
- The PrintOut Method
- How to Print Worksheets
- Activity: Printing a Workbook
Review Questions
Lesson 5: Performing Calculations With Excel Macro Code
TOPIC A: Create User-Defined Functions inside Excel
- User-Defined Functions
- Types of Functions
- Arguments
- How to Create User-Defined Functions
- Activity: Creating and Applying a User-Defined Function
TOPIC B: Automate SUM Functions
- Declared Range Objects
- The Set Statement
- Range Object Cell Addressing
- The Rows Property
- The Formula Property
- The Columns Property
- Address Property Cell Reference Settings
- How to Automate SUM Functions
- Activity: Automating SUM Functions
The prerequisites for joining our VBA macro programming workshop are:
- Basic knowledge of Excel: Participants should have a good understanding of Excel’s features, such as creating and formatting worksheets, entering data, and using basic formulas and functions.
- Access to Excel: Participants should have access to a version of Excel that supports VBA programming, such as Excel 2013 or later.
- Willingness to learn: Participants should be motivated and willing to learn new skills and concepts related to VBA programming.
Post-Course Support
- We provide free consultation related to the subject matter after the course.
- Please email your queries to training@intellisoft.com.sg and we will forward your queries to the subject matter experts.
Venue:
All courses are conducted at:
190 Middle Road, 10-08 Fortune Centre, Singapore 188979. 5 mins walk from Bencoolen MRT station. Bugis, Rochor, Bras Basah MRT are nearby, within walking distance.
The venue is disabled-friendly.
SkillsFuture Ready
Singaporeans can use $500 SkillsFuture Credits for this training to offset the course fees.
Contact us for advise on how to go about claiming your SkillsFuture.
Get Started Today!
Learn By Doing
You learn best when you Do It Yourself.
We teach you, step by step, how you can learn new skills, build your knowledge and enhance your career prospects quickly & easily, with Practical Tips & Tricks!
Do You Have Any Questions or Need a Quotation?
Simple. Just tell us what you need. We’ll be glad to help you!
Some of the companies that experienced our trainings
How To Register
Simply contact us and we will assist you with the course registration. We can arrange a corporate training for your organization too. Just let us know your requirements for the course, and you availability.
