Netwind Learning Center
netwind netwind

 

 facebook     googleplus   twitter    linkedin

netwind netwind

Microsoft Excel 2010 Training Course for MS Office Tutorials Online

Our training for Microsoft Excel 2010 makes it possible to analyze, manage, and share information in more ways than ever before, helping you make better, smarter decisions. Learn about the new analysis and visualization tools to help you track and highlight important data trends. Easily access your important data on the go from almost any Web browser or smartphone. Whether you're producing financial reports or managing personal expenses, our training for Excel 2010 gives you more efficiency and flexibility to accomplish your goals.

 

Excel 2010

Our Training course includes

    instructor based training Instructor led Video Based Training

    test preps Practice Tests. Review questions to test your knowledge of the material and prepare for the exam

    training time More than 30 Hours of training time

    Proven Success Proven success, with thousands sold to individuals and companies

Beginning Level

Getting Started

  • Start and open an existing workbook
  • Features of spreadsheets
  • Functions of key interface elements
  • Create a new workbook
  • Enter data in a given scenario
  • Open a workbook based on an existing template
  • Open an Microsoft Excel workbook
  • Enter data into a workbook

Applying Basic Data Formatting

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

Moving and Getting Around

  • Move around a MS Excel 2010 worksheet
  • How to navigate around  in a given scenario
  • Get Help on tasks or commands
  • Alter your view of the worksheet
  • How Workbook Views alter the appearance of a worksheet
  • Zoom in or out of a worksheet
  • Different windows
  • Panes in workbooks
  • Move around a worksheet
  • Alter your view of a worksheet
  • Arrange and view workbook data

Moving Data and Modifying Worksheets

  • Copy and move data
  • Use paste options to preview and control how data displays
  • Insert and delete rows and columns in MS Excel 2010
  • 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 Workbooks

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

Using Conditional Formatting, Tables, and Sparklines

  • Format data as a table
  • Sort and filter table data in a given scenario
  • Apply conditional formatting rules
  • 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

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

Using Basic Formulas

  • Elements of a formula
  • Calculates precedence in a formula
  • Examples of reference types used in 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

  • Identify the characteristics of functions
  • Perform basic calculations using most commonly used functions
  • Financial functions
  • Date and time functions
  • Logical functions to help perform calculations on worksheet data
  • Perform basic calculations
  • Financial function to determine the monthly repayment of a loan
  • Date function and a logical function

Inserting Basic Charts

  • When to use different charts
  • Insert a chart
  • Elements of a chart
  • Update an existing 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

  • Insert illustrations, including pictures, clip art, shapes, and SmartArt graphics, into a worksheet
  • 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

Advanced Training Level

Customizing Visual Elements

  • 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 themes and styles
  • Save an template and apply to a new workbook
  • Adjust individual chart elements
  • Format illustrations
  • Create a new cell style
  • Create an theme

Workbook Settings, Conditional Formatting, and Number Formats

  • Customize workbook settings using Options
  • Change workbook properties
  • Create a custom number format
  • 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

  • Sort data in more than one column or row
  • Ceate 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
  • Ceate an outline so you can group and summarize data
  • Arrange objects on a page
  • Create a hyperlink from a worksheet to a web page

Verifying  Data and Formulas

  • Use formula auditing tools to evaluate and correct formulas
  • 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

Automating Tasks Using Macros

  • The features of macros
  • Use the Macro Recorder to record and run a macro
  • 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

  • Goal Seek for data analysis
  • 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

  • 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
  • Create a PivotChart report

PivotTable Filters, Calculations, and PowerPivot

  • Calculations in PivotTable reports
  • Filter data in PivotTable reports
  • Create and use slicers
  • Functions of elements of the PowerPivot interface
  • 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

Power User Level Training

Sharing Excel 2010 Workbooks Online and on a Network

  • Share a workbook with advanced sharing settings
  • Features that are available in a shared workbook
  • Protect a workbook with Information Rights Management (IRM)
  • Allow users to edit specific ranges in a protected worksheet
  • Save a workbook as a Web file
  • Share workbooks

Using Excel 2010 to Collaborate Online and with Other Office Applications

  • Scenarios appropriate for using Excel Web App
  • Export data from Excel to SharePoint
  • Export data from SharePoint to Excel
  • Paste the contents of another Office file into an Excel worksheet
  • Add an Office document to an Excel worksheet
  • Manage linked Office files in Excel
  • Use with other applications

Using Lookup, Reference, Math, and Text Functions

  • Use lookup functions
  • When to use the lookup functions
  • Reference functions
  • Math functions
  • When to use the rounding functions
  • Trig functions
  • Text functions
  • Use advanced functions

Manipulating Formulas and Using Forms

  • Statistical functions
  • When to use cube functions
  • Conditional functions
  • Recognize when to use conditional functions
  • Array formulas
  • Use advanced functions
  • Add and edit ActiveX Controls in a worksheet

Using Data Connections: Web Queries, XML, and Databases

  • Use and configure existing data connections
  • Create a web query
  • When to use a web query
  • Create a data connection to an XML file
  • Create a data connection to a data source using the Query Wizard
  • Use data connections

 

netwind

Call 1.800.617.5586 for pricing

Excel Training 2010
(item# skexc10on)


Payment Options

1-800-617-5586 (352.404.8866)
All major credit cards (Visa, MasterCard, Amex, and Discover)
Company Purchase Orders may be faxed to 1.877.557.3064

netwind

 

Questions? e-mail us at: salesinfo@netwind.com

netwind netwind netwind netwind
Return Policy Netwind Learning Center

Copyright  © 1996-2016 Netwind Learning Center / CDi Communications, Inc.

Privacy Policy       Site-Map Navigation