Resources for Word, Excel, PowerPoint, and Access

The following are great resources to add into your knowledge of computer skills. Each section below is under the heading of the specific computer literacy skill, based on the Computer Literacy Courses page of this web site.
Some of the links below apply to all of the Microsoft Office Suite programs: Word, Excel, PowerPoint, and Access.

Resources that apply to Microsoft Word, Excel, PowerPoint, and Access

Custom Number Format

Change a theme and make it the default in Word or Excel

Quick Styles, cell styles, and background styles

Format the date and time field in Access

Draw and write with ink in Office also referred to as drawing with digital ink.

Hidden and Invisible Objects

Getting Started with PowerPoint: Set Up a Theme


Resources for Excel Level 1

Create pie, bar, and line charts (Video)

Chart types

Format numbers in cells (Video)

Number formats in Excel

Smart Lookup


Resources for Excel Level 2

How to create custom number formats

EDATE function

Date and time functions (reference)

YEARFRAC function

LEFT, LEFTB functions

ROUND function

AND function

IF function

Advanced IF functions (Video)

Use Trace to fix formula errors (Video) Highly recommend viewing.

SUBTOTAL function

Create an outline of rows

TRIM function


Resources for Excel Level 3

The following concepts are applicable to the Excel Level 3 knowledge, based on the Computer Literacy Courses page of this web site. The resources below are courtesy of  Microsoft Corporation.

Check if a cell contains text (case-insensitive)

Hidden and Invisible Objects

When to use Calculated Columns and Calculated Fields

VLOOKUP: When and how to use it (Video)
Use VLOOKUP, one of the lookup and reference functions, when you need to find things in a table or a range by row.
The VLOOKUP function: =VLOOKUP(lookup_value,table_array,columns_index_number)

 =VLOOKUP(Value you want to look up, range where you want to lookup the value, the column number in the range containing the return value, Exact Match or Approximate Match – indicated as 0/FALSE or 1/TRUE). 



Things you need to be aware of:

Enable or disable macros in Office documents


Resources for Advanced Excel Level 

Create a Data Model in Excel

A Data Model allows you to integrate data from multiple tables, effectively building a relational data source inside an Excel workbook. Within Excel, Data Models are used transparently, providing tabular data used in PivotTables and PivotCharts.

Overview of Excel tables


Mastering Excel Pivot Tables

Create a PivotTable and analyze your data (Video)

PivotTables are a great way to summarize, analyze, explore, and present your data, and you can create them with just a few clicks. PivotTables are highly flexible and can be quickly adjusted depending on how you need to display your results. You can also create PivotCharts based on PivotTables that will automatically update when your PivotTables do.
Calculate values in a PivotTable report


Data layout of a PivotTables

PivotTable Data Layout link

Before using Power Pivot, you should know how to create PivotTable. This will help you understand better how to use Power Pivot.

Start the Power Pivot in Microsoft Excel add-in

Calculated Columns in Power Pivot

Create a Calculated Column in Power Pivot


Introduction to What-If Analysis and DataTables

Introduction to What-If Analysis


Excel Screencasts created by Francisco

Downloading a File from Email 

The following four screencasts are part of Excel Level 1, and do require you have the FastCourse Excel Level 2 textbook from Labyrinth Learning. You need to ensure that that Adobe Flash Player is enabled.

Creating a Clustered Column Chart 

Changing the Chart Layout 

Adding Axis Titles 

Changing the Chart Type