Main content

Excelling At Excel: The 5 Fs

Microsoft Office logo

Discover the "5 Fs of Excel"

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

  • Formatting: Using and creating custom formatting for SSNs, phone numbers, and other special types of data.
  • Fills: Using fills for dates, numbers, formulas/functions, and how to create your fills.
  • Functions: Using SUM, AVERAGE, COUNT, COUNTA, TODAY, CONCATENATE, and other functions.
  • Formulas: Using Relative, Absolute/Mixed, and 3-D references
  • 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."

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, participants 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
  • Course Schedule

Excelling At Excel: The 5 Fs Course Information

Contact Hours
3 hours

NEXT STEPS

This course is currently not offered to the public.