Training
Provided by Advanced Concepts
Course
Specification:
Course
Length: 1 day/2 evenings
Course Level: Advanced
Software: MS Excel xp/2003/2007 Professional
Course
Description:
Excel
Advanced concentrates more on the advanced functions available on this application to enhance more efficient and stronger management on calculations and worksheets and workbooks.
Target
Students: That already works on Excel and uses Excel on a daily base.
Prerequisites: Windows xp/2003/2007/ MS Word xp/2003/2007 Basic / Ms Excel Intermediate
Delivery Method: Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.
Benefits: Managing Workbooks, Spreadsheets and cells more efficiently by customizing according to the users need.
What s Next: VB on Excel xp/2003/2007
Course content:
X Custom Formatting: - Number Sections, Number Codes, Date Codes, Speedkeys
X Using Conditional Formats
X Creating Range Names
X Range Names in Calculations
X Paste Special
X Object Linking and Embedding
X Sharing Workbooks with Other Applications
X Importing a Text File into Excel
X Importing Data from Web Page
X Creating, Storing and Custom Workbook Templates
X Default Template
X Loading Add-In Programs
X Creating a Custom View and Work Space File
X Creating Formulae to Link Data
X Using the Report Manager to Print Multiple Workbooks and Worksheets
X Using the Look-Up Functions
X Creating, Displaying (hidden), Floating, Docking and Custom the Toolbar
X Understanding, Recording and Running a Macro Virus Protection
X Creating and Editing Data Map Charts
| This is primarily ilt training |  | Contact Advanced Concepts for more information |
|
| Training Presented in: | English |
|
