Join      Renew      Advertise      Directory

Session Descriptions

Monday December 14

A. Tech Update - A 2020 Vision

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.

B1. Mastering Advanced Excel Functions and Formulas

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 time saving, but little used, Excel functions. If you want to improve your knowledge and efficiency with Excel, this session is a must for you.

B2. integrating and sharing data

The number of apps, services, platforms, etc. that we use increases every year. The amount of data we collect and process is expanding at an exponential rate. There is a need to standardize, streamline, and optimize our ability to manage the ever-growing list of systems and their data. Conquering your data can help improve efficiency, effectiveness, reduce cost and errors inside an organization. In this course, you will learn various ways of sharing data easily between different applications, platforms, and services. Further, you will learn about various tools, desktop application functionalities, and programming tools to manage this process.

C1. technoethics

From the dawn of the Digital Age, ethical issues – with no easy solutions – have existed. These include questions relating to privacy, workers’ rights, and intellectual property. And, as technology advances, more issues are sure to arise. In this session, you will learn about the emerging field of technoethics and what you can do to promote ethical behavior in your organization, particularly as it relates to technology. You will also learn about some of the more notable technoethics lapses that have occurred, the fallout resulting from them, and how they could have been prevented.

C2. improving productivity with office 365 cloud applications

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.

D. current tech crimes - ripped from the headlines

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.


Tuesday December 15

E. the very real risk of ransomware

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!

F1. advanced topics in power bi

So, you’ve been using Power BI to create fundamental reports and dashboards and now you’re ready for even more advanced reporting…if so, this session is for you. In this session, you will learn how to extend your Power BI environment by incorporating tools such as Data Analysis Expressions, Key Performance Indicators, Hierarchies, and Apps and Content Packs, among others. By taking advantage of the tools and techniques covered in this session, you will be able to move beyond simple reports and dashboards in Power BI and truly leverage the power of this awesome reporting tool.

F2. understanding workflow and automation essentials

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.

G1. the perfect storm - data governance and data

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.

G2. emerging technologies - 2020 and beyond

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.

H1. the how's and why's of creating user-defined functions in excel

With approximately 500 functions already present, Excel seemingly has a function for every need. But sometimes the function YOU need just simply isn’t available. For example, Excel does not have functions to calculate income tax expense or, in many cases, depreciation expense. To solve these shortcomings, you can create User Defined Functions (UDFs). UDFs provide you with the opportunity to create functions for use in any of your formulas and automate your most complex calculations. Join us to learn how to put the power of UDFs to work to simplify and automate even your most complex calculations.

H2. implementing security and privacy policies

How do you communicate the security needed in your organization to your IT team? When was the last time you updated your security policies? Are you compliant with the current regulatory environment, and is your business using best practices that reflect the threats of today? Attend this session to receive a suggested security strategy and checklist, as well as sample documents to use as models to update your own policies.

I. next generation excel reporting

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.



Visit Us:

3100 South Columbia Road
Suite 500
Grand Forks, ND 58201

Contact Us: 

 (701) 775-7111
or (877) 637-2727
Email: info@ndcpas.org

Connect with us:

Powered by Wild Apricot Membership Software