國立虎尾科技大學 |

Advanced Excel Success = A Practical Guide to Mastering Excel /

Record Type:	Language materials, printed : Monograph/item
Title/Author:	Advanced Excel Success/ by Alan Murray.
Reminder of title:	A Practical Guide to Mastering Excel /
Author:	Murray, Alan.
Description:	XVIII, 349 p. 358 illus.online resource. :
Contained By:	Springer Nature eBook
Subject:	Microsoft software. -
Online resource:	https://doi.org/10.1007/978-1-4842-6467-6
ISBN:	9781484264676

Advanced Excel Success = A Practical Guide to Mastering Excel /
Murray, Alan.

Advanced Excel SuccessA Practical Guide to Mastering Excel /[electronic resource] :by Alan Murray. - 1st ed. 2021. - XVIII, 349 p. 358 illus.online resource.

Chapter 1: Excel Tricks and Data Tools -- Chapter 2: The 10 Power Functions of Excel -- Chapter 3: Advanced Formatting Techniques -- Chapter 4: Advanced Chart Tricks -- Chapter 5: Power Query – You Will Never Work the Same Way Again -- Chapter 6: Power Pivot – The Internal Data Model of Excel.

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. You will: 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.

ISBN: 9781484264676

Standard No.: 10.1007/978-1-4842-6467-6doiSubjects--Topical Terms:

1253736
Microsoft software.

LC Class. No.: QA76.76.M52

Dewey Class. No.: 004.165

Advanced Excel Success = A Practical Guide to Mastering Excel /
LDR:03025nam a22003855i 4500 001 1050344
003 DE-He213
005 20210624003943.0
007 cr nn 008mamaa
008 220103s2021 xxu| s |||| 0|eng d
020 $a 9781484264676 $9 978-1-4842-6467-6
024 7 $a 10.1007/978-1-4842-6467-6 $2 doi
035 $a 978-1-4842-6467-6
050 4 $a QA76.76.M52
072 7 $a UMP $2 bicssc
072 7 $a COM051380 $2 bisacsh
072 7 $a UMP $2 thema
082 0 4 $a 004.165 $2 23
100 1 $a Murray, Alan. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 932898
245 1 0 $a Advanced Excel Success $h [electronic resource] : $b A Practical Guide to Mastering Excel / $c by Alan Murray.
250 $a 1st ed. 2021.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2021.
300 $a XVIII, 349 p. 358 illus. $b online resource.
336 $a text $b txt $2 rdacontent
337 $a computer $b c $2 rdamedia
338 $a online resource $b cr $2 rdacarrier
347 $a text file $b PDF $2 rda
505 0 $a Chapter 1: Excel Tricks and Data Tools -- Chapter 2: The 10 Power Functions of Excel -- Chapter 3: Advanced Formatting Techniques -- Chapter 4: Advanced Chart Tricks -- Chapter 5: Power Query – You Will Never Work the Same Way Again -- Chapter 6: Power Pivot – The Internal Data Model of Excel.
520 $a 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. You will: 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.
650 0 $a Microsoft software. $3 1253736
650 0 $a Microsoft .NET Framework. $3 565417
650 1 4 $a Microsoft and .NET. $3 1114109
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484264669
776 0 8 $i Printed edition: $z 9781484264683
856 4 0 $u https://doi.org/10.1007/978-1-4842-6467-6
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)