Step up your Excel skills with our 6-page laminated guide focusing on tips and tricks for using data efficiently while ensuring data quality. Curtis Frye, author of multiple books on Excel, creator of many Lynda.com videos and an experienced corporate trainer used his experience and knowledge to cover the most relevant functions for users at different levels. This is the second in the Excel 2016 series. Suggested uses: Workplace -- Kept conveniently at your desk for easy reference; Company Training -- reduce help-desk calls and keep productivity flowing for a team or for your entire company; Students/Teachers/Parents -- help for classroom or homework; College Professors/Students -- offers a range of guides for different levels.

Expert systems--problem-solving computer programs that contain the encoded knowledge of experts in a specific application area such as financial planning--represent a crucial turning point in how the typical organization utilizes its computer environment. This volume, written for practitioners in finance and accounting as well as MIS managers who wish to broaden their expertise, offers a comprehensive look at the use of expert systems in the everyday operations of finance and accounting. The author presents selected areas that are viable candidates for expert systems, demonstrating the ways in which organizations can successfully augment their present management information systems with expert systems. Actual programs using a typical PC expert system shell (EXSYS) further illustrate the relative ease with which expert systems for finance and accounting can be developed, implemented, and maintained.

Divided into four parts, the book begins by offering a framework for developing expert systems in finance and accounting. In the second part, Thierauf reviews the current state of development for programming languages in expert systems, the computer hardware necessary to run expert systems, and expert system shells useful in developing business expert systems. Part three presents an in-depth examination of the procedures used in developing expert systems, while the final part focuses on typical applications of expert systems in finance and accounting. Following a chapter on general business and nonbusiness applications, Thierauf addresses finance applications of expert systems and then uses the EXSYS program to develop demonstration and field prototypes and operational expert systems for standard finance applications. The final two chapters take the same approach to accounting applications. An appendix lists vendors of artificial intelligence/expert systems hardware and software.

Renowned Excel experts Bill Jelen (MrExcel) and Tracy Syrstad help you automate Excel tasks to get more done, faster than ever. Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. You'll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions. By reading this book, you will: Quickly master Excel macro development Work more efficiently with ranges, cells, and formulas Generate automated reports and quickly adapt them for new requirements Learn to automate PivotTables to summarize, analyze, explore, and present data Leverage more of Excel VBA's power with classes, collections, and Advanced Filter Make the most of User-Defined Functions (UDFs), including new LAMBDA functions Build sophisticated UserForm custom dialogs to collect data from other Excel users Integrate data from the Internet, Access and SQL Server databases, and other sources Automatically generate charts, visualizations, sparklines, and Word documents Extend Excel's power by controlling other Office programs and Windows itself Create Office Add-ins to expand worksheet functionality or streamline retrieval of external information Get started creating brand-new TypeScript applications for Excel Online About This Book * For everyone who wants to get more done with Microsoft Excel in less time * For business and financial professionals, entrepreneurs, students, and others who need to efficiently manage and analyze data

Contents:
Part 1: First Steps with Excel Making Sense of Pupil Performance Figures How Can We Describe Performance? How Can We Investigate the Relationship between Sets of Marks? Confidence in Sample Estimates Creating an Expectancy Table Part 2A: Scales and their Interpretation Part 2B: Handling Test Data Appendices