0
Content Provider

CREATIVEWISE SDN BHD

Trainer Name

Kent Lau

Skill Area

Education, Skills Development or Languages

Reviews

0 (0 Rating)

Course Requirements

12 years old and above can learn


Course Description

The is level 1 of beginner level.


The participant does not need to have any programming skills.

The course will guide the participant to master the most basic steps to start learning Excel Macro programming language in just 60 minutes.

Course Outcomes

At the end of the course, the participant will learn how to:

  • Record macro
  • Write macro
  • Generate a PDF file with just one click

Course Curriculum

1 Lesson 1 - Getting Start in Excel Macro
10 Min

How to Activate Developer tab Record a macro Add a button Assign macro to a button


2 Lesson 2: How to record Macro
10 Min

How to Revise the last lesson View VBA Editor Introduce VBA Editor View code Insert a module Write your first macro Using Range


3 Lesson 3: How to write your second macro
10 Min

How to Write your 2nd macro Using & Assign values among multiple cells


4 Lesson 4:
10 Min

How to Use Cells object Cells and Range object Assign value – different worksheets


5 Lesson 5: Copy range of values
10 Min

How to Copy range of values to same worksheets Copy range of values to different worksheets


6 Lesson 6: Final project
11 Min

How to use Date, Now use Format function About Final project Convert PDF format faster What outcome required


1. Lesson 3
2. Lesson 4
3. Lesson 5
4. Lesson 6

Trainer

Trainer Name

Kent Lau

0 Rating
0 Reviews

More Courses by Author

Learner Feedback

Microsoft Excel Macro or VBA Level 1

0

Course Rating
0.00%
0.00%
0.00%
0.00%
0.00%

No Review found

Log In or Sign Up as learner to post a review

Shopping Cart

Loading...