Excel 2013 Foundation

Excel 2013 Foundation is for you if you are new to Microsoft Excel or if you are familiar with earlier versions of Microsoft Excel – Excel 2003 or Excel 2007, and wish to migrate to the new user interface of Excel 2013. You will learn all aspects of creating spreadsheets, performing calculations, formatting and using page setup for printing. Your tutor is a Microsoft Certified Master trainer with several years experience in teaching and using Microsoft applications.

Course Duration

The duration of this course is one day, with one  hour for lunch. Course starts at 09:00 and runs until 17:00

Course Objectives

After the course, you will be able to:

  • Create and maintain spreadsheets
  • Create and edit formulae
  • Format and print worksheets
  • Perform basic list management tasks

Prerequisites

Basic keyboard skills. No prior knowledge or experience in Excel is required.

Course Locations

This course is available either on-site or as a public course at our training facility here in Westpark Business Campus, Shannon.

Getting Started With Excel 2013

  • An overview of the screen, navigation and basic spreadsheet concepts
  • Understand Excel terminology workbooks, worksheets, rows, columns, cells
  • Various selection techniques
  • Understanding the various mouse cursors
  • Working with Ribbon Tabs, Groups and Dialog Boxes
  • Standard and Contextual ribbons
  • Use the task pane
  • Understand and use the File Tab
  • Saving, File types, File compatibility (earlier versions)
  • Useful keyboard commands
  • Quick Access toolbar & Mini Toolbar
  • Get Help!

Entering Data

  • Various ways to Enter, Edit and Delete information (Text, Numbers, Dates)
  • Use Auto List feature
  • Date and Time are storage in Excel
  • Enter Dates and Times
  • Date/time formatting
  • Methods to Move and Copy data
  • Use the Fill Handle to copy data and create simple lists
  • Create series of information
  • Insert, Delete and Hiding Rows & Columns
  • Insert, Delete and Move Cells
  • Insert, Delete, Move and Copy Sheets
  • Various navigation techniques

Creating & Editing Formulae & Functions

  • Define Formulae
  • Create & Edit Formulae
  • BoDMAS : Mathematical Order
  • Copy & Move Formulae
  • Use Basic Functions – Sum, Average, Max, Min, Count, Counta
  • Use Autosum tool
  • Introduction to the Function Library
  • Reference a cell in other sheets
  • Understand Relative Referencing
  • Apply Absolute (Fixed) Referencing

Formatting and Proofing

  • Formatting of Cells with Number formats, Font formats, Alignment, Borders, Fill colours and Patterns
  • Quick formats and themes
  • Sheet tab formatting and Renaming
  • Copy and Clear Formats
  • Merging cells
  • Spell Check, Find & Replace and AutoCorrect
  • Printing and Page Setup
  • Page Orientation
  • Add Headers and Footers
  • Print a selection
  • Set a print area
  • Clear a print area
  • Shrink to Fit
  • Adjust page breaks within Page Break Preview
  • Repeat columns and rows
  • Print Gridlines
  • Save print settings
  • Multiple File & Large Workbook Tools
  • Split screen tool
  • Freeze panes
  • Arrange workbook windows
  • Zooming tools
  • GoTo tool
  • Name box navigation

Click here to book a place on this course

Web Design and Search Engine Optimisation SEO by IDF Marketing
Robe De Mariée Bröllopsklänningar