Office Tutorials 2
This series of guides cover a wide range of techniques in the effective use of Microsoft Access, PowerPoint and Excel. Each presentation contains information, links to examples and fully narrated video tutorials.
Here you will find a listing of all these tutorials on one page but if you are just interested in a particular Application use the following links:
Office Tutorials 2 | Access | Excel | PowerPoint | Word
Office Tutorials
2
Click the screenshot or title here to view all these tutorials as a Reload content package which provides both sequential and individual navigation. Alternatively use the links and summaries below to choose which individual tutorials to view.
Using Conditional Formatting in Microsoft Excel
This is a tutorial about
how to use simple conditional formatting, as well as a Microsoft Excel spreadsheet
with some advanced examples.
(3,126
KB) - zip archive
Protecting Worksheets and Changing Display
Options in Microsoft Excel
A tutorial covering how to protect worksheets and
modify their display settings.
(5,097
KB) - zip archive
Using Multimedia in Microsoft PowerPoint
The aim of any PowerPoint presentation
is to get a particular message across. This can be greatly enhanced by careful
use of multimedia resources in the presentation.
(22,492
KB) - zip archive
Working with Charts and Diagrams in Microsoft
PowerPoint
As well as being able to insert charts and diagrams from other
programs, such as Microsoft Excel, via copy and paste, Microsoft PowerPoint
has inbuilt Chart and Diagram facilities.
(6,119
KB) - zip archive
Creating
Simple Quizzes in Microsoft PowerPoint
Microsoft PowerPoint provides an easy
way of creating simple quizzes. The following link has a short tutorial video
illustrating how this can be done.
(5,748
KB) - zip archive
Creating Interactive Presentations in Microsoft PowerPoint
As well as being
able to incorporate multimedia elements such as sound, graphics, animation,
photos, and movies into your PowerPoint presentations, you can also transform
them into interactive tools.
(26,568
KB) - zip archive
Creating Macros
and Quizzes in Microsoft Excel
This tutorial will take you through the basic
steps needed to get started with macros. Including creating a quiz and recording
a macro.
(17,401
KB) - zip archive
Create Tables in Access
For our example, we will be setting up a database
for the following scenario. A local college runs a Foundation Degree in Computing
and the Programme Leader needs to record personal details of each student
and eventually, produce lists of students grouped by the courses that they
are enrolled on.
(8,680
KB) - zip archive
Create Macros in
Access
A Macro is a set of actions that you can create to help you to automate
common tasks.
(13,051
KB) - zip archive
Create Forms in Access
Create a new Form with Access’s Wizard
and then modify the design of the form.
(5,995
KB) - zip archive
Create Relationships in Access
In this tutorial, a further table has been
added to the database – Courses.
This contains course information (title, dates, costs, etc.) that we want
to eventually see output on forms and reports.
(7,414
KB) - zip archive
Create Queries in Access
View both the tables at the same time and check
that the one-to-many relationship does indeed work.
(7,963
KB) - zip archive
Create Reports in Access
Printed reports are still necessary in today’s
electronic world and Access offers the user simple yet powerful reporting
capabilities.
(7,387
KB) - zip archive
Create workspace files in Excel
A workspace file is a file that saves display
information about open workbooks, so that you can later resume work with
the same window sizes, print areas, screen magnification, and display settings.
(7,801
KB) - zip archive
Formatting Excel worksheets with VBA
A tutorial covering accessing the Control Toolbox, adding a Command Button to a worksheet, adding code to the Command Button and navigating between worksheet and code .
(19.342
KB) - zip archive
Collaboration in Word
A guide to using the reviewing toolbar options in Microsoft Word.
(61,867
KB) - zip archive
Drag and Drop in Word
An introduction to creating a basic drag and drop interaction in Word
(50,045
KB) - zip archive
Forms in Word
A tutorial covering the use of the Control Toolbox to create forms in Word.
(33,061
KB) - zip archive
Security
A tutorial covering the various security settings which can be enabled and configured in Microsoft Word.
(35.736
KB) - zip archive
