Loading Events

« All Events

Basic Microsoft Excel (For Women Only)

January 24, 2019 @ 9:00 am - March 23, 2019 @ 5:00 pm

This course covers the very basics of the Excel spreadsheet. It is suitable for complete beginners without prior knowledge of Excel. At the end of this course you will have good understanding of the basic Excel features and you will be able to create a simple, presentable spreadsheet.

 

At Course Completion

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

  • Understand basic spreadsheet concepts
  • Create basic formulas
  • Format worksheets

Module B1: Introduction to Excel 2016 / 2013

Module B2: Working with Excel

  • Creating A New Workbook
  • The Excel Interface
  • Using Accelerator Keys & Dialog Box Launcher
  • Saving A Workbook & Opening A Workbook
  • Creating A Workbook from a Template
  • Switching to Another Workbook
  • Navigating in Excel Using Keyboard
  • Selecting A Range

Continuous range & Non-Continuous range

Current Region

 

Module B3: Data Entry in Excel

  • Entering and Editing Data
  • Moving and Copying Cell Contents
  • AutoFill, Custom Lists (Using the Fill Command), Flash Fill

 

Module B4: Introduction to Functions and Formulas

  • Understanding Formulas-Operators & Using Cell references in Formulas
  • Functions – AutoSum,Average Function, Max Function, Min Function, COUNT, COUNTA

 

Module B5: Formatting a Worksheet

  • Formatting Columns
  • Formatting Text
  • Formatting Numbers
  • Changing Alignment

Horizontal and Vertical Text Alignment

Merging Cells,Text Wrapping &Orientation

  • Borders and Shading

Applying Borders & Cell Colours

  • Format Painter
  • Applying Cell Styles

 

Module B6: Printing

  • Setting up your Worksheets

Page Breaks

Setting Page Orientation

Setting Margins

Setting Headers and Footers

Setting a Print Area

  • Print Titles
  • The Scale To Fit
  • Sheet Options
  • Previewing your Worksheet
  • Printing your Worksheet

 

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 registration form or call WIM Office at 03-77250268 / 77299909.

 

Date: 24 January 2019, Thursday

Time: 9am-5pm

Fee: RM30

(inclusive refreshments, luncheon, course materials and Certificate of Attendance)

 

Have a question?

Your Name (required)

Your Email (required)

Your Message

Details

Start:
January 24, 2019 @ 9:00 am
End:
March 23, 2019 @ 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