31 Spreadsheet Shortcuts in Microsoft Excel

4.4 (251)

David Ringstrom, CPA

Excel Accountant

Monday, December 21, 2020 | 02:00 PM EST

  • CPA
  • CMA
  • CPA(Canada)

Credits: 1.5 CPE | 1.5 CPD

FREE

Subject Area

Computer Software and Applications

Webinar Qualifies For

1.5 CPE credit of Computer Software & Applications for all CPAs

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

excel accountant: filtering data

Jan 18, 2021 | 09:30 AM EST View Details

basis calculations & distributions for pass-thru entity owners schedule k-1 analysis (latest)

(74)

Jan 18, 2021 | 10:00 AM EST View Details

qbo: banking feed and reconciling - make rules & automate

(19)

Jan 18, 2021 | 10:00 AM EST View Details

forensic accounting : value added skill for every accountant

(20)

Jan 18, 2021 | 10:00 AM EST View Details

how to maneuver new irs partnership audits

(4)

Jan 18, 2021 | 10:00 AM EST View Details

schedule c - form 1040 (2020)

(2537)

Jan 18, 2021 | 10:00 AM EST View Details

fraud update - latest 2020

(37)

Jan 18, 2021 | 10:00 AM EST View Details

best overview on individual tax updates 2020 (basic)

(88)

Jan 18, 2021 | 10:00 AM EST View Details

yellow book boot camp - nfp and governmental accounting & auditing update

(3)

Jan 18, 2021 | 10:00 AM EST View Details

corporate budget analysis best practices

(2)

Jan 18, 2021 | 10:30 AM EST View Details

how to strategize your firm’s growth and expand margins in the new world

(302)

Jan 18, 2021 | 10:30 AM EST View Details

passive activity loss limitations: working with the complex pal rules & real estate tax issues.

(44)

Jan 18, 2021 | 08:00 AM PST View Details

annual federal tax update - individuals (form 1040)

(153)

Jan 18, 2021 | 08:00 AM PST View Details

corporate external financial reporting decisions

(33)

Jan 18, 2021 | 08:00 AM PST View Details

corporate accounting & auditing best practices

Jan 18, 2021 | 08:00 AM PST 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?

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

Testimonial

4.4

(251)
53%
39%
7%
1%
0%

LM

Informative

CA

nice job

EM

I really enjoyed it!

BL

Excellent tips to increase knowledge of Excel at any level.

LW

Ok

DG

Very good seminar