Absolute Referencing Demo
Create Basic Queries
Format a Table

05:50

Format a Table
Format a Table
Insert File
Create Basic Queries

21:59

Create Basic Queries

Learn how to search your database for specific information and results. You will also learn how to manipulate your data using a calculated field.

Create Basic Queries
What is good information? Use your RADAR
Insert File

01:35

Insert File
Insert File
Creating Aggregate Queries
What is good information? Use your RADAR

04:22

What is good information? Use your RADAR

This video discusses what good resources are and how to evaluate information. Use your RADAR to find good resources that are trustworthy, scholarly, reliable, and peer reviewed. To evaluate information, look at relevance, authority, date, accuracy and the reason for creation.

What is good information? Use your RADAR
Insert the Date as a Field
Creating Aggregate Queries

08:27

Creating Aggregate Queries

Aggregate queries can take large amounts of information and summarize this into more meaningful results.

Creating Aggregate Queries
Working With Long Tables
Insert the Date as a Field

03:04

Insert the Date as a Field
Insert the Date as a Field
Sort a Table
Working With Long Tables

13:46

Working With Long Tables
Working With Long Tables
Absolute Referencing Demo
Sort a Table

03:20

Sort a Table
Sort a Table
Format a Table
Absolute Referencing Demo

06:14

Absolute Referencing Demo

Absolute referencing is one of the most important concepts in Excel when it comes to creating formulas and functions. Learning how to utilize the principles of absolute referencing will make your formula creation more efficient, as it will avoid the common error of having to re-type a new formula many times over.

‹ ›

Most Popular

  • Thumbnail for entry Format a Table

    05:50

    Format a Table

    Format a Table

    From Sask Polytech AVMedia

    1,124 plays 0  
  • Thumbnail for entry Create Basic Queries

    21:59

    Create Basic Queries

    Create Basic Queries

    From Sask Polytech AVMedia

    1,521 plays 0  
    Learn how to search your database for specific information and results. You will also learn how to manipulate your data using a calculated field.
  • Thumbnail for entry Insert File

    01:35

    Insert File

    Insert File

    From Sask Polytech AVMedia

    571 plays 0