Introduction
Introducing Higher Administration and IT
Communication in Administration
Communication in Business
Communication in Business: Quiz
Editing a Presentation
Slide Backgrounds and Animations
Importing Data, Changing Master Handouts and Printing Presentations
Presentation Software: Quiz
E-mail
Electronic Communication: Quiz
IT Solutions for Administrators
Relational Databases
Relational Databases: Quiz
Forms
Forms: Quiz
Queries
Calculate and Aggregate Queries
Queries: Quiz
Reports
Reports: Quiz
Integration of Databases
Integration of Databases: Quiz
Business Documents: Letters and Itineraries
Business Documents: Meetings Documentation
Mail Merge
Business Documents: Quiz
Tips for Viewing and Editing Your Document
Line Spacing and Lists
Using Indents and Tabs
Editing Documents: Quiz
Using Tables
Using Tables: Quiz
Working with Styles
Table of Contents, Margins and Page Orientation
Breaks
Using Headers and Footers
Watermarks, Comments, Footnotes and Endnotes
Using Word Count, Spellcheck, Thesaurus and Find and Replace
Formatting Documents: Quiz
Relative and Absolute Cell References, Named Cells and Ranges
Mathematical Functions
Cells, Ranges and Mathematical Functions: Quiz
Vertical and Horizontal Lookups
Horizontal Lookup and Conditional Formulae
Conditional Formulae and IF Statements
Nested IF Statements and Conditional Formulae
Lookups, Conditional Formulae, IF Statements and Conditional Formatting: Quiz
Sorting and Filtering Data
Outlining and Grouping Data
Organising Data: Quiz
Linking Cell References and Creating Charts
Charts and Pivot Tables
Pivot Charts, Comments and Working Between Applications
Working Between Applications and Printing
Linking Cells, Charts, Tables, Working Between Applications and Printing: Quiz
Administrative Theory and Practice
The Effectiveness of Administrative Practices Within Organisations
The Effectiveness of Administrative Practices Within Organisations: Quiz
Time and Task Management
Time and Task Management: Quiz
Setting Targets for the Individual and the Organisation
Setting Targets for the Individual and the Organisation: Quiz
Changing Priorities and Monitoring Progress
Effective Teams
Effective Teams: Quiz
Health and Safety Legislation
Health and Safety Legislation: Quiz
Data-Handling Legislation
Data-Handling Legislation: Quiz
Impact of ICT on Working Practices
Working Practices
The Impact of New Work Practices
The Impact of New Work Practices: Quiz
Computer Networks and File Management
Computer Networks and File Management: Quiz
Meetings
Features of Good Customer Care
Features of Good Customer Care: Quiz
Methods of Evaluating Customer Care Policy
Methods of Evaluating Customer Care Policy: Quiz