MS EXCEL 

Our Course Outline

Learn the basics of creating worksheet, manipulation, management and  the introduction to formulas, pivot table, V Look up and graphs. In addition, students will learn to generate reports from the managed sheets.

WEEK 1-2 

• Course Introduction
• What is a spreadsheet?
• Understanding columns and rows
• Starting Microsoft Excel
• Opening/Closing an Existing Workbook
• Excel Window Overview
• Ribbo
• Workbooks and Worksheets

WEEK 3-4 Formatting in Excel

• Select Fonts and Size
• Color Fonts
• Shade or Put Patterns In Cell(s)
• Print Gridlines
• Create Borders
• Toolbar/Ribbon
• Menu
• Task Panes
• Moving around the spreadsheet
• Creating a new workbook
• Saving a workbook
• Opening a workbook

WEEK 5-6 Working/Formatting Data in a Worksheet

• Inserting Data into Cell
• Moving Data Using Cut and Past
• Copying Data Using Copy and Paste
• Changing Column Width
• Selecting cells
• Entering data in a cell
• Copying & Pasting data in a cell
• Moving cells
• Deleting values in a cell
• Sorting and filtering data
• Changing RETURN key behaviour

WEEK 7-8 Working Smart

• Sort Alpha Data
• Sort Numeric Data
• Insert Date at the Top of Worksheet
• Formatting numbers
• Formatting text
• Changing fonts
• Changing cell size
• Autosizing
• Inserting & deleting cells
• Inserting & deleting columns
• Inserting & deleting rows
• Merging cells
• Formatting cells
• Conditional formatting
• AutoSum function
• Reference operators
• Range operator
• Union operator
• Intersection operator
• Mixing reference operators
• Cell referencing
• Intro to Formulas
• Entering formulas using calculation operators
• Troubleshooting a formula

 

WEEK 9-10 FORMULAS – THE BASICS

• Intro to Functions
• SUM Function
• AVERAGE Function
• COUNT Function
• ROUND Function
• MAX Function
• MIN Function
• IF Function
• Entering A Formula
• Editing A Formula
• Addition
• Subtraction

WEEK 6 Commonly used tasks in Excel

• Making a worksheet easy to read or scan
• Fine-tuning the layout
• Fixing page breaks
• Previewing a worksheet
• Printing all or part of a worksheet
• Exam