|
 Microsoft
Excel - Training Level 1 - Introduction
Training
Topic 1: Microsoft Excel basics
The paper spreadsheet
The Excel program
The workbook environment
Training
Topic 2: Entering data and navigating in a worksheet
Entering and correcting data in MS Excel
Saving a file
Using formulas
Opening a second file
Navigation and movement techniques
Training Topic 3: Modifying a workbook in Microsoft Excel
Creating & working with named ranges
Working with functions
Editing cell contents
Training Topic 4: Moving and copying data
Inserting rows and ranges in MS Excel
Moving data
Copying data
Absolute references
Using the Fill Series feature
Training Topic 5: Formatting a worksheet in Microsoft Excel
Formatting a worksheet
Number formats and text alignment
Copying and pasting formats
Special and custom formatting
Training Topic 6: Printing a worksheet
Checking spelling in MS Excel
Using the Print Preview command
Printing a large worksheet
Additional print options
Training Topic 7: Introduction to the workbook environment
Using a multiple-sheet workbook
Creating a chart
Outlining Spreadsheet Solutions
Training Topic 8: Creating Excel Web pages
Using Excel as a Web tool
Microsoft
Excel - Training Level 2
Training Topic 1: Creating charts
Creating a chart sheet in MS Excel
Creating an embedded chart
Comparing chart sheets with embedded charts
Training Topic 2: Modifying charts
in Microsoft Excel
Chart types
Modifying embedded charts
Adding and deleting chart items
Moving and sizing chart items
Training Topic 3: Formatting a chart
Formatting chart text in MS Excel
Formatting labels
Formatting the chart
Printing a chart sheet
Training Topic 4: Using graphic objects
in Microsoft Excel
Adding graphic objects
Formatting graphic objects
Using graphic objects to enhance worksheets and charts
Training Topic 5: Sorting data
Single-level sorting in MS Excel
Multiple-level sorting
Sorting options
Design considerations
Training Topic 6: Filtering data in Microsoft Excel
Filtering a list
Custom criteria
Multiple-condition criteria
Managing a filtered list
Microsoft Excel
- Training Level 3
Training Topic 1: Customizing the Work Area
Working with Built-in Toolbars in MS Excel
Using Custom Toolbars
Creating and Using Styles
Using Templates
Training Topic 2: Advanced Formula Construction
Using Names in formulas in MS Excel
Using the IF Function
Using the VLOOKUP Function for data automation
Using the HLOOKUP Function
Using IS Functions and the Auditing
Training Topic 3: Using Pivot Tables in Microsoft Excel
Creating Pivot Tables for analysis
Modifying Pivot Tables
Grouping and Summarizing Data in a Pivot Table
Creating Interactive Pivot Tables for the Web
Training Topic 4: Working with Multiple Worksheets
Working with Workbooks
Linking Cells in Different Workbooks
Workbook Versus Links and Workspaces
Sharing and Merging Workbooks
Training Topic 5: Consolidating and Analyzing Data
Consolidating Data from More Than One Worksheet
Using the Goal Seek and Solver Utilities in MS Excel
Using Scenario Manager to View a Worksheet with Different Input Values
Training Topic 6: Using Protection and Display Options
Using Comments in MS Excel
Protecting Workbooks
Using Custom Views
Training Topic 7: Introduction to Macros in Microsoft Excel
Running Macros
Recording a Macro
Viewing the VBA Code
Training Topic 8: Working with Interactive Excel
Web Documents
Saving an Excel Worksheet as a Web Document
Spreadsheet Web Components
Please
contact us or call 905 271 1119
for more information
Action eBiz
offers On-site Microsoft Excel training and courses in Ontario, Toronto,
Mississauga. In MS Excel courses trainer covers MS Excel data analysis,
Microsoft Excel Charts, MS Excel pivot tables, Microsoft Excel Graphs, MS
Excel sorting and filtering, MS Excel database. Microsoft Excel training
also includes MS Excel formulas, Microsoft Excel VLOOKUP Function for data
automation,
Microsoft Excel HLOOKUP Function for data automation,
Microsoft
Excel marketing and sales analysis and creating MS Excel formula. We offer
MS Excel training in Toronto, Mississauga, Hamilton, Brampton, Ontario,
Kitchener, Waterloo, Cambridge, Canada We offer customized MS Excel
training for Employees, Managers, Executives involved in Financial,
Accounting, Marketing, Sales etc.. in Toronto, Mississauga, Brampton,
Ontario, Kitchener, Waterloo, Hamilton, Cambridge, Canada On-site Training
Microsoft MS Excel Courses Trainer Toronto Mississauga Brampton Ontario
We also offer on site training in other Microsoft Office software:
MS Project,
MS PowerPoint,
MS Word,
MS Outlook,
MS Access and
MS FrontPage.
|
