« Back to Class Listing

Excelling at Excel: More Formulas and Functions


In Part 2 of this course, we will continue to discuss VLOOKUPS/HLOOKUPS to pull together information from large, database-like workbooks. From there, we will construct logical comparisons between given and expected values using IF…THEN…ELSE statements to make data more readable.

You will discover how to formulate smarter worksheets by understanding Excel’s time format and using Date Calculations such as TODAY, YEAR, and ROUNDDOWN. Track time spent volunteering, traveling, or working by creating a worksheet that calculates the interval between time in and time out. To keep data accurate, we will also learn to use Data Validation criteria.

Using COUNTIF, SUMIF and AVERAGEIF will help us perform calculations on data meeting specific criteria to extract more meaning from our worksheets. Finally, discover how to calculate totals, averages, and counts within a database system based on certain criteria using DSUM, DAVERAGE, and DCOUNT

Audience: We designed this course for current, advanced users of Excel who want to know more about formulas and functions. This course builds on "Excelling at Excel: The FUNdamentals," “Excelling at Excel: The 5 Fs,” and “Excelling at Excel: Formulas and Functions.”

Software: We teach this course using Microsoft Excel 2016 on our lab PCs, but the content should also apply to Excel 2007, 2010, and 2013 for Windows. Material learned in this course may not apply to Excel for Mac.

After completing this course, participants will be able to:

  • Explain more uses of VLOOKUPS/HLOOKUPS
  • Establish criteria using Data Validation to more easily search for data
  • Measure time in hours and minutes, days, and years
  • Create multiple IF-THEN-ELSE statements for more efficient functions
  • Develop functions—COUNTIFS, SUMIFS, AVERAGEIFS, DSUM, DCOUNT, and DAVERAGE—that give results based on criteria

Section: Notice: Undefined variable: SectionNumber in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 617
Dates: Notice: Undefined variable: StartDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620 Notice: Undefined variable: EndDate2Display in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 620 - Time: 9:30 AM
Tuition: Notice: Undefined variable: Cost in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 624 Instructor: Notice: Undefined variable: InstructorString in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 625 Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 628 Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 630 Notice: Undefined variable: ButtonName in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 634
Notice: Undefined variable: SectionDescription in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 650

Class Schedule

Date Times Meeting Type Location
10/25/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 706
Clock Hours: Notice: Undefined variable: ClockHours in /it/web/std-prod/ece.emory.edu/htdocs/catalogSectionDetail.php on line 711