Live Webinar or Recording
January 18, 2019
1:00 pm - 2:40 pm Eastern
Credit: CPE: 2 (Live Only)

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, CPA, begins with the basics and takes you through how to build and work with Excel spreadsheets efficiently and effectively. After participating in this webcast, you’ll be empowered to create functional spreadsheets and manipulate long lists of data.

David’s courses are fast-paced, and attendees often are surprised at the amount of ground he covers in a session. He welcomes participants’ questions, so come ready to pick his brain. His detailed handouts serve as reference tools you can fall back on after participating in one of his webcasts. In addition, he provides an Excel workbook that includes a majority of the examples he uses during each session.

David’s materials cover Excel 2016, 2013, 2010, and 2007. He teaches from the version of Excel the majority of attendees are using.

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

Level: Basic
Format: Live Webcast
Field of Study: Computer Software & Applications
Program Prerequisites: None
Advanced Preparation: None

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.