Question about Microsoft Excel for PC
Posted by Anonymous on
If you have a number in Cell A2 (say 100), and you put the amount of percentage increase or decrease in Cell A3 (say -10%), then put this formula into Cell A4 to calculate the answer:
=A2*(1+A3) , which then shows as the answer (90).
Posted on Sep 08, 2014
Save hours of searching online or wasting money on unnecessary repairs by talking to a 6YA Expert who can help you resolve this issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
Here's a link to this great service
Posted on Jan 02, 2017
SOURCE: average handle time
I have created a spreadsheet for you to a) use and b) to learn from.
It is an Automated spreadsheet (as they should be) which calculates the number of minutes in a working week or month and calculates the average time per email giving Daily, Weekly and Monthly Outputs. It takes into account Public Holidays (or for time off). You can use the Output to create Graphs etc to visually display the Output.
It also allows you to calculate a Part Month average.
I have displayed it as it was CONSTRUCTED and as it would be USED.
The As Used worksheet is Protected and the only Inputs that can be done are in the Green Boxes (also the Saturday and Sunday boxes but you will need to Unhide the Validation List to include these and then to add 2 more columns titled Is Saturday? and Is Sunday? with the appropriate If Statement.
To unprotect the sheet go to Tools - Protection - Unprotect. There is no password so leave this blank.
All the workings are still there, the columns are just Hidden. To Unhide them, highlight the columns to the left and right of the hidden columns, click on Format - Columns - Unhide. To hide them again, highlight the columns that you want hidden, click on Format - Columns - Hide.
The LOGIC used (as in Functions) may seem complex but if you read the Descriptions in the first row you should be able to work out what and why it was done that way. Click on a cell to see what Function was used where.
You said that your spreadsheet was becoming a real mess, well I have created a monster for you (but not a mess).
I have uploaded the file to here:
Hope this gives you the push to really start using Excel.
Posted on Apr 08, 2008
SOURCE: i want the all excel formulas
You will never find a fully comprehensive list anywhere because there are literally hundreds in the basic Excel application and thousands that can be added in as you go via macros. More are being added every time a new version of Office comes out.
But, the easiest way however to get a basic list of functions if your not printing is to hit the function button and simply scroll down the list. The syntax (an example of the method by which you should be formatting the formula) and a definition will list in the bottom of the dialog as you select each function.
That said, you are better solving individual problems as you learn Excel then trying to memorize all the functions themselves. Many, such as mathematical operations are common sense anyway.
Posted on Jun 19, 2009
There are a couple of web sites out there have have good directions. Try these:
Posted on Sep 12, 2009
Tips for a great answer:
Nov 03, 2014 | Office Equipment & Supplies
Sep 18, 2014 | The Learning Company Achieve! Math &...
Dec 13, 2013 | Microsoft Excel for PC
Nov 17, 2011 | Microsoft Excel for PC
Sep 30, 2011 | Microsoft Excel 2010
Sep 20, 2008 | Microsoft Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
379 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: