Microsoft Excel Advanced - 2 Day Course - Brisbane

THIS COURSE IS IDEAL FOR This course exposes several advanced features of Excel for What-if analysis, database analysis and how to build calculations using advanced functions as well as how to automate processes. WHAT YOU WILL LEARN * Build complex calculations with advanced functions. * Link, export and consolidate data. * Limit data entry and build complex models with Lookup functions. * Analyse data with simple PivotTables and PivotCharts. * Create and modify Macros. TOPICS COVERED IN THIS TRAINING COURSE PROTECTING YOUR DATA * Workbook protection * Protecting cells * Protecting structure CIRCULAR REFERENCES * Locating and deleting circular references * When circular references are necessary * Formula error checking RANGE NAMES * Defining range names * Using names in formulas * Navigating with names * Using named constants * Documenting range names FUNCTIONS * Math and rounding functions * The AND function * The OR function * Nested IF function * The VLOOKUP function * The HLOOKUP function * Transposing data * Concatenating functions * INDEX and MATCH functions * Using help for functions DATA VALIDATION * Limiting cell values * Creating drop-down cell lists * Validation error messages WHAT-IF ANALYSIS TOOLS * Using goal seek IMPORTING DATA * Importing CSV files * Text import wizard WORKBOOK LINKING * Workbook linking * Dealing with broken links DATA CONSOLIDATION * Consolidation by cell position * Consolidation by headings EXPORTING DATA * Saving as a different file type * Exporting to Word * Pasting data with a link * Copying a graph with a link PIVOTTABLE REPORTS * Create a PivotTable * Rearranging data * Applying filters * Adding fields * Modify field settings * Refreshing data * Formatting a PivotTable PIVOTCHARTS * Creating a PivotChart * Filtering a PivotChart MACROS * Recording a Macro * Editing a Macro * Relative/Absolute Recording * Stepping through a Macro * Macro buttons * Customising the toolbar * Writing a line of code * Deleting a Macro