© Copyright Ezee Computer Training 2010 Made by Wen Studio Using Logical Functions • How to use logical test IF function • How to use IF function to return a text • How to use IF function to return a value • How to use nested IF function • How to use OR function • How to use AND function Using the VLOOKUP Functions • How to use VLOOKUP to find data • How to limit the lookup value for exact match • How to use the closest match for the lookup value Using Math and Trig Functions • How to use the Round function • How to use the Rand function • How to use SumIf Using Statistical Functions • How to use CountA function • How to use COUNTIF function • How to use CountBlank CREATING A PIVOTTABLE AND ANALYSING DATA Creating a Pivot Table • How to create a PivotTable Updating Pivot Table • How to update information in PivotTable • How to add information in PivotTable • How to arrange information in PivotTable • How to remove information in PivotTable • How to create page in PivotTable • How to display pages on separate sheets Modifying a Calculated Field in Pivot Table • How to use other functions in calculated fields • How to insert calculated fields • How to hide calculated fields • How to delete calculated fields Creating a Chart From a Pivot Table • How to create chart from a PivotTable VALIDATING, AUDITING AND TEMPLATES Using Data Validation • How to validate data input • How to compose data input message • How to create error alert message Creating a New Workbook Using Templates • How to create a new workbook using built-in template on your computer • How to create a new workbook using template on office online • How to create a new template • How to create new workbook from own template • How to edit the template Auditing Worksheets and Tracing Cell References • How to use the auditing toolbar • How to select cells that contain formula • How to watch formulas • How to find cells that provide data to an active cell (precedents) • How to find cells that referred by an active cell (dependents) • How to hide all the auditing arrows Tracing Errors • How to circle and remove circle for invalid data • How to correct calculation errors • How to set error checking options • How to scan and correct all errors Combining Worksheets and Data From Different Workbooks • How to consolidate data • How to move or copy worksheets to another workbook USING ADVANCED FUNCTIONS Using Range or Cell Names • How to name a cell • How to define a range name • How to define a 3-d range name using the menu • How to redefine the cell references in range name • How to delete a range name • How to use range name in formula Using Financial Functions • How to use PMT function • How to use PPMT function • How to use IPMT function • How to use PV function • How to use ABS function WHAT IF TOOLS Exploring Data Tables • How to create one variable data table • How to create two variable data table Using Scenarios  • How to create scenarios • How to apply scenario • How to edit scenario • How to delete scenario Using Goal Seek • How to use goal seek Using the Solver • How to install the solver • How to use the solver • Printing the different reports AUTOMATING ROUTINE TASKS WITH MACROS Understanding Macros • How to record a new macro • How to run macro with menu • How to create a run macro button on toolbar • How to create macro command button on worksheet • How to edit command button Editing a Macro • How to edit macro coding • How to rename a macro • How to delete a macro Using Relative Reference Macros • How to record a relative reference macro • How to run relative reference macro 519-473-1391 eMail