Combining and linking data from multiple tables, sheets, and workbooks is a daily need for most accountants, yet many do not fully appreciate the breadth of Excel options available for accomplishing this task. In this session, you will learn about the full range of Excel data consolidation functionality, including simple sum-through formulas, auto-merging workbooks, consolidation PivotTables, and linking tables to create powerful Data Models. Simplify and streamline your data consolidation processes, improve your personal productivity, and reduce errors with the information contained in this feature-packed session.
Computer Software & Applications
Differentiate between various formula-based approaches to consolidating data, Implement dummy end-point worksheets or columns to simplify the data consolidation process and reduce errors, Differentiate between using Data Consolidation by position and by category, Use consolidation PivotTables to combine data from multiple worksheets and/or multiple workbooks, Create a Data Model by linking multiple tables of data and then build powerful PivotTable analyses from the Data Model
Randy Johnston is a nationally recognized educator, consultant, and writer with over 30 years’ experience in Strategic Technology Planning, Accounting Software Selection, Paperless, Systems and Network Integration, Business Continuity and Disaster Recovery Planning, Business Development and Management, Process Engineering and outsourced managed services.
K2 Enterprises (K2E.com) 1990 – Present Hammond, LA Executive Vice President, Shareholder – Nation’s leading technology CPE provider to CPA professionals. Consults to high profile technology vendors. Delivers national seminars to CPAs, business groups and IT leaders on technologies in accounting, healthcare and banking. Creates and presents seminars and articles on 30+ technology topics including CPA Firm Technology, Cloud, Paperless, Business Continuity, Accounting Software and Business Strategies leveraging technology. Network Management Group, Inc. (NMGI.com) 1983 – Present Hutchinson, KS Chairman & CEO, Stockholder – Consults and specializes in Strategic Technology including planning, selection and implementation. Expertise: CPA Firm Technology and strategy; Paperless; Accounting Software, Business Intelligence and CRM; Infrastructure including: Cloud, Business Continuity, Virtualization, Backup, and remote management. Hutchinson Community College 1977 - 1997 Department Chair, Professor, Adjunct - Mathematics & MIS Depts. Designed and taught courses in all areas of mathematics & computing. Professional Data Services 1978 - 1981 Programmer and system designer - Developed a medical system including the first paperless claims in Kansas, appointments and collection systems. Involved in a chain of ComputerLand and Entre’ stores, received first IBM PC and first Compaq in Kansas Farmland Industries 1977 - 1978 Programmer and system designer - Developed and maintained P&L, Credit Union and Feedlot accounting EDUCATION Hutchinson Community College, 1975 A.A. in Computer Science, Math Kansas State University,1977 B.S., summa cum laude, in C.S., Math, Science Wichita State University, 1981 Masters of Computer Science, 60+ post graduate hours ACKNOWLEDGEMENTS Accounting Today Listed as one of the 2004-2014 Top 100 Most Influential People CPA Practice Advisor Accounting Hall of Fame 2011, Top 25 Thought Leader 2011-2015 Accounting Technology Listed as one of the top nine technology stars in the industry AICPA Technology Conference Past Chair and featured Speaker for the past 29 years. Who’s Who in Business & Industry – 1990-2014; in Computing 1987-2014 Acknowledged as leading business professional and as a leading computing professional CERTIFICATIONS Microsoft Corporation Microsoft Certified Professional – MCP Novell Corporation Certified Network Administrator – CNA AutoDesk, 3Com, Entre’ Certified CAD specialist, Network Professional, Data Communications PUBLICATIONS Various publications 1978 - Present CPA Practice Advisor monthly columnist, Journal of Accountancy, CRN, Accounting Technology, PCWeek, InfoWorld, Interface, State Society newsletters, frequent quotes in accounting and computer press. Mitchell Publishing - 1981 Basic Using Micros Random House - 1982 Business Computing Systems McGraw Hill - 1984 Computers: An Introduction John Wiley & Sons Publishing - 2002 Technology Best Practices K2 Enterprises – 2003-2012 Accounting Software Solutions
Non-Member Price $109.00
Member Price $79.00