K2’s Working Remotely – The New Normal
Information Technology
4 CPE Credits
Major Topics
- Key technologies that facilitate remote work options
- Cybersecurity issues impacting remote work environments
- How to communicate and collaborate when working remotely
Learning Objectives
- Differentiate between options for remotely accessing your computer, applications, and data
- Identify recommended security practices for remote access and related tools and services
- List examples of Cloud-based services and suites that can contribute to working remotely
- Distinguish between communication and collaboration tools for remote workers
Description
Many team members now work remotely, whether by choice or necessity. As a result, questions abound about remote access to desktops and data, security, communications, collaboration, and other considerations in this new normal. When implemented correctly, remote work strategies can be a “win-win” for all involved; however, failed implementations may lead to inefficiencies, security issues, and dissatisfied team members.
This session will teach you today’s best practices for working remotely. Specifically, you will learn about various remote access tools, communication and collaboration options, and security best practices. You will also learn about managing and monitoring workflows in remote work environments and tools you can use. After completing this session, you can implement a remote work strategy that yields efficiency, security, and satisfaction to all involved.
Compliance Information
Overview
Many team members now work remotely, whether by choice or necessity. As a result, questions abound about remote access to desktops and data, security, communications, collaboration, and other considerations in this new normal. When implemented correctly, remote work strategies can be a “win-win” for all involved; however, failed implementations may lead to inefficiencies, security issues, and dissatisfied team members.
This session will teach you today’s best practices for working remotely. Specifically, you will learn about various remote access tools, communication and collaboration options, and security best practices. You will also learn about managing and monitoring workflows in remote work environments and tools you can use. After completing this session, you can implement a remote work strategy that yields efficiency, security, and satisfaction to all involved.
Course Details
- Collaboration and security techniques
- Tables, data models, and PivotTables
- Advanced formulas
- Data queries
- Creating effective visualizations
- Identify? and? implement? the? best?techniques? to? secure? sensitive? information? in? Excel? workbooks?and? collaborate with other users to improve accuracy and efficiency
- Create tables and take advantage of their advanced features, such as dynamic data ranges, structured reference formulas, and the ability to relate multiple tables together into a Data Model
- Import and link data into Excel from external sources – including text, Access, and SQL Server – and use advanced tools, such as Power Query and various cleanup tools to manipulate the data to meet specific needs
- Use advanced functions, such as SUMPRODUCT, VLOOKUP, HLOOKUP, MATCH, INDEX, NETWORKDAYS, RAND, RANDBETWEEN, NPV, IRR, XNPV, and XIRR to create and audit complex formulas
- Analyze worksheet data using techniques such as Data Tables, Subtotals, Slicers, Filters, and PivotTables
- Describe techniques used to create, manipulate, and customize charts for analyzing and communicating information
Intended Audience —
Advanced Preparation — None
Field of Study — Accounting, Computer Software and Applications
Credits — 8 Credits
IRS Program Number –
Published Date – November 2, 2022
Revision Date –