臺(tái)州會(huì)計(jì)繼續(xù)教育網(wǎng)：Excel2007新知-圖表二_專業(yè)圖表輕松做(續(xù))+Excel2007鍵盤訪問模式

高頓網(wǎng)校友情提示，*7臺(tái)州會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-圖表二_專業(yè)圖表輕松做(續(xù))+Excel2007鍵盤訪問模式等內(nèi)容公布如下：　　Charting II – Professional charts, made easy (continued) + Excel 2007 keyboard access model …

　　圖表二: 專業(yè)圖表輕松做(續(xù))+Excel2007鍵盤訪問模式
 

　　Today I want to start with a link to Jensen Harris' UI blog, where Jensen has put up a post that describes the Office 2007 keyboard model. I am personally a big keyboard user, and I know the same is true for a lot of Excel users, so this is a topic that is near and dear to my heart. You can read the details for yourselves, but I want to summarize the key design points.

　　·Every one of the Office 2003 keyboard shortcuts (i.e. CTRL+B) continues to work the same in Office 2007; there's no relearning necessary.

　　·All of the Office2003 menu accelerators (i.e. ALT+I+R to insert a row) will work just like you were running Office 2003 … no need to activate any sort of legacy keyboard mode or anything like that - your menu accelerators just work (note, for the beta users out there, this is a change from beta1). This is very useful for those of us that have memorized menu accelerators over our lives using the product.

　　·Every single command in the Ribbon receives a letter – a KeyTip - which is used to activate that command via the keyboard. Basically, when you press the Alt key, the keytips show up on the ribbon, and you then simply need to press the appropriate letter to execute the command. Here is a picture of the keytips on the formulas tab.
 

　　今天我將通過Jensen Harris的博客介紹Office 2007鍵盤模式. 我個(gè)人經(jīng)常使用鍵盤,我知道有很多Excel的用戶也一樣，所以這是一個(gè)親切的主題。你可以自已閱讀相關(guān)的細(xì)節(jié),這里我僅說明設(shè)計(jì)的要點(diǎn)。.

　　·在Office 2007中繼續(xù)延用 Office 2003的鍵盤快捷鍵(比如CTRL+B)，這就不用再學(xué)習(xí)了。

　　·所有Office2003的菜單快捷鍵(比如用ALT+I+R插入一行)繼續(xù)延用，不需要為傳統(tǒng)鍵盤模式或菜單快捷鍵重新分類 (注,試用版除外，這與Beta1相比是個(gè)改變)。在使用中不用再背菜單快捷鍵，這對(duì)大家是非常方便的。

　　·當(dāng)Ribbon上的個(gè)別命令收到一個(gè)字母 - 一個(gè)關(guān)鍵首字母 – 即通過鍵盤來執(zhí)行命令?；旧?當(dāng)你按下Alt鍵, Ribbon上就會(huì)出現(xiàn)命令首字母，然后你只需按下適當(dāng)?shù)淖帜竵韴?zhí)行指令，下圖介紹的是一個(gè)函數(shù)選項(xiàng)卡上的命令首字母。

　　(Click to enlarge)

　　Again, for beta1 users, this is different from what you have seen. To quote Jensen: “The feedback we got from Beta 1 on the KeyTips was loud and clear: good idea, but the KeyTips key sequences are too long and inefficient compared to the old menu accelerators. So, we went back to the drawing board and looked at how we could shorten KeyTip sequences to be as short as possible. We removed an extra keystroke everywhere by no longer requiring you to type the KeyTip for the group a control is in. And, we did away with most of the two-letter KeyTips by adding numbers as potential KeyTips for very dense Ribbon tabs. The result? We ran an analysis of every single command in Office 2003 and Office 2007--and the average ‘keystroke length” to access a command has gone down considerably. And for frequently-used commands in Office 2007, most are accessible with Alt + two keystrokes, just like the top-level menu commands in Office 2003.”

　　然而,對(duì)beta1用戶來說與所看到的有所不同。Jensen指出:"從Beta 1獲得的反饋：命令首字母大而清晰非常好。但關(guān)鍵首字母的組合太長,比舊的菜單快捷鍵效率要低。 所以,我們回到圖板,看如何縮短關(guān)鍵首字母序列,越短越好。我們?nèi)コ艘粋€(gè)多余的鍵，輸入快捷鍵不再通過命令組了, 并且為Ribbon上較密的大部分兩個(gè)字母的標(biāo)簽增加了替代字母。結(jié)果呢? 我們分別在Office 2003 和 Office 2007中運(yùn)行每一個(gè)單獨(dú)命令進(jìn)行分析：運(yùn)行一個(gè)命令的平均按鍵次數(shù)大為降低，在Office 2007中幾乎接近Alt +二次按鍵，就像Office 2003中高效的菜單命令一樣。

　　I am interested to see feedback on these new designs as people get their hands on beta2, but I am pretty sure this represents a big step forward for keyboard access and the ribbon.

　　我非常想看到用戶對(duì)于新設(shè)計(jì)的beta2快捷鍵的反饋信息,但我肯定鍵盤訪問和ribbon是很大的改進(jìn)。

　　Back To Charting …

　　Last post, we discussed how we have tried to make it easier to create good-looking charts by providing users with four straightforward choices. Specifically, the choices are: chart types, chart layouts, chart styles, and document themes. The second two are covered in this post – the first two are in the previous post.

　　回到圖表

　　上一貼，我們討論了如何設(shè)法使人們更容易創(chuàng)建精美的圖表，向用戶提供簡單的四步選擇。具體而言,就是選擇: 圖表類型，圖表版式，圖表樣式，文檔主題.接下來的二步就在本貼介紹(這是上一貼的二步)。
 

　　The third major choice for creating a chart in Office 2007 is the chart style. I recently covered cell, Table, and PivotTable styles. Probably to none of your surprise, we have also added styles for Charts (and PivotCharts). The user model is the same for charts as the other objects that support styles – the user simply needs to select a chart and then pick from a set of available styles using a gallery in the ribbon. For example, here are the styles just for 2D clustered column charts in current builds.

　　圖表樣式

　　第三個(gè)主要步驟是在Office 2007中創(chuàng)造圖表樣式。我最近介紹了單元格、工作表、數(shù)據(jù)透視表的樣式，也許你并不感到驚奇,我們將介紹的圖表和數(shù)據(jù)透視圖的樣式。于圖表來說和其它對(duì)象的使用模式是相同的, 用戶只需要選中一個(gè)圖表，然后在ribbon上選擇內(nèi)置的一種圖表樣式。例如,下圖是現(xiàn)在內(nèi)置的2D風(fēng)格的柱形圖。

　　(Click to enlarge)

　　For other chart types, the styles look somewhat different, as you might expect. The styles vary widely from simple, flat styles with solid colours to more showy styles with bevel effects or shadows. The styles use colours from the document theme, either a variety of tints of shades of a single colour from the theme, or using all the colours from the theme. The overall goal is to provide a wide gamut of designs, so that users can create very simple or very showy charts quickly and without a lot of fiddling. The one key difference between chart styles and cell, Table, and PivotTable styles is that users cannot create their own chart styles – for Excel 2007, they will be limited to the several hundred that ship in the box.

　　對(duì)于其他圖表類型,正如你期望的這種樣式稍微有些不同. 這種樣式由于簡單，用平面風(fēng)格和過渡顏色加上倒角和陰影，顯得非常炫。這種樣式從文檔主題中設(shè)置顏色, 從文檔主題中選擇漸變色或所有的顏色?？傊?，提供了一個(gè)全方位的設(shè)計(jì)，使用戶可以快速創(chuàng)建非常簡單、非常炫的圖表。在圖表樣式和單元格、列表、數(shù)據(jù)透視表樣式間有一個(gè)主要區(qū)別是：用戶不能創(chuàng)建自己的圖表樣式-Excel2007中只能局限于幾百個(gè)內(nèi)置圖表樣式。
 

　　We have already discussed Document Themes in a number of posts. Charts use Document Theme information in pretty much the same way as Table and PivotTable styles – they pull their colour and font information from the Document Themes. In addition, charts use the lines, fills, and effects information from the theme that as well. Accordingly, your chart will automatically match the text, tables, shapes, and diagrams elsewhere in your document. Change themes, and your chart will change along with the rest of your document. Move your chart to another document, and you can choose to match the destination theme. More on that second point in a later post.

　　我們?cè)谝恍┵N子里已經(jīng)討論了文檔主題，在圖表中使用文檔主題和在表格、數(shù)據(jù)透視表中類似：從文檔主題欄設(shè)置顏色和字體。此外,在圖表中設(shè)置線條,填充色和效果也很好。從而令你的圖表自動(dòng)與文本、表格、自選圖形和其他圖表相匹配。修改主題取決于你的文檔，把圖表移到另一個(gè)文檔時(shí)，可以選擇適合目標(biāo)主題。在下一個(gè)貼子中再談第二點(diǎn)。

　　Summary

　　To show the wide variety of results from these four choices, I took the same data set and created pictures of it with two chart types, two chart layouts, two chart styles, and two document themes. Each of these charts is only four choices away from the original data set. You may have your favourites, but hopefully all of them are professional-looking charts. One other thing to keep in mind – a large number of charts created in Excel end up in PowerPoint, where dark backgrounds and contrasting colours are important for projection, so that should help explain some of the styles you see below.

　　概要

　　分四步創(chuàng)建各種圖表，我曾用同一組數(shù)據(jù)作圖，分別選擇兩種圖表類型，兩種圖表版式，兩種圖表格式，兩種文檔主題，每個(gè)圖表從原始數(shù)據(jù)選中開始僅用了四步。每個(gè)人都有最喜歡的圖表，但希望這些都是精美的專業(yè)圖表。記住另一件事,在Excel中創(chuàng)建一大批圖表最后用在PowerPoint中，在投影片中使用深色背景和對(duì)比色是非常重要的，將有助于突出主題，見下文。

　　(Click to enlarge)

 　　　　

　　掃一掃微信，學(xué)習(xí)實(shí)務(wù)技巧

　　高頓網(wǎng)校特別提醒：已經(jīng)報(bào)名2014年財(cái)會(huì)考試的考生可按照復(fù)習(xí)計(jì)劃有效進(jìn)行！另外，高頓網(wǎng)校2014年財(cái)會(huì)考試高清課程已經(jīng)開通，通過針對(duì)性地講解、訓(xùn)練、答疑、模考，對(duì)學(xué)習(xí)過程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。