Print Icon

January 2020 Tech Update Newsletter

Excel's Easy to Use LARGE and SMALL Functions

Excel's New Dynamic Array Feature

Excel’s new dynamic array feature is one of the best enhancements Microsoft has added to Excel in years. With dynamic arrays, we now have the capability of creating more powerful formulas than ever before. That is, dynamic arrays allow us to break free from the traditional “one-cell, one-formula” paradigm. Instead, we can now have a single formula that places results into many cells. Further, Microsoft has added several new useful functions that return results into these dynamic arrays.

Is Technology Testing Coming To The

CPA Exam?

Is technology testing coming to the CPA Exam? With the AICPA issuing Maintaining the Relevance of the Uniform CPA Examination, the probability grows, seemingly by the day. Further, given how CPAs use technology today, some would argue that including some technology focus on the Exam is overdue. Accordingly, in this article, you will learn about some of the key drivers associated with adding technology to the CPA Exam.

Technology Focused Learning - Why It's Now A Business Necessity

Planning your professional education curriculum is a balancing act, with many competing options and mandates, including technology focused learning. In the past, many have viewed technology focused learning somewhat dismissively. The following sentiment summarizes the attitude many have on this topic.

Why do I need to learn more about technology? I already use Excel and email and I can open PDF documents and navigate them with ease. What more is there to learn?

Well, the short answer is there is plenty more to learn, and it’s changing by the day. And that is why technology focused learning is a business necessity today to remain competitive.

K2 Enterprises Highlights
February Webinars

Just because it's cold outside doesn't mean that the opportunity to learn is frozen. In fact, during February you have the opportunity of participating in up to nineteen webinar sessions that K2 Enterprises has developed and will produce. Each of these sessions provides great, live content and equally important, the opportunity to interact with an instructor in real-time. You can obtain more information or register for any of these sessions by clicking the button below.

February 4, 2020

  • K2's Introduction to Power Query
  • K2's Word Advanced Tips, Tricks, and Techniques
February 5, 2020
  • K2's Powerful Reporting with Cube Formulas
  • K2's Create Stunning Dashboards with Power BI Desktop
  • K2's Excel Guru - Tips to Make Your Head Spin
February 11, 2020
  • K2's Accessing and Cleaning Data with Excel, Power Query, and Power BI
  • K2's Understanding Key Internal Controls Over Technology
  • K2's The Right Stuff: Best Practices for Purchasing Technology
February 12, 2020
  • K2's QuickBooks Online - Changing the Paradigm of Small Business Accounting
  • K2's PDF Tools for Productivity
February 18, 2020
  • K2's Improving Collaboration with Microsoft Teams (NEW!)
  • K2's Excel PivotTables for Accountants - Part II
February 19, 2020
  • K2's Mastering the Excel Recorder
  • K2's Integrating Excel with Word and PowerPoint
  • K2's Power Query Tips, Tricks, and Advanced Techniques
February 26, 2020
  • K2's Excel Power Query - Ten Things You Need to Know
  • K2's Advanced Excel Reporting - Best Practices, Tools, and Techniques
February 27, 2020
  • K2's Hot Tech Tools, Apps, & Services
  • K2's Securing Your Data - Practical Tools for Protecting Information

K2 Conference and Seminar Schedule Reveal Coming in February!


The team at K2 Enterprises is putting together the final touches on its 2020 Conference and Seminar schedule. We expect to publish this in the February edition of K2's Tech Update, so please be on the lookout for the next issue of the newsletter. We will have lots of great information to share with you on the 2020 learning sessions for you and your team!