|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
MICROSOFT EXCEL 2003
Electronic
spreadsheet program used to perform calculations, analyze information,
and manage lists of data. |
|||||||
|
Level 1: Beginner
|
Level 2: Intermediate |
Level 3: Advanced |
Level 4: VBA/Macros |
||||
|
Overview of Excel: Navigate, Select, Enter, Save, Help Modify a Worksheet: Move & Copy Cells, AutoFill, Insert & Delete Columns & Rows, Find & Replace Data Performing Calculations: Create Formulas, Use Functions, Copy Formulas, Absolute References Format a Worksheet: Fonts, Borders, Widths, Merge Cells, Number Formats, AutoFormat, Styles Develop a Workbook: Format Tabs, Rearrange Sheets, Insert & Delete Sheets, Copy Sheets, Copy Workbook Printing: Print Title, Header & Footer, Margins, Orientation, Page Breaks
Customizing Layout: Split & Freeze Sheets, Hide & Unhide Sheets |
Templates: Create a Workbook from Template, Create Custom Template, Comments, Hyperlinks Charts & Diagrams: Create & Format Charts, Change Chart Type, Create Diagrams Graphic Objects: Insert Graphics, Create & Format AutoShapes, Group & Layer, Move, Copy, Resize Objects Advanced Formulas: Create Range Names, Calculate Across Worksheets Use Functions: Date & Time, Financial, Statistical, Lookup & Reference, Logical Sort & Filter Data: Multi-level Sort, Filter Lists, Create & Apply Advanced Filters, Database Functions, Subtotals Excel & The Web: Export Data, Import Data from Web, Save as HTML |
|
Streamlining Workflow: Create & Edit Macros, Conditional Formatting, Data Validation, Modify Default Settings Collaborating With Others: Share Workbook, Track Revisions, Merge Workbooks, Digital Signatures Auditing Worksheets: Trace Cell Precedents & Dependents, Locate Errors and Invalid Data, Watch & Evaluate Formulas, Group & Outline Data Analyzing Data: Trendline, Scenarios, What-if Analysis, PivotTables & Pivot Charts, Statistical Analysis Multiple Workbooks: Consolidate Data, Link Cells in Different Workbooks Import & Export Data: Export Data to MS Word, Import Text Files XML: Develop XML Maps, Import& Export XML Data, Apply XML Views |
Developing Macros: Create a Macro with the Macro Recorder, Edit and Debug a Macro, Customize Toolbars, Menus, and Hotkeys Formatting Worksheets: Sort Data, Insert Rows and Columns, Insert Text, Format Text, Duplicate Data, Generate a Report Creating an Interactive Worksheet: Determine Dialog Box Type, Capture User Input Working with Multiple Worksheets: Insert, Copy, and Delete Worksheets, Rename Worksheets, Modify the Order of Worksheets, Print Worksheets Performing Calculations: Create User-defined Functions, Automate SUM Functions
|
|||
|
Each level is a 6-hour training class, and
includes a take-home manual with practice disk, a Certificate of
Completion, and you can contact your instructor after your training with
questions. Contact us at 804-288-8331 for a custom-designed training class, that can mix and match these and additional topics. |
|||||||
|
About Us | How We Help | Courses Offered | Class Schedule | Registration Form Commonwealth
Computer Training Website Design by HunterNet is association with Free Rein Marketing. Hosted by Mediatech Enterprises.
|