Software and Management Training Courses

Pre Course Assessment Tool

Personal Details

Name
Company
Phone
Email
Address
Contact Preference Phone Email Mail

  Knowledge Level
Topic Good Fair None N/A
The Excel Screen
Moving About the Workbook
Simple Data Entry
Selecting Ranges
Saving Workbook Formats
Using Fill for Quick Copying
Copying Cell(s) to One/Many Cells & Worksheets
Overwriting/Editing Cell Contents
Editing Formulae/Functions
Using Undo/Redo
Search & Replace
Inserting/Deleting Cells
Inserting/Deleting/Resizing Rows/Columns
Formulae that Add/Subtract/Multiply/Divide
BODMAS/Formula Error Checking
The Sum Function
Problems with Absolute/Relative Cell Referencing
Creating Absolute/Mixed References
Tracing Precedents/Dependent Cells
Circular References
Formatting Numbers/Dates/Currency
Formatting for Effect (Bolding/Italics/Underling
Cell/Background Colours
Cell Alignment
Summing Non-Contiguous Ranges
Average/Maximum/Minimum Functions
Hiding/Unhiding Columns/Rows
Freezing Panes/Splitting Windows
The Chart Wizard
Chart Types
Adding Title/Legends/Lables
Printing Charts
Simple Printing/Previewing
Page Setup & Orientation
Creating and Formatting Page Headers/Footers
Creating Headers & Footers (Information Fields)

Topic Good Fair None N/A
Creating/Deleting Labels/ Names
Creating/Using Names in Formulas/ Across Workbooks
Copying/Moving/Renaming Worksheet(s)
Inserting/Deleting/Grouping Worksheets
Hiding & Unhiding Worksheets
Linking within/between Workbooks & Applications
Sharing Workbooks & Tracking Changes
Adding/Editing/Deleting Worksheet Comments
Paste Special to Copy Formulae/Formats/Validations
Paste Special to Add/Multiple & Transpose
IFs and Nested IF Functions
Using AND/OR/NOT Functions
The VLOOKUP/HLOOKUP Functions
The CHOOSE/ISERROR/INDEX Functions
Adding/Filtering/Summarising Data in a List
A Custom Sort List
Applying & Using AutoFilter
Creating Compound/Custom Filters
Data Forms
Extracting Records with Advanced Filter
Using Formulas In Criteria/Database Functions
Adding Data to a Chart
Formatting/Renaming/Deleting Data Series
Changing the Order of Data Series
Formatting/Modifying Chart Axes
Repositioning Chart Elements
Changing Overlaps between Bars & Columns
Inserting/Using Images in a Chart
Printing a Selection
Setting the Print Area
Setting Margins with Page Setup
Specifying Print Title Rows/Columns
Printing Row/Column Headings & Gridlines
Consolidating Data with Identical/Different Layout

Topic Good Fair None N/A
Creating/Working with an Automatic/Manual Outline
Using The TODAY
NOW & DATE Functions
Using the PMT Function
One & Two-Variable Data Tables
Input Messages/Error Alerts/ Drop-Down Lists
Conditional Formatting
Creating/Displaying Scenarios
Scenario Summary Report
Using Goal Seek
Solver Reports
Restricting Answers Using Solver Options
Creating Subtotals/Nested Subtotals
The Conditional Sum Wizard
Relative Names For Subtotals
CreatingFormatting Simple PivotTables
Page Field in a PivotTable
Formatting a PivotTable
Counting/Percentages with PivotTables
Calculated Fields/Items in PivotTables
Creating/Modifying a PivotChart
Creating/Modifying Templates
Inserting a Worksheet from a Template
AutoStart Templates
Recording/Running a Simple Macro
Relative Cell References
Viewing a Macro Module
Assigning/Removing Macros onToolbar/Custom Button
 

(You will not be able to submit your assessment until you have completed the personal details section and selected the appropriate Knowledge Level for EVERY topic in the above list.)