Ms Office Excel Beginners 2010 Satur Training Course Course: Introduction

This is a Saturday course for beginner’s in Excel, it is one of several Saturday courses we provide. This is intended for novices who have no prior knowledge of Excel. It is a practical course and all course materials will be provided. We will discuss topics such as workbooks, Excel terminology, cells, rows and columns and the features to edit them. Other topics include tables, workbook appearance and printing.

Ms Office Excel Beginners 2010 Satur Training Course Course :Course Outline

1. Setting Up a Workbook
Creating Workbooks
Terminology
Excel Environment
Customising Quick Access Toolbar
Creating a New Workbook
Entering Data into Workbook
Saving a workbook
Open a workbook
Zoom
Insert a new worksheet
Renaming a new worksheet
Changing the tab colour of worksheet
Rearranging the order of worksheets
Move or Copy worksheets
Hide or Unhide Worksheets
Switch windows

Modifying Workbooks and Worksheets
Changing column widths and row heights
Insert Columns or Rows
Delete Columns or Rows
Hide or Unhide columns or rows
Insert Cells
Moving Data by dragging

Customising Excel 2010
Arranging multiple workbook windows.
Customising the ribbon
Minimising the ribbon

2. Working with Data and Excel Tables
Entering Data
Copy, Cut and Paste
Pick from drop down list
Find and Replace data
Spell Check
Thesaurus
Defining an Excel Table
Format as table
Table design
Basic Formulas
How to create a basic formula
Operators
Copy formula down
Absolute cell reference
Basic Functions
Insert a function
Autosum, sum, min, max and average

3. Changing Workbook Appearance
Format Cells
Changing Font, Font size and Font Colour
Borders
Bolt, Italic and Underline
Fill Colour
Themes
Format Numbers as percentage, currency and general
Insert a Picture
Picture Styles, remove background, picture effects
Insert Background

4. Printing
Inserting Headers and Footers
Print Preview
Page Setup
Page break preview
Print active worksheets
Print entire workbook
Print Selection
Print titles
Set Print area
Centre data on page

Ms Office Excel Beginners 2010 Satur Training Course Course: Course Duration

1 day/s

Who should attend: Ms Office Excel Beginners 2010 Satur Training Course Course

This course is intended for novice users of Microsoft Excel.

**Quote does not include Any Exam Fees (if applicable)

IMPORTANT ACTION: Do Not Wait To Improve Your Skills.  

Book Now By Completing Online Booking Form / Customised Proposal or Obtain Approval For Your Already Received Customised Proposal