|
|
| About Us
| Courses
| Web Design | Consultancy
Services | Software
| Contact Us |
 |
| Microsoft Excel Advanced |
 |
| Objectives and Overview |
| This course is designed to give users
an understanding of some of the more advanced features and functions within
Excel and the advantages of using a powerful electronic spreadsheet. The
course is 'hands on', so those attending will get practice in using advanced
features of Microsoft Excel to manage, automate and customise workbooks. |
|
| Who should attend? |
| Users with a good understanding of
Microsoft Excel who want to consolidate and expand on their knowledge of
the basic features. |
| Course prerequisites |
| A good working knowledge of Microsoft
Excel, gained from the workplace or by
prior attendance on an "Excel Intermediate" course. |
| |
| Displaying and Formatting
Data |
| Applying Number Formats •
Creating Custom Formats • Using Conditional Formatting • Performing
Calculations and Changing Detail on a List • Querying an External List |
| Auditing a Workbook |
| Creating a Data Entry List •
Establishing Valid Data Entries • Tracing Errors • Tracing Precedent
Cells • Tracing Dependent Cells • Consolidating Worksheet Data |
| Using Data Analysis Tools
and Features |
| Creating a PivotTable •
Modifying a PivotTable • Creating and Modifying a PivotChart •
Creating an Interactive PivotTable List for the Web • Using Goal Seek
• Analysing Data with the Scenario Manager • Switching Between
Scenarios • Using Solver • Using the Analysis ToolPak |
| Sharing Workbooks |
| Creating, Editing and Removing
Comments in Worksheets • Tracking Changes in Workbook • Accepting
or Rejecting Changes to a Worksheet • Viewing and Changing Workbook
Properties • Applying and Removing Password Protection • Projecting
Worksheets and Workbooks |
| Creating, Customising and
Using Templates |
| Customising a Standard Template
• Opening and Modifying a Customised Template • Creating a Template
from an Existing Workbook |
| Using Macros |
| Planning and Recording a Macro
• Assigning a Macro to a Toolbar Button • Running and Editing
Macros |
| Customising the Excel Environment |
| Moving Toolbars and Toolbar Buttons•
Creating a Custom Toolbar • Testing a Custom Toolbar • Saving
Custom Views of a Workbook • Modifying the Working Folder • Customising
Excel to Help You Work more Efficiently |
| |
 |
| ©
Helen Williams 2008 |
|
Courses 
Home
page