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

Excel® Power Tips and Shortcuts (OnDemand Webinar)

$149.00

SKU: 410708EAU

Description

Learn powerful productivityboosting tips and secrets that will speed up your work in Excel and remove some of those hairtearingout moments.This course will cover the benefits of using tables to store listbased data. We will demonstrate how to create a table and add, delete, and modify data within a table. We will also discuss the advantages of using tables over traditional ranges, including automatic formatting, sorting, and filtering. We will demonstrate how to create a pivot table and show how to summarize and analyze large amounts of data using pivot tables. Learn various timesaving data entry shortcuts for entering data in Excel and how to use data across worksheets and workbooks, including how to use formulas to link data between worksheets, how to use 3D references to summarize data across multiple worksheets, and how to use external references to link data between workbooks. We will also cover how to use conditional formatting to automatically format cells based on their values. We will demonstrate how to create rules to highlight cells that meet certain criteria, such as values above or below a certain threshold, duplicate values, or cells that contain specific text. Lastly, we will cover how to protect your spreadsheets from accidental or intentional changes. We will demonstrate how to lock cells or ranges to prevent users from editing them and how to passwordprotect your workbook to prevent unauthorized access.

Date: 2023-05-09 Start Time: End Time:

Learning Objectives

Tables: What Are the Benefits of Storing List-Based Data in a Table

Data Entry Shortcuts, Including Transpose, Autofill, and Flash Fill

Automating Cell Formatting With Conditional Formatting

Using Data Across Worksheets and Workbooks

Using Protection to ‘Bulletproof’ Your Spreadsheets

Summarize Your Data With a Simple Pivot Table

Mike Thomas-theexceltrainer.co.uk

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

Excel® Power Tips and Shortcuts (OnDemand Webinar)

$99.00

SKU: 407732EAU

Description

Learn simple Excel tricks and shortcuts that will make you instantly more proficient.Most Excel users are underutilizing this software. Start using the full power of Excel, and learn cool Excel tips and tricks that will make you the go to person in your office. Master more than 100 tips to make you a power user. This topic gives you a ton of productivity pointers. Get an immediate return on your investment as you learn powerful and efficient ways to save you hours every week. This topic will be presented using Excel 2010 with occasional references to Excel 2007.

Date: 2020-04-27 Start Time: End Time:

Learning Objectives

With a Single Keystroke Shortcut, You Can:
• Apply Currency, Date, Time, General, Percent or Scientific Formatting
• Display or Hide All Worksheet Formulas Instantly
• Create a Chart of Current Data, Complete With Legend and Scaling
• Add a New Worksheet to the Current Workbook
• Enter the Current Date or Time

Copy Formulas or Data Into Hundreds (Even Thousands) of Cells With a Double-Click

Copy or Move Data With Simple Dragging Instead of Multistep Command Sequence

Increase or Decrease Values in a Range Without Setting up Formulas

Convert Formulas to Values in One Step, Not Six

Create Double-Spaced Printouts Without Tediously Inserting Rows in Your Data

Navigate Seamlessly Through Workbooks and Worksheets With Keystroke or Mouse Shortcuts

Build Lists of Dates, Times or Values Without Using Lengthy Formulas or Commands

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

Dennis Taylor-Taylor Associates

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

Excel® Power Tips and Shortcuts (OnDemand Webinar)

$99.00

SKU: 406543EAU

Description

Learn simple Excel tricks and shortcuts that will make you instantly more proficient.
Most Excel users are underutilizing this software. Start using the full power of Excel, and learn cool Excel tips and tricks that will make you the go to person in your office. Master more than 100 tips to make you a power user. This topic gives you a ton of productivity pointers. Get an immediate return on your investment as you learn powerful and efficient ways to save you hours every week. This topic will be presented using Excel 2010 with occasional references to Excel 2007.

Date: 2019-11-06 Start Time: End Time:

Learning Objectives

With a Single Keystroke Shortcut, You Can:
• Apply Currency, Date, Time, General, Percent or Scientific Formatting
• Display or Hide All Worksheet Formulas Instantly
• Create a Chart of Current Data, Complete With Legend and Scaling
• Add a New Worksheet to the Current Workbook
• Enter the Current Date or Time

Copy Formulas or Data Into Hundreds (Even Thousands) of Cells With a Double-Click

Copy or Move Data With Simple Dragging Instead of Multistep Command Sequence

Increase or Decrease Values in a Range Without Setting up Formulas

Convert Formulas to Values in One Step, Not Six

Create Double-Spaced Printouts Without Tediously Inserting Rows in Your Data

Navigate Seamlessly Through Workbooks and Worksheets With Keystroke or Mouse Shortcuts

Build Lists of Dates, Times or Values Without Using Lengthy Formulas or Commands

Dennis Taylor-Taylor Associates