Home
0
Home
Use Landscape to see Search/Filter
Item Types:
Field of Study:
Authors:
CPE Hours:
Keyword:
Course Details

Agile Excel: Spreadsheet Pranks - Webinar - 17-Feb-2020 at 2pm ET (Course Id 1613)

New / QAS / Registry
Author : David Ringstrom, CPA
Status : Production
CPE Credits : 1.0
IRS Credits : 0
Price : $0.00
Passing Score : 70%
NASBA Technical: No
Primary Subject-Field Of Study:

Computer Software & Applications - Computer Software & Applications for Course Id 1613

Description :

In this somewhat whimsical presentation, Excel expert David H. Ringstrom, CPA, will share with you several Excel features that can be used for good or bad. The more we understand what’s possible in Excel, the easier it becomes to learn even more about spreadsheets. Techniques range from setting a default font for spreadsheets in two different ways, randomizing the months of the year, temporarily making workbooks invisible, and hiding portions of—or even the entire Excel menu. The goal of this presentation is to spark thoughts along the lines of, “Well, if Excel can do that, how do I do this?” You’ll also gain a better sense of how to recover from situations when Excel exhibits odd behavior when certain settings get changed inadvertently.

David demonstrates every technique at least twice: first, on a PowerPoint slide with numbered steps, and second, in Excel 2019. David draws your attention to any differences in the older versions of Excel (2016, 2013, and earlier) during the presentation as well as in his detailed handouts. You’ll also discover some features only available in Office 365 but not in Excel 2019. David also provides an Excel workbook that includes most of the examples used 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.

Usage Rank : 0
Release : 2019
Version : 1.0
Prerequisites : Prior Experience Working with Excel Spreadsheets.
Experience Level : Overview
Additional Contents : Complete, no additional material needed.
Advance Preparation : None.
Delivery Method : Group Internet Based
Intended Participants : Anyone needing Continuing Professional Education (CPE).
Revision Date : 14-Mar-2018
NASBA Course Declaration : Participants must complete the final examination within one year of purchase and with a minimum passing grade of 70% or better to receive CPE credit unless otherwise noted on the Course History page (i.e. California Ethics must score 90% or better). After logging in click on the Course History links on your My Courses page for the Begin date and Expire date for the Final Exam.
Approved Audience :

NASBA QAS - NASBA Registry - 1613

Keywords : Computer Software & Applications, Agile, Excel, Spreadsheet, Pranks, Webinar, cpe, cpa, online course
Learning Objectives :

Course Learning Objectives

  • Identify how to specify the number of worksheets that appear when a new workbook is created.
  • State the location of the Custom Lists feature within Excels menu interface.
  • Describe how to enable or disable the R1C1 reference style in Excel.

  • Course Contents :

    Upon successful completion of this webinar, you should be able to:

            Identify how to specify the number of worksheets that appear when a new workbook is created.

            State the location of the Custom Lists feature within Excels menu interface.

            Describe how to enable or disable the R1C1 reference style in Excel.

    Home page : https://www.cpethink.com/
    Thank you for taking one of our free courses. We would like to be able to let you know when we add free courses or have special offers and will never spam you or share your address with anyone. If you are Ok with that please reply with "Ok" or if not please reply "No Thanks". Either way enjoy your free CPE course.
      
    Exam completed on .

    Do you want to add the course again?