Description |
1 online resource |
Physical Medium |
polychrome |
Description |
text file |
Contents |
Intro; About the Author; Acknowledgments; INTRODUCTION; So, What Is Power Query?; When I Became a Believer ... ; FIRST, SOME BACKGROUND FOR POWER QUERY; Excel Versions; Everything Happens via Queries; Data Types; Power Query Warnings; GETTING DATA INTO POWER QUERY; Importing Data from a Table or Range; Importing Data from a Workbook; FILL UP AND FILL DOWN; PARSING TEXT; Splitting Names by Delimiter; Splitting into Rows; SORTING IN POWER QUERY; MERGING DATA: JOINING AND APPENDING; Joins and Merging; Full Outer Join: Creating a Master List; Inner Join: Determining Who Registered and Attended |
|
Right and Left Anti Joins: Determining What's over Here That's Not over ThereRIGHT ANTI JOIN; LEFT ANTI JOIN; Left and Right Outer Joins: Power Query's VLOOKUP; LEFT OUTER JOIN; RIGHT OUTER JOIN; Appending Datasets; GROUPING DATA; REFRESHING AND UPDATING DATA; ADDING COLUMNS; Adding Conditional Columns; Adding Multiple Conditions; Adding Custom Columns; Adding Custom Columns with Power Query Functions and Adding Whole Numbers to Dates; Adding a Column Using Column from Examples; UNPIVOTING DATA; CONCLUSION |
Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Electronic spreadsheets -- Computer programs.
|
|
Electronic spreadsheets -- Computer programs. |
|
Business -- Computer programs.
|
|
Business -- Computer programs. |
Genre/Form |
Electronic books.
|
ISBN |
9781615471492 (electronic book) |
|
1615471499 (electronic book) |
|