Log In to Register

**There may be a delay in receiving your certificate, please allow up to 1 week from the date of your course**

Please note that this webinar Is from a third party vendor, CPA Crossings. We strongly recommend registering no later than one-hour before the webinar begins. Please contact CPA Crossings webinar hotline if you do Not receive your webinar invitation via email within five minutes after registering:  877-370-2220 ext. 1. Thank you.

Date(s):

09/20/2024

Registration Open:

12:00 AM - 8:00 AM

Time:

8:00 AM - 4:00 PM

Facility:

Online

Meeting Type:

Webinars

CPE Credit:

8.00

Field(s) Of Study:

Computer Software and Applications (8.00)

Level of Knowledge:

Basic

Price:

Member: $239.00
Nonmember: $259.00

Individual Discounts:

Not Available

Overview

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

  • Understand the many keyboard shortcuts that are available to save time and effort
  • Use Excel Templates, Styles, and Themes to add uniformity to workbooks they design or edit
  • Design custom number and date formats to meet their specific needs
  • Add security to the workbooks they use. This includes workbook encryption, and the use of sheet level, range level and cell level security features
  • Understand formula building conventions such as order of operation
  • Troubleshoot formulas that are not working properly
  • Work with functions in the function library to create powerful formulas

Highlights

The major topics covered in this course include:
  • Excel shortcuts and time savers
  • Working with templates, formats, styles, and themes
  • Customizing and enhancing Excel
  • Protecting and securing workbooks
  • Formula building and the Excel function library

Note: This session is taught using a Hands-On methodology. We provide practice files that tie to the examples in the course materials so participants can undertake all the steps in unison with the instructor.

Prerequisites

A basic understanding of Excel conventions