Introductory Microsoft Excel 2013 Training Courses

Getting Started
•First Steps with Microsoft Excel - opening, creating a new spreadsheet, saving, closing, using Help functions, converting documents, compatibility checker, switching between open worksheets and workbooks
•Adjusting Basic Settings - changing spreadsheet view mode, using the zoom tool, Quick Access toolbar, freezing and unfreezing row and/or column titles, modifying basic operations in Excel such as username and the default directories for opening and saving workbooks

Cells
•Inserting Data – entering a number, date, text in a cell
•Selecting Data - cells, range of adjacent or non-adjacent cells, rows, columns
•Copying, Moving, Deleting
•Editing Data – Inserting additional cell content, replacing existing cell content, using the undo and redo buttons
•Finding and Replacing
•Rows and Columns - inserting rows and columns, modifying row height and cell width, deleting rows and columns
•Sorting Data

Worksheets
•Handling worksheets – inserting a new worksheet, renaming a worksheet, deleting a worksheet, copying worksheets, moving worksheets

Formulae and Functions
•Arithmetic and Logical Formulae - addition, subtraction, multiplication, division, standard error messages
•Cell referencing - relative cell referencing, absolute cell referencing, mixed cell referencing
•Working with Functions - sum, average, minimum, maximum, count, if
•Formula AutoComplete

Formatting
•Formatting Numbers and Dates - number of decimal places, commas to indicate thousands, number of zeros after the decimal point, date styles, currency, percentages
•Formatting Cells - text size, bold, italic, font type, underline, double underline, font colour, text orientation, cell background colour, format painter
•Formatting Cell Ranges - centring and aligning cell contents, centring a title over a cell range, adding border effects
•Cell styles
•Applying table formats

Charts and Graphs
•Using charts/graphs – producing different types of graphs and charts to analyse data, editing or modifying charts or graphs, changing chart type, moving and deleting charts or graphs

Preparing Outputs
•Worksheet Setup – modifying worksheet margin settings, adjusting worksheet setup to fit one page, adding a header and footer, changing document orientation, page size, etc.
•Spelling
•Print Preview and Print Break Preview
•Applying automatic title rows printing on every page of a worksheet
•Printing Simple Worksheets – using print options, previewing a spreadsheet, printing a spreadsheet or a worksheet, printing part of a worksheet or a pre-defined cell range