Microsoft Office Training Materials – Excel 2013 Foundation Training Manuals
Microsoft Office 365 Training Materials, plus Office 2013 & Windows 10 Manuals Free SamplesMicrosoft 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
Other Office training manuals
Word 2013 Foundation
Word 2013 Intermediate
Word 2013 Advanced
Excel 2013 Foundation
Excel 2013 Intermediate
Excel 2013 Advanced
PowerPoint 2013 Foundation
PowerPoint 2013 Intermediate
PowerPoint 2013 Advanced
Access 2013 Foundation
Access 2013 Intermediate
Access 2013 Advanced
Publisher 2013 Foundation
Project 2013 Foundation
Visio 2013 Foundation