|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
MICROSOFT EXCEL 2007/2010 |
|||||||
|
Level 1: Beginner
|
Level 2: Intermediate |
Level 3: Advanced |
Level 4: VBA/Macros |
||||
|
Exploring Excel: Intro to Ribbon, Help, Navigate Working in Excel: Navigate, Select & Enter Data, Save Modify a Workbook: Insert & Delete Columns & Rows, Search, SpellCheck Calculations: Create Basic Formulas, Calculate With Functions, Copy Formulas & Functions, Create Mixed Reference Formatting: Fonts, Borders, Merge Cells, Number Formats, Cell Alignment, AutoFormat, Styles, Themes Developing a Workbook: Format Tabs, Reposition Sheets, Insert & Delete Sheets, Copy & Paste Sheets Printing: Print Titles, Header & Footer, Margins, Page Orientation, Page Breaks Customizing Layout: Split & Arrange Sheets, Freezing, Hide & Unhide |
Advanced Formulas: Cell & Range Names, Calculate Across Worksheets, Specialized Functions, Logical & Lookup Functions Tables: Create & Format Tables, Sort & Filter Table Data, Calculate Table Data Charts: Create Charts, Modify & Format Charts PivotTables & PivotCharts: Create a PivotTable Report, Create PivotChart Insert Graphic Objects: Insert ClipArt, Draw & Modify Shapes, SmartArt, Layer & Group Objects Enhance Excel Environment: Customize Excel, Customize Workbooks, Manage Themes, Create & Use Templates |
|
Streamlining Workflow: Create & Edit Macros, Conditional Formatting, Data Validation, Modify Default Properties Collaborating: Protect Files, Share Workbooks, Revision Tracking, Restrict Document Access Auditing: Trace Cells, Troubleshoot Errors & Invalid Data in Formulas Analyzing Data: Create Trendline, Scenarios, What-If Analysis, Statistical Analysis Multiple Workbooks: Consolidate Data, Link Cells, Create a Workspace Excel With the Web: Save Worksheet as HTML, Import Data from Web, Create Web Query XML: Develop XML Maps, Import & Export XML Data |
Developing Macros: Create a Macro with the Macro Recorder, Edit and Debug a Macro, Customize the Quick Access Toolbar and Hotkeys, Work with Macro Security Formatting Worksheets Using Macros: Insert Text, Format Text, Sort Data, Duplicate Data, Generate a Report Creating an Interactive Worksheet: Determine the 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, 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.
|