相關主題
商品描述
Get the most out of Excel 2013 with this exceptional advice from Mr. Spreadsheet himself!
Excel 2013 is excellent, but there's lots to learn to truly excel at Excel! In this latest addition to his popular Mr. Spreadsheet's Bookshelf series, John Walkenbach, aka "Mr. Spreadsheet," shares new and exciting ways to accomplish and master all of your spreadsheet tasks. From taming the Ribbon bar to testing and tables, creating custom functions, and overcoming "impossible" charts, mixing nesting limits, and more, 101 Excel 2013 Tips, Tricks, & Timesavers will save you time and help you avoid common spreadsheet stumbling blocks.
- Reveals ways to maximize the power of Excel to create robust applications
- Draws on John Walkenbach's years of experience using Excel and writing more than 50 books
- Shares tips and tricks for dealing with function arguments, creating add-ins, using UserForms, working with dynamic chart data, and changing data entry orientation
- Provides shortcuts and helpful techniques for sorting more than three columns, entering fake data for testing purposes, and setting up powerful pivot tables
101 Excel 2013 Tips, Tricks, & Timesavers is packed with information that you need to know in order to confidently and seamlessly master the challenges that come with using Excel!
商品描述(中文翻譯)
「從試算表大師本人獲得對 Excel 2013 的最大利用！」
Excel 2013 是一個優秀的軟體，但要真正精通 Excel，還有很多東西需要學習！在這本廣受歡迎的「試算表大師書架系列」最新作品中，John Walkenbach，也就是「試算表大師」，分享了一些全新且令人興奮的方法，讓您能夠完成並精通所有試算表任務。從掌握功能表列到測試和表格，創建自訂函數，克服「不可能」的圖表，混合巢狀限制等等，《101 Excel 2013 必備技巧、訣竅和省時方法》將為您節省時間，幫助您避免常見的試算表困境。
本書揭示了最大化 Excel 功能以創建強大應用程式的方法，借鑒了 John Walkenbach 多年使用 Excel 和撰寫超過 50 本書的經驗，分享了處理函數引數、創建附加元件、使用使用者表單、處理動態圖表數據和更改資料輸入方向的技巧和訣竅，並提供了排序超過三列的快捷方式和有用技巧，輸入測試用的假資料以及設置強大的樞紐分析表。
《101 Excel 2013 必備技巧、訣竅和省時方法》充滿了您需要了解的資訊，讓您能夠自信且無縫地掌握使用 Excel 所面臨的挑戰！
