Conditional Formatting, Tables and Charts in Microsoft Excel
1.符合資格者將於出貨後三個工作日陸續發送交易訊息通知。2.點數將於廠商出貨後,隔天起算110天後陸續確認發送。3.國際商家之商品金額及回饋點數依據將以商品未稅價格為準。4.國際商家之商品金額可能受匯率影響而有微幅差異。5.禮品卡支付以及使用未授權優惠碼不符合贈點資格。6.點數發送依據及返點上限將以「訂單總金額」計算(不含運費及稅額),不論訂單中有多少商品,於LINE購物皆視為只購買一商品(金額為當筆訂單所有商品加總金額),亦即點數回饋計算並非以coursera實際購買商品數量拆分計算 。7. 同6說明,訂單完成後的顯示金額可能包含部分運費或稅金,可返點金額將以系統回傳金額為準 8.若於商家App下單,不符合LINE購物導購資格。商品描述
In this project, you will learn how to analyze data and identify trends using a variety of tools in Microsoft Excel. Conditional formatting and charts are two tools that focus on highlighting and representing data in a visual form. With conditional formatting, you can define rules to highlight cells using a range of color scales and icons and to help you analyze data and identify trends or outliers. You will then use PivotTables to create summaries of the data that focuses on specific relationships which you will represent as a line chart and column chart. Both conditional formatting and charts are two useful ways of visually analyzing data and exploring trends.