Tuesday, May 29, 2007
Undiscovered Excel Funtions and Features
Microsoft has a web page on their site describing 30 little known features and functions in Excel.
Here's their blurb about it.
This article describes some of the most powerful and useful features and functions in Microsoft Excel that remain undiscovered by users. For example, you may create a new macro to perform a calculation when an existing formula or function can perform the task. Or, you may create a new macro to perform a task when you can use an existing feature that performs the task.Some of the functions include:
- Multiply text values by 1 to change text to numbers
Sometimes when you import files from other sources, numeric values may appear to be numbers but behave like text values. To resolve this problem, convert these values into numbers. One method for doing this is to multiply these text values by 1. - View the arguments in a formula
While you enter a formula in a cell, press CTRL+SHIFT+A to see the arguments in a formula. If you type =RATE, and then press CTRL+SHIFT+A, you can see all the arguments for that function--for example, =RATE(nper,pmt,pv,fv,type,guess). If you want more details, type =RATE, and then press CTRL+A to display the Function Wizard.
Labels: Excel, excel 2003, formulas, functions
The Excel Guru's Free Tips and Hints.
Welcome
Welcome to the Excel Tips blog. Free Microsoft Excel Tips and Hints designed to increase your productivity.
Advertisement
Subscribe Me
Previous Posts
- Excel VBA Macro Shortcut Keys
- Excel 2007 Tips
- List of Macro Shortcuts in All Open Workbooks
- Excel 2003-2007 conversion project
- Excel 2007 and backward compatibility
- Clear Excess Formatting in Excel Files
- Cheap Office 2007 for Australian Uni Students
- VBA Declaration of Variables
- Excel charts,
- Linking Cells to Chart Titles
My Blogs and Websites
- Spy Journal Home
- Spy Journal Archives
Personal Blog- Excel Tips Blog
- Blog Tips Blog
- Tech Tips Blog
- Urban Space Novel
- Photo Archive
- Parklife Results
- Parklife Soccer Club Website
- KROSTech LAN Parties
- Jethro Management
- Jethro Consultants
- Oz Bush Poet
Excel Links
- ---RSS Feeds---
- Unofficial Microsoft Office Stuff
- KC on Exchange and Outlook
- Office Zealot
- Automate Excel
- Colo's Excel Junk room
- Daily Dose Of Excel
- The Planning Deskbook
- Excel Pragma
- Andrew's Excel Tips
- ---No RSS Feed---
- Excel Tip
- Mailbarrow
- Experts Exchange
- AJP Excel Information
- Beyond Technology
- Contextures
- ExcelTip
- Mr Excel
- Pearson Software Consulting
- Peltier Technical Services
- John Walkenbach - J-Walk
- Vangelder (wont work in Firefox)
- VBA Express
- xlDynamic
- The Excel Nexus
- Code Net
- Better Solutions
- Excel Business Tools
- Data Pig Technologies
- VBA Express
Other Links
Copyright Notice. All documents and text contained in this web site www.spyjournal.biz and sub pages is copyright material of Jethro Management (c) 2004 unless noted as being copyright material of someone else. No public reproduction of the content on this site in any form is permitted without express written permission.
Unless otherwise expressly stated, all original material of whatever nature created by Tim Miller and included in this weblog and any related pages, including the weblog's archives, is licensed under a Creative Commons License.