Excel Boot Camp Refresher

Description

CPAs who work with Excel every day will benefit from these topics and tips which include: protecting features, range naming, decision-making IF and VLOOKUP functions, financial functions, Pivot Table reporting, controlling calculation inputs, securing files, formula auditing, external formula linking, business graphics, linking Excel data and graphs to Word, many multiple worksheet and consolidation tips, time-saving usage of the macro recorder and Visual Basic tips. Even if you thought you knew it all in Excel, this course will advance your knowledge. Many immediately applicable tips are incorporated into this 2-day course. Participants will receive take-aways for after class use. Topics covered apply to Excel 2016, 2013, and 2010. 

Please note this course will be hands-on. We recommend bringing your own laptop to this program with excel loaded. You can attend without one but you would not be able to participate during the hands on exercises.

Learning Objectives
  • Experience hands-on learning and gain a thorough understanding of how to: Protect your work in Excel
  • Troubleshoot for worksheet calculation errors
  • Apply a wide variety of data analysis tools and features significant to CPAs
  • Compare and contrast which data analysis tool applies best to a particular set of data
  • Incorporate techniques to consolidate and link worksheets
  • Effectively use business graphics to present data
  • Use a wide variety of Excel functions for financial and other calculations, test data for accuracy, use IF and VLOOKUP variations
  • Effectively link Excel data to Word
  • Use macros to automate repetitive steps for data cleanup and reporting
Provider
SCG Training & Consulting
Course Level
Intermediate
Professional Area of Focus
Business & Industry
Technology
CPE Field of Study
Computer Software & Applications
8
Instructor(s)
Judith Borsher
Prerequisites

Fundamental knowledge of Excel

Advanced Preparation

None

Location

Loyola University Maryland Graduate Center Columbia Campus, 8890 McGaw Rd Columbia, MD 21045-4743

View in Google Maps
Register Now
When
Feb 20, 2019
8:00 am - 3:30 pm
Location
Loyola University Maryland Graduate Center Columbia Campus, 8890 McGaw Rd Columbia, MD 21045-4743
Total CPE Credits
8
Format
In-Person
Instructor
Judith Borsher

MEMBER


$ (% off)
$280.00
Price includes $50 early registration discount(s) - expires 01/20/2019
Price increases to $330.00 on 01/21/2019

NON-MEMBER


$ (% off)
$430.00
Price includes $50 early registration discount(s) - expires 01/20/2019
Price increases to $480.00 on 01/21/2019
Become A Member

Register for this Event

Excel Boot Camp Refresher


Loading
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×