K2's Critical Excel Tools Everyone Needs to Know - On Demand (4 hours)

K2's Critical Excel Tools Everyone Needs to Know - On Demand (4 hours)

  • $129.00


Course Description

You use Excel, but do you use it the right way? Are you taking advantage of key features that can help get your work completed more quickly & with fewer errors? Do you sometimes wonder what Excel tools you may not know about? Would you like to know about the new features that have been added to recent versions & how you can put them to use? If you answered 'yes' to any of these questions, then make plans now to participate in this course. In this course, you will learn techniques to summarize & analyze data in ways that you may have never imagined possible. Building upon your existing Excel skill set, you will learn how to create data models & then summarize these models using PivotTables. You will explore new features & learn how to take advantage of them, including tools that are useful in budgeting & forecasting environments. & you will learn innovative ways to use tried-&-true Excel features such as charts, VLOOKUP & HLOOKUP, tables, SUBTOTAL, & even formatting options. If you're planning to take just one Excel course this year, this should be the one.

Major Topics

  • Key new features added to recent versions
  • Tools for summarizing & analyzing data, including tables, data models, & PivotTables
  • Effective budgeting & forecasting techniques
  • Solving everyday business problems using features found in Excel

Learning Objectives

Upon completing this course, you should be able to:

  • Identify key new features added to recent versions
  • Create accurate reports, schedules, & analyses
  • Prepare Excel-based budgets & forecasts with improved accuracy & efficiency
  • Utilize various Excel features to solve common problems associated with spreadsheets

    Course Information

    • CPE Credit: Recommended for 4 hours Accounting
    • Prerequisites: Working knowledge of Excel 2007 or newer
    • Program level: Basic/Intermediate
    • Advanced preparation: None
    • Who should attend: Accounting & financial professionals who use Excel for reporting & want to improve quality of reports

    Instructional Delivery Method: QAS on-demand learning, including review and final exam questions. To earn credit, participants must pass the final exam with a score of 70% or better within one year of registering for this course. Participants may attempt take the final exam up to 10 times.