Events Search
  Summary & Check Out (0)
Thursday, April 11, 2024 Live Webcast

Excel for Staff Level 1 - What You Never Learned (X2-42572)

3:30 PM - 5:30 PM EDT
webcast

Vendor Platform

2 CPE Credits in SK

OVERVIEW

Most Staff Accountants learned Excel in college and many others learned Excel on their own, however most users never learned the important productivity tips that help them build spreadsheets more efficiently. This course will teach new and experienced users how to leverage the many productivity tools built within Excel in order to build spreadsheets with maximum effectiveness.

DESIGNED FOR

Any Excel user that wants to learn the "real" basics of Excel that will increase their productivity.

BENEFITS

After attending this presentation, you will be able to...

  • Identify all the ways you can select cells and ranges
  • Recall ways to leverage custom number formats
  • Recognize the importance of proper worksheet structure

HIGHLIGHTS

The major topics that will be covered in this class include:

  • Navigating around worksheets
  • Selecting cells and ranges
  • How to use custom number formatting
  • How to leverage Views
  • How to build better formulas with

COURSE LEVEL

Basic

PREREQUISITES

None

ADVANCE PREPARATION

None

INSTRUCTOR

Bryan Smith

Bryan L. Smith, CPA.CITP, CISA

CPA Crossings, LLC

Bryan is the co-founder of CPA Crossings, LLC, (est. 2001), which specializes in helping accounting, tax and financial professionals leverage technology to increase the quality and efficiency of their services.

He has extensive knowledge and experience in proper Excel design techniques as well as helping CPAs build spreadsheets that are accurate. As a Certified Information Systems Auditor (CISA), Bryan has spent a considerable amount of time auditing and validating thousands of Excel spreadsheets. He has developed various data analysis and Microsoft Power BI courses and provides coaching services to various organizations to train and coach staff on proper data analysis techniques.

Bryan, who has a Master of Science in Information Assurance, is a member of the Information System Audit and Control Association and is a past chair of task forces for the Michigan Association of CPAs.