What is the quickest way to copy/paste link as transpose in Excel?
There are two ways to do this that I'm aware of. The examples below assume the data to be in cells A1:A5 and the transposed data to be placed in B1:F11) TRANSPOSE function: Select the cells B1:F1. Enter the formula "=Transpose(A1:A5)". Press Ctrl+Shift+Enter, and voila! (The requirement of pressing Ctrl+Shift+Enter arises as this is an array formula)2) OFFSET function: In cell B1, type the formula "=Offset($A$1, column()-2, 0). Offset is a way to select a dynamic range, which is used in this case to select a cell which is 'column()-2' rows down and '0' columns right from the origin ($A$1). Drag this formula all the way to F1, and voila!TRANSPOSE: http://office.microsoft.com/en-u...Array formulas: http://office.microsoft.com/en-u...OFFSET: http://office.microsoft.com/en-u...
How do I write an Excel formula to add one day to a date that is written in text format, 6/25/2015 14:30?
In the one cell you would enter the date and time exactly as you have it -- let's call that cell address D2. In another cell you would simply put =D2+1 and format as date/time if Excel does not already do this for you.This works because Excel uses decimal equivalents for date and time. The decimal value of the date you have above is 42180.6. Because each day increments that number by 1, the number for 6/26/15 14:30 is 42181.6. Give it a try! Good luck!
How can you insert slicer on a line graph in Excel?
Thank you for the A2A :)If you have Excel 2010 or later, sure you can!Step 1 - Select your range and convert it into an a table (Insert Tab > Tables Section > Table):Step 2 - Insert the sliders you want (Insert tab > Filter Section > Slicer)Step 3 - Select the table and insert the Line Graph and edit it in order for it to make sense (Insert Tab > Charts Menu > Insert Line Chart)Step 4 - Enjoy
How can I calculate an annual sales growth rate in Excel?
Since you did not clarify how your data is set, I will make some assumptions:Assumption 1 - You have a table with the Sales values per each year like so:Assumption 2 - You want the growth in percentage and with no decimal places like so:TL;DR versionFull versionStep 1: Mathematical formula for growthWhere:PR = Percent RateVPresent = Present or Past ValueVPast = Value before VPresentStep 2: convert formula to ExcelFor:Year 2 values (C2)Year 1 values (B2)Answer:=(C2-B2)/B2Step 3: formatting - After selecting the values you want to format as a percentage click on Percent Style on the Number Section in the Home tab
How can you see HTTP headers in Chrome?
1. Go to Tools -> Developer Tools 2. Go to the Network tab3. optional: at the bottom of the Network tab, there's an icon that's a solid black circle. When you hover over it, the tooltip is "Preserve Log upon Navigation" If you click that button, it turns red ("recording") and then it won't clear the history when you navigate between pages so you get a full trace4. Pick the URL of the object you want to inspect headers forYou will see both request and response headers there.