Microsoft Office Training Materials – Excel 2013 Foundation Training Manuals

Microsoft Office 2013 Training Resources

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