Microsoft Excel – Foundation

Duration:9:00am - 2:00pm
Cost (pp):$197
Location:3/610 Lorimer Street, Port Melbourne VIC 3207
Entry Requirements:

Participants should be competent in using a mouse and keyboard and basic understanding of Windows.

Description:

Click here to download the Microsoft Excel Foundation course outline

Let our experienced trainers show you how to save time, increase productivity, and transform the way you you Microsoft Excel in the future. All of our training is customised to suit your companies requirements instead of delivering a standard generic course.

Microsoft Excel Foundation Course Outline
The Excel Screen
• Moving around a sheet
• Viewing other sheets
• Using the mouse
• File properties

Formatting Cells
• Inserting text and numbers
• Typing text
• Typing numbers
• Fonts & font sizes
• Cell shading
• The format painter

Navigating a Workbook
• Saving a workbook
• Create a new workbook
• Closing a workbook
• Recent documents

Copying & Moving Data
• Copy/cut & paste data
• Paste options button
• Clipboard task pain
• Drag & drop data

Columns & Rows
• Selecting columns & rows
• Change row width/height
• Adjust columns automatically
• Insert & delete rows
• Hide & unhide rows

Page Setup
• Margin options
• Page orientation
• Basic headers & footers
• Page setup options

Basic Calculations
• Order of operations
• SUM/AVERAGE/MAX/MIN/COUNT functions
• Percentage formula
• Auto fill
• AutoCalculate

Basic Graphs
• Understanding graph types
• Create a graph
• Pie/Column/bar/line chart

Paragraph Formatting
• Numeric formats
• Borders and shading
• Cell alignment
• Cell merging
• Text wrapping

Printing
• Print preview
• Sheet & print settings
• Different types of printing
• Selecting print areas

Graphics
• Insert images
• Insert symbols
• Format images
• Move and rotate

Spelling & Proofing
• Checking spelling
• AutoCorrect
• Find & replace text
• Find & replace formatting

Other courses you might be interested in:

  • Microsoft Intermediate
  • Microsoft Advanced
  • Useful online free Microsoft Excel Advanced tutorials

  • Excel Exposure
  • Microsoft Tutorials
  • GCF Learning Tutorials
  • Excel jet Tutorials


  • To find out more, phone 1300 355 900.

    Units of Competency:
    Assessment Type:No Assessment
    Course Expires After:Certificate of Completion never expires
    Delivery Method:Face to face
    What to Bring and Wear:
    • Closed in shoes
    • Sleeved shirt
    • Photo ID
    Upcoming Course Dates
    Upcoming Course Dates
    Course NameLocationCourse Date
    FoundationPort Melbourne25-09-2017Book Now

    SOME OF THE ORGANISATIONS THAT WE’VE WORKED WITH

    “Working with Training Ahead Australia has been phenomenal. What they have delivered to my organisation has been nothing short of exceptional. We have seen a direct correlation between recent growth and success in sales, productivity and in culture from the training and influence of TAA.”- Bernard Fernandez, Agero Group
    Book online
    Training Ahead Australia - Rail Training