Excel Essentials for the Busy Professional Webinar

Oct 19
11:00 - 5:00 p.m.

Online

6-Other
CPE Credits

Upon completing this course, you should be able to:

  • Identify how to create presentation-quality Excel-based reports quickly by using templates and applying formatting shortcuts
  • Implement Tables as dynamically resizing data ranges and build reports that use Tables as mini-databases in Excel
  • Prepare dynamic charts that allow end-users to filter the data on the fly
  • Utilize Excel's VLOOKUP, HLOOKUP, and CHOOSE functions to find exact data points and work with Excel's Fuzzy Lookup add-in to create approximate matches of data
  • Create formulas that evaluate multiple conditions before summarizing data
  • Apply Conditional Formatting to assist in analyzing data
  • Identify how to track multiple versions of a spreadsheet using Excel's Scenario Manager feature

Highlights

  • Utilizing templates for quality presentations
  • Building reports that use Tables as mini databases
  • Preparing dynamic charts
  • Utilizing functions to analyze data/LI>
  • Registration

    PICPA Member: $164
    Nonmember: $239

    More Information

    Course No. WK2-EEB172 Level: Intermediate

    Prerequisites: Good working knowledge of Excel

    Notes
    Your log-in instructions will be sent by K2 Enterprises at least 24 hours before the webinar.

    Speaker(s)

    Steven Phelan