Essential Excel 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 approach to help you quickly master Microsoft ExcelPlenty of full color, illustrated screenshots and photographs to help youPresented in an easy and simple to read format, written in jargon free EnglishLearn 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 BackStageBuilding spreadsheets, entering data, importing data and formatting textFormatting spreadsheets with borders, text orientations, colors and highlightsConditional formattingBuilding formulas to manipulate dataUsing built in functions to add up, average and count dataUsing Lookup and IF functionsCreating charts from spreadsheet data and customising chart layouts.Working with workbooks, opening, saving, and printingBasic File ManagementData analysis using goal seek, scenarios, forecasts, pivot tables and chartsData validation techniques to help keep entered data accurateand 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.