Get answers and information about COVID-19. VIEW NOW

In Person: MS Technology Conference

← Return to The CPE Catalog
Monday, May 18, 2020 @ 8:30am Tuesday, May 19, 2020 4:30pm
Add to Calendar

Description

This two-day event attracts public, industry, and technology focused individuals seeking best practices in technology. Be impressed by the best tools, software, and resources to help you succeed. This year K2 Enterprises brings a variety of new sessions. Technology has forever changed the business world. Do you have the knowledge you need to move forward? Are you as effective as you can be within your organization or for your clients? Can you remain competitive?

Credits

Category Amount
General 16.00

Sessions

Monday, May 18, 2020

8:30am - 10:10am
$0.00

You know where technology has been, but where is it headed? What technologies are coming that would be useful to you and to your company? You’ve heard about 5G, WiFi6, and collaboration, but what products work to make this practical? This session has the breadth, depth, and recommendations to help you understand what is in the market and what is working so that you can make informed decisions. Attend this session to learn how using the right hardware and software can improve your business and your everyday life. Major Subjects Covered • Hardware trends • Software innovations • Communication and collaboration tools • Unusual technologies you might have missed • Key products to consider for implementation

Credits: General 2
10:20am - 12:00pm
$0.00

Excel now has approximately 500 functions, many of which are unused by most accounting and finance professionals. This two-hour session will put you on the path to improved Excel productivity by introducing you to powerful and timesaving, but little used, Excel functions. If you want to improve your knowledge and efficiency with Excel, this session is a must for you.

Major Subjects Covered

• Using financial functions to calculate loan payments, depreciation, and cash flows • Retrieve summarized data with the GETPIVOTDATA and CUBEVALUE functions • Making sophisticated calculations with array formulas

Credits: General 2
12:50pm - 2:30pm
$0.00

Many Office 365 subscriptions include powerful cloud services for improving productivity. Foundational services, such as SharePoint, OneDrive, and Outlook, are joined by other powerful tools such as Teams, Planner, Power Automation, Forms, and Power Apps to provide a productivity platform second to none. Don't miss this opportunity to get all the knowledge and guidance necessary to take full advantage of your investment in Microsoft Office 365.

Major Subjects Covered

• Understanding the Office 365 cloud interface • Cloud storage with SharePoint and OneDrive • Full review of apps and services to improve productivity

Credits: General 2
2:40pm - 4:20pm
$0.00

Security is a top concern for CPAs every year. Yet many hacks result from organizations not implementing effective internal controls over information technology. In this session, you will learn about critical IT-related controls using a case study approach with stories which are all new for 2020. More specifically, you will learn from real-world examples of breaches and security failures. Accordingly, you will understand better how to protect your company and its data. Attend this fast-paced session and learn more about IT-related controls you can use to prevent computer crimes such as identity and information theft, tax refund fraud, and more. Major Subjects Covered • Data breach and computer security tips • Security awareness training • Learn more about current events and improve your security knowledge at the same time

Credits: General 2

Tuesday, May 19, 2020

8:30am - 10:10am
$0.00

Over the past two years, ransomware has surged as a major threat to individuals and organizations of all sizes. To illustrate the threat ransomware is, its’ annual cost to businesses is now estimated at over $8 billion, up from $1 billion in 2016. Against that backdrop, ask yourself “am I at risk?” Of course, the likely answer is “yes”. To reduce this risk, you should participate in this session where you will learn how you can avoid becoming yet another victim of ransomware. The survival of your business may depend on it! Major Subjects Covered • Understanding what ransomware is and how it is transmitted • Exploring a variety of high-profile ransomware cases • Developing an action plan to reduce your individual and organizational risk

Credits: General 2
10:20am - 12:00pm
$0.00

Proper workflow optimizes a business for profitability. Once your workflow is optimized you can automate it with a variety of software tools. In this session, you will learn how to setup workflow processes properly. You will also learn about a variety of tools that you can use to achieve automated workflow. We’ll review Zoho Flow, Power Automate, XCM, Automation Anywhere, as well as other robotic process automation (RPA) tools. This session will provide a road map on workflow technologies and choices you can implement now.

Major Subjects Covered

• Process documentation • Software options • Practical tools you can use today and may even own now • Tips on optimizing workflow • Demonstration of workflow concepts

Credits: General 2
12:50pm - 1:40pm
$0.00

How do you control the data you are responsible for? Consider the impact of the May 2018 General Data Protection Regulation (GDPR), as well as the December 11, 2019 introduction of a law in India giving authorities sweeping access to data and the most important piece of U.S. legislation, the California Consumer Privacy Act (CCPA) which is in force as of January 1, 2020. Companies like Microsoft and Apple not only claim they are ready, but plan to implement CCPA across the country. What about your business? Have you completed your implementation? Attend this session to learn practical steps you can take to be compliant with mandated regulations.

Major Subjects Covered

• Data transparency and access • Data deletion and portability • Definition of personal information • User opt out and the right to be forgotten • Understanding the fines and risks

Credits: General 1
1:40pm - 2:30pm
$0.00

Emerging technologies are changing so fast, it is hard to predict the future. Quantum supremacy may be driven by the Dowling-Neven Law of double exponential growth. We are seeing this in quantum computing, artificial intelligence, machine learning and robotic process automation. How can you keep from being blind-sided by a technology like blockchain or predictive analytics? This session will provide a road map on emerging technologies and choices you can implement now.

Major Subjects Covered

• Hardware enablement • Software evolution • Practical tools you can use today • Unusual emerging technologies to watch in the future • Emerging technologies that are not ready for prime time

Credits: General 1
2:40pm - 4:20pm
$0.00

New and improved features in Excel tools such as Power Query and Power Pivot means that yesterday’s techniques for generating reports in Excel are obsolete. Best practices for next generation reporting include building queries and transformations using Power Query, adding user-defined calculations with Data Analysis Expressions, managing data models in Power Pivot, reducing dependency on formulas with PivotTables, and adding visualizations where appropriate. Participate in this session so that you can learn the best practices for preparing and automating your Excel-based reports.

Major Subjects Covered

• Key issues with traditional reporting models • The roles associated with various Excel features, including Power Query, Power Pivot, Data Analysis Expressions, and PivotTables in Excel- based reporting environments • How to create “repeatable/refreshable” reports in Excel that link data from external data sources

Credits: General 2

Course Materials

Links to the e-materials will be listed with your course registration in your account on the MSCPA website seven calendar days before the course. You will receive an e-mail when the materials are available.

The option to request printed materials is only available up to 5 business days prior to the course date. Walk-in registrants and those registering between 1 and 5 days before the course will be sent an electronic link to the e-materials by default. “Extra” printed course materials will not be available on site. Printed materials are not available for conferences.



Leaders

Larry A. McClelland

Mac McClelland, an attorney and accounting professional, is an associate of K2 Enterprises of Hammond, Louisiana, and Network Management Group of Hutchinson, Kansas. Mac was formerly the director of the Centre for Financial Studies at the University of Otago in Dunedin, New Zealand, where he lived and worked for seven years from 1990 to 1997. He was also a member of the faculty of the Advanced Business Programme, ranked in the top 100 MBA programs in the world by The Economist, specializing in business strategy and strategic management accounting. He gained his practical experience in information systems with the National Aeronautics and Space Administration, and has an established practice in business and technology consulting. Mac has taught hundreds of continuing professional education seminars to accountants and business managers in the United States, New Zealand, Australia, Japan, and Southeast Asia. His presentations are highly rated, and he has won several awards for teaching excellence. Mac has been published in leading business and practitioner journals, including Tax Ideas, Computers in Accounting, Journal of Accounting Education, Chartered Accountants Journal of New Zealand, and the top-rated Journal of Accounting Research.

Thomas G. Stephens

Thomas G. Stephens, Jr., received a Bachelor of Science in Business Administration degree (Major in Accounting) from Auburn University in 1985. Upon graduation, Mr. Stephens began working for an Atlanta-based public accounting firm. After earning his designation as a Certified Public Accountant, Mr. Stephens worked for BellSouth Corporation in Atlanta as an Internal Auditor. After two years as an auditor, he was promoted to Staff Manager and then Operations Manager of the Internal Audit Group. In 1991, he transferred to the Comptrollers’ department of BellSouth and served as Manager of the Cost Accounting organization. While working full-time at BellSouth Corporation, Mr. Stephens also attended graduate school, earning a Masters of Science (Major in Finance) from Georgia State University in 1992.

Brian Tankersley

Brian Tankersley is a consultant who advises US firms and companies on accounting technology issues. Mr. Tankersley is a frequent speaker at continuing education courses for K2 Enterprises, and publishes a nationally recognized blog on accounting and technology (www.cpatechblog.com). He has also served as the technology editor for a major accounting industry publication. Mr. Tankersley has over 25 years of professional experience, including accounting, auditing, technology, and education, and has been with K2 Enterprises since 2005, and he is also one of the national instructors for Yaeger CPA Review. Tankersley has been recognized eight times as one of the “Top 25 Thought Leaders in Public Accounting Technology” by Cygnus Business Media. Brian has made presentations in 47 of the 50 US states and has served as a guest speaker for many professional accounting organizations across Canada. He received the Outstanding Discussion Leader Award from the Tennessee Society of CPAs in 2009 and 2013, and was recognized for writing the Article of the Year for the Tennessee CPA Journal in 2011. Brian has presented sessions at most major national accounting technology conferences, including AICPA TECH+/Practitioners Conference, The Sleeter Group’s Solutions Conference, Sage Summit, CCH Connections, and Thomson Reuters Synergy User Conference. Brian is a certified public accountant (Tennessee), a certified information technology professional (CITP), and a Chartered Global Management Accountant (CGMA). He holds bachelor’s degrees in both Accounting and Finance, cum laude, from the University of Tennessee. Tankersley also maintains numerous vendor software certifications, and is a member of the Tennessee Society of CPAs and the American Institute of CPAs.