Sign Up Today

SPECIAL OFFER for the rest of 2020
Use Discount Code InIT2020 for £50.00 Off

Outlook

Who is the Course for?

This course is designed for users who have some knowledge of Microsoft Outlook and are keen to extend their understanding and knowledge beyond basic email use.

This course will help the delegate use time more effectively & productively by using more features of Outlook.

The Basics

  • Outlook Basics (Help, Menus, Dialog Boxes)
  • Navigating in Outlook & Creating Folders
  • Customising Views
  • Creating Messages
  • Using Attributes (Bold, Colour, etc.)
  • Justification
  • Bullet Lists
  • Copying/Moving Text
  • Changing Fonts & Point size
  • Indenting
  • Signature Blocks
  • Using the Spell Checker
  • Using Stationary
  • Outlook Options

Managing Emails

  • Delivering/Getting Messages
  • Deleting/Printing
  • Working with Attachments
  • Flagging Messages
  • Using Rules
  • Handling Junk Mail
  • Organising Messages
  • The Address Book
  • Common Emoticons/Acronyms
  • Reading Messages
  • Replying/Forwarding Messages
  • Creating a Contact List
  • Sorting/Grouping Contacts
  • Deleting Contacts
  • Saving a v Card

Managing Time

  • Organising Tasks
  • Completing/Deleting Tasks
  • Accept, Decline and Delegate Tasks
  • Creating Appointments
  • Recurring Appointments
  • Scheduling Meetings
  • Creating/Editing/Deleting Events
  • Creating Notes
  • Sending Contact Info
  • Adding Folder Shortcuts
  • Editing/Moving Appointments
  • Deleting Appointments
  • Printing/Publishing Your Schedule
  • Creating a To-Do List
  • Editing/Moving Tasks
  • Recurring Tasks

Word Level Two

Who is the Course for?

This course is designed for delegates who have knowledge of Microsoft Word and are keen to extend their skills beyond basic document creation.

This level will help the delegate to use more productive word processing techniques at work.

Content

  • Refresher to Word
  • The Ribbon Bar
  • The Word Window
  • Managing Word
  • Version Control
  • Document Views
  • Navigating the Document
  • Pages and Sections
  • Working with Text and Tables
  • Text to Tables
  • Tabs and Indents
  • Working with Word Art
  • Headers and Footers
  • Working with Styles
  • Creating New Templates
  • Symbols and Dates
  • Charts and Objects
  • Hyperlinks
  • Importing Data
  • Linking Information from another source
  • Mail Merge
  • Graphics Positioning and Text
  • Tasks and Assignments Included

Word Level One

Who is the Course for?

This course is designed for people who have little or no knowledge of Microsoft Word. A general understanding of the personal computer and Windows would be useful.

This course is aimed at the beginner; however, many current users of Word find it a useful refresher and learn many new tips to increase their productivity and prepares them for the next level.

Content

  • Introduction to Word
  • The Ribbon Bar
  • The Word Window
  • Managing Word
  • Document Views
  • Navigating the Document
  • Working with Text
  • Fonts and House Style
  • Creating New Documents
  • Cut Copy and Paste
  • Margins and Orientation
  • Headers and Footers
  • Bullets and Borders
  • Tables
  • Inserting Graphics
  • Working with Columns
  • Tabs
  • Paragraph and Line Spacing
  • Spelling and Grammar
  • Printing
  • Tasks and Assignments Included

Excel XLOOKUP Function - 40 Minute Webinar

Get a good understanding of how the new XLOOKUP function works and more importantly how to use it different scenarios.

Content

  • XLookup
  • XLookup Array
  • XLookup Horizontal
  • XLookup Nested
  • XLookup Filter
  • XLookup SUM
  • XLookup Search
  • XLookup Wildcard
  • XLookup Approximate Match

Maths for Excel

Understanding the Maths

This short webinar takes a look at the maths behind the spreadsheet. How does the spreadsheet carry out calculations, what order and why! We’ll go back before computers were used, maybe a few thousand years. This is really crucial to understand if you are going to create formulas on a spreadsheet.

  • Order of Calculations
  • Why is there an order
  • Examples
  • Have a go yourself (don’t worry only primary level)

Excel Dates and Times - 40 Minute Webinar

This quick 40-minute webinar gives you a quick insight to using dates and times in your Excel spreadsheet. We take a look at straight forward calculations using Dates and Times and how to format the cells so you see the results in the correct format.

  • Entering Dates and Times
  • Dynamic and Static Dates and Times
  • Calculations
  • DATE Function
  • YEAR Function
  • MONTH Function
  • DAY Function
  • TEXT Function with Dates
  • Hidden Secret Function!!!!
  • CONCATENATE Date Results
  • 30 day End of Month Calculations
  • Calculating a Fraction of a Year
  • Time Formats
  • Difference between Times

PowerPoint

Who is the Course for?

This course is designed for users who either have no knowledge of PowerPoint or have some knowledge and wish to learn more about its features. The course is also suitable for users who would like a refresher of the basics. A general understanding of the personal computer and Windows would be useful.

The aim of this course is to look at all the features of PowerPoint and how to produce memorable slides to help the audience remember what the presenter is delivering. Don’t make do with basic Microsoft templates when you can easily create stunning corporate presentations yourself. This is a practical hands-on course, where you get the opportunity to practice creating stunning slides and not just a bullet point type presentation.

Content

  • Introduction
  • PowerPoint Views
  • Planning a Presentation
  • Create a Presentation
  • Slide Layouts
  • Working with Tables
  • Working with Images
  • Charts
  • Changing Slide Layouts
  • Font Formatting
  • Apply WordArt
  • Slide Master
  • SmartArt
  • SmartArt – Adding Shapes
  • SmartArt – Layout, and Styles
  • Shapes
  • Slide Sorter
  • Notes and Printing
  • Slide Transitions
  • Animation
  • Motion Paths
  • Audio Clips
  • Video Clips
  • Action Buttons & Hyperlinks
  • Saving and Printing

Excel Power Pivot

Who is the Course for?
This course is ideal for experienced users who are responsible for analysing data from many sources and have a good understanding of Excel functions and formulas.

Content

    • Introduction to Excel Power Business Intelligence
    • Enable Power Pivot
    • Import and reshape CSV files & more
    • Power Query
    • Power Query Editor
    • Query Editor Tools
    • Loading Data
    • Pivoting and Unpivoting
  • Merging Queries
  • Appending Queries
  • Data Model Views
  • Database Normalisation
  • Data and Lookup Tables
  • Power Pivot
  • DAX Measures
  • Data Analysis Expressions (DAX)
  • Basic Measures
  • SWITCH and SWITCH(TRUE) Functions
  • Date and Time Functions (Basic)

Excel Level Three

Who is the Course for?
This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.

Content

  • Excel Forms
  • Scenario Manager
  • Goal Seek
  • Installing Solver
  • Solver
  • Subtotals
  • Grouping & Outlining
  • Pivot Tables
  • Pivot Charts
  • Slicers
  • Tables
  • Cleansing Data
  • Excel Macros
  • Macro Security
  • Saving a Macro Workbook
  • Recording & Running a Macro
  • Relative Cell References (Macros)
  • Viewing & Editing a Macro
  • Assigning Macros
  • Global Macros
  • Object to run Macros
  • VBA Code

Excel Two

Who is the Course for?
This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques.
Content
    • Logic Functions
    • TRUE – FALSE
    • SumIF
    • SumIFs
    • AverageIF
    • AverageIFs
    • CountIF
    • CountIFs
    • IF
    • Nested IF
    • IFERROR
    • AND
    • OR
    • NOT
    • Naming Cells & Ranges
    • Managing Names
    • Using Names
    • Lookup Functions
    • Including the new Lookup function
    • Sort and Unique
    • Custom Fill
    • Static Dates and Times
    • Custom Date Formats
    • Custom Time Formats
    • Dynamic Dates and Times
    • Basic Date Calculations
    • Date Functions
    • Times
    • Handy Shortcuts

Excel Level One

Who is the Course for?
This course is ideal for both new and long term users who have had no formal training (often self-taught) and would like to make sure they are prepared for further levels. A general understanding of the personal computer and Windows would be useful. There are lots of useful time-saving tips.
Content
    • Introduction to Spreadsheets
    • Data Entry
    • The Ribbon Bar
    • Formatting
    • Basic Maths
    • Resizing
    • Basic Calculations
    • Sum
    • Copy & Fill
    • Absolute & Relative Referencing
    • Percentage
    • Sorting Data
    • Filter Data
    • Find Data
    • Selecting Data
    • Selecting Multiple Ranges
    • Insert New Columns and Rows
    • Date and Time Entries & Functions
    • Comments
    • Working with Multiple Worksheets
    • Printing
    • Page Setup
    • Show Formulas
    • Freeze Panes
    • Average, Maximum, Minimum
    • Conditional Formatting
    • Basic Charts
    • Embedded Chart
    • Handy Shortcuts