Microsoft Excel 2010: Calculating Data with Advanced Formulas
- 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
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.
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 30 days to complete the course
All those new to using Excel 2010
- 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.
