Trusted Training Partners

Quick Look Course Summary:Ms Office Excel Beginners 2010 Satur Training Course Course
  • Next Public Course Date:

  • Length: 1 day(s)

  • Price (at your venue): 1 Person R 4,475.00 EX VAT 3 Person R 3,399.06 EX VAT 10 Person R 2,529.41 EX VAT

  • Certification Type:Accredited

  • Locations & Venues: Off-site or in-house. We train in all major city centres throughout South Africa.

Get Free & personalised
Training Advice

    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

    Realize incredible savings by sending more delegates

    Do you want to save costs by doing training at your premises?

    Save costs by providing own laptop

    Region *

    Please Contact Us Now - We Will Respond in 15 Minutes


      Accredited Courses

      Additional Courses

      Leadership & Management Courses

      Software & IT Courses

      Top Rated