Author Description

<p>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!</p> <ul> <li>Great for beginners, a computing class, or as an update.</li> <li>Step-by-step, visual approach to help you quickly master Microsoft Excel</li> <li>Plenty of actionable, illustrated screenshots and photographs to help you</li> <li>Presented in an easy and simple to read format, written in jargon free English</li> </ul> <p>Learn how to use and navigate Excel 2016, the latest update to Microsoft's Spreadsheet Application. With screen prints, photographs and illustrations, this guide explores...</p> <ul> <li>Starting Excel, ribbon menus and the BackStage</li> <li>Building spreadsheets, entering data, importing data and formatting text</li> <li>Formatting spreadsheets with borders, text orientations, colors and highlights</li> <li>Conditional formatting</li> <li>Building formulas to manipulate data</li> <li>Using built in functions to add up, average and count data</li> <li>Using Lookup and IF functions</li> <li>Creating charts from spreadsheet data and customising chart layouts.</li> <li>Working with workbooks, opening, saving, and printing</li> <li>Basic File Management</li> <li>Data analysis using goal seek, scenarios, forecasts, pivot tables and charts</li> <li>Data validation techniques to help keep entered data accurate</li> <li>and more...</li> </ul> <p>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.</p> <p>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.</p>