Showing 1–20 of 30 results

Advanced Excel Reporting for Management Accountants

$84.90

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

Android App Inventor for the Absolute Beginner

Even if you’ve never tried programming before, Android App Inventor lets you quickly and easily create apps that will run on the Android platform. Whether you’re a first-timer or a seasoned application developer, Android App Inventor For The Absolute Beginner has something for you. Beginners will find clear step-by-step instructions and a thorough introduction to this fun and intuitive visual programming environment. Experienced developers will enjoy the coverage of more advanced topics, including various sensors, robotics, and TinyWebDB. Mobile app development is booming; there’s never been a better time to get started. With Android App Inventor (free, open source software created by Google and MIT) and this book, you can design an app and upload it to your device in as little as 30 minutes. No prior experience in programming is necessary – and you don’t need to be a math or graphics wiz. Get ready for a fun and fascinating introduction to app development with Android App Inventor For The Absolute Beginner.

About the Author

Alex Whiteside is a computer engineering student at the University of Florida in Gainesville. He has worked as a programmer for numerous agencies, including the U.S. Air Force Research Laboratory and American Express. He currently serves as the chief technology officer at RILE, Inc. Jeffrey Hawthorne earned a bachelor’s degree in interdisciplinary information technology with a specialization in digital media and a master’s degree in software engineering at the University of West Florida. He currently works at Global Business Solutions as an open-source developer. Dr. Lakshmi Prayaga is an assistant professor in the Department of Applied Sciences, Technology, and Administration at the University of West Florida. She has an interdisciplinary background with a master’s in philosophy, a master’s in business administration, a master’s in software engineering, and a doctoral degree in instructional technology. She has been a recipient of several local and national grants. She is currently working on designing a robotics platform for education that online students can access using the Internet.

Out of stock
Out of stock

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.

Out of stock
Out of stock

Excel Dashboards and Reports For Dummies 2nd Edition

Create dynamic dashboards and put your data on display with. For Dummies No matter what business you’re in, reports have become a staple of the workplace, but what good is a report if no reads it, or even worse, understands it? This all new edition of Excel Dashboards & Reports For Dummies is here to help you make meaning of all your data and turn it into clear and actionable visualizations. Fully updated for the latest business intelligence and spreadsheet tools in Excel 2013, this book shows you how to analyze large amounts of data, quickly slice data into various views on the fly, automate redundant reporting, create eye-catching visualizations, and more. It helps you move beyond reporting data with simple tables, rows, and columns to designing high-impact reports, dashboards, and visuals. It walks you through a wide array of technical and analytical concepts to give you the background you need to select the right tool for interpreting and displaying data. It covers how to build a chart, work with pivot tables, group and bucket your data, represent trends, create What-If analyses, and increase the value of your reports. Excel Dashboards & Reports For Dummies, 2nd Edition is the business analysis tool you need to transform your raw data into a powerful and effective presentation that is accessible to everyone.

About the Author

Michael Alexander is a Microsoft Certified Application Developer (MCAD) and author of several books on Microsoft Access and Excel. He has more than 15 years experience consulting and developing Office solutions and has been named a Microsoft MVP for his ongoing contributions to the Excel community.

Out of stock
Out of stock

Excel Data Analysis For Dummies 2nd Edition

Harness the power of Excel to discover what your numbers are hiding Excel Data Analysis For Dummies, 2 nd Edition is the ultimate guide to getting the most out of your data. Veteran Dummies author Stephen L. Nelson guides you through the basic and not-so-basic features of Excel to help you discover the gems hidden in your rough data. From input, to analysis, to visualization, the book walks you through the steps that lead to superior data analysis. Excel is the number-one spreadsheet application, with ever-expanding capabilities. If you’re only using it to balance the books, you’re missing out on a host of functions that can benefit your business or personal finances by uncovering trends and other important information hidden within the numbers. Excel Data Analysis For Dummies, 2 nd Edition eliminates the need for advanced statistics or analysis courses by allowing you to harness the full power of Excel to do the heavy lifting for you. This 2 nd Edition is fully updated to include information about Excel’s latest features, making it a your go-to Excel guide for data analysis. Topics include: Working with external databases PivotTables and PivotCharts Using Excel for statistical and financial functions Solver, Small Business Finance Manager, and more The book also includes a guide to chart types and formatting, and advice on effective visual data presentation. You already have the data, so you might as well get something great out of it. Excel Data Analysis For Dummies, 2 nd Edition is the key to discovering what your numbers are hiding.

About the Author

Stephen L. Nelson is an author and CPA who provides accounting, business advisory, tax planning, and tax preparation services to small businesses. He is the author of more than 100 books, including QuickBooks For Dummies and Quicken For Dummies .

Out of stock
Out of stock

Excel University Volume 2 – Featuring Excel 2010 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals

Building on the firm foundation established in the first volume, the second installment in the Excel University series continues to explore the Excel features, functions and techniques relevant to accounting and finance professionals. Volume 2 focuses on how to automate recurring-use reports. Amounts in hands-free reports update the instant updated data is inserted into the workbook, for example, when an updated trial balance is pasted into the data sheet. This volume covers the Excel items needed to build and automate reports, including lookups, dynamic headers, mapping tables, error trapping, conditional summing, and date related functions. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.

About the Author

Author of Excel University In his live CPE training sessions, Jeff Lenning CPA CITP has shown thousands of CPAs and accounting professionals across the country how to use Excel to streamline their work and become more efficient. Several publications have featured his Excel articles, including the Journal of Accountancy and California CPA Magazine. Highlights After graduating from the University of Southern California, Jeff began his career in the audit practice at Arthur Andersen’s Orange County office. He was a senior financial analyst at Gateway computers and the accounting manager at Interpore Cross International. In 2000, he founded Click Consulting Inc., a technology-consulting firm that specializes in Excel training, consulting, development, and personal coaching. Professional Involvement He is a past president of the CalCPA OCLB Chapter, the former chair of the California CPA State Technology Committee, co-chair of the California CPA OCLB Chapter Technology Committee, and an instructor for the AICPA and the California CPA Education Foundation. A Microsoft Office Certified Excel Expert, he is a nationally recognized trainer.

Out of stock
Out of stock

Excel University Volume 3 – Featuring Excel 2013 for Windows: Microsoft Excel Training for CPAs and Accounting Professionals

The third installment in the Excel University series picks up right where Volume 2 leaves off. In the final exercise of Volume 2, we created a formula-based report that required several features and functions. In Volume 3, we build that same report without writing a single formula. We create it with the PivotTable feature. The first section of this volume covers PivotTable basics and concludes with a comparison between formula-based and PivotTable reports. The second section explores various report layout and design options that enable us to replace our formula-based reports with PivotTables when appropriate. In the final section, we consider the reporting process, including efficient ways to get data into our workbooks, how to prepare the data for use, and how to summarize it graphically with PivotCharts and other Excel features. Excel practice files and solutions videos are available online so you can work hands-on as you read through the content. The skills developed in this volume will help you get your work done in less time.

Out of stock
Out of stock

Excel University: Microsoft Excel Training for CPAs and Accounting Professionals: Volume 1: Featuring Excel 2010 for Windows

During live CPE training sessions, and through Excel articles featured in magazines such as the Journal of Accountancy and California CPA Magazine, Jeff Lenning, founder of Click Consulting, Inc., has shown thousands of CPAs and accounting professionals across the country how to use Excel more effectively. Drawing on his experience as an auditor, a financial analyst in industry, an accounting manager at a public company, and a consultant, he has demonstrated how to leverage Excel in order to improve efficiency by reducing the time it takes to complete job tasks. Written to reach those he won’t have the opportunity to meet in one of his CPE sessions, Lenning’s series, Excel University: Microsoft Excel Training for CPAs and Accounting Professionals, offers a comprehensive collection of the features, functions, and techniques that are of direct benefit to accountants working in industry, public practice, consulting, or not-for-profit. Concentrating on Excel for Windows, his books offer a hands-on approach to learning and include narrative, screenshots, video content, Excel practice files, and exercises that demonstrate the practical application of the items presented in each chapter. Visit http: //www.clickconsulting.com/books to access the Excel University video library and to download the practice files. Features, functions and techniques are presented in a sequential and progressive manner, so the books are best read in order. In Volume 1, the author presents material and information that will prove useful to every accountant, regardless of the type of work they do. Blown away by the power of Excel, readers are sure to find this series relevant, enlightening, and extremely easy-to-follow.

Out of stock

Illustrated Microsoft Office 365 & Excel 2016: Comprehensive

$40.30

ILLUSTRATED MICROSOFT OFFICE 365 & EXCEL 2016: COMPREHENSIVE engages both computer rookies and today’s pros as this edition guides readers in thoroughly mastering advanced Microsoft Excel 2016 skills. Praised for its concise, focused approach and user-friendly format, this book, like all others in the Illustrated Series, incorporates a hallmark two-page layout that allows readers to see an entire task in one view. Each presentation is easy to follow with Learning Outcomes that outline the skills covered in each lesson and larger full-color screens that reflect exactly what readers should see on their own computers. Each module begins with a brief overview of the lesson’s principles and introduces a case study for further application to ensure readers gain a complete understanding of Microsoft Excel 2016. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Out of stock

Illustrated Microsoft Office 365 & Excel 2016: Comprehensive + E-Book Succeeding with Techology

Whether you are a computer rookie or pro, you can thoroughly master Microsoft Excel 2016 skills quickly and efficiently with ILLUSTRATED MICROSOFT OFFICE 365 & EXCEL 2016: COMPREHENSIVE. Using a concise, focused approach and user-friendly format, the Illustrated Series incorporates a hallmark two-page layout that allows you to see an entire task in one view. Each presentation is easy to follow with Learning Outcomes that clearly outline the skills covered in each lesson and larger full-color screens that reflect exactly what you should see on your own computer. Each module begins with a brief overview of the lesson’s principles and introduces a case study for further application to ensure you gain a complete understanding of Microsoft Excel 2016. In addition, new Productivity Apps visually introduce Microsoft OneNote, Sway, Office Mix and Edge using hands-on activities.

About the Author

Ms. Elizabeth Eisner Reding has authored numerous books for Delmar and Course Technology on a variety of software programs, including Adobe(R) Photoshop, Microsoft(R) Office, and Microsoft(R) Publisher. Living in New Mexico with her husband, Ms. Reding spends her free time grilling, water gardening, road and mountain biking, and collecting Southwestern art. Lynn Wermers is a Professor in the Computer Science Department at North Shore Community College in Massachusetts where she teaches MS Office and web development courses. She also teaches part-time in the Math Department for the School of College of Professional Studies at Northeastern University. Ms. Wermers has authored numerous leading books that focus on Excel for Cengage Learning.

Out of stock

Illustrated Microsoft Office 365 & Word 2016: Comprehensive

$40.30

Both computer rookies and pros can thoroughly master Microsoft Word 2016 applications quickly and efficiently with ILLUSTRATED MICROSOFT OFFICE 365 & WORD 2016: COMPREHENSIVE. Skills are accessible and easy to follow with a hallmark two-page layout that allows readers to see an entire task without turning the page. Using a concise, focused approach and user-friendly format, this book incorporates Learning Outcomes that outline the Microsoft Word 2016 skills addressed in each lesson. Larger full-color images reflect exactly what readers should see on their own computer screens. Each module begins with a brief overview of the principles of the lesson and introduces an updated case study for further application to ensure readers gain a full understanding of Microsoft Word 2016. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

Out of stock

Joomla!® 3 Explained: Your Step-by-Step Guide 2nd Edition

Master Joomla! Hands-On, Step-by-Step, Using Easy, Practical Examples Today, millions of websites rely on Joomla!-from personal sites to those of huge organizations like General Electric, Porsche, and the United Nations. Now, using Joomla! 3, you too can create websites that are mobile-ready, responsive, flexible, powerful, and secure-even if you’re an absolute beginner. In Joomla!(R) 3 Explained, top Joomla! trainer Stephen Burge teaches you everything you need to know. Burge has taught thousands of Joomla! newcomers and thousands more who’ve experimented with Joomla! but haven’t mastered it yet. Nobody knows more about guiding you up the Joomla! learning curve. You’ll master Joomla! 3 hands-on, through a complete case study, crystal-clear visuals, simple explanations, and on-target analogies, all extensively tested with real Joomla! beginners. Burge walks you through installing Joomla! 3, planning sites that are easy to use and manage, adding content, and incorporating powerful site features without programming. Finally, Burge shows you how to run your site securely and efficiently, no matter how big or popular it becomes!

bout the Author

Stephen Burge runs OSTraining.com, which specializes in teaching website development. OSTraining.com’s clients include Apple, Pfizer, and the U.S. Departments of Energy, Education, and Commerce. Burge’s Joomla!(R) Explained (Addison-Wesley, 2011) and Drupal(TM) 7 Explained (Sams Publishing, 2014) are each the world’s best-selling guides to the software they cover.

Out of stock
Out of stock

Microsoft Access 2010: Introductory

Microsoft Office Access 2010: Introductory provides a project-based, step-by-step approach to successfully teach students Microsoft Access 2010 skills.

Out of stock
Out of stock

Microsoft Access 2016 Programming By Example: with VBA, XML, and ASP

Microsoft Access 2016 Programming by Example with VBA, XML, and ASP takes nonprogrammers through detailed steps of creating Access databases from scratch and shows them how to retrieve and manage their data programmatically using various programming languages and techniques. With more than 275 applied examples and 10 projects, Access users can quickly build database solutions with Data Access Objects (DAO) and ActiveX Data Objects (ADO); define database objects and manage database security with Structured Query Language (SQL); enhance and alter the way users interact with database applications with Ribbon customizations and event programming in forms and reports; and program Microsoft Access databases for internet access with Active Server Pages (ASP) and Extensible Markup Language (XML). The book, which covers the latest release of Access 2016 and earlier versions, is divided into nine parts (32 chapters) that progressively introduce you to programming Access .mdb and .accdb databases.

Out of stock
Out of stock

Microsoft Access 2016 Programming Pocket Primer

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”

Out of stock
Out of stock

Microsoft Business Intelligence Tools for Excel Analysts

Bridge the big data gap with Microsoft Business Intelligence Tools for Excel Analysts The distinction between departmental reporting done by business analysts with Excel and the enterprise reporting done by IT departments with SQL Server and SharePoint tools is more blurry now than ever before. With the introduction of robust new features like PowerPivot and Power View, it is essential for business analysts to get up to speed with big data tools that in the past have been reserved for IT professionals. Written by a team of Business Intelligence experts, Microsoft Business Intelligence Tools for Excel Analysts introduces business analysts to the rich toolset and reporting capabilities that can be leveraged to more effectively source and incorporate large datasets in their analytics while saving them time and simplifying the reporting process. Walks you step-by-step through important BI tools like PowerPivot, SQL Server, and SharePoint and shows you how to move data back and forth between these tools and Excel Shows you how to leverage relational databases, slice data into various views to gain different visibility perspectives, create eye-catching visualizations and dashboards, automate SQL Server data retrieval and integration, and publish dashboards and reports to the web Details how you can use SQL Server’s built-in functions to analyze large amounts of data, Excel pivot tables to access and report OLAP data, and PowerPivot to create powerful reporting mechanisms You’ll get on top of the Microsoft BI stack and all it can do to enhance Excel data analysis with this one-of-a-kind guide written for Excel analysts just like you.

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.

Out of stock
Out of stock

Microsoft Excel 2010: Introductory

Microsoft Office Excel 2010: Introductory provides a project-based, step-by-step approach to successfully teach students Microsoft Excel 2010 skills.

Out of stock
Out of stock

Microsoft Excel 2013 for the Business Analyst

As one of the most popular software tools in the world, Microsoft Excel is used by business analysts across the globe to keep track of details, look deeply into the data that drives business, and provide managers with the information and insights they need to keep their companies moving forward. MICROSOFT EXCEL 2013 FOR THE BUSINESS ANALYST is an introduction to Excel, written by a business analyst for business analysts. While providing a general overview of the features and functions of Excel, the book places special emphasis on helping users in the task of data analysis. The book begins with a conceptual overview and a discussion of Excel’s main components–cells, worksheets, tables, pivot tables, and pivot charts. That material provides an understanding of how Excel summarizes data and paves the way for a detailed exploration of the software’s formulas and functions. Written in an easy-to-grasp style, with plenty of helpful screenshots, MICROSOFT EXCEL 2013 FOR THE BUSINESS ANALYST is perfect for analysts who are new to Excel or experienced users who wish to learn more about Excel’s business-analysis capabilities.

About the Author

Larry Rockoff has been involved with Excel and business intelligence development for many years. He currently works as a senior reporting analyst for Walgreens. His main area of expertise is with data warehouse systems and reporting tools. He holds an MBA from the University of Chicago, with a specialization in management science.

Out of stock
Out of stock

Microsoft Excel 2016 Programming by Example

Microsoft Excel 2016 Programming by Example with VBA, XML, and ASP is a practical, how-to book on Excel programming, suitable for readers already familiar with the Excel user interface. The book introduces programming concepts via numerous multi-step, illustrated, hands-on exercises. More advanced topics are introduced via custom projects. From recording and editing a macro and writing VBA code to working with XML documents and using classic ASP to access and display data on the Web, this book takes you on a programming journey that will change the way you work with Excel. Completely updated for Excel 2016, this book provides information on performing automatic operations on files, folders, and other Microsoft Office and Web applications. Thirty chapters loaded with illustrated, hands-on projects and exercises that tell you exactly where to enter code, how to debug it, and then run it. Each exercise/project step is clearly explained as it is performed.

Out of stock
Out of stock

Microsoft Excel 2016 Programming Pocket Primer

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”

Out of stock