Thornton Vare Seminars
...the new way to learn

 

 
 

Home  |  About Us  |  The Seminars  |  Locations & Dates  |  Fees & How to Book  |  Special Offers  |  In-House Seminars

 
     
 

Delegate Comments

"Really extremely useful and
very well presented. An obvious
natural teacher which makes all the difference."

"Excellent! The best course Iíve been on. Where have you been all my professional life? I just wish I had been on this 10 years ago."

"This was absolutely brilliant and will save me 20 minutes a day."

Click here for more comments

 


The Seminars

Seminar Outlines

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 seminar title. 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 Secrets.

Advanced Excel 1

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 & Forecasting.

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 portrait.

Advanced Word

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

Understanding the 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 Access

Database Design 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 Access

Advanced Field 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 Access Documenter.

Seminar Notes

Detailed 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.

Application Versions

The seminars are run under Windows and are suitable for users of 2007, 2010, 2013 and 2016. Delegates will be provided with notes appropriate to the version that they use.

 

Contact Details

Thornton Vare Seminars Limited
13 Claremont Road
Norwich Norfolk
NR4 6SH
 

Tel: 07500 496971
seminars@thorntonvare.co.uk
 

 

 

 Microsoft Registered Partner

 
 
 

Copyright © 2008 All Rights Reserved 2008 Thornton Vare Seminars Limited is part of the Thornton Vare group
Registered Office: The Old Rectory Hainford Norfolk NR10 3BH