R.M. Hyttinen - Excel 2016: Up To Speed

Excel 2016: Up To Speed

R.M. Hyttinen

Excel 2016: Up to Speed

By R.M. Hyttinen

Copyright 2016 by R.M. Hyttinen . All rights reserved.

Published by PCM Courseware, Milwaukee, Wisconsin.

http://pcmcourseware.com

ISBN: 978-0-9915186-5-4

Examples used in this book are fictional . Any resemblance to actual persons living or dead, businesses, incidents, organization or events is purely coincidental.

All rights reserved. No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, without the prior permission of the Publisher. Although every precaution has been taken in the preparation of this book, the publisher and author assume no responsibility for errors and omissions. Nor is any liability assumed for damages resulting from the use of information contained within.

If you found this book helpful, p lease consider leaving a review wherever you purchased this book. Also consider telling your friends about it to help me spread the word about my book.

Thank you so much for supporting my work!

License Notes

This e-book is licensed for your personal enjoyment only. This e-book may not be re-sold , given away to other people or used in any type of training classes. If you would like to share this book with another person, please purchase an additional copy for each recipient. If youre reading this book and did not purchase it, or it was not purchased for your use only, then please return to your favorite e-book retailer and purchase your own copy. Thank you for respecting the hard work of this author.

Trademark Acknowledgements

Microsoft, Windows and Excel are registered trademarks of the Microsoft Corporation. All other known trademarks have been appropriately capitalized and are the property of their respective owners.

TABLE OF CONTENTS

As the author and founder of PCM Coursewar e, I am delighted to bring you the first in our Up To Speed series of guides: Excel 2016 . Since 2003, PCM Courseware has been publishing innovative Print-On-Demand electronic courseware for both the PC and the Macintosh and beginning with the Up to Speed series, we are now creating software guides for everyone, not just for software trainers.

My mission is to create guides to make learning technology concepts easy, no matter what kind of learner you are. The guides are simple to use yet comprehensive in their effectiveness. Many students find the step-by-step approach of our manuals to be a valuable self-study resource.

You do not need to read the book sequentially, although this can certainly be helpful if you are just starting out with Excel. Ive written the book from scratch, starting with basic Excel topics and moving on to more advanced features of application, designed to help you to become more productive more quickly.

If you are looking to accomplish a specific task, be sure to take advantage of our handy Table of Contents.

So lets get started with Excel 2016 Up to Speed.

Welcome to Microsoft Excel 2016! Microsoft Excel is a powerful and user-friendly spreadsheet application that allows you to enter, calculate, organize and analyze data. You can use Excel for a variety of tasks, such as preparing a budget, creating invoices, tracking inventory, and preparing financial forms, just to name a few. Excel has powerful calculating and charting capabilities as well as formatting features that allow you to really jazz up your documents.

The cell is the most basic part of Excel it is in the cell where data is entered. In Excel, data is organized in rows (the horizontal divisions) and columns (the vertical divisions) which make up an Excel Worksheet . Worksheets are stored in an Excel file called a workbook.

A workbook can consist of several worksheets. When Excel first launches, a blank worksheet appears and you can begin entering your data and formatting the look of your document.

Lets begin by creating a new workbook and examining the Excel environment.

1. If you are using Windows 8 or Windows 10, click the Excel tile on the Start screen (if you dont see an Excel tile, type: Excel until the application is highlighted).

2. If using Windows 7 or before, click the Start button on the lower-left corner of your screen to display the Start menu, select All Programs > Microsoft Office > Microsoft Excel 2016 from the Start Menu to launch the application (this may vary, depending on your installation).

3. Click Blank Workbook in the right pane of the Welcome screen.

When you first start Microsoft Excel, the application opens to a blank worksheet along with the parts of the Microsoft Excel screen as shown in the screen shot above. If you have worked with versions of Excel prior to Excel 2007, you will immediately notice that the user interface has been completely redesigned.

The Excel Working Environment

The menu and toolbar system of older Excel versions are replaced by the Ribbon. The Ribbon is designed to help you quickly find the commands you need in order to complete a task. On the Ribbon, the menu bar has been replaced by Command Tabs that relate to the tasks you wish to accomplish. The default Command Tabs in Excel are: File, Home, Insert, Page Layout, Formulas, Data, Review and View.

Different command icons, called Command Sets appear under each Command Tab. The commands that appear depend on the Command Tab that is selected. Each command set is grouped by its function. For example, the Insert tab contains commands to add tables, charts, illustrations, links and text objects into your spreadsheet. Contextual Commands only appear when a specific object is selected. This helps in keeping the screen uncluttered.

Under the File tab on the Ribbon is what Microsoft refers to as Backstage view. The view allows for quick access to permissions, meta-data, and common document management tasks such as opening, closing, printing and saving files. If you have worked at all with Windows 8 or Windows 10, you may notice that Backstage view is similar to many screens in these versions of Windows.

On the bottom of many of the Command Sets is a Dialog Launcher, which when clicked, launches a dialog box for that set of commands.

To the right of the Excel button (from where you access basic window options), is the Quick Access Toolbar. This toolbar contains by default the Save, Undo and Redo and Touch/Mouse commands. In addition, clicking the drop-down arrow to the right allows you to customize the Quick Access Toolbar and to add other tools that you use regularly. You can choose from the list which tools to display on the Quick Access Toolbar or select More Commands to add commands that are not in the list.