Duration: 1 day (9am - 4pm)
Cost: $149.00 + GST
Schedule: Please phone (09) 630.1220 for Auckland or (07) 857.0770 for Hamilton to request for a schedule
Course Outline
Working with More Functions
Applying Nested IFs to test multiple conditions
Combining the IF function with other functions such as AND, OR, ISBLANK, and ISERROR
Combining the VLOOKUP function with Conditional Formatting
Joining several text strings into one text string with CONCATENATE function
Using the NETWORKDAYS function to calculate whole workdays between two dates
Filtering and Querying Data
Applying data validation to prevent entry of invalid data in a worksheet
Using AutoFilter to dynamically sum up and average numerical data
Performing data queries using Database Functions
Creating multilevel subtotals automatically
Importing Information
Importing external files from the following sources: tabbed text data (.txt), comma delimited file (.csv), Microsoft Access database (.mdb)
Performing web queries
Working with Pivot Tables
Creating and modifying a Pivot Table and a Pivot Table Chart
Formatting a Pivot Table
Making Projections and Analysing Data
Solving ‘What If’ situations with Data Tables and Goal Seek commands
Using the Solver add-in option to forecast results or to generate summary of several quantity and pricing scenarios
Protecting Workbooks and Worksheets
Password-protecting worksheets and workbooks
Limiting access to cells and cell ranges
Restricting formatting options
Creating a custom workbook structure
Working with Macros
Recording and running a macro
Assigning macros to a shortcut key, toolbar, or custom button
Consolidating data within a workbook and across multiple workbooks
