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
Draw and write with ink in Office also referred to as drawing with digital ink.
Resources for Excel Level 1
Resources for Excel Level 2
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.
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:
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
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.
Introduction to What-If Analysis and DataTables
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.
15 total views, 6 views today