* Required
Complete every section relevant to you below, then click Send.
Can you do the following?
Create a spreadsheet using Microsoft Excel?
Do simple formulae such as add, subtract, multiply, divide?
Use autofill & autosum?
Work out percentages & statistics such as max, min, average & count?
Use absolute references?
Print effectively using print preview and page preview?
Create bar charts and pie charts?
Work with multiple workbook sheets & link them using 3D formulas?
Link workbooks?
Sort columns and lists?
Filter data?
Use group and outline functions?
Get automatic subtotals in lists?
Use Pivot Tables to display data?
Use Slicers and Timelines?
Work with ranges?
Use lookup tables such as vlookup, hlookup and xlookup?
Protect workbooks and cells?
Use hyperlinks?
Use conditional formatting?
Create if formulas?
Use countif, sumif, nested ifs?
Use text functions such as concatenate, upper & lower?
Use the forecasting function with goal seek?
Create simple macros?
Create Dashboards?
Dynamic Arrays?
Power Queries?
Overall, how would you describe your competency using Excel?
Would you like to attend a 1 day basic course?
Would you like to attend a 2 day intermediate course?
Can you create and edit slides?
Can you format text for headings and bullets?
Can you import text from Word or elsewhere?
Can you create drawings using autoshapes?
Can you import clipart and change the clipart?
Can you import pictures or photos from your PC or internet?
Can you use pictures for watermarks or backgrounds?
Can you create organisation charts?
Can you use smart art features effectively?
Can you create, edit and format tables?
Can you create graphs and pie charts?
Can you use grouping and ungrouping functions?
Can you work with layers?
Can you apply templates and backgrounds?
Can you use the master slide?
Can you create a slide show?
Can you add special effects to a slide show?
Can you add sound to a continual photograph display?
Can you present confidently using Microsoft Teams?
Overall, how would you describe your competency using PowerPoint?
Can you create, save, open, print and close documents?
Can you cut, copy, paste & format text?
Can you use bullets and numbering features effectively?
Can you create and amend tables?
Can you use borders and shading?
Can you use tabs effectively such as left, centre, right, decimal & dot leaders?
Can you add pictures and graphics into your documents and get text to flow around?
Can you use columns, page borders and images?
Can you use shortcut keys?
Can you print envelopes and labels?
Can you do a mail merge?
Can you set up a template?
Can you use headers and footers on a document?
Can you use styles and table of contents in longer documents?
Overall, how would you describe your competency using Word?
Can you use email effectively?
Can you attach files to an email message?
Can you send emails to groups?
Can you use a personal address book as well as the global?
Can you use signatures?
Can you use the calendar functions?
Can you look at someone else's calendar?
Can you colour code appointments?
Can you create tasks?
Can you create folders, move messages & delete messages?
Can you create automatic rules for mail?
Can you find mail using search?
Can you use folder panes and previews?
Can you use immersive reader?
Overall, how would you describe your competency using Outlook?
Would you be interested in a half day Teams & OneNote training course?
What level of training in the following packages are you interested in?
Microsoft Visio?
Microsoft Project?
Microsoft Access?
Crystal Reports?
Presentation Skills? (One Day)
