CPE PACKAGES (Incl. Ethics) for Multiple States and Qualifications @ $4/credit. CLICK HERE to view.

31 Spreadsheet Shortcuts in Microsoft Excel

  • CPA (CA)
  • CFEs
  • CMA
  • CPA (US)
  • CVA
  • Tax Preparer
  • SHRM
31 Spreadsheet Shortcuts in Microsoft Excel

1.5 Credits

FREE

Subject Area

Computer Software and Applications

Webinar Qualifies For

1.5 CPE credit of Computer Software & Applications for all CPAs

1.5 CPE credit for Certified Management Accountants (CMA)

1.5 PDC credit for SHRM Certified Professionals (Approval No. 21-4SRET)

1.5 CPD credit (Verifiable) for Canadian CPAs

1.5 CPE credit for Certified Fraud Examiners (CFEs)

1.5 CPD credit (Verifiable) for Certified Valuation Analyst (CVA)

1 CE credit of Computer Technology for Maryland Tax Preparers

1.5 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Course Description

Are you working on Excel? Or is it working for you? In this online CPE webinar Excel expert David H. Ringstrom, CPA shares nearly three dozen different shortcuts for reclaiming your day in Excel. David will cover keyboard shortcuts, mouse techniques, and will show you how to unearth hidden features within Microsoft Excel. He also offers an open forum for questions, so feel free to share what’s slowing you down in Excel.

David demonstrates every technique at least twice in this continuing education course: first, on a PowerPoint slide with numbered steps, and second, in the Microsoft 365 (formerly known as Office 365) version of Excel. David draws your attention to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during the online webinar as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the online continuing education course.

Microsoft 365 is a subscription-based product that provides new feature updates as often as monthly. Conversely, the perpetual licensed versions of Excel have feature sets that don’t change. Perpetual licensed versions have year numbers, such as Excel 2019, Excel 2016, and so on.

Highlights of the online CPE webinar : 
  • Applying formatting to multiple locations within a worksheet by way of the Format Painter feature.
  • Avoiding frustration by understanding the nuances between Enter and Edit modes.
  • Capitalizing on keyboard shortcuts to make navigating within a table easier.
  • Creating a shortcut to allow you to clear the decks in Excel by closing all open documents at once.
  • Enabling a hidden keyboard shortcut for toggling the Freeze Panes feature on or off.
  • Leveraging Excel’s Quick Access Toolbar to create a shortcut that enables you to filter lists with a keystroke instead of multiple mouse actions.
  • Restoring “classic” Print Preview functionality in Excel 2010 and later.
  • Simplifying repetitive tasks by creating your own keyboard shortcuts.
  • Streamlining redundant data entry with a handy keyboard shortcut.
  • Streamlining repetitive tasks by way of Excel’s Quick Access Toolbar.
  • Streamlining the process of printing spreadsheets to .PDF format.
  • Striking through list items with a custom shortcut.
  • Toggling the locked status of a worksheet cell on or off by way of a custom shortcut.
  • Using keyboard shortcuts to enter the current date or time.
  • Utilizing keyboard shortcuts to identify precedent and dependent worksheet cells.

Click for more webinars on Accounting | Taxes | Finance | Financial Planning etc

Learning Objectives

  • To identify the command that you use to active Quick Access Toolbar shortcuts.
  • To state which keyboard shortcut displays the Format Cells dialog box.
  • To recall the keyboard shortcut for selecting the current region within an Excel worksheet.

Who Should Attend?

  • Accountant
  • Accounting Firm
  • Accounting Managers
  • Accounting Practice Owners
  • Bank Managers
  • Compliance Managers
  • CPA (Industry)
  • CPA - Mid Size Firm
  • CPA - Small Firm
  • Entrepreneurial Accountant
  • Finance Pros
  • Innovation Manager/Director
  • IT Managers
  • Risk Managers
  • Senior Accountant
  • Staff of Accounting Firm
  • Tax Accountant (Industry)
  • Tax Managers
  • VP Accounts
  • Young CPA

Testimonial

Array
(
    [average] => 4.5649
    [no_of_record] => 1425
)
 

4.6

(1425)
63%
32%
5%
0%
0%

LC

The webinar was fantastic! I considered myself a pretty advanced Excel user, but I was unaware of many of the tips shared during this webinar.....great content!!!

WMW

The instructor made the content and examples easy to understand and follow. He didn't use acronyms or unfamiliar verbiage when explaining formulas and sequences, which I highly appreciate...coming from a healthcare background.

JM

Instructor was very knowledgeable and had a good tone throughout.

CP

Great!

SH

It was extremely helpful.

PW

Great! I always enjoy and learn so much from these programs!