AJ Training
  • View Course Overviews:

  • Excel
  • Word
  • Outlook
  • PowerPoint
  • AJ Training.net

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.



  • Excel
  • Word
  • PowerPoint
  • Outlook

    Using Data

  • How to apply a drop down using data validation
  • How to only allow dates in cells using data validation
  • How to identify invalid data in Excel?

    Tables and Named Ranges

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

    Security

  • How to encrypt your workbook?
  • How to lock down a spreadsheet?
  • How to protect the workbook structure?

    Management

  • How do I filter my emails?
  • How do I view calendars in outlook?
  • How do I restore accidentaly deleted emails?

    Formatting Emails

  • Learn the outlook shortcut keys.
  • How do I categorise my emails?
  • How do I add a signature to my email account?

    outlook

  • How to send a draft email

    Elements

  • Making a shape 3D.
  • How to embed an object in PowerPoint?
  • How to insert a symbol in PowerPoint?

    Slides

  • How to remove sections?
  • How to expand and collapse sections?
  • How to apply an exit animation to your presentation.

    Backstage

  • How to use templates in PowerPoint?

    Personalising Word

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

    Formatting Documents

  • How do I change the bullet point type in word?
  • Different Paste Options in word
  • Strikethrough, Subscript & Superscript

    Insert Tab

  • How to use Quick Parts
  • How do I create a table in word?
  • How do I add shapes to my work?
Scroll

© AJ Training - 2017