Print Page   |   Contact Us   |   Sign In   |   Join
Excel Boot Camp (130-16)
Tell a Friend About This EventTell a Friend
 

If you are ready for two days of intensive Excel training in a “laptop optional, laptop friendly” environment, then this course is for you. By using accounting-centric examples, developed for accountants, by accountants, Excel Boot Camp takes you through Excel from A to Z and shows you how to elevate your use of Excel to the next level.

11/9/2016 to 11/10/2016
When: November 9-10, 2016
7:30 AM
Where: UACPA Training Room
136 South Main Street, Suite 510
Salt Lake City, Utah  84101
United States
Contact: April Deneault
801-466-8022


Online registration is closed.
« Go to Upcoming Event List  

Acronym EBC16
CPE 16 hours
Category
Info Tech
Level Intermediate
Vendor K2 Enterprises
Who should attend

Excel users and potential Excel users who want to increase their efficiency and effectiveness with Excel

Prerequisite
Fundamental knowledge of Excel 2007 or higher
Fees: Early Bird
(through 10/26)
Standard
(after 10/26)
Member $414 $460
Non-Member: N/A
$550

The Member rate applies to UACPA members and reciprocal state society members. To register online, use the ‘Register’ button above. To register by phone, call the UACPA at 801.466.8022, Monday through Friday, 8am to 4pm.

Description 

If you are ready for two days of intensive Excel training in a “laptop optional, laptop friendly” environment, then this course is for you. By using accounting-centric examples, developed for accountants, by accountants, Excel Boot Camp takes you through Excel from A to Z and shows you how to elevate your use of Excel to the next level.

In addition to long-standing features in Excel such as lookup functions, the Camera tool, and formatting options, this program will highlight the number of recent improvements to Excel including additions to the function library, tables, a vastly improved charting engine, and an overhaul of PivotTable functionality. You will also learn various techniques for enhancing, not only your efficiency, but also your effectiveness, when working with Excel by taking advantage of a wide variety of “power features” to assist you in creating accurate spreadsheets in a fraction of the time previously required.


Objectives

  • Implement various tips, tricks, and techniques in Excel to address issues, such as formatting, AutoCorrect, handling dates and times, and selecting cells with special characteristics
  • Utilize Excel’s formula-building tools
  • Identify how and when Excel’s table feature should be used
  • Create and audit complex formulas, including those containing arrays and SUMIFS,  VLOOKUP, HLOOKUP, INDEX, and MATCH functions
  • List and apply various techniques for securing Excel workbooks
  • Create charts in Excel that captivate audiences and communicate messages effectively
  • List the six components of PivotTables and create PivotTables, including PivotTables that perform user-defined calculations
  • Implement Excel’s Camera function to assist in creating custom reports
  • Utilize Excel’s Macro Recorder tool to create simple, yet very useful, macros that you can put to work right away

 

 

Membership Management Software Powered by YourMembership  ::  Legal