Set out below is a
summary of the topics covered on each seminar. To view a more detailed
list of the content of each seminar, please click the appropriate
These files are in pdf format. If
you are not able to read this file format you can click
here to download Adobe Reader.
Making the Most of Excel
Understanding the Excel Screen; Creating an Excel Spreadsheet;
Calculations & Functions; Formatting Essentials including Conditional
Formatting; Viewing & Printing Larger Spreadsheets; Splitting up Text in
Excel; Sorting & Filtering Lists & Creating Basic PivotTables; Chart
Using Dates & Times in
Calculations; Restricting Data Entry with Data Validation; Protecting
Worksheets; Using Range Names for Navigation & Calculations; Additional
ways to Manipulate Lists including VLOOKUP, SUMIF & COUNTIF; Advanced
PivotTables; Using IF with Information & Logical Functions; Automating
Worksheet Operations with Macros.
Advanced Excel 2
What If techniques including Goal Seek & Scenario Manager; Add together
data held in different Sheets & Files; Paste Special techniques;
Manipulate Text using Text Functions; Advanced Conditional Formatting
using Rules Manager; Sort Lists by Colour, Icon & Custom List; Filter
Lists on Multiple Criteria using Advanced Filter; Create & Edit
Templates; Advanced Charting including Combination Charts, Trend Lines &
Making the Most of Word
The Word Screen;
Accessing Commands & Keyboard Shortcuts; Working with two parts of a
Document at the same time; Moving around your Document; Selecting Tips;
Drag & Drop; Paste Options; Office Clipboard including how to Link to
Excel; Table Secrets; Bookmarks & Hyperlinks; Auto Formatting; Auto
Correct & Auto Text; Format Painter; Bullets & Numbering; Sections.
Merging a Letter to
Data in Word & Excel; Sending an email by Merging Word to Outlook
Contacts or a Data File; Tracking Changes; Non-Printing Comments;
Comparing two Versions of a Document; References including Footnotes;
Index & Table of Contents; Macros & Templates; Inserting & Manipulating
Objects including Pictures, Shapes, WordArt & SmartArt.
Making the Most of
PowerPoint Screen; Creating a Presentation; Working with Slides, Slide
Layouts, Masters, Themes & Templates; Page Setup; Working with Text
including Bulleted Lists; Utilising SmartArt; Inserting, Moving,
Aligning, Distributing, Grouping & Ungrouping Objects; Inserting Tables,
Charts, Diagrams, Photographs, Movies & Sounds; Linking Tables & Charts
to Excel Data; Enhancing your Presentation with Transitions &
Animations; Printing; Running the Slide Show.
Getting Started with
Concepts; Fields & Data Types; Creating a Table; Converting Excel Data;
Field Properties; Indexes & Primary Key; Using Datasheet View; Linking
Tables; Creating & Customising a Form; Creating & Running a
Query; Query Criteria; Building, Enhancing & Printing a Report;
Exporting Data to Excel.
Making the Most of
Properties & Indexes; Multiple Field Primary Key; Advanced Table Linking
Features; Enhancing a Form using the Toolbox & Form Properties; Combo
Boxes; Using Functions, Calculations & Dates in Queries; Parameters
Queries; Summary Queries; Office Links between Access, Excel & Word; the
seminar notes, workbook and data files are emailed after the
seminar allowing delegates to review and practise what they have learned
in their own time and at their own pace.
seminars are run under Windows and are suitable for users of 2007, 2010,
and 2016. Delegates will be provided with notes appropriate to the
version that they use.