select






Microsoft Excel -Tips and Tricks

Description

This is an on-line course. It will not be held on campus.

Prerequsite: To participate in this online course students must have access to a computer that has MS Office 2016 or MS Office 2019/365 installed on it.

Students who register for this class will receive an email from the instructor a few days before the class begins with information on how to access the course materials exercise files, and how to submit assignment exercises.

Tables/Pivot Tables

Learn the power of Tables to analyze data from large spreadsheets. Students will also learn the fundamentals of using PivotTables to summarize data from large spreadsheets so data can be analyzed. Students will learn how to create  pivot table using data from a variety of different data lists. By the end of the course students will be able to generate pivot tables to present data in a variety of ways for analysis.

V-Lookp

Are you tired of copying and pasting data from one workbook to another? Learn how to use the VLOOKUP function to efficiently match up data between databases into one comprehensive list. A variety of lists will be used in the learning process of this course. Be prepared to use your creative and critical thinking skills to reach a final outcome.





Classes

Add Section Location Instructor Dates Days Times Fees Details Open