Home > Microsoft Office Training:
Microsoft Excel Training - Microsoft Excel Expert
Microsoft Office 2000-2003
Application Overview:
Microsoft Excel
Microsoft Excel is a powerful tool to create and format spreadsheets and to analyze, evaluate, and calculate data. You can use advanced features to manage, track, and chart critical business data to create rich data visualization, PivotTable views, and professional-looking charts. Goal Seek is another advanced feature, part of a suite of commands sometimes called what-if analysis tools. When you know the desired result of a single formula but not the input value the formula needs to determine the result, you can use the Goal Seek feature available by clicking Goal Seek on the Tools menu. When goal seeking, Microsoft Excel varies the value in one specific cell until a formula that's dependent on that cell returns the result you want.
Users:
IT, Database, Engineering, Finance, Legal, Marketing and Admin Professionals as well as anyone who needs create and edit spreedsheets that can be searched, sorted, analysed, reported, updated and shared with other users.
Upgrade to Microsoft Office 2007 Training
Microsoft Office 2000-2003 Training
Microsoft Excel
Microsoft Excel Expert
Course Information
Duration: One-Day Course
Platform: Windows and Macintosh
Fee: $295 CDN (+GST)
This class is limited to eight people.
Course Overview
Now that you have been working with the advanced features in Microsoft Excel, you are ready to take your skills to the next level. You will learn how to use the What if Analysis commands such as Goal Seek and Scenarios. You will delve into the more advanced functions to help you understand the power of using Excel in your everyday work. You will explore many features you can use to summarize and organize your data using pivot table. You will create an on line form and enhance the look of your worksheet by adding drawings and diagrams. You will create hyperlinks and save your Excel worksheet as a web page. Finally, you will reach from Excel to get and use external data.
Course Content
What If Analysis
- Learn how to use the Goal Seek command when you know the desired result of a single formula but not the input value the formula needs to determine the result
- Learn how to use the Scenario command when you have a set of values that Excel saves and can substitute automatically in your worksheet
Advanced Functions
- Learn more functions in each category, including financial, date and time, math and trig, statistical, lookup and reference, database, text, logical and information
Advanced Pivot Tables
- Take advantage of the many features you can use to summarize, organize and analyze your data using pivot tables
Create an Online Form
- Create a form which a user can fill in online. You will include: check boxes, option buttons, combo boxes and spinners
Use Drawings
- Enhance the look of your worksheet by adding text boxes, callouts, arrows, and pictures to the worksheet
- Add visual interest to your worksheet by adding a Cycle, Radial or Venn diagram
Hyperlinks and Web Pages
- Create hyperlinks to link a cell in one worksheet to another worksheet, workbook, document or web page
- Save your Excel worksheet as a web page
Import External Data
- Reach from Excel to get your Microsoft Access data or create a web query so that you can create for example a chart with the imported data
Calendar Dates:
Jul 18, 2008
Sep 5, 2008
Oct 1, 2008
Nov 5, 2008
Dec 15, 2008
Download PDF of Course Outline
If you have Adobe Reader installed you can view it now:
Related Training
DPA Certificate Programs
Our certification programs give you the opportunity to build your proficiency in electronic imaging, page layout, Internet, and office productivity while saving you a considerable amount.
more >>
(PDF 55 kb)