Loading...

Course Description

In this half-day course, students will discover the important 5 Fs of Excel: Formatting, Fills, Formulas, Functions, and Filters/Sorts.

  1. Formatting: Using and creating custom formatting for SSNs, phone numbers, and other special types of data.
  2. Fills: Using fills for dates, numbers, formulas/functions, and how to create your fills.
  3. Functions: Using SUM, AVERAGE, COUNT, COUNTA, TODAY, CONCATENATE, and other functions.
  4. Formulas: Using Relative, Absolute/Mixed, and 3-D references
  5. Filters/Sorts: Using Excel as a database/table for filtering and sorting data.


Audience: This course is designed for those who are familiar with Excel and want to learn to perform more complex tasks and functions. This course builds on "Excelling at Excel: The FUNdamentals."

Software: This class is taught using Microsoft Excel 2016 on our lab PCs, but the content applies to Excel 2007, 2010, 2013, and 2016 for Windows. Material learned in this course may not apply to Excel for Mac.

Format: This class is offered in a HyFlex format. Students can choose to attend online or in-person at our Century Center location. Please register for the option that best suits your needs. 
 

Course Outline

Lesson 1: Formatting

  • Merge and Center, Text Orientation, Fills and Borders
  • Conditional Formatting
  • Styles and creating your own style for cells, rows, and columns
  • Special formats for SSNs, Phone numbers, and Zip Codes
  • Custom formats for creating your own data format

Lesson 2: Fills

  • Text, dates, numbers, and formulas and functions
  • Custom Lists
  • Flash Fill (Excel 2013 and 2016)

Lesson 3: Formulas

  • Syntax for creating formulas
  • Calculate time periods for days and years
  • Difference formulas
  • Various references in Excel for relative, absolute/mixed, and 3-D References

Lesson 4: Functions

  • SUM, AVERAGE, COUNT, TODAY
  • CONCATENATE (join two or more text strings into one string)
  • Linking worksheets with a formula/function

Lesson 5: Filters/Sorts

  • Table/database rules and guidelines
  • Format as Table using Table Styles
  • Filtering a table/database for date ranges
  • Filtering for number ranges and Top/Bottom Rules
  • Filtering for specific text
  • Filtering for texts begins with, ends with, or contain text characters
  • Sorting a table/database using one and multiple criteria with custom sorts
  • Sorting a worksheet that is not in a table/database format

Learner Outcomes

After completing this course, you will be able to:

  • Create and use special and custom formats
  • Employ Conditional Formatting based on various criteria
  • Use AutoFill to save lists and for dates, text, numbers, and formulas and functions
  • Develop formulas and functions in Excel for tables and databases
  • Filter your information quickly for date ranges, numbers, and text lists
Loading...
Enroll Now - Select a section below
Section Title
Excelling at Excel: The 5 Fs: Formatting, Fills, Formulas, Functions, and Filters/Sorts
Type
Classroom
Days
W
Time
9:00AM to 12:00PM
Dates
Jun 15, 2022
Schedule and Location
View Schedule
Contact Hours
3.0
Location
  • Century Center
Delivery Options
Classroom  
Course Fee(s)
Tuition non-credit $185.00
Drop Request Deadline
Jun 08, 2022
Transfer Request Deadline
Jun 08, 2022
Instructors
Section Notes
This course is offered in a HyFlex format. Choose this section to attend in-person at our Century Center Location.
Section Title
Excelling at Excel: The 5 Fs: Formatting, Fills, Formulas, Functions, and Filters/Sorts (Online)
Type
Online (Instructor-led)
Days
W
Time
9:00AM to 12:00PM
Dates
Jun 15, 2022
Schedule and Location
View Schedule
Contact Hours
3.0
Location
  • Zoom (Eastern Time)
Delivery Options
Online (Instructor-led)  
Course Fee(s)
Tuition non-credit $185.00
Drop Request Deadline
Jun 08, 2022
Transfer Request Deadline
Jun 08, 2022
Instructors
Section Notes
This class is offered in a HyFlex format. Choose this section to attend online. 
Required fields are indicated by .