Online Training | 800‑258‑3837
Back to Course List

Microsoft Excel 2010: Calculating Data with Advanced Formulas

Preview video
Preview Video
Course Format
Video on Demand  Video On Demand
Product ID
soniecda_vod
Training Time ?
84 to 90 minutes
Language(s)
English
Video Format
High Definition
Required Plugins
None
Number of Lessons
9
Quiz Questions
6
Question Feedback
Wrong Answer Remediation
Lesson Bookmarking
Interactive Producer
Mastery Training Content Network
Original Content Producer
Sonic Performance Support GmbH
A pop up table showing how to calculate data with advanced formulas in Microsoft Excel 2010 Running multiple advanced formulas in a spreadsheet to calculate data in Microsoft 2010 The end results of Calculating Data with Advanced Formulas in Microsoft Excel 2010 in one spreadsheet
Overview

Microsoft Excel 2010: Calculating Data with Advanced Formulas

Newcomers to Excel learn the basics of spreadsheet navigation, how to find and name cells, how to refer to cells in other spreadsheets or workbooks, and what the Functions Wizard is and how to use it. Learn how to enter formulas, what formulas to use when, and get an overview of the Formula ribbon. Time-saving tips for building If formulas contingent upon single or multiple variables are covered, as are using the VLookup and HLookup functions to reference data stored in tables. More experienced users benefit from an overview of improvements to Excel functions, new functions and renamed formulas.

Learn how to harness the power of Excel’s advanced formulas in this thorough video.

Video on Demand   This course is in the Video On Demand format, to read about Video On Demand features click here.

  • Install on any SCORM LMS
  • Full-screen video presentation
  • Print certificate and wallet card
  • You have 60 days to complete the course
Audience

All those new to using Excel 2010

Topics
The course presents the following topical areas:
  • Calculating Data with Advanced Formulas
  • Appling Cell and Range Names
  • Cell References to Other Sheets
  • The Function Wizard
  • Creating and Entering Formulas
  • Improvements to Excel Functions
  • The IF Function
  • The Nested IF Function
  • VLOOKUP and HLOOKUP Functions

© Mastery Technologies, Inc.