• About the site - Computer News Deals.com
  • Computer News Deals.com is a web portal with very unique concept of news blended with other important aspects of computer and internet technology.
Home : August 05 2016 Computer News : Excel: 5 timesaving power tips

Excel: 5 timesaving power tips

August 05, 2016

There's no such thing as too fast when you're crunching numbers on deadline in Excel. Any of these power tips will speed up your tasks. Did we miss an even better one? Let us know in the comments. 1. FORMULATEXT() adds notes to formulas If you and your colleagues share spreadsheets, it’s nice to have notes that explain what your formulas are doing (plus a copy of the formula). Some organizations even require it, especially if you’re a programmer or analyst. This little formula and the +N function are the quick answer to your spreadsheet documentation needs. Move your cursor to the column beside the formula column. If that column of cells has additional data in it, you can insert another column (which you can hide when you’re working or printing the spreadsheet), or you can create a separate “FORMULATEXT” matrix out to the side of your original spreadsheet.To read this article in full or to leave a comment, please click here

Link: http://www.pcworld.com/article/3088207/software/excel-5-timesaving-power-tips.html#tk.rss_howto
Related News
Linoma Announces Partnership with Syntax
2016 Olympics Gymnastics Contender Joins Champion Gymnastics & Cheer Coaching Team
Apple’s bug bounty program favors quality over quantity
Apple announces invitation-only bug bounty program at Black Hat conference