相關主題
商品描述
Explore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel.
Advanced Excel Success starts with a few useful data tools in Excel followed by advanced formulas that will help you increase productivity. Here, you will learn power functions that aggregate, return ranges, and much more. Further, you will look at custom formatting tricks along with advanced charting tricks. These include automatically changing the color of key metrics, dynamically sorting chart data, and building creative labels.
Next, you will understand the role of Power Query which is one of the most important upgrades in Excel. Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables business users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, with an easy-to-use, engaging, and no-code user experience. Finally, you will learn Power Pivot which is a distinct feature in Excel that goes beyond spreadsheets.
After reading this book, you will be well equipped to work on Excel with its advanced features.
What You Will Learn
- Work with the most useful data tools Understand formulas and the ten power functions
- Use advanced chart and formatting tricks and techniques for dynamic and effective visuals Work with power tools
Who This Book Is For
Excel users looking to take the next step to expert level.
商品描述(中文翻譯)
探索 Excel 的進階技能，獲得一系列驚人的技巧和工具，以提高您的生產力。本書討論了新的技術，例如強大函數、圖表技巧等，幫助您精通 Excel。
《進階 Excel 成功》首先介紹 Excel 中幾個有用的數據工具，接著是能幫助您提高生產力的進階公式。在這裡，您將學習聚合、返回範圍等強大函數。此外，您還將了解自訂格式技巧以及進階圖表技巧，包括自動更改關鍵指標的顏色、動態排序圖表數據和創建創意標籤。
接下來，您將了解 Power Query 的角色，這是 Excel 中最重要的升級之一。Power Query 是微軟的數據連接和數據準備技術，使商業用戶能夠無縫訪問存儲在數百個數據源中的數據，並根據需求進行重塑，提供易於使用、引人入勝且無需編碼的用戶體驗。最後，您將學習 Power Pivot，這是 Excel 中一個超越電子表格的獨特功能。
閱讀完本書後，您將能夠熟練使用 Excel 的進階功能。
您將學到的內容：
- 使用最有用的數據工具
- 理解公式和十個強大函數
- 使用進階圖表和格式技巧，創造動態且有效的視覺效果
- 使用強大工具
本書適合對象：
希望邁向專家級別的 Excel 使用者。
作者簡介
Alan is a Microsoft MVP, Excel trainer, YouTuber, and freelance writer. He has been helping people in Excel for over 20 years. He loves training and the joy he gets from knowing he is making people's working lives easier.
Alan runs his own blog - Computergaga - and writes for multiple other websites. His YouTube channel has over 500 videos and over 24 million views. He organizes a monthly Excel meetup in London where the Excel community learns, shares, and enjoys each other's company.
作者簡介(中文翻譯)
艾倫是微軟MVP、Excel培訓師、YouTuber和自由作家。他在Excel方面已經幫助人們超過20年。他熱愛培訓，並從中獲得快樂，因為他知道自己正在使人們的工作生活變得更輕鬆。
艾倫經營自己的部落格 - Computergaga - 並為多個其他網站撰寫文章。他的YouTube頻道擁有超過500部影片和超過2400萬次觀看。他在倫敦組織每月一次的Excel聚會，讓Excel社群學習、分享並享受彼此的陪伴。
