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

31 Spreadsheet Shortcuts in Microsoft Excel

  • CPA (CA)
  • CMA
  • CPA (US)
  • CVA
  • Tax Preparer
  • SHRM
  • CFE
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 PDC credit for SHRM Certified Professionals (Approval No. 21-4SRET)

1.5 CPD credit (Verifiable) for Canadian CPAs

1 CE credit of Computer Technology for Maryland Tax Preparers

1.5 General Educational credit for Tax Professionals / Bookkeepers / Accountants

Upcoming Webinars

Cyber Incident & Response–An Interview with former United States Attorney Jay Town

(20)

Oct 22, 2021 | 04:00 PM EDT View Details

Best investments and investment strategies

(99)

Oct 22, 2021 | 04:00 PM EDT View Details

Financial Intelligence for Entrepreneurs, Executives, and Directors

(1)

Oct 25, 2021 | 09:00 AM EDT View Details

Are You Ready for a Capital Campaign?

Oct 25, 2021 | 09:00 AM EDT View Details

Differences between IFRS and GAAP

(16)

Oct 25, 2021 | 09:30 AM EDT View Details

Corporate External Financial Reporting Decisions

(17)

Oct 25, 2021 | 10:00 AM EDT View Details

Everything You Need to Know About Partnerships

(13)

Oct 25, 2021 | 10:00 AM EDT View Details

Basis Calculations & Distributions For Pass-thru Entity Owners Schedule K-1 Analysis (Latest)

(122)

Oct 25, 2021 | 10:00 AM EDT View Details

Basic Concepts of Fixed Asset Accounting

(4)

Oct 25, 2021 | 10:00 AM EDT View Details

Excel Accountant: Internal Control

(6)

Oct 25, 2021 | 10:00 AM EDT View Details

Real Estate Tax Strategies: Cost Recovery, Partial Dispositions, Removal Cost, Int. Deductions, Repairs & Capital Improvements

(20)

Oct 25, 2021 | 10:00 AM EDT View Details

The Structure and Organization of the IRS

(745)

Oct 25, 2021 | 10:00 AM EDT View Details

Federal Tax Update – Individual & Business Current Developments

(10)

Oct 25, 2021 | 10:00 AM EDT View Details

IRS Form 1099 Reporting Req. including updates on FORM 1099-NEC (LATEST 2021)

(272)

Oct 25, 2021 | 10:00 AM EDT View Details

Money Laundering Risks and Countermeasures for Accountants and Other Professionals

(9)

Oct 25, 2021 | 10:30 AM EDT View Details

Course Description

Are you working Excel? Or is it working you? In this presentation 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: 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 presentation as well as in his detailed handouts. David also provides an Excel workbook that includes most of the examples he uses during the webcast.

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 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.

Learning Objectives

  • Identify the command that you use to active Quick Access Toolbar shortcuts.
  • State which keyboard shortcut displays the Format Cells dialog box.
  • 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

4.6

(1525)
63%
32%
5%
0%
0%

BK

Practical and relevant Excel tips!

LF

Very useful information. Utilized some of it the same day as the course

BB

Overall the webinar was really fantastic. The presenter was great and possessed the skills and competencies for this program. He was knowledgeable and was able to answer questions on the spot. A very good lecturer.

JM

I learned a lot from this webinar. I felt the handout was a bit confusing. When the instructor went through it, it was clear, but I felt like the handouts could have been more user friendly for after the webinar when I want to go back and review.

TH

Good

NT

great tips, really enjoyed this