[X]
Activia for Microsoft Office Training
speedy course quote from Activia Training
Bookings and Enquiries:                0845 230 6150
Customer Service:                           0845 230 6159
We're here to help!      Click for a  FREE CALLBACK
Access your Dashboard:  Click to  log in

CLICK to view our courses
CLICK to view our locations
CLICK to view prices and dates
CLICK for information, tools, etc
CLICK for contact details
    Groups of delegates?   Save hundreds of pounds when we deliver training  at your offices

Office Training Courses

Training courses for Office 2003 to 2013

Office training at our centres or your offices UK-wide
Office Training Courses from Activia

About Microsoft Office training

Microsoft Office contains a suite of applications that are each designed to fulfil a specific purpose. These can be deployed to fulfil both domestic and corporate requirements, making the software extremely versatile, enabling users to compose and edit documents, create powerful presentations, manage their accounts and much more.

We can also tailor your Microsoft Office training to your needs (click the button on the right) or to your company project requirements, taking you from first principles to whatever level you want to achieve.

Microsoft Office Courses With Activia

Office 2007 courses

Introduction: We offer two one-day courses. The first day covers Windows Vista, Word and Outlook 2007, and the second covers Excel and PowerPoint 2007. These courses can be run together as a two-day course, or customised for a bespoke one-day session.
New Features: Although we deliver one-day New Features courses on Excel, Word, PowerPoint and Access 2007, for those who want a quick overview, our one-day Office 2007 New Features course covers the main changes in Excel, Word and PowerPoint 2007.

Office 2010 courses

Introduction: We offer two one-day courses. The first covers Windows 7, Word and Outlook 2010, and the second covers Excel and PowerPoint 2010. These courses can be run together as a two-day course, or customised to create a bespoke one-day course. New Features: Our one-day Office 2010 New Features course covers the main changes in Outlook, Word, PowerPoint and Excel 2010.

Our Approach

We are great believers in interactivity and promote the importance of it in every course we teach.  When you book with us you’ll be able to choose from one of our nationwide venues – or elect to have the training delivered at your place of work.

The History Of Microsoft Office

Microsoft Office was initially released back in 1990, and the first version contained just three programmes: Word, Excel and PowerPoint.  In the years since, it has grown to incorporate a wider range of applications, including Outlook, Access, Visio and Publisher.
During its lifespan it has also grown to incorporate new features, such as spell checking, Visual Basic Application scripting and OLE data integration. The latest update was released in 2013.

Office 2007

With the release of Office 2007 Microsoft made a globally sweeping change by replacing the familiar – and extremely popular – toolbar that had once been part of Office’s intrinsic chemistry with something called the ribbon. This separated functions in to individual groups, which depended on the use value they performed. The thinking behind this was that it would make it easier for users to locate the information they needed quickly.

Not all the changes made were on the same scale, although many of them were useful. The Live Preview function was just one such example, allowing a user to check formatting changes were suitable before applying them. Office 2007 also worked with XML files. This allowed people to import information from previously unsuitable programs.

Office 2010

Not every release of Office contains a ground breaking new feature.  But thankfully the 2010 version contained an extremely useful addition to its array of options: BackStage.  The purpose of it was to help users manage their documents more effectively, doing this not by adding new functions, but by putting them all in one place. How BackStage worked in Office 2010 depended on the program that was open – hence different features were available depending on whether you used Outlook, Word or Excel.

Office 2013

Technology has changed since the last version of Office was released.  This update caters tfor the tablet and SmartPhone market by building in functions suitable for fingers and thumbs.  This makes it an ideal choice for business or domestic users who access their apps through a tablet or smartphone. As expected, Office 2013 is fully compatible with SkyDrive and its interface is cleaner and crisper too.

Related Courses

You will find related training courses in our Microsoft Software section.

Feedback from delegates on our Microsoft Office courses

Average Review 4.7/5 based on 7 reviews.

"The tutor Jibunnessa was excellent in teaching the course and communicated the topics well."     Jonathan Miller     Nov 25 2014    

"The training provided by Activia has always been extremely well received. Your bespoke and flexible approach to providing training to best suit the needs of the customer is greatly appreciated."     Joanne Coulson     Sep 29 2014    

"The training provided by Activia has always been extremely well received. Your bespoke and flexible approach to providing training to best suit the needs of the customer is greatly appreciated. The feedback received on Jibunessa was very positive. "She was very proactive, 'clued up', helped no end and ensured we all made good use of her skills""     Joanne Coulson     Sep 16 2014    

"Caroline is a very lovely lady. She helped to make excel more understanding and easy for me to use."     Catherine MacQuarrie     Jun 3 2014    

"Trainer did a great job, i also enjoyed that is was one on one training. I felt i had lots of support and it made learning alot easier. "     Emma Woolford     Nov 14 2013    

"Training was an excellent."     Mark Hamilton     Jan 8 2013    

"Thank you - great course."     Darren Middleton     Jan 8 2013    

Office 2010 Introduction: Windows 7, Word & Outlook

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Content covered

Windows 7: Getting Started
• The Basics of Windows 7  • Basic Windows 7 Tasks  • Exiting Windows 7  • Working with Files and Folders  • The Basics of Help 
Windows 7 Accessories
• WordPad Basics  • The Windows Calculator  • Paint 
Outlook 2010: Starting Out
• Getting Started  • Interacting with Outlook  • Working with The Outlook Interface 
Outlook 2010: Sending & Receiving E-Mail
• Receiving E-Mail  • Working with E-Mail Messages  • Answering Mail  • Composing E-Mail 
Word 2010: Starting Out
• Meeting Microsoft Office Word 2010  • Creating a Document  • Navigating in Your Document 
Word 2010: Working With Documents
• Creating a New Document  • Selecting Text  • Moving Text  • Applying Advanced Text Effects 
Word 2010: Doing More with Your Document
• Working with Your Document  • Getting Help in Word 
Word 2010: Doing More with Text
• Fonts on the Home Tab  • The Font Dialog  • Using Tabs  • Paragraph Options 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Office 2010 Introduction: Windows 7, Word & Outlook

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course is designed to teach delegates the fundamentals of using Microsoft Windows, Word and Outlook to gain basic familiarity with essential skills within Microsoft Office 2010. The course has been designed to go hand in hand with our Office 2010 Introduction: Excel and PowerPoint course.

Who Should Attend

Anyone who needs instruction in the basics of using Microsoft Windows 7 and Office 2010, either as a starting point or as a refresher course.

Office 2010 Introduction: Excel & PowerPoint

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Content covered

Excel 2010: Starting Out
• Starting Out  • About Workbooks  • Exploring your Workbook  • Getting Help with Excel 
Excel 2010: Basics & Formatting
• Working with Excel  • Basic Excel Features  • Moving your Data  • Modifying Cells and Data  • Cell Formatting  • Enhancing a Worksheet’s Appearance 
Excel 2010: Printing and Viewing your Workbook
• Using the View Tab  • Managing Multiple Windows  • Printing your Workbook 
Powerpoint 2010: Starting Out
• About Microsoft Office Powerpoint 2010  • Creating a Presentation  • Working with Your Presentation  • Arranging Slides 
Powerpoint 2010: Creating Presentations
• Working with Text Boxes  • Basic Editing Tools  • Formatting Text  • Advanced Text Tools  • The Design Tab  • The Transitions Tab 
Powerpoint 2010: Printing and Viewing Your Presentation
• Using Layouts and Views  • Viewing a Slide Show  • Preparing Your Presentation  • Printing Your Presentation 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Office 2010 Introduction: Excel & PowerPoint

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course is designed to teach delegates the fundamentals of using Microsoft Excel and PowerPoint 2010 to gain basic familiarity with essential skills within Microsoft Office 2010. The course has been designed to go hand in hand with our Office 2010 Introduction: Windows, Word and Outlook course.

Who Should Attend

Anyone who needs instruction in the basics of using Microsoft Excel and PowerPoint 2010, either as a starting point or as a refresher course.

Microsoft Office 2010 New Features

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Content covered

Understanding and Customizing the Interface
• Getting Acquainted  • The Quick Access Toolbar  • Tabs and Groups  • Contextual Tabs  • Customizing the Ribbon 
Outlook 2010: Working with the Outlook Interface
• Working with the Outlook Ribbon  • Using the Outlook Panes  • Managing E-Mail Messages 
Word 2010: Creating Documents
• The Home Tab  • The Insert Tab  • Creating Basic Headers and Footers  • Making Your Document Consistent  • Using the Navigation Pane 
Word 2010: Managing Your Documents
• Saving Your Files  • Making Word Work Backwards 
PowerPoint 2010: Managing PowerPoint Files
• File Management Tools  • Using Presentation Tools, Part One  • Using Presentation Tools, Part Two 
PowerPoint 2010: Adding the Finishing Touches
• Using Themes and Backgrounds  • Creating Slide Transitions  • Creating Basic Animations 
Excel 2010: Working with Excel
• Working with Tables  • Conditional Formatting  • Working with Charts; Part 1  • Working with Charts; Part 2 
Excel 2010: Showing Data as a Graphic
• Inserting SmartArt  • Sparklines  • Editing Sparklines 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Office 2010 New Features

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course is designed to teach delegates the main changes introduced with Microsoft Office 2010, with comprehensive coverage of the new Ribbon interface that was introduced with Office 2007.

Who Should Attend

Anyone who wishes to gain a working knowledge of how to use Office 2010 in the shortest possible time. NOTE: delegates must be existing users of Office 2000, XP, 2003 or 2007 and be proficient at least to Intermediate level.

Microsoft Excel Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Office" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Getting Started with Microsoft Excel
• Starting Out  • About Workbooks  • Exploring your Workbook  • Getting Help with Excel 
The Excel Interface
• The Quick Access Toolbar and File Menu  • The Home Tab  • The Insert Tab  • The Page Layout Tab  • The Formulas Tab  • The Data Tab  • The Review Tab 
Microsoft Excel Basics
• Working with Excel  • Basic Excel Features  • Moving your Data  • Smart Tags and Options Buttons  • Editing Tools 
Editing your Workbook
• Modifying Cells and Data  • Cell Formatting  • Enhancing a Worksheet’s Appearance 
Printing and Viewing your Workbook
• Using the View Tab  • Managing a Single Window  • Managing Multiple Windows  • Printing your Workbook 
Working with Charts in Excel
• Creating Charts  • Selecting Chart Data  • Working with Chart Options 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Introduction (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive one-day training course is designed to let users get to grips with the main features of Microsoft Office Excel 2007, 2010 and 2013, including a thorough treatment of the new 'Ribbon' interface, introduced with Excel 2007. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Who Should Attend

The course is intended for new users of Microsoft Excel 2007, 2010 or 2013 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Excel is required.

Microsoft Excel Intermediate (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Office" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced File Tasks
• Saving and File Management  • Converting and Encrypting Files  • File Properties and Digital Signatures  • File Accessibility and Compatibility 
Working with Functions and Formulas
• Autosum Functions (SUM & AVERAGE)  • IF and Nested Functions  • Working with Named Ranges  • Array Functions (SUMIF & AVERAGEIF)  • Formula Auditing 
Managing Tables in Microsoft Excel
• Creating Excel Tables  • Working with Records and Filters  • Advanced Filters 
Data Tools in Excel
• Text to Columns  • Flash Fill  • Remove Duplicates  • Data Validation  • Consolidate 
Doing More with Charts in Excel
• Trendlines  • Error Bars  • Working with Axis Options  • Advanced Chart Formatting 
Sparklines
• Creating Sparklines  • Editing Sparklines 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Intermediate (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Excel 2007, 2010 and 2013, in order to increase their knowledge and productivity.

Who Should Attend

Users with a basic understanding of Microsoft Excel 2007, 2010 or 2013 who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Microsoft Excel Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Office" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Grouping & Outlining and Subtotals
• Outlining and Grouping Data  • Using the Subtotals Tool 
What-If Analysis
• Exploring Scenarios  • Goal Seek and Data Tables  • Using Solver 
PivotTables
• Getting Started with PivotTables  • Displaying Data in a PivotTable  • Formatting a PivotTable  • Using the Classic PivotTable Layout  • Slicers 
Charting Pivoted Data
• Getting Started with PivotCharts  • Using the PivotChart Tools Tabs  • Formatting a PivotChart 
Advanced Excel Tasks
• Excel and Hyperlinks  • Using Custom AutoFill Lists  • Sharing Workbooks 
Creating HLOOKUP and VLOOKUP Functions
• Using the VLOOKUP Function  • Using the LOOKUP Function 
Introduction to Macros in Excel
• Recording and Playing Macros  • Copying and Deleting Macros  • Visual Basic and Macros 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Advanced (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010 or 2013 tools and concepts in order to increase their knowledge and productivity.

Who Should Attend

Users with a good understanding of Microsoft Excel 2007, 2010 or 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Microsoft Excel Professional (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

FREE eLearning revision

Note: FREE eLearning revision is available with this course.   Click the "About Microsoft Office" button at the top of the right hand menu for more details.

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced Conditional Formatting
• Editing Standard Formatting Rules  • Using Formulas in Conditional Formatting 
Using Form Controls and Templates
• Using Form Controls  • Creating Templates 
Advanced Lookup Functions
• Using the Index Function  • Using the Match Function  • Using Index and Match Together  • Using Index and Match with Array Formula  • Using the Indirect Function 
Advanced Functions in Excel
• Using Error Functions  • Using Logical Functions  • Using Array Formulas  • Using Rounding Functions 
Advanced Pivot Table Tools
• Importing Pivot Table Data  • Calculated Fields in Pivot Tables  • Showing Pivot Data as a Percentage  • Creating Custom Pivot Tables Styles 
Introduction to User Defined Functions Using VBA
• Creating a User Defined Function  • Creating an Interactive Procedure  • Create and Share a Function Add-in 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Professional (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a very advanced set of tools and concepts for Excel 2007, 2010 and 2013 in order to further increase their knowledge and productivity.

Who Should Attend

Users with a solid understanding of, and experience with, Microsoft Excel 2007, 2010 or 2013 who want to increase their ability in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction, Intermediate and Advance courses.

Microsoft Excel VBA Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Recording and Running Macros in Excel
• Setting Excel Macro Options  • Record and Run Simple Macros  • Assign Macros to the Quick Access Toolbar 
Introduction to the Excel VBA Editor
• Starting the Visual Basic Editor  • Using the Project Explorer  • Using the Properties Window  • Creating, Importing and Exporting Modules  • Explore Recorded Macros 
Creating Procedures and Functions
• Creating Sub and Function Procedures  • Declare and Use Variables  • Displaying Message to the User  • Getting Input from the User 
Working with the Excel Object Model
• Understanding Objects, Properties and Methods  • Referencing Cells and Ranges  • Gathering Cell and Range Information  • Using the Offset Method  • Using the Resize Method  • Using With Blocks  • Referencing Workbooks and Worksheets 
Controlling Program Flow
• Using the IF Statement  • Using the Select Case Statement  • Using For Next Loops  • Using Do Loops  • Using For Next Loops 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel VBA Introduction (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

About Microsoft VBA

VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language.

Course Aims

This intensive, hands-on one-day course has been designed for people who wish to learn the basics of the Excel VBA programming language, get used to the concepts and methods of VBA programming, and understand (and use) the relevant techniques.

Who Should Attend

The course is designed for existing, experienced users of Excel 2007, 2010 or 2013 who need to use VBA to automate their spreadsheets.
Delegates should therefore have a solid grounding in, and understanding of, Microsoft Excel to a high level.   Familiarity with the content of the Advanced course would be a minimum requirement although the Professional level is ideal.

Microsoft Excel VBA Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced Procedures
• Calling Procedures  • Passing Values to Procedures 
Advanced Variables
• Understanding Variable Scope  • Understanding Object Variables  • Creating Array Variables  • Creating Dynamic Array Variables 
Interacting with Office Applications
• Setting References to other Applications  • Setting References using Late Binding  • Create a PowerPoint Presentation  • Create a Letter in Word 
Debugging and Error Traps
• Review of Error Types  • Debugging tools  • Setting Error Traps 
Creating Custom User Forms
• Creating a Custom Form  • Adding Form Controls  • Creating Event Procedures 
Workbook and Worksheet Events
• Create Workbook Events  • Create WorkSheet Events 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel VBA Advanced (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

About Microsoft VBA

VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language.

Course Aims

This intensive, hands-on one-day course has been designed to build on the foundation created in the VBA Introduction course, to increase their capability to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts.

Who Should Attend

This is a course which naturally follows on from the Introduction course. Delegates must either have attended the Introduction course or be fully conversant with all its subject matter.

Microsoft Excel Introduction (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Getting Started with Excel 2003
Introduction: • Opening Excel  • Exiting Excel 
Help with Excel: • Finding Help  • The Office Assistant  • The Help Task Pane 
Beginning Excel: • The Standard Toolbar  • The Formatting Toolbar  • Working with Excel Menus  • Exploring Task Panes  • Excel Short-cut Keys 
Basic Workbook Tasks
The Basics of File Management: • New Workbooks  • How to Open Existing Workbooks  • How to Save Workbooks  • How to Close Workbooks  • Excel File Types 
Explore your Workbook: • Switching Worksheets  • The Active Cell  • Selecting Cells  • Exploring a Worksheet  • The Zoom Feature 
Working with Excel: • Columns, Rows, Cells, and Ranges  • Creating Worksheet Labels  • Entering and Deleting Data  • Printing your Worksheet 
Modifying Excel Toolbars: • Hiding Toolbars  • Showing Toolbars  • Moving Toolbars  • Customizing Toolbars 
Entering and Editing Data
Basic Excel Features: • What is AutoFill?  • What is AutoSum?  • What is AutoComplete?  • Working with Basic Formulas 
Editing Tools: • AutoCorrect  • Spell Check  • Find and Replace  • Documenting a Worksheet with Comments 
Manipulating Data
Moving your Data: • Dragging and Dropping Cells  • How to Cut, Copy, and Paste Cells  • How to Cut, Copy, and Paste Multiple Cells and Items  • How to Use Paste Special  • How to Insert and Delete Cells, Rows, and Columns  • Undo, Redo, and Repeat 
Smart Tags and Option Buttons: • What are Smart Tags?  • The Error Option Button  • The AutoFill Option Button  • The Paste Option Button 
Formatting Worksheets
Modifying Cells and Data: • Changing the Size of Rows or Columns  • Working with the Formatting Toolbar  • Adjusting Cell Alignment  • Rotating Text  • Creating Custom Number and Date Formats 
Cell Formatting: • Conditional Formatting  • What is the Format Painter?  • What is AutoFormat?  • Cell Merging and AutoFit  • Find and Replace Formatting 
Enhancing a Worksheet’s Appearance: • Adding Patterns and Colours  • Adding Borders  • Adding Fill Effects  • Working with Styles 
Introduction to Charts
Working with Charts: • Creating a Chart  • Formatting a Chart  • Manipulating a Chart  • Enhancing a Chart with Drawing Tools  • Enhancing your Chart with Titles and Tables 
Working with Charts and Data: • Changing the Type of Chart  • Changing the Source Data  • Creating 3-D Charts  • Working with the Chart Axes and Data Series  • Making Custom Charts 
Organising and Formatting Workbooks
Organizing your Workbook: • Inserting and Removing Worksheets  • Renaming, Moving, and Colour-Coding Worksheets  • How to Split and Freeze a Window  • Using Multiple Workbooks and Windows  • Using a Watch Window  • Creating a Custom View 
Formatting your Workbook: • Headers and Footers  • Inserting Page Numbers  • Changing Margins and Orientation  • Hiding Rows, Columns and Worksheets 
Printing and Managing Workbooks
Printing a Workbook: • Choosing a Print Area  • Setting up Page Breaks  • Choosing Paper Size and Changing Print Scale  • Adding Print Titles and Gridlines 
More Workbook Features: • Linking Workbooks  • Consolidating Workbooks  • Combining Worksheets  • Protecting Worksheets  • Templates 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Introduction (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

Microsoft Excel 2003 is the popular spreadsheet from Microsoft and part of the Microsoft Office XP suite. This training course is designed to let users get to grips with the main features of Microsoft Excel. It is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Who Should Attend

New or intending users of Microsoft 2003 or XP who wish to gain a good understanding of the software. Note : A working knowledge of using PCs in the Microsoft Windows environment is required.

Microsoft Excel Intermediate (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Working with Formulas
Creating Simple Formulas: • Basic Mathematical Operators 
Absolute and Relative Formulas: • Relative Cell References  • Absolute Cell References 
Using Formulas across Worksheets: • Using Formulas across Worksheets 
Formula Auditing: • Fixing Formula Errors  • Displaying And Printing Formulas 
Working with Functions
Sum and Average Functions: • Using the Insert Function Window  • Function Syntax 
Using IF and Nested Functions: • Using the IF Function  • Working with Nested Functions 
Naming Cell Ranges: • What Are Range Names?  • Defining And Using Range Names  • Selecting Nonadjacent Ranges  • Auto Calculate 
Functions and Array Formulas: • What Are Array Formulas  • Using Basic Array Formulas  • Using Functions with Array Formulas  • Using the IF Function in Array Formulas 
Text Functions: • CONCATENATE  • LEFT and RIGHT Functions  • UPPER, LOWER and PROPER Functions 
Managing Lists
Working with Lists: • What Is A List?  • Creating Lists  • Modifying Lists  • What Is The Total Row? 
Working with Records and Fields: • What Are Records And Fields?  • Adding Fields By Inserting Columns  • Adding Records By Inserting Rows  • Adding Records With A Data Form  • Finding And Deleting Records 
Working with Lists and Filters: • Sorting A List  • What Is An Autofilter  • Custom Autofilters  • Using An Advanced Filter  • Filtering With Wild Card Characters  • Copying Filtered Records 
Using Excel as a Database
Using Database Functions: • Using Database Functions 
Data Validation: • Data Validation 
The VLOOKUP and HLOOKUP Functions: • VLOOKUP  • HLOOKUP 
Using Excel with Other Programmes
Using Excel in Word: • Inserting Excel Data In Word  • Modifying Excel Data After Insertion  • Linking Excel Data In Word  • Linking An Excel Chart In Word 
Using Excel with Other Programs and Files: • Using Outlook To Send Excel Data  • Opening An Excel File In A Different Format  • Importing Data From A Text File  • Importing Data From A Database 
Working with Charts
Using the Chart Wizard: • Using the Chart Wizard 
Modifying a Chart’s Appearance: • Modifying a Chart’s Appearance 
Other Chart Types: • Other Chart Types 
Reusing a Custom Chart: • Reusing a Custom Chart 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Intermediate (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This hands-on one-day training course has been designed to delegates a solid understanding of more advanced Excel tools and concepts in order to increase their knowledge and productivity.

Who Should Attend

Users with a basic understanding of Microsoft Excel 2003 or XP who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Microsoft Excel Advanced (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Outlining and Grouping your Data
Outlining and Grouping your Data: • Using Automatic Outlining  • Displaying And Collapsing Levels  • Grouping Data Manually  • Creating Subtotals 
Using Pivot Tables
Creating PivotTables: • What Is A PivotTable?  • Creating A PivotTable Frame  • Specifying Data in a PivotTable  • Rearranging PivotTable Data 
Pivot Tables and Charts: • Modifying PivotTable Calculations  • Formatting A PivotTable  • Refreshing A PivotTable  • Charting A PivotTable  • Creating A PivotTable Based On Data From An External Database 
What If Analysis
Exploring Scenarios: • What Is A Scenario?  • Creating A Scenario  • Creating A Scenario Summary Report  • Saving Multiple Scenarios 
Goal Seek, Data Tables and Solver: • Using A One And Two Input Data Table  • Using Goal Seek  • Using Solver 
Excel and the Internet
Excel and Hyperlinks: • Hyperlinks and the Internet  • Inserting Hyperlinks  • Modifying Hyperlinks  • The Web Toolbar  • Browsing Hyperlinks In Excel 
Excel Workbooks as Web Pages: • Interactive and Non-Interactive Web Pages  • Saving A Workbook As A Web Page  • Saving A Worksheet As A Web Page  • Saving A Chart As A Web Page  • Saving A Range As A Web Page 
Creating and Using Shared Workbooks
Creating and Using Shared Workbooks: • Sharing A Workbook  • Requesting Reviews  • Reviewing A Workbook  • Tracking Changes  • Merging And Revising A Shared Workbook 
Advanced Excel Tasks
Advanced File Management: • Identifying File Properties  • Searching For Files  • Protecting Personal Information  • Creating Back Up Files  • Changing Auto-Recovery Settings 
Custom and Advanced Features in Excel: • Customizing Excel By Changing Options  • Using Custom AutoFill Lists  • Text To Speech  • Using Detect And Repair 
Macros and Form Controls
Creating Macros in Excel: • What Is A Macro?  • Creating A Macro  • Playing A Macro  • Assigning A Shortcut Key To Macro  • Macros, Buttons, And Toolbars 
Excel Form Controls: • What Is A Form Control?  • The Form Toolbar  • Adding A Control To A Worksheet  • Assigning A Macro To A Control  • Form Controls 
Visual Basic (VBA) and Macros
Visual Basic (VBA) and Macros: • Adding Code To Your Macro  • Adding Comments To VBA Code  • Declaring Variables  • Prompting For User Input  • Iteration Over A Range  • If Then Else Statements 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Excel Advanced (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This course will give students the ability to create advanced spreadsheets using the full range of Microsoft Excel 2003's tools and features.

Who Should Attend

The course is intended for existing users of Microsoft Excel 2003 or XP who want to use the more advanced features of the software in order to increase their productivity and effectiveness. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Microsoft Access Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Getting Started with Access 2010
• Starting Out  • Interface Basics  • Database Security  • Getting Help 
The New Ribbon Interface
• The Quick Access Toolbar  • Basics of Tabs  • The Home Tab  • The Create Tab  • The External Data Tab  • The Database Tools Tab 
Creating a Simple Database
• First Steps in Database Creation  • Database Records  • Creating a Table  • Formatting Text 
Forms; Queries; Reports and Filters
• Creating and Using Forms  • Creating and Using Queries  • Creating and Using Reports  • Sorting and Filtering Data  • Viewing Data  • Printing a Database Object 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Access Introduction (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive one-day training course is designed to enable users to get to grips with the main features of Microsoft Access 2007, 2010 and 2013, including a thorough treatment of the new 'Ribbon' interface. It is entirely 'hands on', so delegates will get practice in using the software in a realistic and practical way.

Who Should Attend

The course is intended for new users of Microsoft Office Access 2007, 2010 or 2013 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Access is required.

Microsoft Access Intermediate (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced File Tasks
• Using Windows Explorer within Access  • Database Management  • Saving Your Files  • Exporting Files  • Linking Files 
Working with Tables
• Customising Tables  • Table Properties: Formatting  • More Table Properties  • Data Validation and Lookup Wizard 
Working with Forms
• Basic Form Controls  • Advanced Form Controls  • Formatting Your Form  • Formatting Controls  • Using Themes 
Working with Reports
• Organizing Report Data  • Formatting Reports  • Common Report Tasks 
Working with Queries
• Basic Queries  • Doing More with Queries  • Creating Advanced Queries  • Creating Management (Action) Queries 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Access Intermediate (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts for Access 2007, 2010 and 2013 in order to increase their knowledge and productivity.

Who Should Attend

Users with a basic understanding of Microsoft Office Access 2007, 2010 or 2013 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Microsoft Access Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Advanced Data Management
• Referential Integrity  • Table Relationships  • An Introduction to SQL  • Modal Dialog Boxes 
Advanced Form Tasks
• Using Subforms  • Creating a Navigation Form  • Advanced Form Controls  • Exporting a Form  • Other Form Tasks 
Creating Web Apps
• Creating a Ready to go Web App  • Creating a Custom Web App  • Modifying Web Apps 
SQL and Microsoft Access
• Understanding SQL  • Using the SELECT Statement  • Using Subqueries  • Using SQL Joins 
Macros and Visual Basic for Applications (VBA)
• Macro Basics  • More about Macros  • Access and VBA  • Building Advanced Procedures  • Using VBA in a Database 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Access Advanced (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced tools and concepts in Access 2007, 2010 and 2013 in order to increase their knowledge and productivity.

Who Should Attend

Users with a solid understanding of Microsoft Office Access 2007, 2010 or 2013 who want to expand on their capabilities in a short space of time. Tsome of the lessons are quite technical and delegates must have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Microsoft Access Introduction (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Getting Started
Starting Out: • Basic Terminology  • Opening Microsoft Access  • Interface Overview  • Closing Microsoft Access 
Using the Access Interface: • UsingThe Access Menus  • Access Task Panes  • Using Toolbars  • Adding, Removing, and Moving Toolbars  • The Switchboard  • Using the Database Window 
Getting Help: • The Help Menu  • The Help Task Pane  • The Office Assistant  • Using the Type a Question Box  • Getting Help in a Dialog Box  • Using the Sample Databases 
Creating a Database
First Steps: • Planning a Database  • Creating a Blank Database  • Database Objects 
Records: • What is a Record?  • Adding Records  • Editing Records  • Deleting Records  • Printing Records 
Creating a Table: • About Tables  • Creating a Table in Design View  • Creating a Table using the Wizard  • Entering Data into a Table  • Formatting a Table 
Formatting Text: • The Zoom Toolbar  • Selecting Data  • Cutting, Copying, and Pasting  • The Format Painter  • Undo and Redo  • Checking your Spelling 
Formatting Controls: • Changing the Colour of a Control  • Control Properties  • Aligning Controls  • Applying Special Effects 
Doing More with Your Database
Creating Forms: • What is a Form?  • Bound vs. Unbound Controls  • Creating a Form with the Wizard  • Creating a Form in Design View  • Using Forms 
Creating Queries: • What is a Query?  • Creating a Query with the Wizard  • Using Design View to Modify a Query  • Using Queries 
Reports: • What is a Report?  • Creating a Report with the Wizard  • Creating a Report in Design View  • Using Reports 
Sorting and Filtering Data: • Using Find and Replace  • Sort Ascending or Descending  • Using Filter by Form  • Using Filter by Selection  • Creating a Filter 
Viewing and Printing Your Data
Formatting a Datasheet: • Adjusting Row Height and Column Width  • Rearranging Columns  • Freezing a Row or Column  • Hiding a Column  • Changing the Datasheet Font 
Viewing Data: • The View Menu  • The Window Menu  • Hiding and Unhiding Windows  • Arranging Windows  • Closing Individual Windows 
Printing a Database Object: • The Print Icon  • Print Preview  • Page Setup 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Access Introduction (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on training course is designed to give delegates an understanding of some of the major features and functions within Microsoft Access. An introduction to database theory and practice, plus hints and tips on good database design techniques are also given.

Who Should Attend

New, recent or intending users of Access 2003 or XP who have little or no existing database knowledge. Note : A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required.

Microsoft Access Intermediate (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Database Design Basics
Database Normalisation: • The Rules of Normalization 
Relating Tables: • One-to-One Relationships  • One-to-Many Relationships  • Many-to-Many Relationships 
Referential Integrity: • Planning Relationships Between Tables  • Orphan Records  • Cascading Deletes  • Cascading Updates 
Advanced File Tasks
Using My Computer within Access: • Navigating with My Computer  • Performing Basic Tasks with My Computer  • Changing Views with My Computer  • The My Places Toolbar 
Database Management: • Repairing a Database  • Compacting a Database  • Backing up Your Database  • Editing Database Properties 
Saving Your Files: • Save As Dialogue  • Object Properties  • AutoRecover 
Exporting Files: • Exporting to Word  • Exporting to Excel  • Exporting to Older Versions of Access  • Exporting vs. Save As 
Linking Files: • Linking to an Excel Spreadsheet  • Linking to Another Database  • Creating a Hyperlink  • Inserting an OLE Object 
Working with Tables
Customizing Tables: • Understanding Field Properties  • Adding a Primary Key to a Table  • Indexing a Field  • Inserting, Deleting, and Moving Fields  • Importing a Table from Another Source 
Formatting Tables: • Formatting Number Fields  • Formatting Text Fields  • Adding Field Descriptions  • Changing Field Data Types  • Adding Captions 
Controlling Table Data Entry: • Setting a Default Value  • Setting a Required Value  • Creating and Using Input Masks  • Creating and Removing Table Relationships 
Managing Table Data Entry: • How to Validate Data  • Creating a Lookup Field  • Modifying a Lookup Field  • Creating a Value List  • Modifying a Value List 
Working with Forms
Basic Form Controls: • Adding a Control  • The Control Wizard  • Cutting, Copying, Pasting, and Moving a Control  • Formatting a Control 
Advanced Form Controls: • Modifying a Control’s Properties  • Changing a Control’s Data Source  • Changing a Control’s Default Value  • Creating a Calculated Control  • Using Form Properties 
Formatting a Form: • Formatting Gridlines  • Modifying the Font  • Adding Images  • Using AutoFormat 
Reports
Organizing Report Data: • Adding and Removing Fields  • Using Report Sections  • Changing Section Properties  • Grouping and Sorting in a Report  • Changing Group Properties  • Using Calculated Controls in a Report 
Formatting Reports: • Formatting Gridlines  • Modifying the Font  • Adjusting the Layout of your Report  • Using AutoFormat 
Common Report Tasks: • Adding a Photo  • Adjusting Page Properties  • Adding Headers and Footers  • Adding Page Numbers  • The Label Wizard 
Working with Queries
Basic Queries: • Review of Queries  • Creating a Query  • Sorting a Query  • Filtering a Query  • Hiding Fields  • AND/OR Operators  • IIF Functions 
Multiple Table Queries: • Creating a Multiple Table Query  • Creating a Calculated Field  • The Expression Builder  • Using Queries to Summarize  • Make-Table Queries 
Management (Action) Queries: • Append Queries  • Delete Queries  • Update Queries  • Exporting Queries 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Access Intermediate (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive training course will help delegates to build on their basic understanding of Access 2003, in order to produce more comprehensive and robust database applications. Students will get experience in the theory and application of creating a database; creating more complex queries; and enhancing data entry and reporting with forms and reports.

Who Should Attend

Existing users of Microsoft Access 2003 or XP who want to get grips with some of the more advanced features of this package as quickly as possible. Note : delegates should have some experience with creating a basic database in Access (including table design and specifying field data types and properties) and be proficient in all topics covered in the Introduction course.

Microsoft Access Advanced (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Customizing Access
Customizing Menus and Toolbars: • Customizing Menus  • Creating Menus  • Showing and Hiding Toolbars  • Customizing Toolbars  • Creating Toolbars 
Setting Access Options, Part 1: • Setting General and View Options  • Setting Editing and Keyboard Options  • Setting Datasheet, Form, and Report Options  • Setting Page and Tables/Queries Options  • Setting Error Checking Options  • Setting Advanced Options 
Setting Access Options, Part 2: • Setting International Options  • Setting Spelling Options  • Setting AutoCorrect Options  • Setting Start-Up Options  • Setting Macro Security Options 
Creating Macros: • The Macro Design Toolbar  • Creating a Macro  • Running a Macro  • About Macro Groups 
Advanced Macro Uses: • Editing a Macro With the Visual Basic Editor  • Assigning a Macro to a Keystroke  • Assigning a Macro to a Toolbar  • Viewing and Printing Macro Definitions 
Advanced Data Tools
Switchboards: • Using a Switchboard  • The Switchboard Manager  • Creating a Switchboard  • Editing a Switchboard  • Deleting a Switchboard 
Creating Data Access Pages: • The Data Access Page Wizard  • Using Design View to Create a Data Access Page  • Using an Existing HTML Page 
Modifying Data Access Pages: • Adding a Theme  • Adding Text and Controls  • Formatting Text and Controls  • Aligning and Sizing Content  • Adding Images 
Data Access Pages: • Basics of Using Data Access Pages  • Viewing Data Entered Via a Data Access Page  • Protecting Data 
Advanced Queries
Table Relationships: • Normalizing Your Data  • Establishing Referential Integrity  • Using Cascade Update and Cascade Delete  • Setting Fields for Indexing  • Using Indexing 
CrossTab Queries: • Understanding CrossTab Queries  • Creating a CrossTab Query Using the Wizard  • Creating a CrossTab Query Manually 
Using Parameter Queries: • Setting Up Parameter Queries  • Using a Parameter Query 
Advanced Reporting Features: • Using AutoFormat  • Aligning and Formatting Controls  • Adding Pictures and Lines 
Pivot Tables and Pivot Charts
Creating a PivotTable: • Creating a PivotTable Using the Wizard  • Continuing Where the Wizard Left Off  • More About Fields  • Completing Your PivotTable 
Using AutoForm and Creating PivotCharts: • Creating a PivotTable Using AutoForm  • Creating a PivotChart Using AutoForm  • About PivotChart Fields  • Completing A PivotChart 
PivotTables and PivotCharts: • Using a PivotTable  • Using a PivotChart  • Editing a PivotTable or PivotChart  • Common PivotChart Editing Features  • Turning a PivotTable Into a PivotChart and Vice-Versa 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Access Advanced (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course has been designed to delegates a solid understanding of advanced Access tools and concepts in order to increase their knowledge and productivity in the shortest possible time.

Who Should Attend

Proficient users of Microsoft Access 2003 or XP who want to consolidate and expand on their knowledge in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Microsoft PowerPoint Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Getting Started with Powerpoint 2010
• Meeting Microsoft Office PowerPoint 2010  • Creating a Presentation  • Working with Your Presentation  • Editing Your Presentation  • Arranging Slides  • Getting Help in PowerPoint 
Understanding & Customising the PowerPoint Interface
• Getting Acquainted  • The Quick Access Toolbar  • Tabs and Groups  • Customising the Ribbon 
Creating and Formatting Presentations
• Using Templates  • Working with Text Boxes  • Basic Editing Tools  • Formatting Text: Effects; Fonts and Spacing  • Formatting Text: Alignment; Indenting and Lists  • Advanced Text Tools 
Adding Shapes and Art to Your Presentation
• Drawing Shapes  • Working with Shapes  • Working with Text and Shapes  • Advanced Shape Tasks 
Viewing and Printing Your Presentation
• Using Layouts and Views  • Viewing a Slide Show  • Preparing Your Presentation  • Printing Your Presentation 
Adding the Finishing Touches
• Research Tools  • Using Themes and Backgrounds  • Creating Slide Transitions  • Creating Basic Animations  • Creating Advanced Animations 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft PowerPoint Introduction (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive one-day training course is designed to enable users to get to grips with the main features of Microsoft PowerPoint 2007, 2010 and 2013, including a thorough treatment of the 'Ribbon' interface, introduced with Powerpoint 2007. It is entirely 'hands on', so delegates will get practice in using the software in a real life and practical way.

Who Should Attend

The course is intended for new users of Microsoft PowerPoint 2007, 2010 or 2013 who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with PowerPoint is required.

Microsoft Powerpoint Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Managing PowerPoint Files
• Using Windows Explorer within PowerPoint  • File Management Tools  • Using Presentation Tools: Optimisation and Compression  • Using Presentation Tools: Inspection and Checking 
Working with Pictures
• Inserting Pictures  • Editing Pictures  • Manipulating Pictures  • Formatting Pictures  • Managing Pictures 
Adding Multimedia to a Presentation
• Inserting Video Files  • Editing Video Files  • Inserting Audio Files  • Editing Audio Files 
Adding Tables Charts and Diagrams
• Inserting Tables  • Editing Tables  • Formatting Tables  • Inserting Charts  • Inserting SmartArt  • Formatting SmartArt 
Setting up Slide Masters
• Creating a Slide Master  • Using Placeholders  • Using Slide Masters  • Using Hand-out Masters  • Using Notes Masters 
Reviewing Presentations
• Using Comments  • Reviewing a Presentation 
Creating Advanced Types of Shows
• Setting up Your Show  • Presenting Your Show  • Creating a Custom Show  • Advanced Presentation Techniques 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Powerpoint Advanced (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced PowerPoint tools and concepts in order to bring their ability to create powerful presentations to an expert level.

Who Should Attend

Users with a good understanding of Microsoft PowerPoint 2007, 2010 or 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Microsoft PowerPoint Introduction (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Getting Started
Starting Out: • Opening Microsoft PowerPoint  • Interacting with PowerPoint  • Closing Microsoft PowerPoint 
Slides: • What is a Slide?  • Adding a Slide  • Deleting a Slide  • Cutting, Copying and Pasting Slides  • Text AutoFit 
Creating a Slide: • Creating Text  • Deleting Text  • Selecting Text  • Cutting, Copying and Pasting Text  • The Format Painter  • Find and Replace 
Working with a Presentation: • Saving A Presentation for the Second Time  • Opening a Presentation  • Closing a Presentation  • Using the Save As Command 
Getting Help in PowerPoint: • The Help Menu  • The Help Task Pane  • The Office Assistant  • Configuring the Office Assistant  • Using the Type a Question Box  • Getting Help in a Dialog Box 
Editing Slides
Placeholders (Text Boxes): • Types of Placeholders (Text Boxes)  • Resizing Placeholders  • Moving a Placeholder  • Deleting Placeholders 
Formatting a Slide: • Add a Background Colour  • Add Gradient Fills  • Add Textures or Pictures 
Other Formatting Tools: • Inserting Headers and Footers  • Inserting Slide Numbers  • Inserting the Date and Time 
Managing Slides: • The View Toolbar  • Slide Sorter View  • The Slides Tab  • The Outline View 
Adding Effects
Formatting Text: • Adjusting Font Size  • Adjusting Font Type  • Adding Effects  • Changing Text’s Colour  • Changing Font’s Case 
Formatting Text from the Fonts Dialog Box: • The Fonts Dialog Box 
Creating a Bulleted or Numbered List: • Adding Bullets and Numbers  • Customizing Bullets and Numbers  • Removing Bullets and Numbers  • Discontinuing Bullets and Numbers 
Using Paragraph Alignment: • Left, Right, Or Centre Alignment  • Justification  • Changing Text Direction 
Printing and Viewing a Presentation
Proofing Tools: • Spell Check  • AutoCorrect  • Set Your Language 
Print Preview: • Opening Print Preview  • The Print Preview Toolbar  • The Print What Menu  • Setting Options  • Printing Your Presentation 
Organizing Your Data
Creating and Working with Tables: • Inserting and Drawing Tables  • Inserting and Deleting Columns and Rows  • Working with Cells 
Constructing Table Layout: • Changing Your Border  • Shading and Fills  • Adding and Formatting WordArt 
Working with Charts and Graphs: • Creating Charts and Graphs  • Adding Titles and Data  • Legends and Labels 
Creating Customized Charts: • Choosing and Designing your Chart Style  • Constructing 3-D Charts  • Editing Chart Axes  • Exhibiting Gridlines and Trendlines 
Working with Organization Charts: • Creating Organization Charts  • Choosing your Chart Style  • Inserting Chart Shapes  • Resizing Charts 
Customizing Your Diagrams: • Adding/Editing Shapes  • Altering Diagrams  • Changing Diagram Schemes  • Incorporating Text 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft PowerPoint Introduction (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

Microsoft PowerPoint 2003 is the popular business presentation graphics application and is part of the Microsoft Office 2003 suite. This one-day training course teaches new users to the software how to get the most out of PowerPoint's powerful features. Users will be able to customize and style presentations, create sophisticated on-screen shows and print their presentations. Specially prepared exercises provide hands-on experience of using PowerPoint, enabling users to work quickly and confidently.

Who Should Attend

New and recent users of Microsoft PowerPoint 2003 or XP who want to expand and consolidate their knowledge of the application. Note : A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required.

Microsoft PowerPoint Advanced (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Implementing Audio Visual Effects
Incorporating Movies and Animated GIF’s: • Insert from Clip Organizer or File  • Looping a Movie  • Rewinding Movies 
Inserting Sound Effects: • Insert from Clip Organizer or File  • Looping a Sound and Selecting Sound Options  • Recording a Sound  • Playing a CD  • Deleting a Sound 
Creating Voice Narrations: • How to Check Settings  • Link and Embed Voice Narrations  • Record and Delete Narrations 
Special Features and Custom Animation
Creating Photo Albums: • Create New Album  • Inserting Pictures and Images  • Text, Captions, and Picture Order  • Picture Layout, Frame Shape, and Design Templates  • Applying Color Effects 
Implementing Animation: • Entrance and Exit Effects  • Emphasis Effect  • Animation Schemes  • Add and Draw Motion Paths  • Speeds and Timing Options 
Executing Your Presentation
Reviewing a Presentation: • Sending a Presentation for Review  • Adding Comments and Making Changes  • Combining Reviewed Presentations 
Finishing Touches: • Applying Design Templates  • Slide Transition  • Creating Self Maintained Presentations 
Delivery Options: • Packaging a Presentation to a CD  • Opening Packaged Presentations  • Delivering a Presentation on a Computer 
Configuring and Customizing
Customizing Program Options: • The View Tab  • The General Tab  • The Edit Tab  • Print And Save Tab  • The Security Tab  • The Spelling And Style Tab 
Customizing Your Toolbar: • Designing A Custom Toolbar  • Customize Toolbar Options  • Adding And Removing Commands  • Resetting And Renaming A Toolbar  • Modifying Buttons  • Deleting Toolbars And Custom Menus 
Set Up PowerPoint to Automatically Correct Text: • Modifying And Customizing Autocorrect Options  • Modifying And Customizing Autoformat Options  • Smart Tags 
Using Reference Material: • Adding And Removing Resources  • Parental Control Option 
Creating Advanced Presentations: • Presenting And Linking Shows  • Edit, Copy And Delete Shows  • Setting Up The Custom Show 
Working With Slide Masters: • Creating a Slide Master  • Formatting a Slide Master  • Adjusting and Re-inserting Placeholders  • Inserting a Title Master  • Deleting Slide Masters  • Using Multiple Slide Masters  • Preserving Slide Masters  • Renaming Slide Masters  • Saving Slide Master Templates  • Omit Master Images 
Macros, Links, and Embedded Objects
Creating and Working with Macros: • Recording And Playing Macros  • Writing A Macro With The Visual Basic Editor  • Copying, Edit And Delete Macros  • Macro Security 
Using Links: • Linking Part Of A File  • Linking An Entire File  • Revising Links  • Open And Edit Source Files  • Changing The Location Of The File  • Deleting Or Cancelling Links 
Operating with Embedded Objects: • Create A New Embedded Object  • Embedding Part Of A File  • Embedding An Entire File  • Edit Embedded Objects 
Implementing Hyperlinks: • Inserting Hyperlinks  • Change and Remove Hyperlinks  • Creating Action Buttons 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft PowerPoint Advanced (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course will enable students to create better business presentations using the advanced features of PowerPoint 2003. Delegates will learn how to implement audio visual effects and custom animation, as well as configuring, customising and executing animations. There is also a short intoduction to Macros.

Who Should Attend

Existing users of Microsoft PowerPoint 2003 or XP who want to use the more advanced features of this software to create slides with greater impact. Note : A good basic working knowledge of PowerPoint is required. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Microsoft Word Introduction (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Getting Started with Microsoft Word
• Meeting Microsoft Office Word 2010  • Creating a Document  • Navigating in Your Document  • Doing More with Your Document  • Working with Your Document  • Getting Help in Word 2010 
The Ribbon Interface in Word
• Getting Acquainted  • The Quick Access Toolbar  • Tabs and Groups  • The Home Tab  • The Insert Tab  • The View Tab 
Advanced Tabs and Customisation
• The Page Layout Tab  • The References Tab  • The Mailings Tab  • The Review Tab  • Contextual Tabs  • Customising the Ribbon 
Creating Word Documents
• Creating a New Document  • Selecting Text  • Moving Text  • Applying Advanced Text Effects 
Doing More with Text
• Fonts on the Home Tab  • The Font Dialog  • Using Tabs  • Paragraph Options 
Viewing and Printing Your Document
• Using Layouts and Views  • Basic Viewing Tools  • Advanced View Tools  • Preparing Your Document  • Printing a Document 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Word Introduction (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive one-day training course is designed to enable users to get to grips with the basic features of Microsoft Word 2007, 2010 and 2013, including a thorough treatment of the new 'Ribbon' interface, introduced with Word 2007. It is entirely 'hands on', so delegates will get practice in using the software in a real life and practical way.

Who Should Attend

The course is intended for new users of Microsoft Word who want to become productive in the shortest possible time. Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Word is required.

Microsoft Word Intermediate (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Managing Your Documents
• Using Windows Explorer within Word  • Saving Your Files  • Finishing Your Files  • Making Word Work Backwards  • Viewing Your Files 
Using Formatting Tools in Word
• Working with Templates  • Using Bullets and Numbering  • Using the Paragraph Dialog  • Using Delineation Tools  • Working with Pages  • Adding Hyperlinks 
Creating Headers and Footers
• Creating Basic Headers and Footers  • Using the Header & Footer Tools – Design Tab  • Inserting Page Numbers  • Doing More with Headers and Footers 
Working with Pictures
• Inserting Pictures  • Editing Pictures  • Doing More with Pictures  • Formatting Pictures  • Managing Pictures 
Working with Shapes
• Drawing Shapes  • Working with Shapes  • Working with Text and Shapes  • Advanced Shape Tasks 
Performing a Mail Merge in Word
• Using the Mail Merge Wizard  • Performing a Manual Mail Merge  • Sending a Document Electronically 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Word Intermediate (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course has been designed to give delegates a solid understanding of more advanced tools and concepts used in Word 2007, 2010 and 2013, in order to increase their knowledge and productivity.

Who Should Attend

Users with a basic understanding of Microsoft Office Word 2007, 2010 or 2013 who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Microsoft Word Advanced (2007, 2010 & 2013)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2007, 2010 and 2013.
TIP: If your screen has the modern top ribbon interface, rather than the old drop-down menus that featured in earlier versions of the software, this is the course you need.

Content covered

Managing and Reviewing Documents
• Using Comments  • Tracking Changes  • Combining Multiple Versions of Documents  • Creating an Outline 
Working with Reference Tools
• Creating a Table of Contents  • Creating References within a Document  • Creating a Bibliography  • Creating Index and Reference Tables  • Creating References to Other Documents 
Using Time Saving Tools
• Using Language Tools  • Inserting Pre-Defined Text  • Using the Navigation Pane 
Working with Advanced Graphics and Objects
• Inserting Text Boxes  • Inserting WordArt  • Creating SmartArt  • Editing SmartArt  • Using Building Blocks and Quick Parts 
Creating Tables in Word
• Inserting Tables  • Editing Tables  • Formatting Tables  • Working with Table Data 
Creating Equations and Charts
• Working with Equations  • Creating Charts  • Formatting Charts  • Analysing Chart Data 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Word Advanced (2007, 2010 & 2013)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Word 2007, 2010 and 2013 tools and concepts in order to increase their knowledge and productivity.

Who Should Attend

Users with a good understanding of Microsoft Word 2007, 2010 and 2013 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.

Microsoft Word Introduction (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Getting Started
Opening Microsoft Word 2003: • Launching Word  • Interface Overview  • Interacting with Word  • Menu Overview 
Toolbars: • About the Standard Toolbar  • About the Formatting Toolbar  • Adding or Removing Toolbars  • Customizing Toolbars  • The Customize Command 
Creating and Selecting Text: • Creating a New Document  • Typing Text  • Using the Mouse to Select Text  • Using the Keyboard to Select Text  • Tips and Tricks 
Working With Your Document: • Saving Files  • Opening Files  • Switching Between Open Files  • Closing Documents  • Closing Word 
Getting Help in Word: • The Help Menu  • The Help Task Pane  • The Office Assistant  • Configuring the Office Assistant  • Using the Type a Question Box  • Getting Help in a Dialog Box 
Formatting and Editing Options
Working with Text: • Cutting, Copying, and Pasting Text  • Basic Formatting  • Finding Text  • Navigating Through a Document 
Moving Text: • Dragging and Dropping Text  • The Office Clipboard  • Deleting Text  • Undo and Redo (AKA Repeat) 
Fonts: • Setting a Font Type and Size  • Setting Font Styles and Colours  • Using Character Spacing  • Animating Fonts  • Setting Your Default Font 
Text Effects: • Basic Effects  • Setting Underline Styles and Colours  • Font Effects  • Drop Caps  • Changing Font Cases 
Changing Text’s Position: • Aligning Text  • Justifying Text  • Margins  • Using Tabs  • Setting Tabs  • Moving or Removing Tabs 
Formatting Tools
Paragraph Options: • Aligning a Paragraph  • Indenting a Paragraph  • Changing Paragraph Spacing  • Inserting Page Numbers 
Templates: • Opening a Template  • Downloading Templates  • Using Templates  • Creating Templates 
Language Tools: • Checking Your Spelling and Grammar  • The Spelling and Grammar Context Menu  • Setting Spelling and Grammar Options  • Using Word Count and Readability Statistics 
Using Graphics: • Searching for ClipArt  • Inserting ClipArt  • Formatting ClipArt  • Inserting a Picture  • Formatting Pictures 
Links in a Document: • Types of Links  • Inserting a Link  • Editing a Link  • Following a Link 
Viewing and Printing
Layouts and Views: • Normal View  • Web Layout  • Print Layout  • Reading Layout  • Outline View  • Full Screen View 
Viewing Tools: • Zoom  • Thumbnails  • The Document Browser  • The Document Map 
Print Preview: • Opening Print Preview  • Print Preview Options  • Print Preview versus Print Layout 
Printing a Document: • How to Print a Document  • Basic Print Options  • Advanced Print Options 
Using Page Setup: • Gutters and Margins  • Changing Paper Options  • Setting Layout Options  • Applying Page Borders  • Setting Default Page Setup Options 
Using Tables
Creating Tables: • Inserting a Table  • Drawing a Table  • Selecting Cells, Rows and Columns  • Inserting and Deleting Cells, Rows and Columns 
Editing Tables: • Merging and Splitting Cells, Columns, or Rows  • Resizing Cells, Columns, or Rows  • Selecting a Table  • Moving and Resizing a Table 
Applying Basic Formatting: • Aligning a Table  • Changing Table Spacing  • Changing Text Direction 
Applying Advanced Formatting: • AutoFit  • The Borders and Shading Dialog  • Using the Tables and Borders Toolbar to Modify Borders and Shading  • AutoFormat 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Word Introduction (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This one-day training course is designed to introduce users to Word 2003, the popular word processing application from Microsoft and part of the Office 2003 suite. This entirely 'hands on' course includes specially prepared exercises that give participants practical experience of using Word's tools.

Who Should Attend

New or intending users of Microsoft Word 2003 or XP who want to gain a good understanding of the software in a short space of time. Note : A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required.

Microsoft Word Intermediate (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Advanced Interface Options
Using My Computer within Word: • Navigating Using My Computer  • Performing Basic Tasks with My Computer  • Using Views in My Computer  • The My Places Toolbar 
Advanced Saving Options: • File Formats  • File Properties  • Setting File Passwords  • Auto Recovery 
Advanced Viewing Options: • Opening a Copy of Your Document  • Arranging Windows  • Comparing Documents Side-By-Side  • Splitting a Document 
Customizing Toolbars and Menus: • Toolbar Fundamentals  • Hidden Toolbars  • Adding Menus  • About the Work Menu  • Adding Menu Commands  • Re-Arranging Menu and Toolbar Commands 
Toolbar Specifics: • The Basic Toolbars  • Graphic Toolbars  • Language Toolbars  • Coding Toolbars  • Web Toolbars  • Document Management Toolbars  • About the Task Pane “Toolbar” 
Formatting Tools
Working with Templates: • Creating Your Document with a Wizard  • Opening an Existing Template  • Modifying and Saving a Template  • Creating a Template  • Attaching a Template to a Document  • About Global Templates 
Creating Lists: • Types of Lists  • Creating a Bulleted or Numbered List  • Modifying and Removing Bulleted or Numbered Lists  • Restarting or Continuing a Bulleted or Numbered List  • Outlined Lists  • Customizing Bullets and Numbers 
Headers and Footers: • Viewing Headers and Footers  • Creating or Deleting a Header or Footer  • The Header/Footer Toolbar  • Inserting Dynamic Text  • Inserting Page Numbers  • Applying Page Settings  • Header and Footer Links 
Paragraph Tools: • Viewing Document Markings  • Applying Borders  • Applying Shading and Patterns  • Applying Alignment and Indentation  • Applying Spacing 
Customizing Your Documents
Using Styles: • Applying Styles  • The Styles Task Pane  • Modifying a Style  • Creating a Style  • Creating a Character Style  • Deleting a Style  • Using Click and Type Styles 
Managing Styles: • Organizing Your Styles  • Displaying Styles in a Document  • Revealing Formatting  • Using AutoFormat as You Type  • Using AutoFormat 
Using Pre-Defined Text: • Inserting AutoText  • Customizing AutoText  • Inserting the Date and Time  • Inserting a Symbol  • Inserting Special Characters 
Timesaving Tools: • The Format Painter  • Themes  • Smart Tags 
Working With Graphics
Basic Graphics Tools: • Inserting a Picture from a File  • The Picture Toolbar  • Formatting a Picture  • Adding Captions 
Using Pre-Defined Graphics: • WordArt  • Watermarks  • Inserting ClipArt  • The Online Gallery 
Inserting Diagrams and Charts: • Using an Organization Chart  • Inserting a Cycle Diagram  • Using a Radial Chart  • Inserting a Pyramid Diagram  • Inserting a Venn Diagram  • Inserting a Target Diagram 
Customizing Graphics: • The Drawing Toolbar  • Creating a Drawing  • Inserting AutoShapes  • Editing AutoShapes  • 3-D Styles and Shadows  • Inserting and Using Text Boxes 
Using Objects: • Inserting an Object  • Selecting, Moving, and Resizing Objects  • Object Groups  • Arranging Objects 
Managing Documents
Tracking Changes: • The Reviewing Toolbar  • Tracking Changes  • Adding Comments  • Reviewing Changes  • Changing the Changes That You See  • Setting Options for Tracking Changes  • Finishing Your Document 
Using Versions: • Saving, Opening, and Deleting Versions  • Comparing Documents  • Merging Documents  • Protecting Documents 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Word Intermediate (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive, hands-on one-day training course has been designed to give delegates a solid understanding of more advanced Word tools and concepts in order to increase their knowledge and productivity.

Who Should Attend

Users with a basic understanding of Microsoft Word 2003 or XP who want to consolidate and expand on their knowledge of the basic features in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

Microsoft Word Advanced (2003 & XP)

Course Outline

Duration: this is a one-day training course

training-courses-for-office-2003-to-2013

Versions covered

This course covers Microsoft Office 2003 and 2002 (XP).
TIP: If your screen has drop-down menus, rather than the top ribbon interface which replaced them in later versions of the software, this is the course you need.

Content covered

Advanced Tools
Delineation Tools: • Inserting a Section Break  • Inserting a Page Break  • Inserting a Line Break  • Page and Line Break Options  • Columns 
Language Tools: • Using and Customizing AutoCorrect  • The Research Pane  • The Thesaurus  • AutoSummarize Your Document 
Graphics Tools: • Microsoft Office Picture Manager  • Using Microsoft Office Clip Organizer  • Creating Charts Not Based on Table Data  • Customizing Charts Not Based on Table Data 
Table Tools: • Sorting Your Data  • Using Tables to do Calculations  • Creating a Chart Based on Table Data  • Tabbed Text and Tables  • Creating an Excel Table  • Inserting an Excel Table 
Sending a Document
Mail Merge Using the Wizard: • Mail Merge Basics  • Creating Letters with the Mail Merge Wizard  • Creating E-mail Messages with the Mail Merge Wizard  • Creating Envelopes with the Mail Merge Wizard  • Creating Labels with the Mail Merge Wizard  • Creating a Directory with the Mail Merge Wizard 
Manual Mail Merge: • The Mail Merge Toolbar  • About Word Fields  • Creating Envelopes and Labels  • The Letter Wizard 
Creating Forms and Using Macros
Creating Forms: • The Forms Toolbar  • Creating a Form  • Inserting Form Fields  • Protecting a Form  • Testing a Form  • Distributing a Form 
Advanced Forms Tasks: • Assigning Help to a Form Field  • The Document Protection Task Pane  • Using Multiple Sections 
Macros: • Setting Macro Security  • Recording a Macro  • Running a Macro  • Editing a Macro’s Code Using the Visual Basic Editor 
Other Macro Tasks: • Copying a Macro from a Template  • Assigning a Macro to a Keystroke  • Assigning a Macro to a Toolbar  • About Macro Names 
Managing Documents
Creating an Outline: • Outline View and the Outlining Toolbar  • Creating an Outline  • Expanding and Collapsing Headings  • Modifying Your Outline  • Moving Headings 
Creating a Table of Contents: • The ABCs of TOC’s  • Marking Text Using Heading Styles  • Marking Text Using Custom Styles  • Marking Text Using Outline Levels  • Inserting the Table of Contents  • Updating a Table of Contents 
Creating References Within a Document: • Footnotes and Endnotes in Print Layout  • Footnotes and Endnotes in Normal Layout  • Bookmarks  • Captions  • Adding Cross-References  • Creating an Index 
Creating References to Other Documents: • Linking to another Document  • Creating and Working With a Master Document  • Creating and Working With Sub-Documents  • Other Master and Sub Document Tasks 
Advanced Topics
Modifying Word Options: • Changing General, View, and User Information Options  • Modifying Printing, Editing and Saving Options  • Editing Security Options  • Changing Options for Spelling and Grammar and Track Changes  • Modifying Compatibility and File Location Options 

Call Activia Training on 0845 230 6150 Click to request a callback from Activia Training

Microsoft Word Advanced (2003 & XP)

About the Course

training-courses-for-office-2003-to-2013

Duration

This is a One-day training course.

Course Aims

This intensive one-day training course is designed to allow users to work with Word 2003's advanced features. Practical 'hands on' exercises will give delegates the chance to develop their skills in a structured and practical way.

Who Should Attend

Anyone who has been using Word for some time and who now wishes to get greater productivity from the software. Note : delegates on this course should have a good working knowledge of the topics covered in the Introduction and Intermediate courses.

Prices for Microsoft Office training

Please note : all prices exclude VAT.

Scheduled public classes

[The simplest and most cost-effective option for 1, 2 or 3 delegates]
If you book in advance, Early Bird prices start at just £209
•  Office 2010 Intro: Windows, Word & Outlook
 
First delegate: £239
2nd delegate: £229
3rd delegate +: £219 each
•  Office 2010 Intro: Excel & PowerPoint
 
First delegate: £239
2nd delegate: £229
3rd delegate +: £219 each
•  Office 2010 New Features
 
First delegate: £239
2nd delegate: £229
3rd delegate +: £219 each
•  Excel Introduction (2007, 2010 & 2013)
 
First delegate: £179
2nd delegate: £169
3rd delegate +: £159 each
•  Excel Intermediate (2007, 2010 & 2013)
 
First delegate: £189
2nd delegate: £179
3rd delegate +: £169 each
•  Excel Advanced (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £189
3rd delegate +: £179 each
•  Excel Professional (2007, 2010 & 2013)
 
First delegate: £229
2nd delegate: £219
3rd delegate +: £209 each
•  Excel VBA Introduction (2007, 2010 & 2013)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Excel VBA Advanced (2007, 2010 & 2013)
 
First delegate: £299
2nd delegate: £285
3rd delegate +: £269 each
•  Excel Introduction (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Excel Intermediate (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Excel Advanced (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Access Introduction (2007, 2010 & 2013)
 
First delegate: £179
2nd delegate: £169
3rd delegate +: £159 each
•  Access Intermediate (2007, 2010 & 2013)
 
First delegate: £179
2nd delegate: £169
3rd delegate +: £159 each
•  Access Advanced (2007, 2010 & 2013)
 
First delegate: £189
2nd delegate: £179
3rd delegate +: £169 each
•  Access Introduction (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Access Intermediate (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Access Advanced (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  PowerPoint Introduction (2007, 2010 & 2013)
 
First delegate: £179
2nd delegate: £169
3rd delegate +: £159 each
•  Powerpoint Advanced (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £189
3rd delegate +: £179 each
•  PowerPoint Introduction (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  PowerPoint Advanced (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Word Introduction (2007, 2010 & 2013)
 
First delegate: £189
2nd delegate: £179
3rd delegate +: £169 each
•  Word Intermediate (2007, 2010 & 2013)
 
First delegate: £189
2nd delegate: £179
3rd delegate +: £169 each
•  Word Advanced (2007, 2010 & 2013)
 
First delegate: £199
2nd delegate: £189
3rd delegate +: £179 each
•  Word Introduction (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Word Intermediate (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
•  Word Advanced (2003 & XP)
 
First delegate: £249
2nd delegate: £239
3rd delegate +: £229 each
NOTE   [click to show/hide]
To view scheduled dates, click the "Dates" button on the right

Training at your offices

[A convenient and very cost-effective option for groups of delegates]
•  Office 2010 Intro: Windows, Word & Outlook
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Office 2010 Intro: Excel & PowerPoint
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Office 2010 New Features
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Introduction (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Intermediate (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Advanced (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Professional (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel VBA Introduction (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel VBA Advanced (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Introduction (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Intermediate (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Excel Advanced (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Access Introduction (2007, 2010 & 2013)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Intermediate (2007, 2010 & 2013)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Advanced (2007, 2010 & 2013)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Introduction (2003 & XP)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Intermediate (2003 & XP)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  Access Advanced (2003 & XP)
 
First delegate: £479
Extra delegates: £45 each
(Price per day)
•  PowerPoint Introduction (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Powerpoint Advanced (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  PowerPoint Introduction (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  PowerPoint Advanced (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Word Introduction (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Word Intermediate (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Word Advanced (2007, 2010 & 2013)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Word Introduction (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Word Intermediate (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
•  Word Advanced (2003 & XP)
 
First delegate: £449
Extra delegates: £45 each
(Price per day)
NOTES   [click to show/hide]

Scheduled dates for our public classes


Office 2010: no public classes currently scheduled.

Quick Links

Information

About Microsoft Office
Delegate Feedback
Prices
Dates

Course outlines

Click on a course title to view the outline.
Office 2010 Intro: Windows, Word & Outlook
Office 2010 Intro: Excel & PowerPoint
Office 2010 New Features
Excel Introduction (2007, 2010 & 2013)
Excel Intermediate (2007, 2010 & 2013)
Excel Advanced (2007, 2010 & 2013)
Excel Professional (2007, 2010 & 2013)
Excel VBA Introduction (2007, 2010 & 2013)
Excel VBA Advanced (2007, 2010 & 2013)
Excel Introduction (2003 & XP)
Excel Intermediate (2003 & XP)
Excel Advanced (2003 & XP)
Access Introduction (2007, 2010 & 2013)
Access Intermediate (2007, 2010 & 2013)
Access Advanced (2007, 2010 & 2013)
Access Introduction (2003 & XP)
Access Intermediate (2003 & XP)
Access Advanced (2003 & XP)
PowerPoint Introduction (2007, 2010 & 2013)
Powerpoint Advanced (2007, 2010 & 2013)
PowerPoint Introduction (2003 & XP)
PowerPoint Advanced (2003 & XP)
Word Introduction (2007, 2010 & 2013)
Word Intermediate (2007, 2010 & 2013)
Word Advanced (2007, 2010 & 2013)
Word Introduction (2003 & XP)
Word Intermediate (2003 & XP)
Word Advanced (2003 & XP)

Tools

(Note: Tools open in a new window)

Contact details

Phone:
Sales & Bookings:   0845 230 6150
Customer Service:   0845 230 6159
Accounts:                 0845 230 6157
Fax:    
All departments:     08703 500 151
Email:
Click to  

Quality Assured Training

Quick Course Finder

With truly hundreds of training courses to choose from, we have a Quick Course Finder that will help you to find the subject area and course you need.

Just click on any heading (in black) or section
(in blue) to go straight to where you need to be.

Click to use our Quick Course Finder

Contact Us

Activia Training
Head Office:
    Regus House, 268 Bath Road
    Slough,   SL1 4DX

Sales:       0845 230 6150
Service:    0845 230 6159
Accounts: 0845 230 6157

Office Training Courses from Activia

We can provide training courses for Microsoft Office at any of our sixteen centres UK wide, or we can come to your offices – if you have groups of staff, this is a particularly convenient, flexible and cost effective option.

We have been training since 1995 and have continually developed our philosophy of high quality, flexible and cost effective provision of training courses for Microsoft Office.   This means you can be confident that we have the expertise, and the experience, to give all you need with courses for Microsoft Office.

Call us now on 0845 230 6150 or request a free callback.

Quality Assurance