Microsoft Excel Module 4 (Half Day)
Sponsored links
Course Content:
● Functions - A review of the Function Wizard and how to apply functions (pre-defined formulas) within a spreadsheet.
● Logical Functions - An explanation of how and where these functions would be used. Use of IF function for testing data conditions.
● Lookup Functions - Using variable data in calculations. Use with lists of data in an Excel spreadsheet that can be referred to in a formula.
● Data Tables - Use of this forecasting tool to view different permutations of data.
● Scenario Manager - Create several versions of a spreadsheet. Saves time where previously copying a spreadsheet would have been used.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Module 4 - Advanced Level
Aim:
To apply the what-if concept to spreadsheeting using Excels data analysis tools.
Duration:
Half a day (9:30 am to 12:30 pm or 1:30 pm to 4:30 pm).
Who Should Attend:
Those who use Excel regularly and need to put to use the power features for manipulating data.
This Training Course is taught in classrooms in the following locations:
Sheffield
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
