1. Aurora Training Advantage
  2. Live Webinars
  3. Excel 101: Spreadsheet Basics

Live Webinar Series

Excel 101: Spreadsheet Basics

Webinar Details$219

  • Webinar Date: January 21, 2020
  • Webinar Time: 2:00pm - 3:40pm EST  live
  • Guest Speaker:  David Ringstrom
  • Industry:  Business Administration, Business Skills, Finance, Software, Taxation and Accounting
  • Credit: CPE 2.0

  • Register Now

If Excel spreadsheets are new to you, or if you haven’t used a spreadsheet in years, this webcast is just what you need. Excel expert David Ringstrom begins with the basics and takes you through the process of building functional spreadsheets and then working with them efficiently and effectively.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in the subscription-based 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.
 
Office 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.

Topics typically covered:

  • Bring Excel’s green error-checking prompts under control by managing the underlying rules.
  • Get a jump start on spreadsheet projects by using free, prebuilt templates in Excel.
  • Get an overview of the different types of files you can create in Excel.
  • Get oriented with Excel’s grid of rows and columns.
  • Jump-start data visualization with the Quick Analysis feature.
  • Learn the nuances of copying formulas within Excel spreadsheets.
  • Manage column widths within your spreadsheets.
  • Master Excel’s order of operations for mathematical formulas.
  • Navigate large workbooks with ease by way of a hidden menu as well as keyboard shortcuts.
  • Never type $ signs manually in a formula again; use a keyboard shortcut instead.
  • Simplify repetitive tasks by creating your own keyboard shortcuts.
  • Understand how to enter dates in an Excel spreadsheet.
  • Wrangle long lists of data by filtering instead of sorting.

Learning objectives:

  • Skip confusing menus by way of time-saving mouse tricks and keyboard shortcuts.
  • Learn structural basics about Excel worksheets and workbooks.
  • Master some basic data-analysis techniques.

Guest Speaker

David Ringstrom

David Ringstrom

David H. Ringstrom, CPA, is an author and nationally recognized instructor who teaches scores of webinars each year. His Excel courses are based on over 25 years of consulting and teaching experience. David’s mantra is “Either you work Excel, or it works you,” so he focuses on what he sees users don’t, but should, know about Microsoft Excel. His goal is to empower you to use Excel more effectively. To learn more about David, you can view his LinkedIn profile and follow him on&nbsp... View Full Profile

CPE Credit

Aurora Training Advantage is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.

For more information regarding administrative policies such as complaint and refund, and cancellation please contact our offices at 407-542-4317 or training@auroratrainingadvantage.com.