Excel Intermediate Manual - Table Of Contents Sample

We offer your staff electronic version of our training manuals for free

1) Revision of Excel Basic   2)  Working Across 3D Worksheets and Workbooks Adding and Moving Worksheets Work with formulas using 3-D references Insert, rename, and delete worksheets within a workbook. Work with more than one worksheet simultaneously. Create links between cells in different sheets and workbooks and associated design issues   3)  Page Layout and Design Freeze/Unfreeze Panes Split Panes Headers/Footers Page Breaks and Views Print: Columns/Rows Repeat Print Areas/Gridlines/Column/Row Headings Center on Page Horizontally and Vertically   4)  Absolute Referencing   5)  IF Logical Statements Nesting Worksheet Functions   6)  Lookup reference tables Using Named Ranges  ` 7)  Use fill techniques Create data series and create your own custom AutoFill series Mouse fill techniques   8)   Excel databases Designing databases Entering and organizing data Finding and editing, extracting and maintaining data Accessing external databases e.g. Microsoft Access Use the list/database features in Excel including basic list information, sorting, using the Data Form, filtering, database functions, automatic subtotals Organizing Data - Sorting - Filtering   9)  Customizing Excel

Home  Courses Training Manuals Web Design &  Optimization Welcoming letter

© 2008 SkillMaster Computer Training