NOTE: All document downloads are in PDF format.
To download a file, right-click on a link and select 'Save Target As' or 'Save Link As' from the menu. To
view and/or print them you will need to have Acrobat Reader
installed. Click here.
PC Simplicity Series PB/262x200/IllusB&W. 52 pp ISBN: 9781877431302
Microsoft Excel 2007 is a program designed to create and use a
spreadsheet. This Guide will take you through the advanced functions
and building your confidence in the skills needed to use the
software more productively. It assumes you have the skills taught in
the previous Guides.
Table of Contents
Lesson 1 Text Boxes Selecting Text Boxes Text Effects - Transform WordArt Styles Increase Indent Unlock Cells Protect Sheets Unprotect Sheets
Lesson 2 Send Sheet via Email Consolidate WorkSpace
Lesson 3 AutoFilters Working with Filters Removing Filters Pivot Tables Working with Pivot Tables Selecting a Pivot Table Clear a Pivot Table
Lesson 4 VLookup formula Hide Columns/Rows Unhide Columns/Rows
Lesson 5 Data Validation Subtotals
Lesson 6 Count Formula CountIF Formula Advanced Filters Extracting Data
Lesson 7 Advanced Filters – Unique Records CountIF Formulas Working Formulas on several sheetsAbsolute Cell Referencing
Lesson 8 PMT Formula
Lesson 9 Hyperlinks
Lesson 10 Goal Seek
Lesson 11 SQRT Formula Macros Running a Macro Arrays Grand Arrays Labelling Sheets
Lesson 12 Scenario
Lesson 13 Cell Names Go To a Cell Name Deleting a Macro Excel Help
Note: Microsoft Windows, Office, Access, Excel, FrontPage, PowerPoint,
Publisher, Word are registered trademarks of Microsoft Corporation, USA.
Shipped: Usually next business day
Shipping: Can ship anywhere
Your shopping cart is empty. Its contents will appear here when you click on 'Add to Cart'.