Microsoft Excel 2013 Foundation Courseware

Microsoft Office 2013 Training Resources

Download IT Courseware Samples

Getting started with Microsoft 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

Microsoft 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 Microsoft 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 Microsoft 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

Microsoft 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 Microsoft 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 Microsoft 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 Microsoft 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 Microsoft Excel 2013

  • Freezing row and column titles

Microsoft 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

Microsoft 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

Microsoft 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

Customizing Microsoft Excel 2013

  • Modifying basic Excel options

Download IT Courseware Samples

 

Microsoft Excel 2013 Foundation Courseware
5 (100%) 1 vote