Excel Windows 5: Intermediate

Course Code: EXCW5-2 Time: 7 hours

Prerequisites: Excel Windows 5: Introduction

Multiple Sheets and Files Grouping Sheets 3-D Formulas 3-D Ranges Multiple Files External Cell Addresses Spreadsheet Consolidation Saving the Workspace Formula Construction Formula Construction Absolute References Names Naming Ranges Naming Rules What are Names Good For? Sheet Specific Names Names from Existing Text Modifying Names Naming Formulas Some Very Interesting Functions Decision making functions AND(), OR(), VLOOKUP() Push Button Sorting PMT(), ROUND(), COUNT(), COUNTA(), WEEKDAY() Advanced Formatting Copy and Paste Formats The Format Painter

Creating, Applying, Modifying and Merging Styles Advanced Alignment Options Centering Across Selection Hiding/Unhiding Columns/ Rows Hiding and Unhiding Worksheets Worksheet and Workbook Protection The Info Window Customizing Excel Controlling Screen Display Customizing Toolbar Custom Fill Lists Controlling Excel Defaults File Management with Find File Setting the Search Location Viewing File Information File Maintenance Macros and Graphics What is This Thing Called Macro? Charting Basics Modifying a Chart Chart Toolbar Printing a Chart Drawing tools Rectangles, Ellipses, Lines, Arrows, and Text Boxes Moving and Sizing Drawn Objects

Return to Course Listing | Home Page