Excel 2003: Advanced Course Code: AD531 Outline Advanced Data Entry and Formatting Techniques Restricting cell entries Applying custom number formats Applying Conditional Formatting Naming Ranges Defining a Range name Using a Range name in a Formula Selecting a Range name Using Advanced Functions Using the VLOOKUP function Using the HLOOKUP function Using DSum and DAverage functions Creating a Custom Workbook Template Creating and modifying a Template Basing a new workbook on a custom Template Auditing a Worksheet Tracing Precedents and Dependents Tracing Errors Watch and Evaluate formulas Linking Multiple Workbooks Entering a formula to link multiple workbooks Creating a Workspace Filtering and Summarising Worksheet Data Adding Subtotals to a list Applying an advanced Filter to a list Outlining a worksheet Analysing Data Creating a Pivot table and Pivot chart Creating and displaying a Scenario Using the Analysis ToolPak Using Solver Importing and Exporting Data Working with Excel and other Excel Users Tracking changes Sharing and Protecting workbooks Merging revised copies of workbooks Additional Advanced Excel Features Using the Consolidation feature Adding a Trendline to a chart Format Chart and Graphics Working with XML Saving an XML spreadsheet Working with XML maps Managing elements and attributes XML view options After completing this course, students will know how to: Importing and exporting data to and from Excel. Use various functions including VLOOKHUP and HLOOKUP. Create a workbook based on a template. Utilise different protection options. Audit workbooks. Create a Pivot table and Pivot chart. Link multiple workbooks through formulas. Use DSum and DAverage functions Use XML functions. Contact The Fourth R

Home | Schedule | Downloads | Newsletters | Contact Us | Site Map Copyright © The Fourth R. All Rights Reserved.