Microsoft Excel 2010: Specialist 2010

Product Description

Overview

This certification class provides a complete instruction solution to fully prepare students to achieve Microsoft Office Specialist (MOS) Microsoft Office Excel 2010 accreditation. It concentrates on getting delegates from knowledgeable to ?exam ready? in a 2 day class. The class is aimed at delegates who already have the raw skills to take the exam, but wish to hone those skills & practice with assistance from an experienced MOS qualified instructor, prior to taking the exam.
Please note this is the Specialist level: one of two levels of exam available for Microsoft Excel 2010 (Specialist & Expert). MOS exams are also available for Word, Power Point, Outlook & Access 2010.
Included Are
?2-days Instructor Led Instruction using MOS Official Classware
?MOS Practice Exam Voucher
?MOS Exam Voucher
? Free Exam Re-take (where required)
Class Outline
During the 2 day class you will cover the following topics to prepare you for exam 77-882: Using Microsoft Office Excel 2010. During the class, you will have the opportunity to test your knowledge & complete a full practice exam before taking the final exam at the end of day two.
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 & footers, & 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 & groups, manipulate Excel default settings, import data to Excel, import data from Excel, demonstrate how to manipulate workbook properties, manipulate workbook files & folders, apply different name & file formats for different uses by using save & save as features
Creating Cell Data
Construct cell data
? Using paste special (formats, formulas, values, preview icons, transpose rows & columns, operations, comments, validation, paste as a link), & cutting, moving, & select cell data
Apply Auto Fill
? Copy data using Auto Fill, fill series using Auto Fill, copy or preserve cell format with Auto Fill, select from drop-down list
Apply & manipulate hyperlinks
? Create a hyperlink in a cell, modify hyperlinks, modify hyperlinked-cell attributes, & remove a hyperlink
Formatting Cells & Worksheets
Apply & modify cell formats
? Aligning cell content, applying a number format, wrapping text in a cell, & using Format Painter
Merge or split cells
? Using Merge & Center, Merge Across, Merge cells, & Unmerge Cells
Create row & column titles
? Print row & 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 & unhide rows & 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 & footer size
Create & apply cell styles
? Apply cell styles, construct new cell styles
Managing Worksheets & Workbooks
Create & format worksheets
? Insert worksheets, delete worksheets, copy, reposition, copy & move, rename, grouping, apply colouring to worksheet tabs, hiding worksheet tabs, unhiding worksheet tabs
Manipulate window views
splitting window views, arranging window views, & opening a new window with contents from the current worksheet
Manipulate workbook views
? Using Normal, Page Layout, & Page Break workbook views, & creating custom views
Applying Formulas & 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 & 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 & manipulate illustrations
? Clip Art, Smart Art, shapes, screenshots
Create & modify images by using the Image Editor
? Making corrections to an image (sharpen or soften an image, changing brightness & contrast), using picture colour tools, & changing artistic effects on an image
Apply Sparklines
? Using Line, Column, & Win/ Loss chart types, creating a Sparkline chart, customising a Sparkline, formatting a Sparkline, & 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, & saving as PDF or XPS
Manage comments
? Inserting, viewing, editing, & deleting comments
Analysing & Organising Data
Filter data
? Define, apply, remove, search, filter lists using Auto Filter
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 & Apply Conditional Formatting, icon sets, data bars, clear rules