Your cart has 0 item(s)
You are currently
Logged out
Current Users On-line: 17

Microsoft Excel Pre-Course Survey

Please complete the survey below and we will email you the recommended course to attend based on your skill and experience level

Please indicate how often you use the following

Question

Not at All

Yearly

Monthly

Weekly

Daily


Create spreadsheets with SUM and basic formulas
Entering & Editing Data
Spreadsheets with relative, absolute and mixed referencing
Printing large spreadsheets, lists & tables
Creating and modifying Charts
Autofilling formulas, number series, text series and using custom lists
Working with 3D formulas
Sorting and filtering specific records in a list of data
Linking workbooks
Using If and vlookup formulas
Nesting formulas
Use analysis tools such as Goal seek and Solver
Using Scenario Manager to create a report
Record and use Macros for automation
Importing and exporting data

More questions below...

Please indicate your understanding of the following

Question

Don’t understand or use at all

I partially understand the topic

Acceptable understanding

I fully understand the topic

Topic	Description
Excel Environment	Understanding the Excel screen and toolbars. Open and save a workbook
Formatting	Using page setup and print options to present information
Printing a worksheet	Print preview, spell checking and printing worksheets. Working with page breaks.
Creating 3D spreadsheets	Grouping, copying, deleting, moving worksheets. Use a 3D spearing formula
Creating and modifying a chart	Creating column, pie charts and embedded charts
Working with a database	Sorting, filtering, subtotalling and using the advanced filter within a list or database
Pivot tables & pivot charts	Creating and manipulating data in Pivot Tables and Pivot Table Charts
Protecting worksheets	Locking cells, so that no changes can be made.
Range names	Applying names to ranges for use with formulas and other tools
Consolidation	Combining and calculating data from several tables.
Absolute and relative macros	Recording macros and assigning them to the toolbar icon and shortcut keys
Goal Seek, solver, scenario manage	Using Analysis tools with formulas and data to produce results
Parsing	Converting other file formats to Excel
Auditing	Examining the formula structure of a file
Linking applications	Dynamically linking data between other Office applications

(Ensure manditory fields are completed at the top of the page before submitting)