Loading...

Course Description

Learn to design effective spreadsheets that others can use and interpret easily. Practice applying effective design techniques, including naming cells, protecting cells, and making your spreadsheets easy to read. Additional topics include working with multiple worksheets, creating templates, rounding data, using conditional functions, and applying conditional formatting.

In this course, you will learn to: 

  • Work with multiple worksheets in a single workbook 

  • Name cells and ranges and use these names in formulas 

  • Use the ROUND function to round numbers 

  • Use conditional functions to count and sum cell ranges 

  • Test a condition with the IF function 

  • Format cells based on a condition 

  • Apply elements of good spreadsheet design 

  • Create and use templates 

  • Protect cells in your spreadsheet 

  • Use functions on noncontiguous areas 

Prerequisites

Introduction to Excel or equivalent experience.

Applies Towards the Following Certificates

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