Advanced Excel Reporting for Management Accountants
The advanced tools accountants need to build automated, reliable, and scalable reports using Excel Learn about the functions that work together to automate many of the processes involved in Management Reporting. See how to take advantage of the many new features of Excel 2007 and 2010. Find out how to build validation structures into your spreadsheet reports. Discover how to identify missing or new codes, either in the creation process or in the day-to-day running of the reports. Do it all with Advanced Excel Reporting for Management Accountants. * Explore the structures that simplify the report creation process and make the reports more maintainable * Learn techniques to “cleanse” data so that it is ready for use in Pivot Tables and formula-based reports * Find out the tips and tricks that can make the creation process quicker and easier * Discover all you need to know about Excel’s summing functions and how versatile they can be Written in a hands-on style that works towards the completion of two reporting case studies, Advanced Excel Reporting for Management Accountants explains and demonstrates techniques so that Management Accountants can learn how to automate many aspects of the reporting process.
Out of stock
As part of the “Pocket Primer” series, this book provides an overview of the major concepts to program Microsoft Access/VBA. The focus of this book is on basic programming instructions for both Access 2016 and previous versions.Features: Provides an overview of the most important Access/VBA programming techniques Covers both Access 2016 and 2013 versions”
About the Author
Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on advanced business analysis with Microsoft Access and Excel. Jared Decker is the co-founder of StatSlice Systems and a certified BI developer with more than 14 years experience training and developing enterprise reporting solutions. Bernard Wehbe a is a veteran BI consultant and co-founder of StatSlice Systems where he helps organizations implement business analytics and data visualization solutions. John Walkenbach is arguably the foremost authority on Excel. He has written more than 30 books and maintains the popular Spreadsheet Page at www.j-walk.com/ss.
Now in full color! The quick way to learn Microsoft PowerPoint 2016! This is learning made easy. Get more done quickly with PowerPoint 2016. Jump in wherever you need answers–brisk lessons and colorful screenshots show you exactly what to do, step by step. * Get easy-to-follow guidance from a certified Microsoft Office Specialist Master* Learn and practice new skills while working with sample content, or look up specific procedures* Create attractive electronic presentations and printed publications* Incorporate professional design elements* Use built-in tools to capture and edit graphics* Include audio, video, and animated elements* Supercharge your efficiency by creating custom slide masters and layouts* Present data in tables, diagrams, and charts.
About the Author
Joan Lambert has worked closely with Microsoft technologies since 1986, and in the training and certification industry since 1997. As President and CEO of Online Training Solutions, Inc. (OTSI), Joan guides the translation of technical information and requirements into useful, relevant, and measurable resources for people who are seeking certification of their computer skills or who simply want to get things done efficiently. Joan is the author or coauthor of more than three dozen books about Windows and Office (for Windows, Mac, and iPad), video-based training courses for SharePoint and OneNote, and three generations of Microsoft Office Specialist certification study guides. Joan is a Microsoft Certified Professional, Microsoft Certified Trainer, Microsoft Office Specialist Master (for all Office versions since Office 2007), Microsoft Certified Technology Specialist (for Windows and Windows Server), Microsoft Certified Technology Associate (for Windows), and Microsoft Dynamics Specialist. Joan currently lives in a small town in Texas with her simply divine daughter, Trinity; an ever-growing menagerie of dogs, cats, and fish; and the DeLonghi Gran Dama super-automatic espresso machine that runs the house.
Data at Work: Best practices for creating effective charts and information graphics in Microsoft Excel
Information visualization is a language. Like any language, it can be used for multiple purposes. A poem, a novel, and an essay all share the same language, but each one has its own set of rules. The same is true with information visualization: a product manager, statistician, and graphic designer each approach visualization from different perspectives. Data at Work was written with you, the spreadsheet user, in mind. This book will teach you how to think about and organize data in ways that directly relate to your work, using the skills you already have. In other words, you don’t need to be a graphic designer to create functional, elegant charts: this book will show you how. Although all of the examples in this book were created in Microsoft Excel, this is not a book about how to use Excel. Data at Work will help you to know which type of chart to use and how to format it, regardless of which spreadsheet application you use and whether or not you have any design experience. In this book, you’ll learn how to extract, clean, and transform data; sort data points to identify patterns and detect outliers; and understand how and when to use a variety of data visualizations including bar charts, slope charts, strip charts, scatter plots, bubble charts, boxplots, and more. Because this book is not a manual, it never specifies the steps required to make a chart, but the relevant charts will be available online for you to download, with brief explanations of how they were created.
About the Author
Jorge Camoes has been consulting businesses on how to effectively use information visualizations since 2010 with clients that include the global retail giant, IKEA. Prior to starting his consulting business, Camoes worked for 10 years in the business intelligence department of the Portuguese subsidiary of Merck & Co. Camoes runs the popular data visualization blog, Excelcharts.com, which has 30K monthly visitors. He works from his home in Lisbon, Portugal.