Microsoft Excel Intermediate

Even those who are excited about incorporating new technology into their daily tasks may wonder what Microsoft Excel training could possibly do for them. However, the tricks and tools taught in Aspect's Excel Intermediate course reveal capabilities about Excel that most people never imagined.

The greatest thing about learning the ins and outs of this powerful program on Aspect's Excel Intermediate course is that you don't have to know a thing about programming languages or technospeak to be able to create highly interactive spreadsheet that update automatically with the latest information.

Aspect's Excel Intermediate course is designed for those users who wish to step up their current knowledge of Excel to take advantage of the more complex features. This course will show you how to create, edit and format large or multiple spreadsheets. Delegates will also be able to perform calculations and functions within a workbook, manipulate data lists which will enable the user to maintain and present data in a professional environment.

Using financial functionsUsing the PMT and FV functions
Setting up a financial analysis table
Using logical functionsUsing the IF and nesting IF functions
Using date/time functionsUsing the DATE and NOW functions
Using lookup functionsUsing the VLOOKUP and HLOOKUP
functions
Linking worksheets within a
workbookSetting up related worksheets within a
workbook
Moving the cell pointer from one
worksheet to another
Copying data from one worksheet to
another; editing the data
Entering a formula to link related
worksheets
Formatting multiple worksheets in one
operation
Moving and copying worksheets
Previewing and printing multiple
worksheets in one operation
Linking multiple workbooksEntering a formula to link multiple
workbooks
Creating a workspace
Using Excel Internet featuresAccessing the internet from Excel
Linking an Excel workbook to a web
page, saving Excel data as a web page
Additional data entry and formatting
techniquesRestricting cell entries to specific
numbers, dates, times or entries in a list
Applying number formats to cell entries
Creating a custom number format
Applying conditional formatting to a
worksheet
Working with a templateCreating a template; modifying the
default template style
Basing a new workbook on a custom
template
Auditing a worksheetTracing precedents, dependents and
errors in a worksheet
Working with a databaseWhat is a database?
Totalling database entries, filtering and
sorting database records
Specifying a criteria range in a filter
operation
Using a data form to enter database
records
Querying an external database
Analysing data (Part 1)Creating a pivot table report
Resetting a summary function in a pivot
table report
Creating a pivot chart report, creating a
pivot table report for the internet
Analysing data (Part 2)Using the solver, outlining a worksheet
Additional data analysis topics
Importing and exporting dataImporting a text file into Excel
Importing an HTML file into Excel
Exporting Excel data into other
applications
Using Excel workgroup featuresTracking changes and inserting
comments in a worksheet
Accepting and rejecting proposed
changes/reviewing comments
Protecting a shared or unshared
workbook
Additional workgroup topics