You’ve Recently Viewed

{{ item.rank.category_name }} {{ $isZh ? ' ' + item.rank.rank_name +' No.'+ item.rank.rank_num : '#'+item.rank.rank_num + ' ' + item.rank.rank_name }} {{ item.rank.category_name }}

{{ formatNumber(visualViewRate(item)) }} ({{ item.comment.comment_count > 0 ? item.comment.comment_count : __("Be the first!") }})

· {{ viewedItemSaleInfo(item) }}

Sold Out

Get Restock Alerts

Added to cart

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

Your email: {{remindEmail}}

Cancel

KingStone

【繁體】即學即用!超簡單的Excel巨集& VBA-別再做苦工!讓重複性高的工作自動化處理

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

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

Books Science books Encyclopedia knowledge

+ 4 images

Details

Full product details

内容簡介

打造自動化的 Excel 操作環境，提升職場工作效率！

相信不少人對 Excel 的公式、函數應用已經非常熟悉了，但是在進行大量數據的彙整、分析、美化時，還是會覺得現有的功能沒辦法滿足。雖然知道 Excel VBA 可以簡化工作，而且按個按鍵就能執行，但一想到要寫程式就非常頭大！

本書以循序漸進的方式，先從錄製巨集開始，帶您慢慢進入 Excel VBA 的設計領域，再逐步說明 VBA 的架構與用法，並搭配簡單易懂的範例讓您能立即練習應用，即使沒有任何程式基礎，也能親手撰寫 VBA 來提高作業效率，晉身職場高手！

‧如何參照上下左右的儲存格位置？
‧縮小與擴充儲存格範圍
‧插入或刪除儲存格／插入或刪除欄或列
‧設定儲存格的格式
‧變更工作表名稱與工作表標題的顏色
‧依照多個條件分別進行不同處理
‧在條件成立時，重複執行相同的處理
‧查詢工作表或活頁簿是否存在
‧篩選指定的資料
‧將列印範圍限縮在用紙範圍內
‧依照按下的按鈕進行不同的處理
‧新增表單中的文字標籤、文字方塊、命令按鈕、選項按鈕、核取方塊、下拉式方塊、…

本書特色

※圖解 + 實用範例，不懂程式設計，也能輕鬆學會 Excel VBA。
※用 VBA 簡化重複性的作業，避免人工作業疏失。
※從錄製巨集開始解說，體驗 VBA 的妙用。
※步驟解說清楚，順暢學習無障礙。

第1章　學會開發巨集的基礎知識
第2章　了解巨集與VBA的關係
第3章　學會VBA的基本知識
第4章　儲存格、列、欄的操作
第5章　調整表格的外觀
第6章　操作工作表與活頁簿
第7章　了解條件判斷處理與迴圈處理
第8章　排序與篩選資料
第9章　列印工作表
第10章　建立更為靈活的處理
第11章　建立使用者表單
附錄

内容簡介

打造自動化的 Excel 操作環境，提升職場工作效率！

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 {{ itemAct.title || '' }}

Bundle & Combo

【繁體】即學即用!超簡單的Excel巨集& VBA-別再做苦工!讓重複性高的工作自動化處理

Name: 【繁體】即學即用!超簡單的Excel巨集& VBA-別再做苦工!讓重複性高的工作自動化處理
Brand: KingStone
SKU: 3136058311
Price: 30.54 USD
Availability: OutOfStock

{{ 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 }}

Price:

Buy at VVIP Price

Learn more

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

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

Currently unavailable.

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

Unavailable in your area.

Sold Out

Sold by King Stone

Ship to

Free shipping over 49

Genuine guarantee

Ship from Taiwan

King Stone

Overall Rating 5

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

Best before

Frequently Bought Together

Total ${{ priceFormat(totalPrice) }}

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;

Yami reserves the right of final interpretation.

Sold by Yami

Service Guarantee

Free shipping from the US over $49

Easy Returns

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 Yami.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 from the US over $49

Easy Returns

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 Yami.com

Return Policy

Gifts Included with Purchase

Reviews ({{ commentList.posts_count }})

Sort by

Default

{{ commentRatingList[i] ? parseInt(commentRatingList[i]) : 0 }}%

Community photos

View All

Current Item

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

{{ comment.imageList.length }} photos

Show Original

No related comment~

Reviews

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

Write a review

No reviews for this product. Showing reviews from other options.

Sort by

Default

Community photos

View All

Current Item

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

{{ comment.imageList.length }} photos

Show Original

No related comment~

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 + ')' }}

{{ reply.reply_user_name }}reply to{{ reply.parent_user_name }}

{{ showTranslate(reply) }}Show Less

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

Show Original

Please write at least one word

Cancel

That’s all the comments so far!

Write a review

How would you rate this item?

Please add your comment.

A nice nickname will make your comments more popular!
The nickname in your account will be changed to the same as here.

Thanks for your review

Our community rely on great reviews like yours to find the best of Asia.

View the Story

About the brand

Download the Yami App

Feedback

Change Your Zip Code

Location History

【繁體】即學即用!超簡單的Excel巨集& VBA-別再做苦工!讓重複性高的工作自動化處理