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 application form or call WIM Office at 03-77250268 / 77299909.
Date: 25 June 2019, Tuesday
Time: 9am – 5pm
Fee: RM30
(inclusive of morning & afternoon coffee breaks, lunch, course materials and Certificate of Attendance)
Have a question?