What are Lists - Hope-Tech University Online Learning Platform

Excel Intermediate What are Lists

Excel Intermediate

0% Completed

Excel Intermediate

Intermediate Shortcut Keys

Video - 00:4:00 mins

Lists

Video - 00:3:00 mins

Video - 00:1:38 mins

Sorting Multiple Criteria

Video - 00:2:18 mins

Video - 00:2:58 mins

What are Filters

Video - 00:2:31 mins

Format a List as a Table

Video - 00:2:16 mins

DataBase Functions

Introduction to DataBase Functions

Video - 00:3:30 mins

Video - 00:4:54 mins

DSum Function Single Criteria

Video - 00:2:51 mins

DSum Function Multiple Criteria

Video - 00:5:4 mins

Video - 00:2:13 mins

DCount Function

Video - 00:1:49 mins

Video - 00:3:30 mins

Data Validation

Data Validation - List

Video - 00:5:54 mins

Data Validation - Decimal

Video - 00:1:54 mins

Input and Error Messages

Video - 00:4:16 mins

Importing and Exporting

Importing Data from Text Files

Video - 00:5:36 mins

Importing Data from MS Access

Video - 00:6:14 mins

Exporting Data to a Text File

Video - 00:3:35 mins

Creating Basic Charts

Creating Basic Charts

Video - 00:3:32 mins

The Chart Ribbon

Video - 00:4:00 mins

Adding and Modifying Data on a Chart

Video - 00:2:18 mins

Formatting Charts

Video - 00:4:33 mins

Pivot Tables

Understanding Pivot Tables

Video - 00:3:19 mins

Creating Pivot Tables

Video - 00:6:16 mins

Pivot Table Calculations

Video - 00:3:35 mins

Grouping Pivot Table Data

Video - 00:2:53 mins

Formatting Pivot Table Data

Video - 00:3:14 mins

Drilling Down into Pivot Table Data

Video - 00:3:47 mins

Creating Pivot Charts

Video - 00:3:16 mins

Filtering Pivot Table Data

Video - 00:3:44 mins

Filtering using the Slicer

Video - 00:2:51 mins

Working with large data

Video - 00:2:52 mins

Consolidating Data

Video - 00:5:4 mins

LookUp Functions

Video - 00:2:58 mins

Video - 00:3:2 mins

Index and Match

Video - 00:4:50 mins

Advanced Functions

Text to Columns

Video - 00:1:32 mins

Video - 00:4:00 mins

Video - 00:1:38 mins

Video - 00:3:39 mins

Excel Intermediate – Conclusion

Excel Intermediate - Conclusion

Video - 00:1:38 mins

Announcements Reviews Course Info

Exercise Files

Lists (xlsx)

13.95 KB

Scroll to Top