The following tabs list all features and commands included in Classic Menu for Excel 2010 (it is part one of Classic Menu for Office 2010). How to Bring Back Classic Menus and Toolbars to Office 2007, 2010, 2013, 2016, 2019 and 365? Excel 2010 offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if this is required to move the cell pointer. Once the function is in the cell, you can copy and then paste it into another cell to do the same function for that different range of cells. You can also use the AutoFill command (click cell with the function, then drag to the right or down). The formula adjusts automatically for the new values.

2010

I'm beginning a series on dashboards because I think creating attractive dashboards can be a essential skill every marketer wants to know. It's i9000 heading to end up being a lengthy series - but by the period we're completed, you'll become capable to create dashboards that exceI in both form and function. (Publisher's take note: This well-known series proceeds on Marketing Land with!) Why Use Combination Charts?

The very first ability we're going to focus on to that end is usually how to produce a combination chart. When I had taken, in my dissertation, Search engines Analytics evangelist Avinash Kaushik requested me why l didn't display visits and bounce rate collectively in the exact same graph. (Disclosure: I have always been not associated with MarketMotive in any method.) It's disturbing to confess this right now, but I had no concept how to perform that - or that you even could mix totally different metrics like that. But right now, I make use of them all the period. The reason is usually that they provide you the ability to demonstrate data tendencies aesthetically.

In Excel

(So thanks a lot, Avinash!) Some classic metrics I make use of regularly in combination charts are:. Year-over-year information. Trips vs.

Bounce rate. Income vs. Transformation rate. Campaign cost vs.

Conversions Download The Excel Doc If you'd like to follow along, sense free of charge to I taken all my scréenshots from. How Tó Create A Combination Chart Step 1: Possess a dataset with at least the two beliefs you need to chart. (I also usually.) Step 2: Click any cell inside your dataset and proceed to Put in >Charts >Place Column Graphs >Clustered Column (in 2013 on the Computer) or Charts >Line >Clustered Line (in 2011 on Macintosh). With my dataset, I'meters just heading to choose the Visits and Income columns since I possess an extra line for conversion rate. Latest version of word for mac. Click for larger image Action 3: Clear up your chart with the techniques I describe in this posting on.

I washed mine up using various of the strategies I defined in that post:. Removed gridlines. Thinned out the straight axis. Included an intuitive name. Eliminated the mark scars in the horizontal axis. Transformed the default column colours to suit my marketing by selecting one of thé columns in thé series and choosing my brand-new color making use of the Fill Color image (under House >Font for both variations) All of these options are accessible to you by basically pushing Ctrl-1/Command word-1 (PC/Mac pc). Click for bigger image Adding A Supplementary Axis Let's say we would like to also add conversion price to the chart.

I transformed the Revenue series back again to a column chart to reduce chart junk. One very cool trick to adding a new data series to a chart you've currently created is definitely to just select the column, copy it, choose the whole chart (you'll discover the whole chart specified), and then paste it in. It won't look incredible because we're pasting in a worth that's much less than one. But after that, all you possess to do if you're right after along with the download will be: with the chart selected, select the fresh series by heading to Graph Equipment >Structure tabs >Present Selection >Collection “Conversion Rate” (2011: Graphs tabs >Structure tabs >Current Selection >Series “Conversion Price). To alter the graph kind to a range chart, I'll break out the processes for 2013 and 2011 separately since the tips for the Mac are so different. 2013 (PC): With the Transformation Price series chosen, choose Style tabs >Type >Modification Chart Type.

Then, in the Change Chart Type dialog, arranged Conversion Rate to Series from the dróp-down. And put it in a secondary axis by selecting that choice. After that click Alright. 2011 (Mac): With the Conversion Price series chosen, choose Graphs tabs >Transformation Series Chart Type >Range >2-Chemical Range >Range. Then choose the collection again like you do before (it doesn't remain chosen for optimum frustration value) and push Control-1 to pull up your formatting choices. In the Structure Data Collection dialog, choose Axis >Secondary axis. After that click OK.

I changed the series color to natural, thinned out the supplementary axis, and ditchéd the decimal places. If you wear't need them to interpret the information, quit them to the control. (I nearly always get rid of decimal locations in my axes!). Click on for larger image And, here's one even more I did for a client to be capable to look at their PPC campaign costs vis-a-vis their results. In this situation, the very first action in their conversion funnel is usually a contact. Best email app for mac and iphone.

The last step is usually an actual job. This graph has even more data than most I produce, but I wanted to capture both stages of sales in one graph. You can observe that two of their campaigns in Bing went eight occasions more jobs than their AdWords campaign they're also sinking many of their sources into, for much less than 1/10 the price. That's actionable data right presently there!