Excel 2016 Formulas, Formatting, And Printing: Supports Excel 2010, 2013, And 2016 - Softcover

Hutchinson, Jeff

Softcover

ISBN 10: 1975985206 ISBN 13: 9781975985202

Publisher: CreateSpace Independent Publishing Platform, 2017

Synopsis

This workbook is discontinued and replaced by Release 2. See: https://www.amazon.com/dp/B09DMW9SLM

This product has become a valuable industry standard and everyone will need to use Excel at some point in their career. Whether it is used to create a budget, list information, or improve math accuracy, it is a very useful resource. Most people use Excel on some level or are self-taught users. This Workbook is a valuable resource for beginners to understand core concepts as well as an advanced student to learn the "in’s and out’s." Everyone who uses this Workbook will learn a new variety of short cuts and time-saving tricks to enhance spreadsheet use. After studying this group of chapters, students will experience a higher level of increased understanding and productivity of Excel concepts.

Obtain Your PDF Copy and Video Course
This workbook includes an Online Recorded Video course and PDF Download. Refer to the Workbook Introduction for instructions on where to send an Amazon receipt.

This Step-By-Step Workbook will cover three major Excel categories including Formulas, Formatting, and Printing. The following topics will be covered:

• Interface - This will provide an overview of the system including cell manipulation, entering data into cells, Quick Access Toolbar, and Zooming capabilities.
• General Formulas - This will include Sum, Average, Minimum, Maximum, Count functions, as well as other manually entered formulas. Also, it will cover formula manipulation techniques such as Fill Handle, Fill Down, Paste Special, Absolute Reference, and Copying a Formula.
• Row and Columns - This will include Insert, Delete, Hiding, and Auto-Adjust Columns/Rows. We will also cover ways to format and Auto-adjust multiple columns/rows at the same time.
• Worksheet Tabs - These are located on the bottom of the interface and will allow you to Insert, Delete, Rename, Move, Copy, and change the color of the Tabs. We will also cover how to manipulate information in cells and apply them to multiple sheets at the same time.
• Large Spreadsheet Management - This will cover View Workbooks Side-By-Side, Split, Freeze, Arrange All, and Arrange 2 Sheets Side-By-Side.
• Formatting - These chapters cover Font, Alignment, Number, Borders, Format Painter, and Fill Cell Features.
• Printing - This chapter will cover Repeat Title, Print Area, and Print Selection as well as how to Scale a sheet to fit a typical sized page.

What’s in the Workbook? Click on the left side of the screen: Look Inside!
Enter one of the following keywords: Formulas, Formatting, Print, Worksheets, Zooming, Sum, Average, etc.

How the Workbook is Designed
This Workbook contains over 200+ step-by-step practice exercises to help you get up to speed quickly and understand each concept. The commands and features are very similar to previous versions and differences are documented where appropriate. The following link is a Video Clip explaining how the courseware has been designed and how to use it most effectively.
www.elearnlogic.com/media/coursewareexplanation.mp4

About this title

About the Author

Jeff Hutchinson is a computer instructor teaching a variety of classes around the country. He has a BS degree from BYU in Computer-Aided Engineering and has worked in the Information Technology field supporting and maintaining computers for many years. He also previously owned a computer training and consulting firm in San Francisco, California. After selling his business in 2001, he has continued to work as an independent computer instructor/consultant around the country. Jeff Hutchinson lives in Utah and also provides training for Utah Valley University Community Education system, offering valuable computer skills for the general knowledge of students, career development, and career advancement. Understanding the technology and the needs of students has been the basis for developing this material. Jeff Hutchinson can be contacted at jeffhutch@elearnlogic.com or (801) 376-6687.

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2017
• Language: English
• ISBN 10: 1975985206
• ISBN 13: 9781975985202
• Binding: Paperback
• Number of pages: 129