Training Course Outlines
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
Available separately, as part of our Microsoft Office 2013 courseware bundle, or as part of the full IT Courseware library