Schedule	Course List
		Excel Introduction
	Microsoft Excel  Advanced Two Day Course	Excel Intermediate

Course Outline This course is designed to give delegates an understanding of some of the more advanced features and functions within Excel. The course is entirely 'hands on', so those attending will get practice in using advanced features to manage, automate and customise workbooks. Delegates Requirement A working knowledge of Excel and Windows is required, either gained from attendance on an Microsoft Excel Introduction Course or from use in the workplace. Who should attend Existing users of Microsoft Excel who want to gain knowledge on how to consolidate and link worksheets, print and view specific worksheet data using outline and work with simple databases using macros.

Review Creating formulae Applying and Copying Formats Working with multiple sheets Using SpeedKeys Using common Statistical Functions Working with Named Ranges Creating Range Names Using the Go To Command Range Names in Calculations Importing and Exporting Data Using Paste Special Object Linking and Embedding Sharing Data with Other Applications Importing a Text File into Excel Importing Data from Web Pages Templates and Custom Formats Creating Custom Format Applying Custom Formats Creating a Template Applying and Editing a Template Working with Multiple Workbooks Creating Custom Views Creating and using Workspace Files Linking Workbooks Creating Formulae to Link Data   Excel Tools   Creating Scenarios Show Auditing Tools Trace and Remove Precedents Trace and Remove Dependents   Logical Functions   Creating an IF Function Using the AND Function Applying the OR Function   Pivot Tables and Charts   Creating Pivot Tables Changing Pivot Tables Creating Pivot Charts Changing Pivot Charts Creating Charts Amending Charts Using the Shortcut Key to Chart   Excel Introduction Excel Intermediate

Lookup and Reference Functions   Using the VLOOKUP Function Using the HLOOKUP Function Preventing LOOKUP Errors   Working with Toolbars   Displaying Hidden Toolbars Floating and Docking Toolbars Customising Toolbars Creating a New Toolbar   Using Macros   Understanding Macros Recording a Basic Macro Relative References Creating a Macro Button Assigning a Macro to a Toolbar Button Image Editor      Working with Long Data Entries Appling Multiple Sorts Using Subtotals Applying Filters Advanced Filters Using Data consolidation Validating Data Applying Conditional Formatting      Database Functions   Using dmax Using dmin Applying daverage Using dcount      Text and Date Functions Using the Left Function Using the Right Function Applying the Text Function Concatenating Text Using the Datedif Function

Site Map