Webcast: K2's Excel Essentials for the Busy Professional (XKEEB117)
Tell a Friend About This EventTell a Friend
 

Let this be the year that you learn how to take advantage of Excel's best features for busy professionals. Tables, conditional formatting, interactive charting, multi-condition formulas, lookup functions, and formatting shortcuts are all examples of techniques that you should be using to get better results in less time with Excel. If you're not using all of these features, or if you are unsure if you are taking full advantage of these features, you should make plans now to participate in this se

10/19/2017
When: 10/19/2017
10:00 AM until 4:00 PM
Where: Webcast
K2 Enterprises
United States
Presenter: Steven Phelan


Online registration is closed.
« Go to Upcoming Event List  

Acronym XKEEB117
CPE 6 hours
Vendor K2 Enterprises
Category
Management
Level Intermediate
Prerequisite Good working knowledge of Excel
Adv Prep None
Yellow Book? No
Designed for Accountants and business professionals who want to use Excel more efficiently and effectively
Registration
Member $164
CPA Non-Member $214

The Member rate applies to LCPA members, other state society members, and non-CPA staff of LCPA members. To register online, use the ‘Register’ button above. To register by phone, call the LCPA Member Service Center at 800.288.5272 or 504.464.1040, Monday through Friday, 8am to 5pm.

Course Description

Let this be the year that you learn how to take advantage of Excel's best features for busy professionals. Tables, conditional formatting, interactive charting, multi-condition formulas, lookup functions, and formatting shortcuts are all examples of techniques that you should be using to get better results in less time with Excel. If you're not using all of these features, or if you are unsure if you are taking full advantage of these features, you should make plans now to participate in this session to boost your Excel skills.

Objectives

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

Topics

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