Excel Windows 7: Intermediate

Course Code: EXCW7-2 Time: 7 hours

Prerequisites: Excel Windows 7: Introduction

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

Advanced Alignment Options Centering Across Selection Hiding/Unhiding Columns/Rows Hiding and Unhiding Worksheets Protection Worksheet and Workbook The Info Window Macros and Graphics What is This Thing Called Macro? Relative vs. Absolute Macro Recording Charting Basics Modifying a Chart Chart Toolbar Printing a Chart Drawing tools Rectangles, Ellipses, Lines & Arrows Text Boxes Moving and Sizing Drawn Objects Customizing Excel Controlling Screen Display Customizing Toolbar Resetting Toolbars Creating and Deleting Toolbars Custom Fill Lists Controlling Excel Defaults Default Data Folder Gridline Display Controlling Zeros File Management Finding Files Saving Searches The File Dialog Button Bar Cut, Copy, Paste and Delete

Return to Course Listing | Home Page