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 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.
