Loading Events

« All Events

Microsoft Excel – Intermediate Level (Women)

October 17 @ 9:00 am - 5:00 pm

This course covers the intermediate level understanding of the spreadsheet. It is suitable for beginners wanting more knowledge on formulas and creating simple charts. At the end of this course you will have better understanding of the Excel features and you will be able to create formulas and charts.

 

At Course Completion

At the end of the course, participants will be able to:

  • Use multiple worksheets
  • Create bar, lines and pie charts
  • Create drawings & picture objects
  • Print worksheets and graphs

 

Module i1: Worksheets and Workbooks

Adjusting Zoom

Using Multiple Windows

Using Freeze Panes

Custom Views

-To create a custom view of the whole sheet

-To display & delete a saved view

Hiding and Unhiding Worksheets and Workbooks

Working With Multiple Worksheets

Changing Worksheet Tab Colors

Inserting , Moving, Copying & Deleting Worksheets

Grouping and Ungrouping Sheets

 

Module i2: Basic Functions & Formulas

Cell References: Relative and Absolute

Inserting Dynamic  & Static Dates and Times

Mathematical Functions: COUNTIF & SUMIF

 

Module i3: Analysing Data

Quick Analysis (Excel 2013 & 2016 Only)

 

Module i4: Conditional Formatting

Applying Cell Highlighting, Top, Bottom, and Average Rules,

Data Bars, Color Scales, and Icon Sets

Creating a Customized Rule

Editing , Prioritizing & Deleting Rules

 

Module i5: Drawings and Picture Objects

Customizing your Workbook, Inserting a Symbol or Special Character, Adding and Editing Shapes, Creating and Altering Diagrams, Incorporating Text, Adding a Signature Line

WordArt

Online Pictures or Clip Art: Excel 2007, 2010, 2013 & 2016

Inserting a Photographic Image

 

Module i6: Charts

What is a Chart?

Excel 2013’s Recommended Chart

Inserting A Chart

Excel 2016 New Charts

Elements of a Chart

Chart Styles (Formatting a Chart)

3-D Charts

-Enhance a 3-D Chart

Adjust Chart Data

Filtering Chart Data

Working with Charts

Chart Tips

 

Appendix A: Excel Keyboard Short Cuts

Keyboard access to the ribbon

Ctrl combination shortcut keys

Function keys

Other useful shortcut keys

 

About the Trainer:

Chong Sheau Wen

She does Microsoft Excel training programmes delivery and facilitation, Microsoft Excel course development and Microsoft Excel user application solutions consultancy and development. She has developed tools for inventory, chemical requirement/need, purchasing and tracking, and budgeting using Microsoft Excel, developed a platform for Chemical Health Risk Assessment documentation using Microsoft Excel, automated various work process including performance management using Microsoft Excel, conducted training on Microsoft Excel every quarterly for all personnel in various department, conducted and facilitated ‘Fire & Safety’ programmes yearly for the whole organisation.

She has also participated and chaired a session in the ‘Community of Practice in Emotional Intelligence’, organised for a local University’s faculty and corporate staff.

If you wish to get more information, please download brochure with application form or call WIM Office at 03-77250268 / 77299909.

 

Date: 17 October 2019, Thursday

Time: 9am-5pm

Fee: RM30

(inclusive of morning & afternoon coffee breaks, lunch, course materials and Certificate of Attendance)

 

Have a question?

Your Name (required)

Your Email (required)

Your Message

Details

Date:
October 17
Time:
9:00 am - 5:00 pm
Event Category:

Organizer

Women’s Institute of Management
Phone:
603-77250268 /
Email:
admin@wimnet.org.my
Website:
www.wimnet.org.my

Venue

Women’s Institute of Management
Wisma WIM, No 7, Jalan Abang Haji Openg
Taman Tun Dr. Ismail, Kuala Lumpur 60000 Malaysia
+ Google Map
Phone:
+603-77250268

Details

Date:
October 17
Time:
9:00 am - 5:00 pm
Event Category:

Organizer

Women’s Institute of Management
Phone:
603-77250268 /
Email:
admin@wimnet.org.my
Website:
www.wimnet.org.my

Venue

Women’s Institute of Management
Wisma WIM, No 7, Jalan Abang Haji Openg
Taman Tun Dr. Ismail, Kuala Lumpur 60000 Malaysia
+ Google Map
Phone:
+603-77250268