Module One: Using Logical Functions
In this module we will look at defining named ranges and using them in formulas. Identifying and applying Excel’s logical functions, IF, AND. OR and creating nested functions by combining logical functions in a formula.
Module Two: Working with Lookups
This module introduces the use of the VLOOKUP and HLOOKUP function. Excel 2010 provides two lookup functions that you can use to quickly retrieve information from a table. The functions are called HLOOKUP (horizontal lookup) and VLOOKUP (vertical lookup).
Module Three: Advanced List Management
This module will explore applying data validation settings to your worksheet to control data entry. You will also identify and use database functions to perform calculations using multiple database fields.
Module Four: Creating Pivot Tables
PivotTables allow you to analyse numeric data in depth. You can use this tool to answer unanticipated questions about data. PivotTables are interactive, cross- tabulated Excel reports that summarize and analyze data. In this module, you’ll learn how to insert a chart. You’ll gain an understanding of the PivotTable Tools tab. You’ll also learn how to choose fields for your table and group data.
Module Five: Using What If Analysis
“What-if” analysis allows you to have Excel change the values in cells so that you can see how those changes affect the formulas outcomes. There are three kinds of what if analysis: goal seek, scenarios, and data tables. Goal seek allows you to find the necessary value for an unknown in a formula to obtain desired results. Scenarios allow you to view multiple different possible results for up to 32 variables. Data tables allow you to quickly calculate multiple results for one or two variables in one operation. You can view and compare the results of all the different variations together on your worksheet. This module introduces these tools.
Module Six: Macros
A macro is a set of recorded computer instructions. These instructions are associated with a shortcut key or macro name that makes it easy to tell your computer to run that set of instructions. This module will explain how to save time with macros. You’ll learn how to display the Developer tab, which contains the tools you’ll need to record macros. You’ll learn how to record and run macros. This module also explains macro security levels to avoid allowing malicious content to damage your computer with macros. Finally, you’ll learn how to customize and change the Quick Access Toolbar so that you have instant access to your favorite macros.
0.00 average based on 0 ratings