Learn to Use Microsoft Excel 2016 eBook
()
About this ebook
information. With Office® 2016 you are provided an improved landing screen, which makes launching, creating, collaborating, and sharing documents easier than previous versions of Excel. Excel® 2016 also has an improved user interface with an array of
powerful tools to help you manage your data through OneDrive – and better information leads to better decision-making! Learn to Use Excel® 2016 is an omnibus collection of tools and how to’s.
• Enter and edit data in a variety of ways
• Understand formulas, functions, and formula auditing tools
• Use the Quick Analysis features
• Format worksheets and data
• Print and share workbooks
• Use SmartArt and other objects in worksheets
• Create Pivot Tables and Pivot Charts
• Record and run macros
• Use analysis tools
• Work with data and create great visualizations
• Create arrays
• Create a form using a variety of controls
• Use trend lines, secondary axes and chart templates
• Work with slicers in PivotTables
• Create and manipulate a PowerView sheet
• 2 new chapters highlighting new features and short cut keys
Related to Learn to Use Microsoft Excel 2016 eBook
Related ebooks
Mastering Microsoft Excel: a Comprehensive Guide Rating: 0 out of 5 stars0 ratingsExcel 2003 Power Programming with VBA Rating: 5 out of 5 stars5/5Exploring Data with Access 2016 Rating: 0 out of 5 stars0 ratingsMastering Microsoft Excel 2016: How to Master Microsoft Excel 2016 in 30 days Rating: 5 out of 5 stars5/5Microsoft Excel for Beginners and Intermediates Rating: 0 out of 5 stars0 ratingsExcel Pivot Tables & Charts Rating: 0 out of 5 stars0 ratingsExcel 2019 – Business Basics & Beyond Rating: 0 out of 5 stars0 ratingsExcel 2007 for Scientists and Engineers Rating: 4 out of 5 stars4/5Intermediate Access: Access Essentials, #2 Rating: 0 out of 5 stars0 ratingsExcel 2016 Hands-On Lab Rating: 0 out of 5 stars0 ratingsThe Excel Essentials Quiz Book Rating: 0 out of 5 stars0 ratingsExcel Essentials Rating: 0 out of 5 stars0 ratingsLearn Excel Functions: Logical Functions (IF, AND, OR, NOT) Rating: 3 out of 5 stars3/5Excel 365 LOOKUP Functions: Easy Excel 365 Essentials, #6 Rating: 0 out of 5 stars0 ratingsInventory Analysis A Complete Guide - 2021 Edition Rating: 0 out of 5 stars0 ratingsIntermediate Excel 365: Excel 365 Essentials, #2 Rating: 0 out of 5 stars0 ratingsThe IF Functions: Easy Excel Essentials, #4 Rating: 0 out of 5 stars0 ratingsExcel Functions for the Daily User - Vol 2 Rating: 0 out of 5 stars0 ratingsExcel for Beginners: Excel Essentials, #1 Rating: 0 out of 5 stars0 ratingsWord for Beginners: Word Essentials, #1 Rating: 0 out of 5 stars0 ratingsExcel for the Math Classroom Rating: 5 out of 5 stars5/5The 50 Useful Excel Functions Quiz Book: Excel Essentials Quiz Books, #3 Rating: 0 out of 5 stars0 ratingsExcel Techniques Rating: 2 out of 5 stars2/5Microsoft Office Productivity Pack: Microsoft Excel, Microsoft Word, and Microsoft PowerPoint Rating: 0 out of 5 stars0 ratingsEmployability Skills: Brush Up Your Computing Rating: 0 out of 5 stars0 ratingsThe 50 More Excel Functions Quiz Book: Excel Essentials Quiz Books, #4 Rating: 0 out of 5 stars0 ratingsConditional Formatting: Easy Excel Essentials, #2 Rating: 0 out of 5 stars0 ratings
Applications & Software For You
Adobe Illustrator: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsExcel : The Ultimate Comprehensive Step-By-Step Guide to the Basics of Excel Programming: 1 Rating: 5 out of 5 stars5/5Learn to Code. Get a Job. The Ultimate Guide to Learning and Getting Hired as a Developer. Rating: 5 out of 5 stars5/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5Logic Pro X For Dummies Rating: 0 out of 5 stars0 ratingsGarageBand For Dummies Rating: 5 out of 5 stars5/5Six Figure Blogging In 3 Months Rating: 4 out of 5 stars4/5Blender 3D Basics Beginner's Guide Second Edition Rating: 5 out of 5 stars5/5Sound Design for Filmmakers: Film School Sound Rating: 5 out of 5 stars5/5The Best Hacking Tricks for Beginners Rating: 4 out of 5 stars4/5Gray Hat Hacking the Ethical Hacker's Rating: 5 out of 5 stars5/5How Do I Do That In InDesign? Rating: 5 out of 5 stars5/5Adobe Illustrator CC For Dummies Rating: 5 out of 5 stars5/5Start Your Own Podcast Business: Your Step-By-Step Guide to Success Rating: 5 out of 5 stars5/5GarageBand Basics: The Complete Guide to GarageBand: Music Rating: 0 out of 5 stars0 ratingsSynthesizer Cookbook: How to Use Filters: Sound Design for Beginners, #2 Rating: 3 out of 5 stars3/5Adobe Photoshop: A Complete Course and Compendium of Features Rating: 5 out of 5 stars5/5The Most Concise Step-By-Step Guide To ChatGPT Ever Rating: 3 out of 5 stars3/5iPhone Photography For Dummies Rating: 0 out of 5 stars0 ratingsSketchUp Success for Woodworkers: Four Simple Rules to Create 3D Drawings Quickly and Accurately Rating: 2 out of 5 stars2/5Blueprints to Building Your Own Voice-Over Studio Rating: 0 out of 5 stars0 ratingsAdobe Premiere Pro: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratingsAdobe InDesign CC: A Complete Course and Compendium of Features Rating: 0 out of 5 stars0 ratings2022 Adobe® Premiere Pro Guide For Filmmakers and YouTubers Rating: 5 out of 5 stars5/5Book Design Made Simple Rating: 0 out of 5 stars0 ratings80 Ways to Use ChatGPT in the Classroom Rating: 5 out of 5 stars5/5
Reviews for Learn to Use Microsoft Excel 2016 eBook
0 ratings0 reviews
Book preview
Learn to Use Microsoft Excel 2016 eBook - Michelle Halsey
Chapter 1 – Opening Excel
Welcome to the new and improved Microsoft Excel 2016. This chapter will teach you how to open Microsoft Excel files and create new ones. First, we will learn how to open Microsoft Excel. You will learn how to open files from the Recent list or other files. Then you will learn how to create a blank workbook or a workbook from a template.
Opening Excel
To open Excel use the following procedure.
Step 1: From the Start page, select the Excel 2016 icon.
You can get to this screen by pressing the Windows key.
Using the Recent List
To open a workbook from the Recent list, use the following procedure.
Step 1: Select the workbook that you want to open from the Recent list.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:2.pngTo pin an item on the Recent list, use the following procedure.
Step 1: Click the pin on the right side of the Recent list item. The item moves to the top section of the Recent list.
To unpin an item, click the pin on the right side of the Recent list again. The item returns to the previous location in the Recent list.
Opening Files
To open a workbook, use the following procedure.
Step 1: Select File and then Open from the Backstage View.
Step 2: Select one of the Places you would like to look for the workbook. The default options are Recent Workbooks, Shared with Me, Microsoft OneDrive location, This PC, Add a Place, and Browse.
To open a document from the OneDrive or your computer, select Browse.
In the Open dialog box, navigate to the location of the file you want to open. Select it and click Open.
Creating a Blank Workbook
To create a blank workbook, use the following procedure.
Step 1: If the Backstage view is not showing, select the File tab from the Ribbon. Select New.
Step 2: From the New tab, or if you have just opened Excel 2016, select Blank Workbook.
Creating a Workbook from a Template
To create a blank workbook from a template, use the following procedure.
Step 1: If the Backstage view is not showing, select the File tab from the Ribbon. Select New.
Step 2: From the New tab, or if you have just opened Excel 2016, select the template you want to use.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:7.pngStep 3: Select Create.
You can use the left and right arrows to review the other templates in the current search.
To search for a template and filter the results, use the following procedure.
Step 1: Select one of the Suggested Search terms or enter a term in the Search box and press Enter.
Step 2: To apply a filter, select the Filter term from the list on the right side of the screen.
Step 3: To return to the list of templates, select Home.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:10.pngChapter 2 – Working with the Interface
In this chapter, we will introduce you to the Excel 2016 interface, which uses the Ribbon from the previous two versions of Excel. You will get a closer look at the Ribbon and the Status bar. You will also learn how to manage your Microsoft account right from a new item above the Ribbon. This chapter introduces you to the Backstage view, where all the functions related to your files live. You will learn how to save files. Finally, we will look at closing files and closing the application.
Understanding the Interface
Explore the Excel interface, including the Ribbon, the formula bar, the worksheet area, the Quick Access toolbar, and the Status bar.
Each Tab in the Ribbon contains many tools for working with your workbook. To display a different set of commands, click the Tab name. Buttons are organized into groups according to their function.
The Quick Access toolbar appears at the top of the Excel window. It provides you with one-click shortcuts to commonly used functions, like save, undo, and redo.
We will discuss the Formula bar more in a later chapter.
The Status bar shows if any macros are currently running. It also allows you to quickly change your view or zoom of the workbook.
To zoom in or out, use the following procedure.
Step 1: Click the minus sign in the Status bar to zoom out. Click the plus sign in the Status bar to zoom in. You can also drag the slider to adjust the zoom.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:12.pngYou can also click on the number percentage to open the Zoom dialog box.
About Your Account and Feedback
Explore the account options, use the following procedure.
Step 1: Click the File ribbon.
Step 2: Click the Feedback option on the menu.
Step 3: Select the feedback option and provide the feedback.
Step 4: Enter the information requested in the Microsoft Office Feedback dialog. Select Submit.
Using Backstage View
Explore the Backstage View, use the following procedure.
Step 1: Select the File tab on the Ribbon.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:16.pngExcel displays the Backstage View, open to the Info tab by default. A sample is illustrated below.
Understanding Worksheets
To move the active cell, point out the highlighted row and column for the active cell, as well as the name of that cell in the Name box.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:18.pngTo insert a new worksheet, use the following procedure.
Step 1: Click the New Sheet plus sign.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:19.pngExcel opens the new worksheet to the first cell, so that you can begin entering data right away. You can rename the worksheet if needed.
To rename a worksheet, use the following procedure.
Step 1: Right click on the sheet tab and select Rename from the context menu.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:20.pngStep 2: Enter the new name over the highlighted text.
To switch to a different worksheet, use the following procedure.
Step 1: Click on the worksheet tab that you want to view.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:21.pngTo move a worksheet, use the following procedure.
Step 1: Click on the worksheet tab that you want to move and drag it to the new location in the workbook.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:22.pngSaving Files
To save a workbook that has not been previously saved, use the following procedure.
Step 1: Select the File tab on the Ribbon.
Step 2: Select the Save command in the Backstage View.
Step 3: Select the Place where you want to save the workbook.
Step 4: If you choose your OneDrive, you can select the Documents folder. If you choose your This PC, select your Current Folder or one of your Recent Folders. Or in either place, you can choose Browse to select a new location.
Step 5: The Save As dialog opens. Enter a File Name, and if desired, navigate to a new location to store the file. Select Save.
Closing Files vs. Closing Excel
To close a file, use the following procedure.
Step 1: Select the File tab from the Ribbon.
Step 2: Select Close from The Backstage View.
If you have not saved your file, you will see the following message.
To close the application (if only one workbook is open), use the following procedure.
Step 1: Click the X at the top right corner of the window.
Chapter 3 – Your First Worksheet
In this chapter, you will start entering data into a worksheet, including using flash fill and auto fill to quickly populate the information you need to store in your worksheet. You will also learn about editing data, including checking your spelling. Since you probably do not want to move all those rows or columns when you realize that you forgot one, you will also learn how to add rows and columns.
Entering Data
Review how a long label will overlap to the next column. In the following example, Car Payment
is too long for the column width.
To widen a column, use the following procedure.
Step 1: Click on the column you want to widen. Notice the cursor changes to a cross with double arrows. The screen tips indicate how wide in pixels the column currently is.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:30.pngStep 2: Drag the border to the new width
Using Auto Fill
To create a list using AutoFill, use the following procedure. This example creates new columns in the Budget worksheet to cover the second six months.
Step 1: Create a new column heading with the text July
in cell J4.
Step 2: Select that cell to make it active. Excel displays a handle around the cell.
Step 3: Drag the handle across the columns. Excel displays a screen tip showing what AutoFill will place in those cells.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:30.pngStep 4: Release the mouse button at the end of the range.
Editing Data
Explore the relationship between the active cell and the Formula Bar.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:31.pngChecking Your Spelling
Explore the Spell Checker, use the following procedure.
Step 1: Select the Spelling tool on the Review tab of the Ribbon.
Excel opens the Spelling dialog box and begins indicating any spelling errors.
Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:34.pngStep 2: Highlight the