Trending on TikTok

Buldak

Sunscreen

Sanrio

English

{{sellerTotalView > 1 ? __("sellers", {number: sellerTotalView}) : __("seller", {number: sellerTotalView}) }}, {{numTotalView > 1 ? __("items", {number: numTotalView}) : __("item", {number: numTotalView}) }}

View Cart & Check Out

Nickname

Let us know how to properly address you.

Update Your Name

xxxxxxx@yamibuy.com

Account Orders Favorites

Points 0

Coupons 0

Gift Card Balance $0.00

Sign Out

Change Your Zip Code

Inventory information and delivery speeds may vary for different locations.

Location History

We will notify you by email when the item back in stock.

Your email: {{remindEmail}}

Cancel

KingStone

【繁體】舞動 Excel 2010 中文版

View Cart & Check Out

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Books Science books Encyclopedia knowledge

KingStone

【繁體】舞動 Excel 2010 中文版

Name: 【繁體】舞動 Excel 2010 中文版
Brand: KingStone
SKU: 3136061941
Price: 31.71 USD
Availability: OutOfStock

{{__(":people-members", {'people': item.limit_people_count})}} {{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ item.invalid_price }} {{ itemDiscount }}

Ends in

{{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }}

{{ itemCurrency }}{{ item.valid_price }} {{ itemCurrency }}{{ priceFormat(item.valid_price / item.bundle_specification) }}/{{ item.unit }} {{ itemCurrency }}{{ item.invalid_price }} {{itemDiscount}}

Sale ends in

Sale will starts after Sale ends in

{{ __( "Pay with Gift Card to get sale price: :itemCurrency:price", { 'itemCurrency' : itemCurrency, 'price' : (item.giftcard_price ? priceFormat(item.giftcard_price) : '0.00') } ) }} ({{ itemCurrency }}{{ priceFormat(item.giftcard_price / item.bundle_specification) }}/{{ item.unit }}) Details

Best before

Currently unavailable.

We don't know when or if this item will be back in stock.

Unavailable in your area.

Sold Out

Details

Full product details

内容簡介

觀念詳解輕鬆學習
操作步驟圖文教學
秘笈技巧實用廣多
精心設計範例實用

史上最完整的入門指引
全文原創，絕非網頁文章拼湊成書
章節架構嚴謹流暢，絕無東拼西湊
應該有的，不漏失；不應該有的，不硬充篇幅
圖示註釋清晰詳實，無需勞動放大鏡幫忙
觀念釋疑與操作指引並重，不只是告訴你如何做(How)？更重要的是告訴你為什麼要這樣做(Why)？

第一篇基礎篇
第一章　認識Excel的操作環境
1.1　啟動與結束Excel
1.2　Excel視窗的組成元件
1.3　活頁簿視窗
1.4　認識Excel的智慧標籤選項按鈕

第二章　第一次建立活頁簿
2.1　新增一個活頁簿
2.2　選定儲存格或範圍
2.3　輸入資料
2.4　為工作表命名並加上標籤底色
2.5　活頁簿第一次儲存成檔案
2.6　開啟出舊有的檔案
2.7　特殊資料的輸入技巧
2.8　關閉經過編修的舊檔案
2.9　Excel的自動回復功能
2.10　儲存格的另類資料 ─ 註解
2.11　清除儲存格中的資料內容

第三章　提昇效率的輸入技巧
3.1　清單資料的類別與適用的編輯作業功能
3.2　變形的“自動校正”
3.3　好用的“自動填滿”
3.4　填出月底日期數列
3.5　輸入等比數列
3.6　聰明的“自動完成”
3.7　非常、非常重要的“自訂清單”
3.8　有彈性的“從下拉式清單挑選”
3.9　利用群組工作表

第二篇工作表編輯作業
第四章　公式與函數
4.1　建立公式
4.2　相對參照與絕對參照的差異
4.3　函數
4.4　不建立公式就取得統計資訊
4.5　工作表間的連結公式
4.6　含多重小計資料的自動加總
4.7　在公式中應用名稱
4.8　公式的稽核

第五章　工作表的格式設定
5.1　設定字型格式
5.2　變更欄寬或列高
5.3　改變資料在儲存格中的顯示位置
5.4　為儲存格範圍加上框線
5.5　為儲存格加上色彩及圖樣
5.6　數值的格式設定
5.7　自訂數值格式
5.8　樣式
5.9　多樣又易用的條件式儲存格樣式
5.10　自訂格式化的條件
5.11　欄列的隱藏與顯示
5.12　快速複製格式
5.13　工作表的保護機制
5.14　佈景主題

第六章　工作表的編修作業
6.1　複製儲存格資料
6.2　插刪欄、列
6.3　搬移儲存格資料
6.4　刪除儲存格
6.5　多重剪貼簿功能
6.6　儲存格資料的搜尋與取代
6.7　復原與取消復原
6.8　工作表的新增、搬移、複製與刪除
6.9　選擇性貼上由複製而得的資訊

第七章　應用實例與函數探討
7.1　如何從地址資料分割出縣市及鄉鎮區?
7.2　如何用分數表示佔有率?
7.3　如何將地址資料裡的半形數字轉成全形數字?
7.4　如何計算年資?
7.5　如何解決轉檔時日期資料的錯誤?
7.6　如何規避計算公式的錯誤值?
7.7　利用身份證字號判定出性別
7.8　有條件的加總
7.9　多重條件的加總
7.10　資料庫函數的應用
7.11　排名次問題
7.12　查表問題
7.13　如何計算物料需求量?
7.14　如何計算學生成績的落點?
7.15　想知道房貸中利息有多少?

第三篇輸出控制與圖表製作
第八章　活頁簿檔案的管理
8.1　分割視窗
8.2　凍結窗格
8.3　為同一活頁簿的另一張工作表開啟新視窗
8.4　如何讓工作表獨立成另一新的活頁簿？
8.5　檔案的摘要資訊
8.6　重新開啟出有連結關係的活頁簿檔案
8.7　儲存工作環境檔案
8.8　隱藏活頁簿視窗
8.9　改變連結對象
8.10　利用自訂檢視來保有不同的顯示比例
8.11　匯入文字檔資料
8.12　匯入Access檔案資料
8.13　Excel的巨集病毒防範措施
8.14　Excel活頁簿檔案的雜項作業

第九章　報表的列印控制
9.1　認識列印報表的基本程序
9.2　在整頁檢視模式下設定輸出版面
9.3　“分頁預覽”檢視模式
9.4　設定列印標題
9.5　強制分頁線的設定與取消
9.6　建立報表的頁首、頁尾資訊
9.7　設定列印方向
9.8　設定列印時的縮放比例
9.9　單獨列印圖表
9.10　設定列印範圍

第十章　建立統計圖表
10.1　圖表的基本概念
10.2　建立圖表的基本程序
10.3　圖表的版面配置設計
10.4　圖表物件的大小及位置的調整
10.5　在圖表中插入增刪的資料數列
10.6　選定所要處理的圖表元件
10.7　改變圖型的方法
10.8　圖表元件的增刪編輯技巧
10.9　圖表元件的格式設定
10.10　數值Y軸的格式變化
10.11　立體圖型的角度控制及數列順序
10.12　圖表的趨勢預測
10.13　以圖片來表達資料量
10.14　建立自己專用的自訂圖表格式
10.15　在儲存格中的迷你走勢圖

第四篇資料分析
第十一章　資料清單的排序及篩選
11.1　認識資料清單
11.2　資料清單內容的排序
11.3　Excel特有的依自訂清單排序
11.4　Excel特有的欄資料排序
11.5　篩選出想要的資訊
11.6　自動篩選的特殊應用：更正錯誤
11.7　進階篩選作業功能
11.8　認識Excel 2007新型的表格

第十二章　小計、大綱及資料統計
12.1　工作表的大綱模式
12.2　自動小計
12.3　資料驗證
12.4　多重工作表(檔案)的合併彙算

第十三章　樞紐分析表的應用
13.1　認識樞紐分析表
13.2　建立樞紐分析表
13.3　樞紐分析表的編修作業
13.4　樞紐分析表的版面與格式設定
13.5　運用樞紐分析表完成分組統計量
13.6　樞紐分析表的日期分組統計量
13.7　樞紐分析表的趨勢統計量
13.8　依報表篩選項目編製成個別的工作表
13.9　建立樞紐分析圖表
13.10　彙總結果的逆向查詢
13.11　現有樞紐分析表的更新

第五篇網路應用與巨集
第十四章　與工作小組共事
14.1　超連結的應用
14.2　共用活頁簿與追蹤修訂
14.3　用E-Mail方式將活頁簿傳給別人
14.4　將活頁簿檔案發佈成Web網頁

第十五章　打造一個自己的Excel
15.1　範本檔案的應用
15.2　自訂工具列
15.3　巨集初步(一)：錄製
15.4　巨集初步(二)：編修巨集
15.5　巨集初步(三)：執行巨集
15.6　巨集初步(四)：運用圖形物件來執行巨集
15.7　巨集初步(五)：自訂函數

Specifications

Brand

KingStone

Brand Origin

Taiwan

Net Content

Disclaimer

Product packaging, specifications and price are subject to change without notice. All information about the products on our website is provided for information purposes only. Please always read labels, warnings and directions provided with the product before use.

View Full Terms of Use

Scan to Share

Add to favorites

{{ $isZh ? coupon.coupon_name_sub : coupon.coupon_ename_sub | formatCurrency }}

Clip coupons

Quantity

{{buttonTypePin == 3 ? __("Scan to view more PinGo") : __("Scan to start")}}

Sold by King Stone

Ship to

Free shipping over 49

Genuine guarantee

Ship from Taiwan

View details

Region

Added to Cart

Keep Shopping

More to Consider

Coupons

Clip Clipped Over

Expires soon {{ formatTime(coupon.use_end_time) }}

Share this item with friends

Cancel

Yami Gift Card

Get this exclusive deal when paying with gift card

Terms and Conditions

Gift card deals are special offers for selected products;

The gift card deals will automatically be activated if a customer uses gift card balance at check out and the balance is sufficient to pay for the total price of the shopping cart products with gift card deals;

You will not be able to activate the gift card deals if you choose other payment methods besides gift card. The products will be purchased at their normal prices;

If your account balance is not enough to pay for the products with gift card deals, you can choose to reload your gift card balance by clicking on the Reload button at either shopping cart page or check out page;

Products that have gift card deals can be recognized by a special symbol showing 'GC Deal';

For any additional questions or concerns, please contact our customer service;

Yamibuy reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

Yami is committed to provide our customers with a peace of mind when purchasing from us. Most items shipped from Yamibuy.com can be returned within 30 days of receipt of shipment (For Food, Beverages, Snacks, Dry Goods, Health supplements, Fresh Grocery and Perishables Goods, within 7 days of receipt of shipment due to damages or quality issues; To ensure that every customer receives safe and high-quality products, we do not provide refunds or returns for beauty products once they have been opened or used, except in the case of quality issues; Some products may have different policies or requirements associated with them, please see below for products under special categories, or contact Yami Customer Service for further assistance).
Thank you for your understanding and support.

Learn More

Sold by Yami

Terms and Conditions of Yami E-Gift Card

If you choose “Redeem automatically” as your delivery method, your gift card balance will be reload automatically after your order has been processed successfully;

If you choose “Send to Email”as your delivery method, the card number and CVV will be sent to the email address automatically;

Any user can use the card number and CVV to redeem the gift card, please keep your gift card information safely. If you have any trouble receiving email, please contact Yami customer service;

Yami gift card can be used to purchase both Yami owned or Marketplace products;

Yami gift card will never expire;

Yami gift card balance does not have to be used up at once;

Return Policy

Gift card that has already been consumed is non-refundable.

Sold by King Stone

Fulfilled by Yami

Service Guarantee

Free Shipping over $49

Easy Returns

Ships from United States

Shipping

United States

Standard Shipping is $5.99 (Excluding Alaska & Hawaii). Free on orders of $49 or more.

Local Express is $5.99 (Available in Parts of CA, NJ, MA & PA). Free on orders of $49 or more.

2-Day Express (Includes Alaska & Hawaii) starts at $19.99.

Return Policy

You may return product within 30 days upon receiving the product. Items returned must be new in it's original packing, including the original invoice for the purchase. Customer return product at their own expense.

Sold by King Stone

Yami-China FC

Service Guarantee

Cross-store Free Shipping over $49

30-days Return

Yami-China FC

Yami has a consolidation warehouse in China which collects multiple sellers’ packages and combines to one order. Our Yami consolidation warehouse will directly ship the packages to your door. Cross-store free shipping over $69.

Return Policy

You may return products within 30 days upon receiving the products. Sellers take responsibilities for any wrong shipment or missing items. Packing needs to be unopened for any other than quality issues return. We promise to pack carefully, but because goods are taking long journey to destinations, simple damages to packaging may occur. Any damages not causing internal goods quality problems are not allowed to return. If you open the package and any quality problem is found, please contact customer service within three days after receipt of goods.

Shipping Information

Yami Consolidation Service Shipping Fee $9.99(Free shipping over $69)

Sellers in China will ship their orders within 1-2 business days once the order is placed. Packages are sent to our consolidation warehouse in China and combined there. Our Yami consolidation warehouse will directly ship the packages to you via UPS. The average time for UPS to ship from China to the United States is about 10 working days and it can be traced using the tracking number. Due to the pandemic, the delivery time may be delayed by about 5 days. The package needs to be signed by the guest. If the receipt is not signed, the customer shall bear the risk of loss of the package.

Sold by King Stone

Service Guarantee

Free shipping over 49

Genuine guarantee

Ship from Taiwan

Shipping

UPS Ground $11.99(Free shipping over $49)

Seller will ship the orders within 1-2 business days. It will not be shipped between April 7, 2019 and April 4, 2019. Orders during this time will begin shipping on April 8. Thanks for your cooperation.

Yami Points information

All items are excluding from any promotion or points events on Yamibuy.com

Return Policy

Download the Yami App

Feedback

Back Top

Reviews{{'('+ commentList.posts_count + ')'}}

Have your say. Be the first to help other guests.

Write a review

{{i}} star

{{i}} stars

{{ parseInt(commentRatingList[i]) }}%

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

{{ showTranslate(comment) }}Show Less

{{ strLimit(comment,800) }}Show more

Show Original

Show All

{{ formatTime(comment.in_dtm) }} VERIFIED PURCHASE {{groupData}}

{{ comment.likes_count }} {{ comment.likes_count }} {{ comment.reply_count }} {{comment.in_user==uid ? __('Delete') : __('Report')}}

No related comment~

Load more reviews

Review

{{ showTranslate(commentDetails) }}Show Less

{{ strLimit(commentDetails,800) }}Show more

Show Original

Show All

{{ formatTime(commentDetails.in_dtm) }} VERIFIED PURCHASE {{groupData}}

Please write at least one word

Comments{{'(' + replyList.length + ')'}}