Microsoft Excel Intermediate Level

Creativewise Sdn Bhd (formerly UGROW IT Solutions)- 15 yrs experience in IT industry- 8 yrs corporate training experiencesWe provide all level of Microsoft Excel training for senior management and executive. We has successfully trained LB Aluminium Berhad, Nokia Siemen Network, ThaiExpress Sdn Bhd, SGS Malaysia Sdn Bhd, DataStream Solution (Brunei) Sdn Bhd, 3ntity Berhad, SGS Labuan (Group of Oil & Gas Chemists), AVNET Malaysia Sdn Bhd, SOMFY Sdn Bhd, KTC , New Horizons Malaysia, Nota Asia, Tunku Abdul Rahman College, Kawan Food Berhad, Merge Energy Berhad, PUMA, Syngenta, Ntritex Sdn Bhd and etc"Kent has helped my staff to reduce data analysis time in calculating staff overtime." ~ LB Aluminium Berhad

Creativewise Sdn Bhd

<IMG ALT="" SRC="https://cdn.evbuc.com/eventlogos/4275443/why.png" HEIGHT="500" WIDTH="500">
The Microsoft Excel Data Analysis Class is a 1-day hands-on training where Expert Reporting Expert Kent Lau will be sharing with you some of the most powerful Excel Advanced function that will improve your productivity, your ability immediately.with industrial case study related to finance, manufacturing,
With years of experience in training and consulting, Kent Lau has excellent industrial case study related to HR, Finance, Account, Manufacturing, Operation and etc.
Kent Lau has trained over 200 corporates for the past 10 years.
 
At Creativewise, you don't just get just a 1-day training, we give you more:
Kent Lau have consulted over 200 corporate to learn Excel fast and improve their skill of Excel, and in turn, improve my students' productivity.
Please contact me for a list of 40 success stories, see how I can improve HR, Finance, Account, Sales process.
 
The following is what you can expect to learn (and more):
MICROSOFT EXCEL DATA ANALYSIS COURSE OUTLINE
You will learn the following and practice on the spot:
Topic 1: Relative vs Absolute Cell Reference We design easy to understand exercise to help explain what cell address, cell reference, relative reference and absolute cell reference is.
Topic 2: Advanced functions and formulas Logical functions Conditional functions Text functions Date and time functions
Writing your first IF Statement Checking condition with numeric value Checking condition with text value Apply different calculation on different business requirement
Using Function & Formula Part 2 Calculating age using DATE related function TODAY(), NOW(), DAY, MONTH, YEAR, HOUR, MINUTE, SECOND
How to extract text value using TEXT FUNCTIONS such as LEFT. RIGHT. MID. TRIM. CONCATENATE.
VLOOKUP
How to use IF and VLOOKUP function together
Topic 3: Presenting Data Using Charts Create a Chart Create a Chart
Modify Chart Format Chart
 
Topic 4: How to use Hyperlink 
How to create a Hyperlink
Add Hyperlink to a shape
Add Hyperlink to a photo
Inserting photo
How to edit Hyperlink
Remove Hyperlink
Enable your customer/vendor visit your website faster with Hyperlink
Let your customer reach you faster with a Whatsapp link
Send an email with just a click
Topic 5: Applying Conditional Formatting
Formatting with one condition Editing Conditional Formatting Removing Conditional Formatting Essential skill to highlight items that match certain business requirement 
Topic 6: Pivot Table & Pivot Chart
What is Pivot Table How to use Pivot Table The Pivot Table structure Using Pivot Table creatively Extracting key business information from primary data source 
Bonus: 
Learn to use more than 20 Excel shortcuts Entering a Date and time fast Copy worksheets faster Saving a Workbook faster Using QAT toolbar 
 
WHY LEARN WITH CREATIVEWISE SDN BHD? Creative. PSMB Approved Training Provider. We deliver only the excellent Excel training you want. Highly creative and experienced. We are the expert in applying various Excel functions and feature. We have trained more than 200 corporate clients including batches of finance staffs for Bank Negara Malaysia, TESCO, Maybank and etc. Ongoing learning. You can further deepen your Excel skill and understand by purchase videos tutorial after the training session. It’s great and excellent tool for you to revise what you learnt and help you enhance your skill to next level, all this - on your own pace.** Carefully designed course material and exercise. Easy to understand and practical example for various job functions. Class size. maximum of 10 pax. We are committed 100% to your success.
** optional solutions. 
FAQs
Is my registration/ticket transferrable?
Yes. please inform us in advance of 3 days.
 
What is the refund policy?
We have planned the courses in advance. You can transfer the date to future, while refund is not available.
 
The name on the registration/ticket doesn't match the attendee. Is that okay?
Please inform us in advance whenever you are transferring your ticket to another person.
 
Will a certificate be given?
Yes, Certificate will be issued upon completion of the program, you will receive right after the training.
 
Please sign up today. Limited seats to 12 pax.
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;">CREATIVEWISE SDNBHD’s BELIEF
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;"> 
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;">We believe that the full potential of Excel should be mastered by you in the shortest of time possible and we exist to help you feel exceptionally good at Exceland probably in life too.
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;"> 
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;">We believe we are some of the exceptional one, and we want to bring your Excel skill to next level, nothing less than exceptional, including transforming your belief that you can't be excel in life.
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;"> 
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;">We have produced unbelievable, proven track record, changing thousands of Excel user in Malaysia, now they can go home earlier, feel more powerful, capable to perform like never before.
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;"> 
<P STYLE="language: en-US; margin-top: 0pt; margin-bottom: 0pt; margin-left: 0in; text-align: left; direction: ltr; unicode-bidi: embed; mso-line-break-override: none; word-break: normal; punctuation-wrap: hanging;">Our dream is to empower you with the #SpeedExcel mindset<SPAN STYLE="font-size: 14.0pt; font-family: Arial; mso-ascii-font-family: Arial; mso-fareast-font-family: +mn-ea; mso-bidi-font-family: Arial; mso-fareast-theme-font: minor-fareast; color: white; mso-color-index: 0; mso-font-kerning: 12.0pt; language: en-US; mso-style-textfill-type: solid; mso-style-textfill-fill-themecolor: background1; mso-style-textfill-fill-color: white; mso-style-textfill-fill-alpha: 100.0%;">, more than Excel, exceptional Excel master user.

Microsoft Excel Intermediate Level

More events from Creativewise Sdn Bhd

Discover more events from Creativewise Sdn Bhd, from Business to other experiences you might love.

Still looking for the right event?

Explore all events in Puchong and filter by date, category, and more to find the perfect fit.

Microsoft Excel Intermediate Level

More events from Creativewise Sdn Bhd

Discover more events from Creativewise Sdn Bhd, from Business to other experiences you might love.

You might also like...

Browse more events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all events in Puchong and filter by date, category, and more to find the perfect fit.