麗江會(huì)計(jì)繼續(xù)教育網(wǎng)：Excel2007新知-非?？岬臓顟B(tài)欄和精美圖表

高頓網(wǎng)校友情提示，*7麗江會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-非?？岬臓顟B(tài)欄和精美圖表等內(nèi)容公布如下：　　Quick detour – cool things on the status bar and great-looking charts

　　Today I decided to take a quick break from Excel Services to

　　talk about a few small but useful changes that have been made to the status bar and

　　show off a few charts

　　First, the status bar

　　Zoom control - we have added a slider that allows the user to adjust the “zoom” of the document without needing to pop up any windows. When you slide the control, the document resizes as you slide, so you can adjust to just the “zoom” you want before you let go of the slider. You can also click on the + and – buttons to increment or decrement “zoom” by 10% per click. Finally, for those of you that like using the zoom dialog, you can just click on the 100% (which is a button) and it will launch the Zoom dialog.

　　我今天要談Excel2007中質(zhì)的突破：

　　1. 小巧變化的狀態(tài)欄

　　2. 炫耀幾個(gè)圖表

　　首先是狀態(tài)欄

　　縮放控制 - 增加了一個(gè)不需彈出窗口的控制滑塊來(lái)調(diào)整文件的縮放比例，當(dāng)你調(diào)整控制滑塊時(shí),文件同時(shí)改變顯示比例。你也可以在按“+”和“-”按鈕來(lái)放大或縮小顯示比例,每點(diǎn)一次調(diào)節(jié)10%。 最后,對(duì)于喜歡使用顯示比例對(duì)話框的人來(lái)說(shuō),也可以按100%(這是一個(gè)按鈕) 來(lái)調(diào)出顯示比例對(duì)話框.

　　Multiple status bar calculations – In previous versions of Excel, when you selected numerical data, you could see a summary of that data in the status bar – sum, count, average, etc. You could choose from 6 different summaries, but you could only see one at a time. That seemed unnecessarily limiting, so in Excel 12 we let you put any or all of them on the status bar, so you can see sum, min, max, numerical count, count, and average all at once if you like, or any combination of the six.

　　多樣化的計(jì)算狀態(tài)欄確 – 在之前的Excel版本中，當(dāng)你選中了數(shù)值數(shù)據(jù)時(shí)，可以在狀態(tài)欄看到這些數(shù)據(jù)的小計(jì) –求和，計(jì)數(shù)，平均值等等，可以選擇6種不同的小計(jì)方式，但一次只能看到一種。這是不必要的限制，所以在Excel 12中你可以把幾個(gè)或者全部的小計(jì)方式顯示在狀態(tài)欄，求和、*5值、最小值、計(jì)數(shù), 計(jì)數(shù)值,平均值的全部顯示或者顯示其任意組合。

　　You specify the items you would like to see by right-clicking on the status bar.

　　如果要自定義顯示項(xiàng)目只需在狀態(tài)欄上點(diǎn)擊右鍵，如下圖。

　　View switcher – In the tradition of Microsoft Word and Microsoft PowerPoint, we have added a set of buttons to the status bar that allow you to switch between views. One is for normal view, one is for page break preview, and the third is for a great new view we have added to Excel 12 – page layout view. Much more on page layout view when I cover the formatting, printing, and layout improvements we have made in Excel 12 (probably early next year at current speed).

　　視圖切換 - 在傳統(tǒng)的Microsoft Word和Microsoft PowerPoint中,我們已經(jīng)在狀態(tài)欄上增加了一組按鈕來(lái)切換視圖。一個(gè)是普通視圖, 一個(gè)是頁(yè)面視圖,第三個(gè)是一個(gè)全新的視圖,我們已經(jīng)加入Excel 12的頁(yè)面版式視圖。在Excel12的頁(yè)面版式視圖中，包含格式、打印和版式改進(jìn) (按照現(xiàn)在的進(jìn)度可能在明年初)。

　　Insert worksheet button – ok, this isn’t on the status bar, but it is close, so I am including it in this post. You may have noticed in previous posts that there was an additional small button after the tabs in the spreadsheets I have been showing off. When clicked, this button adds a worksheet. The point is simply to make it quicker to add worksheets to your workbooks.

　　插入工作表按鈕 – 好，這個(gè)不在狀態(tài)欄,但卻很接近,所以我把它也放在這個(gè)貼子中. 你也許看到過(guò)以前的貼子里展示過(guò)的這個(gè)新增加的工作表標(biāo)簽后的小按鈕。只要單擊這個(gè)按鈕就會(huì)在工作簿中  新增一個(gè)工作表，這一點(diǎn)比較快捷。
 

　　We have done a lot of great work in charting this release (see the overview post for a bit of a description). I am going to cover this work in detail sometime around the new year, but to give everyone an idea of what is coming, I thought I would post a few screenshots of charts I made yesterday afternoon. This should give everyone an idea as to the vastly improved charting that is coming with Office 12. The most obvious thing you will notice is the range of new graphic effects, like transparency, lighting effects, shadows, reflections, etc. Besides being much better looking with a greater range of graphic effects, we have also done a lot to make it a snap to create a very wide variety of different, professional-looking charts. Each of the charts below were created with no more than 2-3 clicks total, so the whole thing took a matter of minutes. Enjoy.

　　(Note, there is more than one chart on each screenshot, so I encourage you to click on the images below and take a look.)

　　在Office 2007版本中，我們?cè)趫D表方面做了很多工作 (參看總述貼子里的一些說(shuō)明). 在新的一年里我將詳細(xì)介紹圖表,為了讓大家對(duì)新的圖表有一個(gè)印象, 先貼一些我昨天下午做的圖表的屏幕截圖. 在Office 2007圖表中，給人的*9個(gè)印象就是作了許多改進(jìn)，最明顯的是你可以察覺(jué)的一系列新平面效果,如透明度、燈光效果,陰影, 倒影等。除了更加好看,我們也做了很多工作,使之能創(chuàng)建精美的專業(yè)圖表。每個(gè)圖表的創(chuàng)建總共不超過(guò)2-3次點(diǎn)擊,所以非常方便。 滿意。

　　(注,在每個(gè)屏幕截圖中不止一種圖表,所以我希望你點(diǎn)擊圖片的鏈接仔細(xì)地看看).

　　Next week, back to Excel Web Services and more about running spreadsheets on the server.

　　下周回Excel網(wǎng)絡(luò)服務(wù)器，并在服務(wù)器上多用用電子表格。

 　　　　

　　掃一掃微信，學(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)開(kāi)通，通過(guò)針對(duì)性地講解、訓(xùn)練、答疑、?？?，對(duì)學(xué)習(xí)過(guò)程進(jìn)行全程跟蹤、分析、指導(dǎo)，可以幫助考生全面提升備考效果。