Documents

10 views

Excel 2016 Formulas, Charts, And PivotTable

Fórmulas y tablas de Excel
of 50
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Tags
Transcript
  Page 1 Excel 2016 - Formulas, Formatting And Printing  A Step-By-Step Training Guide   Excel  has become a valuable industry standard. Whether it is used to create a budget, list information, or improve math accuracy, it is a very useful resource. The chapters in this manual are grouped and organized to provide focus on various concepts and levels of complexity. The Excel 2010, 2013  and 2016 command and formula structures are very similar and this manual covers all versions. However, new features added to Excel 2013 and 2016  will be covered only as needed. Introductory Concepts - Formulas, Formatting and Printing This manual will cover three major Excel  categories including Formulas , Formatting , and Printing,  beginning with general operational concepts such as Interface , Cell   Manipulation , and Backstage   View.  General Formulas covered include Sum , Average , Minimum , Maximum , as well as manually entered formulas. The Formatting  chapters will cover the Font , Alignment , Number , Borders , and Fill   Cell  features. The Printing  chapter will cover Repeat   Title , Print   Area , and Print   Selection  as well as how to Scale  a sheet to fit a typical sized page. Other topics within this group include Quick Access Toolbar , Zooming   Capabilities , Creating  & Modifying   Spreadsheets , Entering Data into Cells , Autofill , Format , Insert   and   Delete,  as well as Manipulating Columns and Rows . Even if students have  previously used Excel  on some level, or are self-taught users, they 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 productivity and understanding of Excel  concepts. Copyright and Release Information This workbook/guide has been updated on 8/26/2017 (Version 2) and is designed for Excel   2016 . The command differences between Excel 2010, 2013 and 2016  are well documented. This guide is the sole  property of Jeff Hutchinson and eLearnLogic.  Any emailing, copying, duplication or reproduction of this guide, must be approved by Jeff Hutchinson in writing. However, students who take a class or purchase the guide are free to use it for personal development and learning.   ISBN-13: 978-1975985202 ISBN-10: 1975985206 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.   Introduction   Page 2 Table of Contents - A Step By Step Training Guide Chapter 1 - Overview / Interface ........................................................................................................... 4   Section 1: Interface ............................................................................................................................... 4   Section 2: Cell Manipulation ................................................................................................................ 6   Section 3: Backstage View ................................................................................................................... 8   Section 4: Optional Concepts.............................................................................................................. 10   Chapter 2 - Data Entry Techniques .................................................................................................... 12   Section 1: Cell Manipulation .............................................................................................................. 12   Section 2: Keyboard Commands ........................................................................................................ 13   Chapter 3 - Formulas And Functions.................................................................................................. 16   Chapter 4 - Formula Manipulation ..................................................................................................... 21   Section 1: Formula Manipulation ....................................................................................................... 21   Section 2: Fill Handle ......................................................................................................................... 22   Section 3: Paste Special ...................................................................................................................... 24   Section 4: Relative And Absolute Referencing .................................................................................. 27   Chapter 5 - Worksheets ........................................................................................................................ 28   Section 1: Worksheet Tabs ................................................................................................................. 28   Section 2: Column And Row Manipulation ........................................................................................ 29   Section 3: Large Worksheets .............................................................................................................. 30   Chapter 6 - Formatting ......................................................................................................................... 32   Section 1: Font Ribbon Group ............................................................................................................ 32   Section 2: Alignment Ribbon Group .................................................................................................. 33   Section 3: Number Ribbon Group ...................................................................................................... 34   Section 4: Border Format .................................................................................................................... 36   Section 5: Fill Cell Format .................................................................................................................. 38   Section 6: Optional Format Concepts ................................................................................................. 39   Chapter 7 - Printing .............................................................................................................................. 40   Section 1: Page Layout Ribbon Tab ................................................................................................... 40   Section 2: Print Options ...................................................................................................................... 42   Section 3: Page Setup ......................................................................................................................... 43   Section 4: Printer Properties ............................................................................................................... 44   Section 5: Header/Footer .................................................................................................................... 45   Chapter 8 - Application Options .......................................................................................................... 46   Major Project Intro Concepts - Creating a Budget ........................................................................... 48      Introduction Page 3 Exercise Download Exercises are posted on the website and can be downloaded to your computer. Please do the following :   Open Internet Explorer/Edge :  Or Google Chrome :   Type the web address :   elearnlogic.com/download/excel2016-1.exe   You might get several security warnings, but answer yes and run through each one. When you click “ Unzip ,”  the files will be located in C:\Data\Excel2016-1 folder. If there are any questions or problems, please contact Jeff Hutchinson at :   jeffhutch@elearnlogic.com Note:  For Mac  users, download the file at :  elearnlogic.com/download/excel2016-1.zip  Design Strategy This workbook is designed in conjunction with an Online-Instructor-Led course (for more information see: www.elearnlogic.com). Unlike other computer guides, students will not need to review lengthy  procedures in order to understand a topic. All that is necessary are the brief statements and command  paths located within the guide that demonstrate how a concept   is used. There are many Step-By-Step   Practice Exercises  and more comprehensive Student Projects  used to better understand a concept. Furthermore, students will find that this workbook guide is often used as a reference to help users understand concepts   quickly. An index is also provided on the last page of the workbook to reference important topics as necessary. However, if more detail is needed for study, the Internet can be used to search a concept . Also, if student’s skills are weak due to lack of use, they can refresh their knowledge quickly by visually scanning the concept   needed and then testing them out using the application. Manual Organization The following are special formatting conventions: ã   Numbered Sections  on the left are the Concepts  covered  .   ã   Italic Text  is used to highlight commands that will perform the Concept or procedure in completing the practice exercises. ã   Practice Exercises  are a Step-by-Step  approach to demonstrate the Concept.   ã   Student Projects are more comprehensive approach to demonstrate the Concept.   ã   Dark,   Grayed-Out Sections  are optional/advanced Concepts.   ã   Bolded  items are important Concepts,  terminology or commands used. ã   Tip  - These are additional ideas about the Concept.  
Advertisement
Related Documents
View more
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks