TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Excel Formulas and Functions
      • Excel Keyboard Shortcuts
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2023
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 Accounting
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
Shop Now

How to Insert Functions into Spreadsheets in Excel 2013

by Keeley Byrnes / Friday, May 24 2013 / Published in Excel 2013, Latest

Excel is a multi-featured worksheet program in which you can create powerful worksheets that can manipulate numbers for you. It is a very powerful program, and has many advanced features that can automate and simplify your work. Whether you want it to create charts, worksheets, or data sources, Excel can assist you in accomplishing your tasks quickly and easily. In this post, we will discuss how to insert functions into spreadsheets in Microsoft Excel 2013. 

 

 

 

 

1. Click the “Insert Function” button in the “Function Library” group on the “Formulas” tab in the Ribbon, 

Slide1

or click the “fx” (function) button in the Formula Bar. Either of these will launch the “Insert Function” dialog box.

Slide2

 

2. In the “Insert Function” dialog box, search for a function by typing a few words that describe what you want to do into the “Search for a function:” text box and then clicking the “Go” button.

Slide3

3. Or, use the “Or select a category:” drop-down to select a category of functions to inspect for the one that you want to use. If you select the “All” category, you will see an alphabetized listing of all of Excel’s functions in the “Select a function:” text box. You can click on the function that you want to investigate to see a description of its function and syntax in the area below that.

Slide4

4. Select the function, then click the “OK” button to open the “Function Arguments” dialog box, (which is where you will complete the formula).

5. In the “Function Arguments” dialog box, click the small red, white, and blue “Collapse/Expand Dialog Box” button at the right end of any argument shown in the dialog box to collapse the “Function Arguments” dialog box down to a single line. This will give you room to select the cell or range of cells in the worksheet that you want to use for the argument’s reference.

Slide5

6. Simply click and drag over the cell, cell range, or cell ranges that you need to select to complete the selected argument. Then click the small red, white, and blue “Collapse/Expand Dialog Box” button again to expand the “Function Arguments” dialog box back to its full size. You can repeat this process until you have entered all of the required arguments for your selected function.

Slide6

7. Once you have entered all of the required arguments, click the “OK” button in the “Function Arguments” dialog box to insert the function into your worksheet.

Slide7

Tagged under: 2000, 2002, 2003, 2007, 2010, 2013, 97, book, cd, class, classes, course, courses, download, dvd, excel, excell, help, how, how-to, micro, microsoft, ms, office, online, soft, software, training, tutorial, video, xp

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.

What you can read next

Preview a Slideshow in Lightroom Classic CC- Instructions: A picture of a user previewing a slideshow in the Slideshow module of Lightroom Classic CC.
Preview a Slideshow in Lightroom Classic CC- Instructions
QuickBooks 2014 Training: How to Use QuickBooks Payroll- Creating Paychecks (pt 4)
A picture that shows how to create moving overlays in Photoshop Elements.
Moving Overlays in Photoshop Elements – Instructions
Save $150! One Year Online Entire Library $49. Click here for more info.

 

Recent Posts

  • Add Space in HTML – Instructions

    Add Space in HTML: Overview             This tu...
  • The Optics Panel in Camera Raw in Photoshop – Instructions

    Overview:             The Optics panel in Camer...
  • The Color Grading Panel in Camera Raw in Photoshop – Instructions

    Overview:             The Color Grading panel i...

Categories

Archives

  • GET SOCIAL

© 2001-2023 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! $49 All-Access 0 Days 12 Hours 35 Minutes 13 Seconds      $199 $49 Entire Library!
See Deal