GoExcel by AJ Training

GoExcel is a knowledge base, created by AJ Training, designed for users of ALL levels to increase their knowledge and confidence of Excel and other Microsoft Office Software.

Tables and Named Ranges

How to use table names within a VLOOKUP formula
How to create a table in excel
How to create a named range?

Charts

Sorting and Filtering

How to apply filters to data
How to use the asterisk wildcard to filter
How to sort data into alphabetical order?

Formatting Emails

Management

outlook

How to send a draft email

Backstage

How to use templates in PowerPoint?

Elements

Formatting Slides

Insert Tab

Styles

What are styles in Word?
How do I create a style in word?

Personalising Word

Remove or disable unnecessary add-ins on Word
How do I change the background word uses?

Scroll