Jul 06, 2016
Excel has over 350 worksheet functions that provide a massive array of different uses. From the simple =PI() function that refers to the value of Pi (3.14159265358979) to the =MIRR() function that, according to Excel’s help system, “returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest on reinvestment of cash”.
Although the syntax of worksheet functions is consistent, many of them have idiosyncrasies or just need detailed explanation to be able to use them effectively.
All commercial computer programs provide a help system, but these often lack detail and aren’t really good when troubleshooting, in my experience. Excel’s help on functions, however, is actually pretty good.
The ability to search for a function starts when a user clicks either the More Functions… option in the AutoSum menu or one of the two Insert Function buttons (one on the Formulas tab of the Ribbon and one immediately to the left of the Formula Bar):
The Insert Function dialog box then appears and has a search box at the top. You can type key words in this box the same way you would use a search engine. Once you click the Go button (or press Enter), the dialog box should display a list of recommended functions. Help on that function can be accessed by clicking the blue hyperlink at the bottom left that says Help on this Function.
When the user then clicks OK, another dialog appears so that the function’s Arguments can be entered and you're done.
How do your Excel skills stack up?
Test NowNext up:
- Honesty at work
- What is Continual Service Improvement (CSI)?
- Working with Styles - Part 2
- Create cascaded drop-downs in Microsoft Access forms
- PowerShell Basics Series – Measuring objects (Part 2)
- How to omit dates in an Excel chart axis
- 5 posts to help you become a better communicator
- SharePoint 2016 social features
- How-To series: Password protect sections in OneNote 2013
- Managing for excellence: An innovative approach to managing performance
Previously
- Providing feedback for user interactions
- Working with Styles - Part 1
- Millennial Musings
- View Types in SharePoint
- How to Establish a Creative Workforce
- Managing your Azure subscription using PowerShell
- Make a Form Read-Only in Access
- Diamond, Volcano or Pulp
- PowerPoint Designer
- Achieving more from Interpersonal Communication