Microsoft Excel 2010 Training Course

Microsoft Excel 2010 Course Contents

Managing the Worksheet Environment

Navigate through a worksheet

• Hot keys, name box

Print a worksheet or workbook

• Printing only selected worksheets, printing an entire workbook, constructing headers and footers, and applying printing options (scale, print titles, page setup, print area, gridlines)

Personalise environment by using Backstage

• Manipulate the Quick Access Toolbar, manipulate the ribbon tabs and groups, manipulate Excel default settings, import data to Excel, import data from Excel, demonstrate how to manipulate workbook properties, manipulate workbook files and folders, apply different name and file formats for different uses by using save and save as features

Creating Cell Data

Construct cell data

• Using paste special (formats, formulas, values, preview icons, transpose rows and columns, operations, comments, validation, paste as a link), and cutting, moving, and select cell data

Apply AutoFill

• Copy data using AutoFill, fill series using AutoFill, copy or preserve cell format with AutoFill, select from drop-down list

Apply and manipulate hyperlinks

• Create a hyperlink in a cell, modify hyperlinks, modify hyperlinked-cell attributes, and remove a hyperlink

Formatting Cells and Worksheets

Apply and modify cell formats

• Aligning cell content, applying a number format, wrapping text in a cell, and using Format Painter

Merge or split cells

• Using Merge & Center, Merge Across, Merge cells, and Unmerge Cells

Create row and column titles

• Print row and column headings, print rows to repeat with titles, print columns to repeat with titles, configure titles to print only on odd or even pages, configure titles to skip the first worksheet page

Hide and unhide rows and columns

• Hide a column, unhide a column, hide a series of columns, hide a row, unhide a row, hide a series of rows

Manipulate Page Setup options for worksheets

• Configure page orientation, manage page scaling, configure page margins,change header and footer size

Create and apply cell styles

• Apply cell styles, construct new cell styles

Managing Worksheets and Workbooks

Create and format worksheets

• Insert worksheets, delete worksheets, copy, reposition, copy and move, rename, grouping, apply colouring to worksheet tabs, hiding worksheet tabs, unhiding worksheet tabs

Manipulate window views

• Splitting window views, arranging window views, and opening a new window with contents from the current worksheet

Manipulate workbook views

• Using Normal, Page Layout, and Page Break workbook views, and creating custom views

Applying Formulas and Functions

Create formulas

• Use basic operators, revise formulas

Enforce precedence

• Order of evaluation, precedence using parentheses, precedence of operators for percent vs. exponentiation

Apply cell references in formulas

• Relative, absolute

Apply conditional logic in a formula

• Create a formula with values that match your conditions, edit defined conditions in a formula, use a series of conditional logic values in a formula

Apply named ranges in formulas

• Define, edit and rename a named range

Apply cell ranges in formulas

• Enter a cell range definition in the formula bar, define a cell range using the mouse, define a cell range using a keyboard shortcut

Presentibg Data Visually

Create charts based on worksheet data

Apply and manipulate illustrations

• Clip Art, SmartArt, shapes, screenshots

Create and modify images by using the Image Editor

• Making corrections to an image (sharpen or soften an image, changing brightness and contrast), using picture colour tools, and changing artistic effects on an image

Apply Sparklines

• Using Line, Column, and Win/Loss chart types, creating a Sparkline chart, customising a Sparkline, formatting a Sparkline, and showing or hiding data markers

Sharing worksheet data with other users

Share spreadsheets by using Backstage

• Sending a worksheet via E-mail or Skydrive, changing the file type to a different version of Excel, and saving as PDF or XPS

Manage comments

• Inserting, viewing, editing, and deleting comments

Analysing and Organising Data

Filter data

• Define, apply, remove, search, filter lists using AutoFilter

Sort data

• Using sort options (values, font color, cell color)

Apply conditional formatting

• Apply conditional formatting to cells, use the Rule Manager to Apply Conditional Formats, use the IF Function and Apply Conditional Formatting, icon sets, data bars, clear rules