Print Icon

May 2019 Tech Update Newsletter

How To Avoid Being A Victim Of Social Engineering

One of the key emerging threats of the digital age is social engineering, which is tricking someone into parting with personal information or into taking some kind of action through the misuse of technology. As its name suggests, social engineering is playing on psychological and emotional tendencies to take advantage of another person. A typical hacker might try to find some software weak spots; however, a social engineer might pretend to be a technician support worker or bank employee to trick someone into giving detailed information about their account.


The Top Five New Features In Excel 2019

Now that Excel 2019 has been available for approximately six months, many companies have begun the process of upgrading their team members to the new version of Microsoft’s market-leading spreadsheet tool. However, upgrading will not pay dividends unless team members are aware of and take advantage of some of the new features found in Excel 2019. To that end, following are five of the top new features you will find in Excel 2019 and how you might take advantage of each.


K2 Enterprises Highlights May/June
Webinar Series

Throughout the months of May and June, K2 Enterprises is producing eighteen webinars, providing technology-focused CPE opportunities to accountants and other financial professionals. The topics for these sessions include coverage of Excel, budgeting, business intelligence, Outlook, Word, and analyzing data. Specific dates and topics for these webinars are listed below.

May 22

  • K2's Array Formulas - Exceptional Power at Your Fingertips
  • K2's Excel's Budgeting Techniques
  • K2's Top Excel Tips and Tricks
May 23
  • K2's Data Consolidations and Combinations in Excel
May 29
  • K2's Excel Tables - Database Technology Comes to Spreadsheets
  • K2's Excel 2013-2019 - Best New Features for Accountants
  • K2's QuickBooks Statement Writer
May 30
  • K2's Powerful Data Analysis with PowerPivot
  • K2's Word: Advanced Tips, Tricks, and Techniques
June 5
  • K2's Excel Guru - Tips to Make Your Head Spin
  • K2's Create Stunning Dashboards with Power BI Desktop
  • K2's Introduction to Power Query
June 6
  • K2's Detecting and Preventing Spreadsheet Errors
  • K2's Excel PivotTables for Accountants - Part II
June 26
  • K2's Mastering PivotTable Calculations and Data Summaries
  • K2's Microsoft Outlook Tips, Tricks and Advanced Techniques
June 27
  • K2's Mastering Excel Charts
  • K2's Introduction to the Excel Data Model
You can obtain complete details for each session, including learning objectives and registration information by clicking the button below.


Using Excel's Transform Data By
Example Add-In

Dating back to Excel 2010, Microsoft has been adding features to Excel to assist us in transforming our data so that it is more useful. Among the tools that Excel now offers are PowerQuery, Flash Fill, and the relatively unknown Transform Data by Example add-in – the focus of this discussion.


Personal privacy is a “hot” topic in many circles today. Many individuals are becoming increasingly outraged when they learn how much information has been collected about them and how it is being used. Further, most are startled to find out the sheer volume of information that has been collected about them and may be available for sale in various on-line marketplaces. If you are concerned about personal privacy and want to get back in control of your own information, following are five easy-to-implement ideas that can help you reach your goal.


K2 Team Members On The Road In June

During June, K2 team members are scheduled to deliver 131 in-person training sessions in 50 settings across North America! A summarized schedule is shown below. We hope that you will be able to attend one or more of these sessions, and we look forward to the opportunity of serving you soon.