MS Excel 2010 (Basic – Intermediate) (MDA135)

09 March 2017 - 10 March 2017

OBJECTIVE
Participants will be able to create a formatted spreadsheet with formulas/functions, print data in worksheet

COURSE OUTLINE

BASIC LEVEL
Module A: Getting Started with Excel 2010
• Identify the Elements of the Excel Interface
• To Customize the Ribbon
• The Quick Access Toolbar
• Backstage View
• Creating and Opening Workbooks

Module B: Cell Basic
• Understand the cells
• To select a Cell and Multiple Cells
• To Insert and Delete Content Cells
• To Copy and Paste Cell Content
• To Cut and Paste Cell Content
• To Access Formatting Commands shortcut
• Drag and Drop Cells
• To Use the Fill Handle (Auto Fill)

Module C: Modifying Columns, Rows and Cells
• Modifying Columns Column Width
• To Modify the Row Height
• To Insert Rows and Columns
• To Delete Rows and Columns
• Wrapping Text and Merging Cells

Module D: Formatting Cells
• Change the Font, Color and Fill Color
• Use the Bold, Italic and Underline Commands
• Add Border
• To Change Horizontal and Vertical Text Alignment
• Formatting Numbers and Dates

Module E: Saving
• Use the Save and Save As Command
• Use AutoRecover
• Save As a PDF

Module F: Creating Simple Formulas
• To Create a Simple Formula in Excel
• Creating Formulas with Cell Reference
• To Create a Formula using the Point and Click Method
• To Edit a Formula

Module G: Worksheet Basics
• To Rename Worksheets
• To Insert and Delete Worksheets
• To Copy and Move a Worksheet
• To Color-Code Worksheet Tabs
• To Group Worksheets
• To Ungroup All Worksheets
• Freezing Worksheet Panes
• To Freeze Rows and Columns
• To Unfreeze Panes

Module H: Printing
• To View the Print Pane
• To Print Active Sheets
• To Print the Entire Workbook
• To Print a Selection, or Set the Print Area
• To Change Page Orientation
• To Fit a Worksheet on One Page
• To modify Margins While in Print Preview
• To Use Print Titles
• To Insert a Break

INTERMEDIATE LEVEL
Module I: Work Protection
• Protecting Worksheets, Workbooks and File
• Protecting Worksheets with Hidden Formulas
• Protecting Workbooks and File with Passwords

Module J: Performing Calculation on Named Groups
• Understand Relative And Absolute Reference
• Naming Method
• Create Multisheet Names
• Calculate Data Across Worksheet
• Create Formulas With Range Names

Module K: Advanced Function
• Logical Functions
• VLOOKUP and HLOOKUP Functions

Module L: Presenting Data In Charts
• Overview of Excel Charting Features
• Creating Chart
• Charts Modifications
• Change Appearance of Charts
• Creating Combination Chart with Secondary Axis

Module M: Working with Sparklines
• Overview of Sparklines
• Creating Sparklines
• Change Appearance of Sparklines

Module N: Apply Conditional Formatting
• The conditional Formatting Rules Manager Dialog Box
• Using Conditional Format
• Create a new Conditional Formatting
• Remove Conditional Formatting Rules

Module O: Enhancing Your Work with Picture and Drawing
• Graphic Object
• Pictures and Clip Art
• The Screen Capping Tool
• Picture Formatting Options
• Format Artistic Effects Feature
• Draw and Modify Shapes
• Types of Shapes
• Illustrate Workflow Using SmartArt Graphics
• Layer and Group Graphic Object

DURATION
2 days

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

DATES
9 – 10 March 2017
14 – 15 November 2017

*Training dates are subject to change