Computer Course Content

One Day Computer Courses

All courses are tutor led. The tutor will use demonstration and discussion along with hands-on practical tasks and assignments to ensure each user has gained an understanding of each topic. Questions are encouraged throughout the session. During each task and assignment, the tutor will give one to one support as required. Below is a summary of each computer training course content with links to more detail.

One Day Excel Courses

Excel level 1 – Essentials
COURSE OBJECTIVES:
Concepts and Terms.
Enter & Edit Data.
Modify the worksheet.
Functions to calculate Values.
Formatting to enhance appearance.
Page Setup & Printing

Excel Level 1 - More Details

Excel level 2 – Intermediate
COURSE OBJECTIVES:
Use Logic Functions
Use Lookup Functions
Sort and Filter data
Understand and use Nested Functions
Chart Formatting

Excel Level 2 - More Details

Excel level 3 – Advanced
COURSE OBJECTIVES:
Subtotals and Grouping
Intro to Macros & VBA
Data Validation
What If Analyses
Working with Scenarios
PivotTables

Excel Level 3 - More Details

One Day Excel Masterclass

Excel level 4 - Masterclass - Power Pivot
Excel Business Intelligence

If you analyse data from many sources e.g. CSV, Text, Access etc. or you have too much data to fit on a traditional worksheet then understanding how to use the most up to date features of Excel will benefit you and your staff.

This course provides a solid foundation and understanding of Power Query, Power Pivot and DAX.

Excel level 4 - Masterclass
Concepts & Terms
Import Raw Data
Connect to Data
Shape & Transform
Create Relationships
Data Analysis Expressions
(DAX)

Excel Level 4 - More Details

One Day Word Courses

Word level 1 – Introduction
COURSE OBJECTIVES:
Create and save documents for easy retrieval.
Insert and delete text to edit a document.
Move, copy, and replace text.
Modify text for emphasis.
Document and paragraph formatting
Set and remove tab stops to enhance document appearance
Margins, indents, bullets, and numbering
Use templates and Style Sets to enhance documents

Word Level 1 - More Details

Word level 2 – Intermediate
COURSE OBJECTIVES:
Use advanced editing tools
Mailmerge
Import Data
Learn to use drawing tools and features in Word
Create, use and modify tables in documents.
Work with Graphics
Working with Templates
Create Templates
Create Styles

Word Level 2 - More Details

One Day Outlook & PowerPoint Courses

Outlook in a Day
COURSE OBJECTIVES:
To cover the main components of Outlook
Email
Calendar
Tasks
Contacts
Notes
Folders (Search & Filing)
Journal
Junk Email

Outlook - More Details

PowerPoint in a Day
COURSE OBJECTIVES:
Views
Planning a Presentation
Creating Slides
Creating Master Slides
Templates
Slide Layout
Inserting Objects
Presenter Notes
Printing

PowerPoint - More Details