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
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.
Getting Started with PowerPoint: Set Up a Theme
Resources for Excel Level 1
Create pie, bar, and line charts (Video)
Format numbers in cells (Video)
Resources for Excel Level 2
How to create custom number formats
Date and time functions (reference)
Use Trace to fix formula errors (Video) Highly recommend viewing.
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)
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).
Macros
Things you need to be aware of:
Enable or disable macros in Office documents
Resources for Advanced Excel Level
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.
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
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
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