MS Excel 2013 (Basic – Intermediate) (MDA139)

08 August 2017 - 09 August 2017

COURSE OUTLINE

Module A: Setting Up a Worksheet
• Identify the Elements of the Excel Interface
• Creating a New Worksheet with Data
• Using AutoFill for Data Entry
• Making Changes to Data
• Navigating and Selecting along Cell Ranges quickly
• Splitting Windows Horizontally or Vertically
• Freezing Windows Screen

Module B: Modifying Excel Worksheet
• Inserting, Deleting, Coping Worksheets
• Renaming and Coloring worksheet Tabs
• Changing Orders of Worksheet
• Working with Multiple Sheets
• Navigating Worksheets in a Workbook
• Hiding/Unhiding Worksheet

Module C: Formatting Data
• Formatting Data in a Worksheet
• Making Worksheet Contents Less Crowded by Changing Column Width and Row Height
• Inserting or Copying Column / Row with Insert or Paste options
• Adding Comment to Data

Module D: Writing Formula
• Entering Simple Formulas in Worksheet
• Using AutoSum to calculate Total, Average, Max, Min and etc
• Using AutoCalculate as Calculator

Module E: Printing Data
• Printing Worksheets
• Changing Page Orientation, Margin and Scaling
• Inserting Headers & Footers
• Inserting Page Break

Module F: Sign in to Office and OneDrive
• Sign In
• Saving a Workbook as OneDrive

Module G: Protecting Workbook
• Protecting Worksheets, Workbooks and File
• Exercise : Protecting Worksheets with Hidden Formulas
• Exercise : Protecting Workbooks and file

Module H: Analyze Your Data Instantly
• Analyse Your Data Instantly

Module I: Presentation Data in Charts
• Creating Chart
• Modified Chart
• Recommended Chart

Module J: Working with Sparklines
• Types of Sparklines
• Create Sparklines
• Changing the Appearance of Sparklines
• Change the display Range

Module K: Performing Calculation In Name Group
• Understand Relatives and Absolute Reference
• Named Method
• Creating and Re-defining Range names
• Creating Formulas with Range Names

Module L: Advance Function
• Using VLOOKUP Function
• Using IF Function
• Using PMT Function
• Using FV Function

Module M: Visualization Data Using Conditional Formatting
• Formatting Data Based on Its Value
• Using Conditional Format
• Create a New Conditional Formatting Rules
• Remote Conditional Formatting Rules

Module N: Enhancing You Work with Picture
• Inserting ClipArt And Picture
• Modify a graphic
• Insert a Screenshot
• Add Background to a Worksheet
• Draw and modify Shapes
• Insert a SmartArt Graphics

DURATION
2 days

COURSE FEE
Program 100% Claimable Under SBL Scheme
PSDC Members: RM 630/pax
Non-Members:   RM 680/pax

DATES
14 – 15 March 2017
8 – 9 August 2017

*Training dates are subject to change