Microsoft Excel 365 Pre-course Skills Assessment

Please complete the pre-course skills assessment 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

QuestionResult
Create spreadsheets with SUM and basic formulas
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Entering and Editing Data
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Create spreadsheets with relative, absolute and mixed cell referencing
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Printing large spreadsheets, lists & tables
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Creating and modifying Charts
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Autofilling formulas, number series, text series and using custom lists
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Working with 3D formulas
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Sorting and filtering specific records in a list of data
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Linking workbooks
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Using If and Vlookup formulas
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Nesting functions in a formula
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Use analysis tools such as Goal seek and Solver
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Create and manipulate PivotTables and PivotCharts
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Record and use Macros for automation
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily
Importing and exporting data
  • Not at All
  • Yearly
  • Monthly
  • Weekly
  • Daily

More questions below...

Please indicate your understanding of the following

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