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 Worksheet;
Calculations & Functions including SUM, AVERAGE, MIN, MAX, COUNT &
Locking Cell References in Calculations;
Formatting Essentials including Conditional Formatting; Viewing &
Printing Larger Worksheets; Splitting Up Text in Excel; Sorting &
Filtering Lists; Chart Secrets.
Using Range Names for Navigation & Calculations; Date & Time functions
including TODAY, NOW, NETWORKDAYS & EDATE; Logical Functions including
IF, AND & OR; Restricting Data Entry with Data Validation including Drop
Down Lists; Protecting Worksheets & Files; Additional ways to Manipulate
Lists including VLOOKUP, SUMIF & COUNTIF; PivotTables; 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; Using
Text Functions to Manipulate Text; 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
Understanding the Word screen; Finding the Keyboard Shortcuts; Setting
the default text formats; Powerful editing techniques including Click &
Type and White Space; Working with two parts of a document at the same
time; Moving around your Document; Selecting tips; Converting tabbed
text to a Table; Table tips & secrets; Drag & Drop; Paste Options;
Office Clipboard including how to link to Excel; Auto Text for standard
paragraphs; Bullets, Numbering and Multilevel Lists; Understanding
Sections so that you can have some pages in landscape and others in
Merging a letter or
another document to data in Word or Excel; Merging to labels or
envelopes; Sending multiple emails by merging Word to Outlook Contacts
or Excel data; Inserting files; Track Changes; Adding Comments;
Comparing two versions of a document when Track Changes has not been
used; References including Footnotes, Index and Table of Contents;
Building Templates for standard documents; Recording Macros; Adding
Macros to the Quick Access Toolbar; Inserting & manipulating Objects
including 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 as well as Office 365. Delegates will be provided with notes appropriate to the
version that they use.