Microsoft Excel 2013 Foundation Training Materials

Training Course Outlines

Download sample courseware

Getting started with Excel 2013

  • Starting Excel 2013 using windows 7 (or previous versions)
  • Selecting the blank worksheet template
  • The Excel 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
  • Switching between workbooks
  • Saving a workbook using another name
  • Saving a workbook using a different file type
  • Getting help within Excel 2013
  • Searching for online help
  • Alt key help

Excel 2013 selection techniques

  • 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

Manipulating rows and columns within Excel 2013

  • 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

Manipulating cells and cell content within Excel 2013

  • 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

Excel 2013 worksheets

  • 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

Font formatting within Excel 2013

  • Font formatting options
  • Font type
  • Font size
  • Bold, italic, underline formatting
  • Cell border formatting
  • Formatting the background colour
  • Formatting the font colour

Alignment formatting within Excel 2013

  • 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

Number formatting within Excel 2013

  • Number formatting
  • Decimal point display
  • Applying and removing comma style formatting (to indicate thousands)
  • Currency symbol
  • Date styles
  • Percentages

Freezing row and column titles within Excel 2013

  • Freezing row and column titles

Excel 2013 formulas

  • 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

Excel 2013 functions

  • 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

Excel 2013 charts

  • 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 design tab
  • Modifying the chart title
  • Modifying the chart axis
  • Modifying the chart legend
  • Modifying chart data labels
  • Displaying chart data tables
  • Modifying chart gridlines
  • Copying and moving charts within a worksheet
  • Copying and moving charts between worksheets
  • Copying and moving charts between workbooks

Customising Excel 2013

  • Modifying basic Excel options

Download sample courseware

Available separately, as part of our Microsoft Office 2013 courseware bundle, or as part of the full IT Courseware library

 

Microsoft Excel 2013 Foundation Training Materials
5 (100%) 1 vote