This course prepares you for the Excel MOS 77-882 exam by providing an introduction to using formulas and functions in Excel 2010. It also provides some tips for troubleshooting common errors with formulas and functions.
Objectives:
This course prepares you for the Excel MOS 77-882 exam by providing an introduction to using formulas and functions in Excel 2010. It also provides some tips for troubleshooting common errors with formulas and functions.
Work with formulas
Name cells and ranges, and use cell references
Perform calculations
Locate and correct formula errors
Create and use functions
Topics:
Working with Formulas
Editing Formulas and Using References
Naming Cell Ranges
Performing Calculations
Correcting Errors
Audits and Circular References
Creating Functions
Array Formulas and Nested Functions
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
