和田會(huì)計(jì)繼續(xù)教育網(wǎng)：Excel2007新知-文檔主題_Excel2007的新特性（一）

高頓網(wǎng)校友情提示，*7和田會(huì)計(jì)繼續(xù)教育網(wǎng)上總結(jié)信息Excel2007新知-文檔主題_Excel2007的新特性等內(nèi)容公布如下：　　Document Themes Part I

　　In the last post, I presented an overview of the work we are doing in the area of “great looking documents”. Over the next few posts, I want to walk through a number of the improvements in a bit more detail. Today, I am going to introduce the idea of Document Themes, because a lot of the other features that I am going to discuss are tied into document themes in one way or another.

　　在上篇文章中，我概述了我們?cè)诰牢臋n方面所做的改進(jìn)。在接下來(lái)的這幾篇文章中，我想從更多的細(xì)節(jié)方面來(lái)進(jìn)一步介紹這些改進(jìn)。今天，我要介紹Document Themes(文檔主題)這個(gè)概念，以后將要介紹的許多其他的特點(diǎn)或多或少與Document Themes(文檔主題)有關(guān)。

　　To put it in the simplest terms, a Document Theme (or “theme” for the remainder of this post) is a new way to specify the colours, fonts, and graphic effects that can be used to format a document. We have integrated themes into the applications (Word, Excel, PowerPoint) wherever it is possible to apply formatting, and we have added a set of features to create new themes, change themes, specify themes for templates, etc.

　　Document Themes(文檔主題)(下面簡(jiǎn)稱(chēng)主題)是一種指定顏色、字體、圖形效果的新方法，能用來(lái)格式文檔。我們已經(jīng)將文檔主題整合到了應(yīng)用程序中(Word,Excel,PowerPoint)，使它在任何地方都能應(yīng)用。同時(shí)，還可以創(chuàng)建新的主題、改變主題、為模板指定主題等等。

　　There are a couple of goals behind this work. First and foremost, we wanted to give users a better set of tools for building good-looking documents without having to worry about the formatting for each element. For example, in current versions of Office, if a user inserts a table, a chart, and some text into a document, they need to worry about tweaking all the low-level formatting to try and make sure that everything matches and “looks good” (the latter being more subjective). The user interface does not make this easy, and the default out-of-the-box formatting does not help in most cases either. Second, we wanted to make it much easier for users to build Word documents that match PowerPoint documents that match Excel documents. Because the theme architecture is shared between all apps, users will find this much simpler. Third, we wanted to provide “professional design help” out of the box … meaning that we have professional designers creating the themes and the cell, Table, PivotTable, and chart styles that will be shipped in Excel 2007, so that users can take advantage of their work in creating documents. Finally, we wanted to make it easy to change the look of a document without needing to adjust all the element-level formatting.

　　這項(xiàng)工作的目標(biāo)是：*9，提供一組更好的創(chuàng)建精美文檔的工具，而不需要(逐個(gè)地對(duì)文檔的)每個(gè)部分進(jìn)行格式化。例如，在目前版本的Office中，如果用戶插入一張表格、一張圖表、和一些文本到文檔中，他們需要對(duì)這些部分的格式進(jìn)行逐步調(diào)整，并確定每一部分是否協(xié)調(diào)和“外觀精美”(后者是更主觀的)。用戶界面不會(huì)使這樣的操作變得容易，并且在大多數(shù)例子中這種預(yù)設(shè)的所見(jiàn)即所得格式也不會(huì)有助于更便利的操作。第二，使用戶建立的Word文檔更容易與PowerPoint文檔和Excel文檔相互兼容，因?yàn)橹黝}架構(gòu)就是讓所有的應(yīng)用程序間能更方便地共享。第三，提供所見(jiàn)即所得的“專(zhuān)業(yè)設(shè)計(jì)幫助”……這意味著在Excel 2007中將配置由專(zhuān)業(yè)的設(shè)計(jì)者所創(chuàng)建的主題樣式和單元格樣式、表格樣式、數(shù)據(jù)透視表樣式和圖形樣式，在創(chuàng)建文檔時(shí)能加以利用。第四，使改變文檔的外觀變得容易，而不需要調(diào)整所有(組成文檔的)部分的格式。

　　Let’s take a look at how this is exposed in the Excel user interface in a few places (same goes for Word and PowerPoint for the most part), and then talk through how to create and modify themes, how they related to templates, etc. (Note that a lot of this is primarily exposed through features like styles that I have only touched upon, so things should continue to get clearer after the next several posts.)

　　讓我們先看看在Excel中所顯示的(關(guān)于文檔主題的)用戶界面(這些界面大部分在Word和PowerPoint中是相同的)，接著介紹如何創(chuàng)建和修改主題，如何使主題與模板相關(guān)等等。(注：一些主要的界面像樣式特點(diǎn)在這里僅簡(jiǎn)略地提到，在后面的幾篇文章中將有更詳細(xì)的講述)

　　Each theme specifies two fonts – one for “headings”, and one for “body”. This distinction is more pr*ent in Word and PowerPoint, but we do have some cell styles (more on that in a later post) that use the heading font. Excel’s default text style uses the “body” font (the default out-of-the-box case being Calibri), so when users enter data, they are creating themed text. In addition, the Excel’s font picker has been updated to show the user the current theme fonts.

　　每一個(gè)主題指定了兩種字體，分別為標(biāo)題和正文設(shè)置。這種區(qū)分更普遍的存在于Word和PowerPoint中，但我們使用標(biāo)題字體設(shè)置一些單元格樣式(這將在后面的文章中詳述)。Excel的默認(rèn)文本樣式使用的是“正文”字體(默認(rèn)的是Calibri字體)，當(dāng)用戶輸入數(shù)據(jù)時(shí)，實(shí)際上他們就正在創(chuàng)建主題文本。另外，Excel的字體選取器相應(yīng)地顯示用戶當(dāng)前使用的主題字體。

　　Each theme specifies a number of colours (12 to be exact). Four of the colours are for text and backgrounds, six are for “accents”, and two are for hyperlinks (followed and not followed). Those 12 colours are designed to look good together. The colour model is designed to handle light text on dark backgrounds, dark text on light backgrounds, and everything in between. In Excel, this becomes important in charts for example. The colours are exposed in the new colour picker. The first four are the text/background colour, the next 6 are the accent colours, and the hyperlink colours are not exposed.

　　每一個(gè)主題指明了一些顏色(確切地說(shuō)是12種顏色)，4種是文本色和背景色，6種為強(qiáng)調(diào)色(“accents”)，2種為超級(jí)鏈接色(跟蹤的和沒(méi)有跟蹤的)。這12種顏色被設(shè)計(jì)組合在一起形成美觀的效果。顏色模式被設(shè)計(jì)來(lái)處理在深色背景下的淺色文本，淺色背景下的深色文本，以及介于深色和淺色之間的背景和文本。在Excel的圖表中，這是重要的。顏色顯示在新的顏色選取器中，前4個(gè)是文本色/背景色，接下來(lái)的6個(gè)是強(qiáng)調(diào)色，超級(jí)鏈接色未顯示。

　　Note a couple of other things. First, the 10 colours featured are designed to work well together – this is an example of a place where our professional designers have helped out. Second, for each of the 10 theme colours exposed, the first row shows the “most saturated” version, and then the next 5 rows show the same hue with different saturation and lightness. The goal here is to provide users with variants of a colour for use in different scenarios … for example, you would likely want a subtle blue for a cell background, and a more intense blue for a font colour. Third, at the bottom are non-theme standard colours that are always available. Finally, you can always choose “No Fill” or choose any colour you want.

　　注意其它的幾點(diǎn)：*9，這10種特定的顏色被設(shè)計(jì)在一起很好的協(xié)同工作，這是我們的設(shè)計(jì)專(zhuān)家已經(jīng)幫助完成的其中一個(gè)例子。第二，在所顯示的10個(gè)主題顏色中，*9行是“最飽和”顏色模式，接下來(lái)的5行顯示具有不同飽和度和明亮度的相同色調(diào)，目標(biāo)是提供在不同情況下不同的顏色……例如，單元格背景設(shè)置為淺藍(lán)色，而字體為深藍(lán)色。第三，(顏色拾取器界面)底部是可用的非主題標(biāo)準(zhǔn)色。最后，你總是能選擇”無(wú)填充色(No Fill)”或者選擇你想要的任何顏色。

　　In addition to the colour picker, theme colours are used cell styles, Table styles, and PiovtTable styles. More on that in later posts.

　　除了顏色拾取器外，在單元格樣式、表格樣式和數(shù)據(jù)透視表樣式中也能使用主題顏色，這將在后面的文章中詳細(xì)介紹。
 

　　Charts and shapes have been significantly upgraded – they look great, and they support a much wider set formatting options (more on that in posts coming soon). Each theme specifies the “effects” that will be used by charts and shapes – for example, whether lines are thick or thin, whether fills are simple or opulent, whether objects will have bevels or shadows, etc. This allows users to determine how subtle or intense they want their graphic objects to appear in their work.

　　極大的升級(jí)了圖表和形狀樣式——它們外觀精美，支持更多格式設(shè)置選項(xiàng)(這方面的內(nèi)容將在后面的文章中詳細(xì)介紹)。圖表和形狀能使用每個(gè)指定“效果”的主題——例如，直線的粗或細(xì)，簡(jiǎn)潔的或華麗的填充，對(duì)象有無(wú)斜邊或陰影，等等。這使得用戶可以決定工作表中圖形對(duì)象顏色的深淺程度。

　　Here is an example of a formatting gallery for a shape (a rectangle) – you can see how the theme colours and theme effects are combined to provide the user with a gallery of choices that are the result of a graphics designer making a hundred separate decisions.

　　下圖是一個(gè)形狀(矩形)的格式化gallery(圖形目錄)示例——能看到合并在一起的主體顏色和主題效果的gallery(圖形目錄)提供給用戶選擇，這里有圖形設(shè)計(jì)者創(chuàng)作出的一百個(gè)不同的效果。

 　　　　

　　掃一掃微信，學(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)，可以幫助考生全面提升備考效果。