« Back to Class Listing

Excelling at Excel: Formulas and Functions

Description


Knowing how to work efficiently with Excel’s formulas and functions is a critical skill whether you are creating a monthly budget or working in complex worksheets at a Fortune 100 company.

Excel helps us perform very complex tasks using very simple built-in functions. In this course, you will learn different cell references—Relative, Absolute/Mixed, and 3-D—and use them to begin creating and using formulas. From there, you will begin introductory functions such as SUM, AVERAGE, COUNT, and TODAY to help track your monthly budget and expenses. We will discuss how to more efficiently create, copy, and organize worksheets before creating an annual budget using summary worksheets and Mixed and Absolute cell references to forecast your budget for the future.

We will also calculate loan payments, amortization, and repayment schedules using the Name Box, Name Manager, PMT, and CONCATENATE functions. Finally, we begin looking at different database functions like VLOOKUP/HLOOKUP and IF…THEN…ELSE to locate information in a workbook and avoid duplicate entries.

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

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:

  • Prepare formulas using basic, intermediate, and advance functions
  • Differentiate between cell references in Excel – Relative, Absolute/Mixed, and 3-D
  • Optimize budgeting with introductory functions including SUM, AVERAGE, COUNT, and TODAY
  • Evaluate loan repayment options using intermediate functions – PMT and CONCATENATE
  • Construct advanced functions to find and display data with VLOOKUP/HLOOKUP and IF-THEN-ELSE.

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
06/02/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