Google+
Microsoft Excel 2010/2013 (Foundation)
Course Details
icon-dollar Fees: $345 + GST* icon-book Course ID: EXL005
icon-clock-o Duration: 1 Day icon-file-text Certificate: Only participation
icon-archive Delivery Type: Classroom icon-globe Language: English
icon-flag-checkered Locations: Perth

icon-pencil-square Notes:

  • Discount on multiple person bookings available. Give us a call for an obligation free quote.
  • If you would like the training to be arranged at your premises, we can do that. Please contact us via email or phone for quotation and further information.

About this course

Microsoft Excel 2010/2013 Foundation is the basic course designed for people who need to learn how to start using Microsoft Excel 2010/2013. The Course Highlight section below has in detail what features you will learn in this course.

Pre-requisites
To ensure success, participants are required to be familiar with using personal computers and should have experience using a keyboard and mouse. The training will be provided on Windows® 7 platform, therefore if participants are able to use Windows 7 to manage information on their computers it will help them concentrate on the specifics of the training. Some basic tasks include: managing files and folders, launching and closing applications and navigating basic file structures.

Course Highlights

Section 1: Getting Started

In this section you will learn:

  • Starting Excel 2010/2013
  • Selecting the Blank Worksheet Template
  • The Excel 2010/2013 Cell Referencing System
  • Entering Numbers and Text
  • Default Text and Number Alignment
  • Summing a Column of Numbers
  • Entering a Date
  • Worksheets and Workbooks
  • Saving a Workbook to Your Hard Disk
  • Closing a Workbook
  • Creating a New Workbook
  • Opening a Workbook
  • Opening a Recently Used Workbook
  • Pinning Files and Folders
  • Switching between Workbooks
  • Saving a Workbook Using another Name
  • Saving a Workbook Using a Different File Type
  • Getting Help within Excel 2013
  • Searching For Help
  • The Help ‘Table of Contents’
  • Printing a Help Topic
  • Alt Key Help
  • Using Other Excel Templates

Section 2: Selection Techniques

In this section you will learn about:

  • Why Are Selection Techniques Important?
  • Selecting a Cell
  • Selecting a Range of Connecting Cells
  • Selecting a Range of Non-Connecting Cells
  • Selecting the Entire Worksheet
  • Selecting a Row
  • Selecting a Range of Connecting Rows
  • Selecting a Range of Non-Connected Rows
  • Selecting a Column
  • Selecting a Range of Connecting Columns
  • Selecting a Range of Non-Connecting Columns
  • Recommended Techniques When Creating or Editing Lists

Section 3: Manipulating Rows and Columns

In this section you will learn how to:

  • Inserting Rows into a Worksheet
  • Inserting Columns into a Worksheet
  • Deleting Rows within a Worksheet
  • Deleting Columns within a Worksheet
  • Modifying Column Widths
  • Modifying Column Widths Using ‘Drag and Drop’
  • Automatically Resizing the Column Width to Fit Contents
  • Modifying Row Heights

Section 4: Manipulating Cells and Cell Content

In this section you will learn how to:

  • Copying a Cell or Range Contents within a Workbook
  • Deleting Cell Contents
  • Moving the Contents of a Cell or Range within a Workbook
  • Editing Cell Content
  • Undo and Redo
  • Copying Data between Worksheets (Within the Same Workbook)
  • Moving Data between Worksheets (Within the Same Workbook)
  • Moving Data Worksheets (Between Different Workbooks)
  • Copying Data between Worksheets (In Different Workbooks)
  • AutoFill
  • Copying a Data Range Using AutoFill
  • Sorting a Cell Range
  • Searching and Replacing Data

Section 5: Worksheets

In this section you will learn how to:

  • Switching between Worksheets
  • Renaming a Worksheet
  • Recommended Techniques with Naming Worksheets
  • Inserting a New Worksheet
  • Deleting a Worksheet
  • Copying a Worksheet within a Workbook
  • Moving a Worksheet within a Workbook
  • Copying or Moving Worksheets between Workbooks

Section 6: Font Formatting

In this section you will learn how to:

  • Font Formatting Options
  • Font Type
  • Font Size
  • Bold, Italic, Underline Formatting
  • Cell Border Formatting
  • Formatting the Background Colour
  • Formatting the Font Colour

Section 7: Alignment Formatting

In this section you will learn how to:

  • Horizontally Aligning Contents in a Cell Range
  • Centring a Title over a Cell Range
  • Cell Orientation
  • Text Wrapping within a Cell
  • Aligning Cell Contents Vertically
  • Format Painter

Section 8: Number Formatting

In this section you will learn how to:

  • Number Formatting
  • Decimal Point Display
  • Applying and Removing Comma Style Formatting (To Indicate Thousands)
  • Currency Symbol
  • Date Styles
  • Percentages

Section 9: Freezing Row and Column Titles

In this section you will learn how to:

  • Freezing Row and Column Titles

Section 10: Customising

In this section you will learn how to:

  • Modifying Basic Excel Options

Section 11: Formulas & Functions

In this section you will learn how to:

  • Creating Formulas
  • The Easy Way to Create Formulas
  • Copying Formulas
  • Operators
  • Using Operators in Formulas
  • Formula Error Messages
  • Relative Cell Referencing within Formulas
  • Absolute Cell Referencing within Formulas
  • What Are Functions?
  • Common Functions
  • Sum Function
  • Average Function
  • Max Function
  • Min Function
  • Count Function
  • The Counta Function
  • The Countblank Function
  • What Are ‘If Functions’?
  • Using the If Function

Section 12: Charts

In this section you will learn how to:

  • Inserting a Column Chart
  • Inserting a Line Chart
  • Inserting a Bar Chart
  • Inserting a Pie Chart
  • Resizing a Chart
  • Deleting a Chart
  • Chart Title or Labels
  • Changing the Column, Bar, Line or Pie Slice Colours in a Chart
  • Modifying the Legend Fill Colour
  • Changing the Chart Type
  • Modifying Charts Using the Layout Tab
  • Copying and Moving Charts within a Worksheet
  • Copying and Moving Charts between Worksheets
  • Copying and Moving Charts between Workbooks

MENU
Loading
×