K2's Technology Update

K2's Technology Update

K2’s Technology Update

Information Technology
4 CPE Credits
Course - K2's Tech Update
23s-tup-4
Webinar
Live
Basic
200 Minutes
Topics Learning Objectives Description Compliance

Major Topics

  • Developments in hardware and software
  • Options for communicating and collaborating more effectively
  • Addressing cybersecurity issues

Learning Objectives

  1. Identify major hardware trends and software developments
  2. List examples of technologies that can improve communications and data transfers
  3. Differentiate between various communication tools and platforms
  4. List key security issues and identify appropriate responses

Description

Which technology trends will impact you and your business? What emerging technologies will potentially help you to address security and efficiency? How will the emergence of Windows 11 affect you? Should you consider subscription-based software? What does the future of communication technology have in store for you? Get answers to these and other questions by participating in K2’s Technology Update, a four-hour review of technology trends and developments affecting virtually all business professionals.

In this session, you will learn about significant issues such as:
• Hardware trends,
• Software innovations,
• Communication and collaboration tools,
• Security issues and solutions,
• Key products to consider for implementation, and
• Unusual and emerging technologies you may have missed.

If you’re taking just one technology-focused training session this year, this should be it!

Compliance Information

Business professionals and advisors seeking to learn more about technologies impacting accounting and financial professionals None Information Technology 4 Credits November 2, 2022
Topics

Overview

Which technology trends will impact you and your business? What emerging technologies will potentially help you to address security and efficiency? How will the emergence of Windows 11 affect you? Should you consider subscription-based software? What does the future of communication technology have in store for you? Get answers to these and other questions by participating in K2’s Technology Update, a four-hour review of technology trends and developments affecting virtually all business professionals.

In this session, you will learn about significant issues such as:
• Hardware trends,
• Software innovations,
• Communication and collaboration tools,
• Security issues and solutions,
• Key products to consider for implementation, and
• Unusual and emerging technologies you may have missed.

If you’re taking just one technology-focused training session this year, this should be it!

Course Details

  • PivotTable fundamentals, including Recommended PivotTables and the six elements of PivotTables
  • Formatting PivotTables
  • Advanced PivotTable techniques and options, including consolidation PivotTables, user-defined calculations, and working with Power Pivot
  • Analytical techniques available in PivotTables

  1. Identify the six main elements of a PivotTable report and their use when creating PivotTables
  2. Create PivotTables and manipulate data in PivotTables using grouping techniques, modified Field Settings, user-defined calculations, and sorting and filtering options
  3. Import and link data from external data sources into PivotTables; additionally, use Tables and Data Models as data sources for PivotTables
  4. Create Consolidation PivotTables to consolidate data from multiple data sources in Excel
  5. Construct PivotTables in enterprise-class organizations using Power Pivot and Slicers
  6. Analyze data in PivotTables using tools and techniques, such as sorting, filtering, and Excel’s GETPIVOTDATA function
  7. Apply specific PivotTable methods to solve problems in areas of PivotTable formatting, creating multiple PivotTables from a single data source, grouping PivotTable data into fiscal reporting periods, and keeping PivotTable row order intact

Intended Audience — Accounting and financial professionals who want to use the power of Excel PivotTables to analyze and summarize data

Advanced Preparation — None

Field of Study — Accounting, Computer Software and Applications

Credits — 8 Credits

IRS Program Number –

Published Date – November 2, 2022

Revision Date –

Course Authors

No items found