Books: 189

Office

CoverTitleYear
Whether you're upgrading from a previous version or using it for the very first time, this book will guide you through Microsoft Office 2016 one step at a time, to help you understand the software more quickly and easily! * Great for beginners, a basic computing class, or as an update. * Systematic, more » visual approach to help you quickly master Microsoft Office * Plenty of full color, illustrated screenshots and photographs to help you Updated for the new Office 2016 Suite, and in full color, here's what you'll learn... * Office 2016, Office 365 and the cloud * Purchasing, Downloading and Installing Microsoft Office 2016 * Using Office Online Apps, Sway, Docs, Office Mix, Office Lens, Mail, People and Calendar * Using OneDrive cloud storage and basic file management * Using Word to build professional looking documents utilizing templates, paragraph styles, text formatting and images * Using Excel to build and format spreadsheets. Learn to enter, manipulate and analyse your data * Using PowerPoint to create presentations with text, graphics, audio/video, animations and transitions * Setup and present confidently with tablets, laptops and projectors * Getting started with Microsoft Outlook 2016; keeping in touch with friends, family and colleagues * Getting started with Microsoft Access 2016; creating tables, forms, reports and queries * Getting started with OneNote 2016 to hand-write notes, add graphics * Learn to record audio/video and take photos to complement your OneNote 2016 notebooks as well as type notes * and more... Techniques are illustrated systematically using photography and screen prints throughout, together with clear, concise and easy to follow text from an established expert in the field.Whether you are new to Microsoft Office 2016, upgrading, or an experienced user needing an update, this book will provide you with a firm grasp of the underpinning foundations, and equip you with the skills needed to use Microsoft Office 2016 effectively and productively. « less
2017
Whether you're upgrading from a previous version or using it for the first time, this book will guide you through Microsoft PowerPoint 2016 step by step, to help you understand the software more quickly and easily! * Great for beginners, a computing class, or as an update * Step-by-step, visual approach more » to help you quickly master Microsoft PowerPoint * Plenty of full color, illustrated screenshots and photographs to help you * Presented in an easy and simple to read format, written in jargon free English Learn how to use and navigate PowerPoint 2016, the latest update to Microsoft's Presentation Suite. With full color screen prints, photographs and illustrations, this guide explores... * Starting PowerPoint, ribbon menus and the BackStage * Building presentations, inserting slides, adding text, animations, transitions, motion paths and graphics * Formatting presentations with borders, text orientations, colors and highlights * Inserting and formatting charts and tables to represent data * Working with presentation documents; opening, saving presentations, and printing handouts * Adding sound, video and recording voiceovers for your presentations * Exporting presentations as PDF, video and so on * Presenting wirelessly with projectors and tablets * Setting up and giving presentations and broadcasting a presentation online * and more... Techniques are illustrated step-by-step, using photography and screen prints throughout, together with concise, easy to follow text from an established expert in the field. Whether you are new to Microsoft PowerPoint, upgrading, or an experienced user needing an update, this book will provide you with a firm grasp of the underpinning foundations and equip you with the skills needed to use PowerPoint effectively and productively. « less
2017
Save time and be way more productive with Microsoft Excel macros Looking for ready-made Excel macros that will streamline your workflow? Look no further! Excel Macros For Dummies, 2nd Edition helps you save time, automate, and be more productive–even with no programming experience at all. Each chapter more » offers macros you can implement right away, with practical exercises that extend your knowledge and help you understand the mechanics at work. You'll find over 70 of the most effective Excel macros for solving common problems and explanations of why and where to use each one–plus invaluable guidance and step-by-step instruction for applying them effectively. Microsoft Excel is the world's leading spreadsheet application, and it supports VBA macros that allow you to customize the program and automate many common tasks. In no time, you'll learn how to customize your applications to look and work exactly the way you want them to, with simple, friendly walk-throughs that directly apply to real-world tasks. Follow it through from start to finish, or quickly look up problems as they occur. It's the perfect desk reference for all of your Microsoft Excel macros needs! * Immediately implement the given Excel macros * Work with workbooks, worksheets, and ranges * Clean data, automate reporting, and send email from Excel * Streamline your workflow If you have an Excel problem, there's a macro to solve it–and now, you don't need to be a programmer to customize it for your own use!. « less
2017
The Step-By-Step Guide
LEARN HOW TO CREATE PIVOT TABLES QUICKLY AND EASILY WITH THIS STEP-BY-STEP GUIDE! Updated for Microsoft® Excel® 2016! This book provides easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards. In just a few short hours, you’ll learn how to: Organize more » and summarize data Format & filter Pivot Table results Create Pivot Charts Display averages & percentages Group data into predefined ranges Use Slicers Rank results Apply calculated fields Create Pivot Table reports from imported files And more! In addition to the above, you will also learn how to create, format, and update a basic Dashboard using Pivot Table data. Including how to incorporate charts and performance symbols into your reporting. A great resource for: Business Analysts Data Analysts Financial Analysts Administrative and Support staff Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft® Excel’s® best features! « less
2017
Microsoft Excel Training for CPAs and Accounting Professionals: Featuring Excel 2016 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 Excel University, Inc., has shown thousands of CPAs and accounting professionals across the country how to use Excel more effectively. more » 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.excel-university.com 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. « less
2017
Featuring Excel 2016 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 more » 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. « less
2017
**INTRODUCTORY PRICE** People don’t stay on the same path nowadays; they have many jobs and often a few careers. Corporate loyalty is disappearing as people feel uncertain about the stability of the company they belong to and actually, what they want to do. Job security is seen as an antiquated concept more » and people are discovering that they need to be more flexible. Some people even think that the concept of a career is dead, that jobs are more project-based nowadays. All this said; you can benefit from this uncertainty with the right mind-set. You no longer have to wait the obligatory 5 or 10 years to move along the career path and work your way up to middle management and beyond. With uncertainty comes opportunity. For me, there are many skills to master in business but there is one consistent visible ‘hard’ skill that ALWAYS provides results, and it’s Excel. But why do you really want to know Excel better? Become an Excel master? Most likely no! Do you want to learn some nugget which will help you to get a better job and earn more money? Mostly likely yes! This ebook talks through 5 levels of Excel use and how using Excel can provide the tools to really make the world your oyster - but you need to decide how far you actually want to go. It's no good learning how to create complex business models if you want to be in a client-facing role, but in the same breath it's worth knowing how to create easy to understand dashboards if you want to work up the ladder towards senior management or CEO level. In short - you need to figure out what you need to know, and that's what this ebook is designed to help you discover. On top of that I'll give you some great ways to put Excel to strategic use and make the right moves to prime and ask for that pay rise. - Level 1 – Be an Above Average User - Level 2 – Data Manipulation and Analysis - Level 3 – Management Information and Dashboards - Level 4 – Automation - Level 5 – Business and Financial Modelling - Prime that Pay Rise - Ask for that Pay Rise Is this ebook right for you? Will it give you the Excel and job guidance you're looking for? Take a glimpse inside the first few pages - if you like what you see, then go ahead and buy! Don't forget - it's currently at an introductory price - so it's the best time to buy. « less
2017
A Step-by-Step Guide
This book shows you how easy it is to create, edit, sort, analyze, summarize and format data as well as graph it. Loaded with screen shots, step-by-step instructions, and reader exercises, Essential Excel 2016 makes it easy for you to get to grips with this powerful software and what it can do. What more » You’ll Learn * How to create amazing visualizations of your data * Easy and accurate methods for entering data * How to extract just the information you want from imported data, and manipulate it and format it the way you want * Export your results to other programs or share with others in the cloud * Organize, Summarize, Filter, and Consolidate your Data in almost any way imaginable * Audit, Validate and Protect your Data Who This Book Is For Anyone new to Excel, or looking to take better advantage of the platform and find out its latest features « less
2016
Whether you're upgrading from a previous version or using it for the first time, this book will guide you through Microsoft Excel 2016 one step at a time, to help you understand the software more quickly and easily! * Great for beginners, a computing class, or as an update. * Step-by-step, visual more » approach to help you quickly master Microsoft Excel * Plenty of full color, illustrated screenshots and photographs to help you * Presented in an easy and simple to read format, written in jargon free English Learn how to use and navigate Excel 2016, the latest update to Microsoft's Spreadsheet Application. With full color screen prints, photographs and illustrations, this guide explores... * Starting Excel, ribbon menus and the BackStage * Building spreadsheets, entering data, importing data and formatting text * Formatting spreadsheets with borders, text orientations, colors and highlights * Conditional formatting * Building formulas to manipulate data * Using built in functions to add up, average and count data * Using Lookup and IF functions * Creating charts from spreadsheet data and customising chart layouts. * Working with workbooks, opening, saving, and printing * Basic File Management * Data analysis using goal seek, scenarios, forecasts, pivot tables and charts * Data validation techniques to help keep entered data accurate * and more... Techniques are illustrated step-by-step, using photography and screen prints throughout, together with concise, easy to follow text from an established expert in the field. Whether you are new to Microsoft Excel, upgrading, or an experienced user needing an update, this book will provide you with a firm grasp of the underpinning foundations and equip you with the skills needed to use Word effectively and productively. « less
2016
This introductory textbook for business statistics teaches statistical analysis and research methods via business case studies and financial data using Excel, MINITAB, and SAS. Every chapter in this textbook engages the reader with data of individual stock, stock indices, options, and futures. One more » studies and uses statistics to learn how to study, analyze, and understand a data set of particular interest. Some of the more popular statistical programs that have been developed to use statistical and computational methods to analyze data sets are SAS, SPSS, and MINITAB. Of those, we look at MINITAB and SAS in this textbook. One of the main reasons to use MINITAB is that it is the easiest to use among the popular statistical programs. We look at SAS because it is the leading statistical package used in industry. We also utilize the much less costly and ubiquitous Microsoft Excel to do statistical analysis, as the benefits of Excel have become widely recognized in the academic world and its analytical capabilities extend to about 90 percent of statistical analysis done in the business world. We demonstrate much of our statistical analysis using Excel and double check the analysis and outcomes using MINITAB and SAS – also helpful in some analytical methods not possible or practical to do in Excel. « less
2016