« Back to Class Listing

Excelling at Excel: The 5 Fs: Formatting, Fills, Formulas, Functions, and Filters/Sorts

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.

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

Section:
Notice: Undefined variable: SectionNumber in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 613
Dates:
Notice: Undefined variable: StartDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 616

Notice: Undefined variable: EndDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 616
-
Time: 9:30 AM
Tuition:
Notice: Undefined variable: Cost in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620
Instructor:
Notice: Undefined variable: InstructorString in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 621

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 624

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 626

Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 630

Notice: Undefined variable: SectionDescription in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 646

Class Schedule

Date Times Meeting Type Location
10/11/2017 9:30 AM - 12:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
Notice: Undefined variable: FinalEnrollmentDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 702

Clock Hours:
Notice: Undefined variable: ClockHours in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 707