Loading...

Course Description

Learn advanced functions and database management techniques, including sorting, filtering data, and using database statistical functions. Get the most out of your Excel applications by linking data between worksheets and workbooks. Other topics include using lookup tables and performing what-if analysis using Goal Seek and scenarios.

By the end of the course, you will be able to: 

  • Use Excel tables to manage data by sorting and filtering records, eliminating duplicates, adding total rows, and creating calculated columns 

  • Use database statistical functions to perform calculations on data that meet certain criteria 

  • Use Excel’s LOOKUP functions to look up information in a table 

  • Link data between worksheets and workbooks 

  • Use Goal Seek and scenarios to analyze your Excel data 

Prerequisites

Intermediate Applications of Excel or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced Applications of Excel
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
May 30, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
May 28, 2024
Transfer Request Deadline
May 28, 2024
Section Title
Advanced Applications of Excel
Type
Discussion
Days
Th
Time
8:30AM to 4:00PM
Dates
May 30, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
May 28, 2024
Transfer Request Deadline
May 28, 2024
Section Title
Advanced Applications of Excel
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Jun 21, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 19, 2024
Transfer Request Deadline
Jun 19, 2024
Section Title
Advanced Applications of Excel
Type
Discussion
Days
F
Time
8:30AM to 4:00PM
Dates
Jun 21, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $199.00
Drop Request Deadline
Jun 19, 2024
Transfer Request Deadline
Jun 19, 2024
Required fields are indicated by .