Excel: the next level. Expert with formulas and charts
※注意事項:
1.需透過LINE購物前往並在同一瀏覽器於24小時內結帳才享有回饋,點數將於廠商出貨後,隔天起算之90個日曆天陸續確認發送。
2.國際商家之商品金額及回饋點數依據將以商品未稅價格為準。
3.國際商家之商品金額可能受匯率影響而有微幅差異。
4.若於商家App下單,不符合LINE購物導購資格。商品描述
This is a course for those who are already familiar with Microsoft Excel but need to move to the next level and understand how to create professional reports which require strong calculations and graphical representations of the data and data flow. The students get a first overview of the Info and Options areas where a lot of information and configuration is done in order to setup your files and report in the correct way. The course includes then: An overview of the functionalities and options of the different ribbons information about how to create advanced formatting using the conditional formatting functionalities instructions about how to define data validation for set of cells and ranges explanations of the main formulas and functions, especially about text, lookup & reference, information, logical, and more instructions about how to create and format charts will different set of data tutorial on how to create and manage pivot tables and charts instructions to protect a worksheet (entirely or partially) and a workbook At the end the students will be able to generate complex report, separating data from formulas, formatting tables, generate easily charts and modify them at a glance is a few clicks.