MICROSOFT EXCEL BASIC COURSE (MEXB1)
Take the road to becoming an Excel expert.

WHO SHOULD ATTEND?

Microsoft Excel 2010 training course
The purpose of this course is to provide learners with a basic understanding of Microsoft Excel and form a solid base for higher level Excel functions.

This is also a great refresher course for individuals who want to sharpen up their Excel skills.

Being highly efficient in Excel can save huge amounts of time and save costs.

After completing this course, Level 2 & 3 are advisable, to enhance your Excel efficiency to an expert level.

  • Duration 8:30 - 16:30
  • Receive a Certificate of attendance
  • Training by a dynamic and experienced facilitator
  • Training manual with notepad & pen

DOWNLOAD REGISTRATION FORM HERE

registration_form.pdf
File Size: 119 kb
File Type: pdf
Download File

COURSE OUTLINE


SECTION 1 THE BASICS

WINDOWS CONCEPTS
  • Menus 
  • Ribbons 
  • Office Button
  • Toolbars 
  • Name Box
  • Formula Bar
  • Worksheets
  • Status Bar 
  • Task Pane 
  • Smart Tags

GETTING HELP

MICROSOFT EXCEL HELP


SECTION 2 MOVE AROUND AND ENTER INFORMATION


MOVING
  • Moving Around Workbook
  • Scrolling

USEFUL KEYS FOR MOVING
  • Workbook Sheets
  • Moving Around Sheet 

DATA ENTRY
  • Enter Text And Numbers
  • Cancelling And Editing Data Entries 
  • Enter Dates
  • Autocomplete 
  • Pick From List

EDITING
  • Typing Replaces Selection
  • Use The Mouse To Edit 
  • Using The Keyboard 
  • Select Information
  • Select Multiple Sheets
  • Select Non‐Adjacent Sheets

CLEAR CONTENTS, FORMATS AND COMMENTS

THE FILL HANDLE

USEFUL INFORMATION
  • Scrolling
  • Data Entry 
  • Select Cells To Limit Data Entry
  • Select Cells For Multiple Entry 

 
SECTION 3 FORMULAE AND FUNCTIONS

FORMULAE
  • Typing Formulae 
  • Entering Formulae By Pointing
  • Errors In Formulae 
  • Filling Formulae
  • The Fill Handle And Formulae 
  • Fill Formulae Using Keystrokes
  • BODMAS With Formulae

FUNCTIONS
  • Sum Function 
  • Autosum
  • Other Common Functions
  • Function Library 
  • Insert Function 
  • Function Box 
  • Type Functions 
  • Function Argument Tool Tips

CELL REFERENCES
  • Counting And Totalling Cells Conditionally 
  • Use Sumif()
  • Use Countif

ABSOLUTE AND RELATIVE REFERENCES
  • Relative References
  • Absolute References 
  • Fill Handle
  • Absolute References 
 

SECTION 4 FILE OPERATIONS
  • Save Files
  • File Types And File Names
  • Saving Changes To Files
  • Saving As A Different Type Or Different Name 
  • Close Files
  • Open Files
  • New Files 


 SECTION 5

MOVING AND COPYING DATA
  • Moving Items 
  • Copying Items
  • Clipboard
  • Drag And Drop
  • Shortcut Menus
  • Moving And Copying Between Files
  • Insert Paste 
  • Moving And Copying Between Worksheets
  • Paste Special 
 

SECTION 6 FORMATTING
  • Formatting Groups On Home Ribbon 
  • Font 
  • Point Size
  • Bold, Italic And Underline 
  • Font Colour
  • Background Fill Colour 
  • Borders
  • Alignment
  • Merge Cells 
  • Indents 
  • Number Formats 
  • Advanced Formats 
  • Format Cells Dialog 
  • Custom Number Formats

FORMATTING COLUMNS AND ROWS
  •   Column Width 
  • Row Height
  • Hide Columns, Rows And Sheets

INSERT AND DELETE CELLS, ROWS, COLUMNS OR SHEETS
  • Add Cells
  • Delete Cells 

FORMAT PAINTER
  • Shortcut Keys For Formatting 


 SECTION 7 NAMES
  • Rules When Naming Cells 
  • To define a name 
  • Selecting Names (Navigation) 
  • Manage Names By Using The Name Manager
  • Names In Functions
  • Paste List Of Names
  • Intersecting Names 
 

SECTION 8 WORKING WITH MULTIPLE SHEETS

MULTIPLE WORKSHEETS
  • Moving Between The Workbook Sheets
  • Worksheet Names
  • Move And Copy Worksheets
  • Insert And Delete Worksheets

ACTIVATE GROUP MODE
  • Group Adjacent Sheets 
  • Group Non‐Adjacent Sheets 
  • Deactivate Group Mode

FILL DATA ACROSS WORKSHEETS
  • 3‐D Formulae
  • External References 

PROTECT WORKSHEET DATA
  • Unlock Cells 
  • Worksheet Protection
  • Unprotect Sheets 
  • View Worksheets Side By Side 
  • Hide Windows
  • Watch Window 
  • Change Colour Of Worksheet Tab
 

SECTION 9 PRINTING

PRINT PREVIEW

PAGE SETUP
  • Margins Tab
  • Header/Footer Tab
  • New Methods For Headers And Footers In 2007
  • Insert Specific Elements In A Header Or Footer
  • Header Or Footer For A Chart 
  • Add A Predefined Header Or Footer
  • Choose The Header And Footer Options 
  • Sheet Tab 
  • Print Titles 
  • Page Breaks 
  • Print Data 
  • Copies
 

SECTION 10 MANIPULATING LARGE WORKSHEETS
  • Split Screen
  • Freeze Panes 
  • Zoom 


SECTION 11 SORTING & SUBTOTALLING DATA

LISTS
  • Do
  • Do Not 

SORTING LIST DATA
  • Quick Sort
  • Multi Level Sort

SUBTOTALS
  • Organising The List For Subtotals
  • Summarising A Subtotalled List
  • Show And Hide By Level
  • Remove Subtotals 
 

SECTION 12 CUSTOMISING EXCEL

SET EXCEL OPTIONS
  • Popular
  • Proofing
  • Save
  • Resources

ADVANCED OPTIONS

2 Day course @ R2 950 
All inclusive 
(20% Discount: 2+ delegates)

Register here
Picture
Picture
Picture
Picture
Photos used under Creative Commons from http://www.freedigitalphotos.net: Andy Newson,  Arvind Balaraman, Ambro, digitalart, photostock, 

Biz Training Institute © 2012

Accepted in the ezSearch South African business directory. Accepted in the ezSearch South African business directory.