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?