Excel’s Operators CHEAT SHEET

Excel’s Operators CHEAT SHEET

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 […]

Read More

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 […]

Read More
change negative numbers to positive in Excel

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.

Read More
prevent edits to the final version of a workbook

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, […]

Read More
Real Excel power users know these 11 tricks

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 […]

Read More
How to create relational databases in Excel 2013

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 […]

Read More
Do more than just pie charts and bar charts

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, […]

Read More
Identical Excel worksheets

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 work­­sheets you’ll need. Select the first worksheet in […]

Read More
Recover Unsaved Excel File

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 […]

Read More
Calculator in Excel

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 […]

Read More