Microsoft Office Training Resources
Below you will find useful informational articles , including tips and tricks, how-to articles etc. Content is updated on a weekly basis.
Access Learning Resources:
An Introduction to Access Databases
Access is a relational database. A relational database is a collection of data items organized as a set of tables. In this lesson, you’ll get a chance to familiarize yourself with the basic components of the database. First, we’ll look at some common database terms. You’ll also take a closer look at the Navigation pane. We’ll introduce tables, table relationships, queries, forms, and reports. Read more.
Performing Basic Access Database Tasks
This lesson focuses on tables. You’ll learn how to enter and edit data in the Datasheet view of a table. Next, we’ll look at using the clipboard to cut, copy, and paste data to and from different fields. Read more.
Formatting Text in Access Databases
There are several options for formatting your text in the Datasheet. To change the font face and size using the Ribbon tools, use the following procedure. Read more.
Excel Learning Resources:
Editing and Copying Formulas in Microsoft Excel
The spot color effect is when everything on the screen is in black and white except for a certain color.
This effect can be done with both stills and video. Read more.
Recording Macros in Excel
If you perform certain opertations over and over in Excel, you can record a macro which stores all the steps, and when you run the macro it will automatically perform each step automatically save you a lot of manual repetitive work. Read more.
Protecting Excel Worksheets
By default, all cells in a worksheet are designated as locked. You cannot prohibit changes to locked cells unless you protect the worksheet, after which none of the locked cells can be modified. If you want to be able to modify specific cells in a protected worksheet, you must unlock them before protecting the worksheet. When you modify any unlocked cells, the results in any protected cells that contain formulas dependent upon unlocked cells will also be modified. Read more.
More Excel Learning Resources
PowerPoint Learning Resources:
Your First PowerPoint Presentation
In this article, you will be shown how to create your first presentation. Presentations consist of slides. Each slide can contain text, graphics, animations, and more. You’ll learn how to add slides, use the content placeholders, and add text to your presentation. Read more.
Getting to know the PowerPoint Interface
In this article, we’ll introduce you to the PowerPoint 2013 interface, which uses the Ribbon from the previous two versions of PowerPoint. You’ll get a closer look at the Ribbon, as well as the Navigation pane and the Status bar. You’ll also learn how to manage your Microsoft account right from a new item above the Ribbon. Read more.
Working with Text in Microsoft PowerPoint
The PowerPoint 2013 editing tools make editing your presentation a breeze. This article covers how to work with text, including selecting, editing, deleting, cutting, copying, and pasting. It also explains how to use the Office Clipboard. You’ll learn how to use undo and redo and how to find and replace text, such as when you want to change a PowerPoint or phrase throughout your presentation. Read more.
Project Learning Resources:
Adding Tasks in Microsoft Project
In this article, we'll delve a little deeper into understanding tasks. Project 2010 introduces manually scheduled tasks. You can also schedule tasks automatically using the Project scheduling engine. We’ll discuss the key terms for understanding tasks in this module. We’ll also learn how to view task information and sort and filter tasks. Read more.
A filter is used to screen out unwanted tasks for a particular view to identify a particular aspect of the current state of the project, for example the filter can be set to show the tasks that make up the Critical Path. Read more.
Adding Gantt Bars
If you want to spotlight a particular task category that is not represented by its own Gantt bar, you can create a new Gantt bar. For example, you can create a Gantt bar to show available slack or to call attention to delayed tasks. Read more.
More Project Learning Resources
Outlook Learning Resources:
Managing Mail and Auto Archiving in Outlook
When your Outlook items become out of date, you can store them or delete them. You can archive them automatically after a specified time interval or archive them manually. When you archive your items, you store them in your My Documents folder on your hard drive. You can retrieve archived items at any time. Read more.
Manually Archiving and Retrieving Items in Outlook
If you want to archive a folder immediately, you use the Archive dialog box, shown in Figure 1-3, which you access from the File menu. If you want to archive your Contacts folder, you can only archive it manually. Read more.
Adding a Signature in Outlook
Outlook includes several ways to automatically manage different tasks. This article explains how to control your signatures. You can have a different signature for different email accounts, as well as different signatures for both new messages and replies/forwards. Read more.
More Outlook Learning Resources
Visio Learning Resources:
The Visio Interface
Visio 2010 has a new interface that builds on interface from the previous version of Visio. Visio 2010 uses the ribbon interface that was introduced in Microsoft Office 2007 applications. Each tab in the ribbon contains many tools for working with your drawing. To display a different set of commands, click the tab name. Buttons are organized into groups according to their function. Read more.
Setting up your Screen in Visio
In this module, you will learn how to set up your Visio screen. You have different elements to help you create your drawing, which you can show or hide as needed. This module will explain how to add, move, and delete a guide. It will also explain how to change the ruler settings and the grid settings. Read more.
Starting a Drawing in Visio
In this module, you will create your first drawing. Drawings consist of shapes. This module will cover how to find the right shape and place it on your drawing. You’ll learn how to add text to shapes. You’ll learn how to work with shapes, including resizing, moving, and deleting shapes. This module will also cover using the Tools group, which helps with refining your shapes. Read more.
Word Learning Resources:
Starting a Document in Word
Before you can begin using the many features of Microsoft Word 2013, you need to know several basic skills and concepts. Identifying word processing functions and Word screen components, creating and opening a document, and moving around within a document are the foundations you will build on in this course. Read more.
Starting a Document in Word
Word lets you begin working in documents in two ways: by typing into a new, blank document, or by opening an existing document. New and Open commands are reached, using the mouse method of navigating, by clicking the File Ribbon Tab first. Read more.
Modifying Page Breaks
Word automatically determines where each page of a document should begin and end by inserting automatic page breaks. As you create and edit multipage documents, you might find that you need to manipulate the automatic page breaks. You can quickly create a manual (forced) page break by clicking the Page Break button in the Pages group on the Insert tab. Read more.