Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    Only $11.99/month after trial. Cancel anytime.

    Learn to Use Microsoft Excel 2016 eBook
    Learn to Use Microsoft Excel 2016 eBook
    Learn to Use Microsoft Excel 2016 eBook
    Ebook470 pages1 hour

    Learn to Use Microsoft Excel 2016 eBook

    By Michelle Halsey

    ()

    Read preview

    About this ebook

    Learn how to use the features of Excel® 2016 and experience some of the new features that are offered in Excel® 2016. Excel® 2016 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your
    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
    LanguageEnglish
    PublisherSilver City Publications
    Release dateOct 10, 2020
    ISBN9781640042971
    Learn to Use Microsoft Excel 2016 eBook

    Related to Learn to Use Microsoft Excel 2016 eBook

    Related ebooks

    Applications & Software For You

    View More
    View More

    Related podcast episodes

    Related articles

    • Article

      Make Office Better

      Sep 22, 2021

      Make Office Better
      2 min read

    • Article

      50 Ways To Work Faster

      May 11, 2023

      50 Ways To Work Faster
      19 min read

    • Article

      50 Ways To Work Faster

      Jun 19, 2023

      50 Ways To Work Faster
      19 min read

    • Article

      Make Office Better

      Mar 29, 2023

      Make Office Better
      3 min read

    • Article

      Get Scripting

      Aug 20, 2024

      The Categories tab also includes an entry called Scripting and while novices are unlikely to get to grips with everything it offers straight away, over time it’ll take your shortcuts to another level. Scripting actions use your device’s system featur

      2 min read

    • Article

      Miscrosoft Excel

      Feb 8, 2021

      Miscrosoft Excel
      5 min read

    • Article

      General Office tips

      Aug 12, 2019

      General Office tips
      5 min read

    • Article

      At Work

      Aug 20, 2024

      Shortcuts are supposed to make performing tasks more efficient, so it’s rather fitting that they could save you lots of time and make you more productive when you’re working. As you look through the actions available to you in Shortcuts, you’ll find

      1 min read

    • Article

      50 Ways To Work faster

      Jul 18, 2023

      50 Ways To Work faster
      16 min read

    • Article

      Make Office Better

      Aug 25, 2021

      MICROSOFT WORD & EXCEL Regular Wikipedia users should consider installing an Office add-in that adds content to your your documents and spreadsheets. First, open Word or Excel, then click the Insert menu, followed by ‘Get Add-ins’. In the screen that

      2 min read

    • Article

      Embed An Excel File On Your Site

      Jul 20, 2022

      When you need to share data in an Excel spreadsheet, you could choose to extract it and then send it to members. An easier way is to embed it on your site for everyone to see. In our example, our local history club wants to share details of its yearl

      2 min read

    • Article

      What Should I Download?

      Mar 13, 2024

      Q I’m a retired pensioner looking for a cheap or free spreadsheet app. I did use Excel, but unfortunately I can’t afford to renew it. Can you suggest a free alternative? I’m using Windows 11. David Parnell A Take a look at LibreOffice, which comprise

      2 min read

    • Article

      Copilot Pro For Excel

      Mar 7, 2024

      Unlike the other Copilot Pro tools, Copilot for Excel is labelled prominently as “beta”. But even in this qualified state, it has the promise of being a game-changer for anyone who needs to work with data but doesn’t want to become an expert in writi

      2 min read

    Related categories

    Reviews for Learn to Use Microsoft Excel 2016 eBook

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      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.png

      To 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.png

      Step 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.png

      Chapter 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.png

      You 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.png

      Excel 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.png

      To 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.png

      Excel 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.png

      Step 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.png

      To 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.png

      Saving 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.

      Macintosh HD:Users:Halsey:Desktop:Microsoft Screen Shots:Excel 2013 Screen Shots:Essentials:29.png

      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.png

      Step 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.png

      Step 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.png

      Checking 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.png

      Step 2: Highlight the

      Enjoying the preview?
      Page 1 of 1