Essential Excel 2016 - Wilson, Kevin

. .

Résumé :
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.

Biographie:
Kevin Wilson, a practicing computer engineer and tutor, has had a passion for gadgets, cameras, computers and technology for many years.

After graduating with a masters in computer science, software engineering & multimedia systems, Kevin has worked in the computer industry supporting and working with many different types of computer systems. He has served as a tutor running specialist lessons on film making, visual effects, IT lessons and computer literacy in schools. He has taught in colleges in South Africa, and worked as a tutor for adult education in England running IT courses such as beginner's IT, CLAIT, ECDL and ICT Advanced. His books have become a valuable resource amongst the students.

His latest works, the computer essentials series, modelled on the philosophy if you can't explain something simply, you haven't understood it well enough, aims to bring a simplified approach to computer training and breaks down computing terms, tasks, operating systems and software into simple concepts with easy to follow steps and plenty of visual aids. It is his hope that these books will help you as much as they've helped us get to grips with the latest technology.

The best-selling computer fundamentals series was created in the hope that it will help people to use their computer with greater joy, understanding, productivity and efficiency. To help students and people in countries like South Africa and India who have never used a computer before. It is his hope that they will get the same benefits from computer technology as we do. So get yourself a copy today and help us make a difference in someone's life.