IRS Form 1099, 1099-NEC, and Form 1099-MISC: Advanced Issues and Updates

Basic Excel® Skills for Accountants (OnDemand Webinar)

$199.00

SKU: 409012EAU

Description

Gain insight into applicable Excel fundamentals that will improve the accuracy and efficiency of your spreadsheets.In this comprehensive topic, you will learn applicable Excel fundamentals that will enable accounting professionals to achieve those goals. Stepbystep, this information demonstrates and explains several alternatives to Excel’s SUM function, including conditional summing a better alternative to manually hidingunhiding rows and columns automating repetitive tasks by way of Excel’s Table feature, including creating selfexpanding charts contrasting the Table feature with Data Tables and PivotTables helpful keyboard shortcuts and ways to repair damaged Excel workbooks. This topic demonstrates every technique at least twice first, on a PowerPoint slide with numbered steps, and second, in the subscriptionbased Office 365 version of Excel. Your attention is drawn to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during this topic. An Excel workbook is provided that includes most of the examples used. Office 365 is a subscriptionbased 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.

Date: 2021-05-10 Start Time: End Time:

Learning Objectives

Inserting Totals Into Lists With a Few Mouse Clicks by Way of Excel’s® SUBTOTAL Function

Learning a Simple Design Technique That Greatly Improves the Integrity of Excel’s® SUM Function

Summing Disparate Sections of a Spreadsheet Quickly With the SUBTOTAL Function

Comparing the AGGREGATE Function in Excel® 2010 and Later to the SUBTOTAL Function Available in All Versions of Excel®

Employing the SUMIF Function to SUM Values Related to Multiple Instances of Criteria You Specify

Using the SUM Function to Drill Through Two or More Worksheets

Using the SUMIF Function to Sum Values Based on Multiple Criteria

Eliminating the Need to Manually Resize Charts When Data Is Added-Automate This With Tables Instead

Avoiding the Need to Write Repetitive Formulas Using Excel’s® Data Table Feature

Managing Cumbersome Lists of Data Using the Table Feature

Removing the Table Feature From a Worksheet If It’s No Longer Needed

Streamlining the Filtering of Lists in Excel® 2013 and Later by Using the Slicer Feature With Tables

Learning How the Table Feature Empowers You to Improve the Integrity of Excel® Spreadsheets

Understanding the Data Integrity Risks Posed by Pivot Tables When Users Add Additional Data to the Original Source List

CPE ,Additional credit may be available upon request. Contact Lorman at 866-352-9540 for further information.

David H. Ringstrom, CPA-Accounting Advisors, Inc.

IRS Form 1099, 1099-NEC, and Form 1099-MISC: Advanced Issues and Updates

Basic Excel® Skills for Accountants (OnDemand Webinar)

$199.00

SKU: 406835EAU

Description

Gain insight into applicable Excel fundamentals that will improve the accuracy and efficiency of your spreadsheets.
In this comprehensive topic, you will learn applicable Excel fundamentals that will enable accounting professionals to achieve those goals. Stepbystep, this information demonstrates and explains several alternatives to Excel’s SUM function, including conditional summing a better alternative to manually hidingunhiding rows and columns automating repetitive tasks by way of Excel’s Table feature, including creating selfexpanding charts contrasting the Table feature with Data Tables and PivotTables helpful keyboard shortcuts and ways to repair damaged Excel workbooks. This topic demonstrates every technique at least twice first, on a PowerPoint slide with numbered steps, and second, in the subscriptionbased Office 365 version of Excel. Your attention is drawn to any differences in the older versions of Excel (2019, 2016, 2013, and earlier) during this topic. An Excel workbook is provided that includes most of the examples used. Office 365 is a subscriptionbased 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.

Date: 2020-01-22 Start Time: End Time:

Learning Objectives

Inserting Totals Into Lists With a Few Mouse Clicks by Way of Excel’s® SUBTOTAL Function

Learning a Simple Design Technique That Greatly Improves the Integrity of Excel’s® SUM Function

Summing Disparate Sections of a Spreadsheet Quickly With the SUBTOTAL Function

Comparing the AGGREGATE Function in Excel® 2010 and Later to the SUBTOTAL Function Available in All Versions of Excel®

Employing the SUMIF Function to SUM Values Related to Multiple Instances of Criteria You Specify

Using the SUM Function to Drill Through Two or More Worksheets

Using the SUMIF Function to Sum Values Based on Multiple Criteria

Eliminating the Need to Manually Resize Charts When Data Is Added-Automate This With Tables Instead

Avoiding the Need to Write Repetitive Formulas Using Excel’s® Data Table Feature

Managing Cumbersome Lists of Data Using the Table Feature

Removing the Table Feature From a Worksheet If It’s No Longer Needed

Streamlining the Filtering of Lists in Excel® 2013 and Later by Using the Slicer Feature With Tables

Learning How the Table Feature Empowers You to Improve the Integrity of Excel® Spreadsheets

Understanding the Data Integrity Risks Posed by Pivot Tables When Users Add Additional Data to the Original Source List

David H. Ringstrom, CPA-Accounting Advisors, Inc.