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 Layout
Navigate a Worksheet/Workbook
Simple Data Entry
Select Cells and Cell Ranges
Save, Open and Close Workbooks
Move/Copy Cell Content Using Mouse or Clipboard
Use Fill for Quick Copying
Edit/Overwrite Cell Contents
Use Undo/Redo
Insert/Delete/Resize Rows/Columns/Cells
Create Formulae that Add/Subtract/Multiply/Divide
Understand Arithmetic Precedence Rules
Use Simple Functions (e.g. SUM, COUNT, AVERAGE)
Use Relative and Absolute References
Circular References
Formatting Numbers/Dates/Currency
Formatting for Effect (Bolding/Italics/Underling)
Cell/Background Colours
Aligning Cell Content
Use the Chart Wizard
Add Title/Legends/Labels
Printing Charts
Preview/ Print a Worksheet
Page Setup Options
Headers and Footers
Add Buttons to Existing Toolbars
Remove Buttons From Existing Toolbar
Reset Toolbars to Their Default Settings

Topic Good Fair None N/A
Copy/Move/Rename/Insert/Delete Worksheet(s)
Grouping Worksheets
Hide & Unhide Worksheets
Formulae Using Data from Multiple Worksheets
Password Protect a Workbook
Protect Workbook Structure
Protect All/Part of a Worksheet
Consolidating Data with Identical/Different Layout
Create or Define Range Names
Use Range Names in Formulae
Paste Special to Copy Formulae/Formats/Validations
Paste Special for Arithmetic & Transpose Options
Use the IF/AND/OR/NOT Functions
Nested Functions
Use VLOOKUP/HLOOKUP Functions
Use the Insert Function Feature
Create a Database (List)
Use Data Forms With List Data
Sort List Data
Select Rows Using AutoFilter and Custom AutoFilter
Use Advanced Filter Feature for Complex Selection
Large Worksheet Viewing Options
Add Data to a Chart
Chart Options
Printing a Selection
Setting the Print Area
Setting Margins with Page Setup
Specifying Print Title Rows/Columns
Printing Row/Column Headings & Gridlines

Topic Good Fair None N/A
Using the TODAY, NOW & DATE Functions
Overview the Range of Available Functions
One & Two-Variable Data Tables
Save Different Views of a Worksheet
Include Filters and/or Print Settings in Views
Input Messages/Error Alerts/ Drop-Down Lists
Apply Conditional Formats
Locate/Remove Conditional Formatting
Create/Apply Scenarios
Generate a Scenario Summary Report
Creating Subtotals/Nested Subtotals in Excel Lists
Create a Simple PivotTable
Page Field in a PivotTable
Format a PivotTable
Creating/Modifying Templates
Inserting a Worksheet from a Template
Record and Run a Simple Macro
Relative Cell References
Viewing a Macro Module
Assigning/Removing Macros on Toolbar/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.)