This course will cover getting started with Excel 2010, manipulating, formatting data and Worksheets, reviewing and printing. The training also teaches you Excel 2010 formulas, functions, charts, pictures, themes, styles, advanced formatting, advanced data management, advanced customization and how to analyze data and how to protect and share Excel 2010 workbooks.

Upon successful completion of this Microsoft Office Excel 2010 training course, you will be fully prepared to sit for the Microsoft Office Specialist Exam 77-882 MOS: Microsoft Office Excel 2010. All of our Microsoft Office 2010 training courses map to MOS certification paths.

Expected Duration (hours) – 15
Mentoring – 24x7

Price: USD $149.00

USD

Getting Started with Excel 2010

• Start Excel 2010 and open an existing workbook
• Identify the features of spreadsheets
• Recognize the functions of key Excel 2010 interface elements
• Create a new workbook
• Enter data in a given scenario
• Open a workbook based on an existing template
• Open an Excel workbook
• Enter data into an Excel workbook

Applying Basic Data Formatting in Excel 2010

• Apply basic text formatting
• Apply and copy cell formatting
• Format text and cells
• Recognize how alignment commands change the position of text
• Apply and modify number formats
• Match number formats with examples
• Align text in a cell
• Modify and apply a number format

Moving and Getting Around in Excel 2010

• Move around a worksheet
• Recognize how to navigate around Excel in a given scenario
• Get Help on Excel tasks or commands
• Alter your view of the worksheet
• Recognize how Workbook Views alter the appearance of a worksheet
• Recognize how to zoom in or out of a worksheet
• Work with different windows in Excel 2010
• Work with panes in Excel workbooks
• Move around a worksheet
• Alter your view of a worksheet
• Arrange and view workbook data

Moving Data and Modifying Worksheets in Excel 2010

• Copy and move data
• Use paste options to preview and control how data displays
• Insert and delete rows and columns
• Format rows and columns
• Insert and delete worksheets
• Copy or move worksheets
• Copy and paste data
• Modify rows and columns
• Copy and modify worksheets

Saving, Sending, and Printing Excel 2010 Workbooks

• Save a workbook in a different format
• Save an Excel workbook
• Change the default save options in Excel 2010
• Share and send a workbook
• Use the Page Setup settings to prepare a worksheet for printing
• Print an Excel 2010 workbook
• Save a workbook
• Share a workbook
• Prepare and print a workbook

Using Conditional Formatting, Tables, and Sparklines in Excel 2010

• Format data as a table
• Sort and filter table data in a given scenario
• Apply conditional formatting rules
• Recognize when to use specific conditional formats
• Use sparklines to show data trends
• Format sparklines
• Sort and filter table data
• Use conditional formats to highlight data
• Use sparklines to highlight trends in data

Reviewing and Protecting Content in Excel 2010

• Use Excel's proofing tools
• Use the Excel comments feature
• Use track changes in Excel 2010
• Select statements that describe Excel's track changes tool
• Apply worksheet and workbook protection
• Check spelling in worksheet and add notes using comments
• Use Excel's track changes feature
• Protect elements of a worksheet

Using Basic Formulas in Excel 2010

• Identify elements of a formula
• Recognize how Excel calculates precedence in a formula
• Recognize examples of reference types used in Excel formulas
• Create and insert formulas
• Use names in formulas
• Correct common error values
• Edit formulas
• Create a formula
• Define a name reference and use it in a formula
• Copy and paste a formula between cells

Using Basic Functions with Excel 2010

• Identify the characteristics of functions in Excel
• Perform basic calculations using Excel's most commonly used functions
• Use financial functions
• Use date and time functions
• Use logical functions to help perform calculations on worksheet data
• Perform basic calculations
• Use a financial function to determine the monthly repayment of a loan
• Use a date function and a logical function

Inserting Basic Charts in Excel 2010

• Recognize when to use different Excel charts
• Insert a chart
• Identify the elements of an Excel chart
• Update an existing Excel chart's style, layout, or location
• Change the data range on which a chart is based
• Insert a chart
• Update a chart's type, layout, and style
• Update the chart's source data and change chart's location

Adding Visuals, Themes, and Styles to Excel Workbooks

• Insert illustrations, including pictures, clip art, shapes, and SmartArt graphics, into a worksheet
• Use Excel's image editing tools to format illustrations
• Insert a screenshot into a workbook
• Add text features to a worksheet
• Use cell styles to apply consistent formatting
• Apply an Excel theme to a worksheet
• Add a picture and clip art to a worksheet
• Add a screenshot to a worksheet
• Apply a theme and a cell style

Customizing Visual Elements in Excel 2010

• Manually adjust a chart's layout and formatting
• Save and apply a chart template
• Manually format illustrations using the Format object dialog box
• Customize and save Excel themes and styles
• Save an Excel template and apply to a new workbook
• Adjust individual chart elements
• Format Excel illustrations
• Create a new cell style
• Create an Excel theme

Customizing Workbook Settings, Conditional Formatting, and Number Formats

• Customize workbook settings using Excel Options
• Change workbook properties
• Create a custom number format
• Recognize how to alter code strings to create custom number formats
• Create a conditional format based on a new formatting rule
• Manage conditional formatting rules
• Customize workbook settings and the Quick Access Toolbar
• Create and apply a custom number format
• Create a new conditional formatting rule

Organizing Data and Objects in Excel 2010

• Sort data in more than one column or row
• Create a custom filter
• Outline data using the Subtotal, Auto Outline, or Group commands
• Arrange objects on a worksheet page
• Recognize how you can arrange data to fit a specified page layout for printing
• Create a hyperlink
• Modify hyperlinks
• Sort and filter data
• Create an outline so you can group and summarize data
• Arrange objects on a page
• Create a hyperlink from a worksheet to a web page

Ensuring Excel 2010 Data and Formulas are Right

• Use Excel's formula auditing tools to evaluate and correct formulas
• Use the Watch Window to inspect, audit, or confirm formula calculations and results
• Use data tools to convert text to columns and remove duplicates
• Add data validation to worksheet cells
• List the different things you can use data validation for
• Use error checking to identify a formula error
• Separate text in one column into two columns
• Restrict data entry in specific cells

Also includes bonus modules - not required for Excel 2010 Exam 77-882 certification.

Automating Excel 2010 Tasks Using Macros

• Identify the features of Excel 2010 macros
• Use the Macro Recorder to record and run a macro
• Identify the steps in recording a macro using the macro recorder
• Edit and delete macros
• Run a macro in different ways
• Prepare for recording a macro
• Record and run a macro
• Assign a macro to the developer tab on the Ribbon
• Add a macro the Quick Access Toolbar

Analyzing Data with What-if Analysis in Excel 2010

• Use Goal Seek for data analysis
• Use Solver to perform data analysis
• Create scenarios using the Scenario Manager
• Manage Excel 2010 what-if scenarios
• Create a data table for what-if analysis
• Recognize how to project values in a series
• Use what-if analysis to find out how to achieve a desired result
• Use what-if analysis to determine the maximum or minimum value of one cell by changing other cells
• Use what-if analysis to forecast best-case and worst-case results
• Use what-if analysis to explore a possible set of outcomes at a glance

PivotTables and PivotCharts in Excel 2010

• Create a PivotTable report
• Rearranging data in PivotTable reports
• Customize PivotTable reports
• Modify a PivotTable report's design
• Create a PivotChart
• Modify a PivotChart report
• Create a PivotTable report
• Customize a PivotTable report
• Create a PivotChart report

PivotTable Filters, Calculations, and PowerPivot

• Use calculations in PivotTable reports
• Filter data in PivotTable reports
• Create and use slicers
• Identify the functions of elements of the PowerPivot interface
• Identify the features of PowerPivot for Excel add-in
• Change functions in PivotTable reports
• Create your own formula in a PivotTable report
• Enable multiple filters and apply a Report filter
• Use slicers to filter data in a PivotTable report