Excel Bootcamp Virtual

You Pay: $379.00
MSCPA Members save $100.00 on this course. Login or Join to take advantage of these savings.
This course is 8.00 credits
Field of Study
Technology
Course Level
Intermediate
Vendor
CPA Crossings LLC

Registration Fees

MSCPA-AICPA Member
$279.00
MSCPA Member
$279.00
AICPA Member
$379.00
Non-Member
$379.00
Return to Course List

Tuesday, Oct 27, 2020
8:45am – 4:30pm

Due to the ongoing COVID-19 (coronavirus) pandemic, the MSCPA has made the difficult decision to make our scheduled live seminars in 2020 virtual-only events. The topics, dates, times and CPE credits will remain the same, and you will learn from the same top-level speakers that you expected to see at our live programs

Whether you are relatively new to the accounting profession or have been around for many years, there is a good chance that you are developing your Excel spreadsheets the hard way and leaving them susceptible to errors and omissions of important data. This course is designed to teach you the fundamentals of good spreadsheet design that will increase your accuracy and efficiency when creating Excel workbooks. You will also learn how to perform powerful data analysis using Excel. It will be well worth attending this course because of all the time it will save you in building your spreadsheets and analyzing your data. This is a fast-paced course that is sure to provide valuable knowledge to every Excel user. Note: Computers will not be provided, so if you want to apply the concepts presented "hands-on," you will need to bring your own PC with Excel pre-installed. Excel practice files will be provided.

Course Objectives

The key topics that will be covered in this course:  Building your spreadsheets for maximum efficiency and accuracy  The most popular functions and formulas  How to audit your spreadsheets to detect errors in formula logic  How to analyze your data with PivotTables and Excel's Power BI tools  Tools for presenting your spreadsheets in a meaningful way

Major Subjects

Upon completing this course, you will.  Design spreadsheets with greater efficiency and accuracy  Understand how to use advanced Excel functions  Use auditing techniques to build more accurate spreadsheets  Use advanced analytical tools to summarize detailed data  Make your spreadsheets more professional in appearance

Prerequisites

Good understanding of Excel

Registrants

+ $379.00

Search for and register other people in our database:

Add Person
Click above and type the first 3 letters of the person's name to search. Search may take 2-5 seconds.

Confirm E-Materials Only

One or more individuals have "e-materials only" selected and will not receive a hard copy for courses indicated. Please confirm this choice by pressing “Confirm” or press "Cancel" and unselect “No hard copy” to receive a hard copy.

Can't find the right person? Add them to our database

The MSCPA or its contractors may photograph or videotape MSCPA events. Attendees agree to allow their image to be used in MSCPA publications, website and marketing materials. Images may also be shared with the media. Attendance at MSCPA events waives the MSCPA from liability resulting from these uses. For questions, contact the MSCPA at mscpa@mscpaonline.org or call 617.556.4000.
Printer-friendly registration form