Corporate training in excel
We offer on and offsite Customized Excel Training. Experience the most practical computer training in NYC. Click here for information about our customizing procedures and pricing.
COMMON Excel topics
Listed below are some commonly requested Excel topics. This is not a complete list of what the program covers, but provides ideas for enhancing your learing. We can accommodate most requests and customize your session
to fit your needs. You may use your own documents as examples during your training sessions.
Excel for Business: Group Class
Outline & Schedule
Advanced Excel for Business: Group Class Outline & Schedule
Excel for the Financial Industry: Group Class Outline & Schedule
Getting Started
Identify
What You Can Do with Excel
Enter
Data in a Worksheet
Edit
Data
Change
the Appearance of Data
Save
a Workbook
Obtain
Help
Editing Your Worksheet
Moving
Data to Other Cells
Copy
Data to Other Cells
Fill
Cells with a Series of Data
Insert
and Delete Rows and Columns
Undo
and Redo an Entry
Find
and Replace Numbers
Enter
Data in a Range
Verify
Data in a Range
Performing Calculations
Sum
a Range of Data
Use
a Built-in Function
Copy
a Formula
Create
an Absolute Reference
Formatting
Specify
Number Formats
Create
a Custom Number Format
Change
Font Size and Type
Apply
Styles
Add
Borders and Color to Cells
Find
and Replace Formats
Change
Column Width and Row Height
Align
Cell Contents
Merge
and Center Cells
Apply
an AutoFormat
Working with Multiple
Worksheets
Format
Worksheet Tabs
Reposition
Worksheets in a Workbook
Copy
Worksheets
Change
the Number of Worksheets
Creating and Modifying
Charts
Create
a Chart
Modify
Chart Items
Format
a Chart
Change
the Chart Type
Setting Page Display and
Printing Options
Freeze
Rows and Columns
Set
Print Title
Set
Page Margins
Create
a Header and Footer
Change
Page Orientation
Insert
and Remove Page Breaks
Print a Range
Working
with Templates
Create a Workbook from an Excel Template
Create a Template
Create a Graphic
Create a Workbook from a User-defined Template
Sorting
and Filtering Data
Sort Data
Add Subtotals to a Worksheet
Filter Lists
Create and Apply Custom Filters
Importing
and Exporting Data
Import Data from the Web
Import Data from an External Source
Export Data
Save a Worksheet as a Web Page
Publish a Worksheet to the Web
Working
with Advanced Formulas
Share Data Among Worksheets
Create a Name for a Range of Cells
Use Functions to Create Advanced Formulas
Trace Cell Precedents
Trace Cell Dependents
Locate Errors in Formulas
Analyzing
Data
Create a PivotTable Report
Create a PivotChart Report
Create Scenarios
Use Solver
Use Goal Seek
Collaborating
Insert and Edit a Hyperlink
Add and Edit Comments in a Worksheet
Create Discussion Comments
Respond to Discussion Comments
Customizing
your Workbook
Apply Conditional Formatting
Add Data Validation Criteria
Customize Menus
Customize Toolbars
Create a Macro
Edit a Macro
Group and Outline Structured Data
Working
with Multiple Data Sources
Create a Workspace
Consolidate Data
Link Cells in Different Workbooks
Edit Links
Export Excel Data as XML
Import XML Data into Excel
Create a Web Query
Collaborating
with Others Using Workbooks
Protect your Worksheets
Protect Your Workbook
Share Your Workbook
Set Revision Tracking
Merge Workbooks
Track Changes
Enhancing
Your Worksheet Using Charts
Chart Non-adjacent Data
Modify Chart Items
Create a Trendline
Using
Graphic Objects to Enhance your Worksheets
Create
Graphic Objects
Resize,
Move, and Copy Graphic Objects
Change
the Order of Graphic Objects
Group
Graphic Objects
Format
Graphic Objects
Insert
Clip Art
Modify
Clip Art
Copyright New York Interactive Media 2008.
Manhattan Location (Union Square):
1 Union Square, Suite 903
New York, NY
10003
Directions
|
