Event Registration

Description:

MICROSOFT EXCEL: TOP ESSENTIAL FUNCTIONS CLASS - Virtual

May 26, 2022 | 8:30 - 11:00 am MST | Virtual | Cost: $25.00 pp

Online registration required |

Prerequisite: LEVEL 2 – This is an intermediate-level course. Participants should be familiar with creating and editing Excel worksheets and building simple formulas and functions (such as SUM).

More than 500 functions are built into Microsoft Excel for simple to complex calculations. Which of these functions are likely to be most valuable to you to build formulas, analyze data, extract essential information, and use your Excel worksheets more effectively? This workshop focuses on many of the frequently used and essential functions in Microsoft Excel.
• Understanding absolute and relative references
• Creating named ranges
• Improving data analysis with logical functions including IF, SUMIF, AVERAGEIF
• Looking up values with VLOOKUP & XLOOKUP
• Working with date values
• Leveraging function for combining and extracting text

Instructor Dawn Bjork, Software Pro Inc

Class Policies:

1. No refunds, unless under emergency conditions or Federal government deployment or Temporary Duty. Contact the CFEB office at 303 202 4588 no later than 24 hours in order to secure a refund.
2. Paid registrants can substitute another person, but notify the CFEB no later than 24 hours prior to class start date/time.
3. Agency's are required to notify the CFEB office for any ADA registered participants.

CONTACT Jeff Conn | jeff.conn@gsa.gov | 303 202 4588