Showing 1–20 of 30 results
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.
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.
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.
Excel Dashboards and Reports For Dummies 2nd Edition
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.
Excel Data Analysis For Dummies 2nd Edition
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 .
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.
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.
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.
Illustrated Microsoft Office 365 & Excel 2016: Comprehensive
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.
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.
Illustrated Microsoft Office 365 & Word 2016: Comprehensive
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.
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.
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.
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.
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”
Microsoft Business Intelligence Tools for Excel Analysts
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.
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.
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.
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.
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”