Excel’s Operators CHEAT SHEET Believe it or not, Excel has 16 infix operators, 5 match fix operators, 3 prefix operators and a postfix operator. Infix Operators + Addition – Subtraction * Multiplication / Division ^ Exponentiation > is Greater than < is Less than = is Equal to >= is Greater Than or Equal to […]
Category: Excel Tips
Add A Character To Every Cell In Microsoft Excel 2010 / 2013
Sometimes we need to add a Prefix&Suffixto existing data to clearly indicate what the data pertains to and make it more understandable to the reader. If you want to add certain text in every selected cell beforeor after the original cell text, you can follow these steps, rather than editing each cell individually. This will save […]
How to Change Negative Numbers to Positive in Excel?
When you are processing operations in Excel, sometimes, you may need to change the negative numbers to the positive numbers or vice versa. Are there any quick tricks you can apply for changing negative numbers to positive? This article will introduce you the following tricks for converting all negative numbers to positive or vice versa easily.
How to prevent edits to the final version of a workbook
If you want to share the final version of a workbook and ensure that changes aren’t made to it, you can use the Mark as Finalcommand. This command communicates that you are sharing a completed version of the workbook and helps prevent reviewers or readers from editing it. When a file is marked as final, typing, […]
Real Excel Power Users Know These 11 Tricks
There are two kinds of Microsoft Excel users in the world: Those who make neat little tables, and those who amaze their colleagues with sophisticated charts, data analysis, and seemingly magical formula and macro tricks. You, obviously, are one of the latter—or are you? Check our list of 11 essential Excel skills to prove it—or discreetly pick […]
How to create relational databases in Excel 2013
Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up. Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated […]
Do more than just Pie Charts and Bar Charts
Beyond simple pie charts, bar and column charts, you can create an additional layer of information in your Excel charts. Two such techniques are a secondary axis and trendlines. Secondary axis As an example, say you have production cost and retail price information in a spreadsheet. The difference between these, divided by your production cost, […]
Quick Tip: Identical Excel worksheets
Q. What is the best way to create identical worksheets? I do a lot of copying and pasting, but I’m sure there is a better way. A. One of the easiest ways is to create them all at once. Try this six-step process. Create the number of blank worksheets you’ll need. Select the first worksheet in […]
How to recover unsaved excel file?
Recover Unsaved Excel File At times you get into a scenario when you have worked on a file and it is closed, for some reason, without being saved. It results into data lose to the extent it is not saved. If you are interested in learning as how to recover unsaved excel file, then keep […]
Do you know there is a Calculator in Excel?
Do you know there is a Calculator in Excel? Calculator in Excel is having lot of functionality like Standard / Scientific / Programmer / Statistics Calculator. It also do the Unit Conversion / Date Calculation and much more. Lets see how it can be added and the above mentioned functionality be used. Go to Customized Quick […]