Your Excel Survival Kit, 2nd Edition: A Guide to Surviving and Thriving in an Excel World

Length: 262 pages
Edition: 2
Language: English
Publisher: Holy Macro! Books
Publication Date: 2021-03-15
ISBN-10: 1615470654
ISBN-13: 9781615470655
Sales Rank: #2347399 (See Top 100 Books)

You have just been promoted into a job that requires more Excel skills than ever. You are floundering, drowning in a sea of spreadsheets. This book walks you through the program in an accessible way—everything from vlookups, pivot tables, and Power Query to Power BI and Power Pivot. The Excel Survival Kit is small enough to slip into your purse and carry with you to the office.

About the Author
Dedication
Acknowledgements
Introduction
Who This Book Is For
What This Book Covers
Typographical Conventions and Special Elements
Chapter 1 - Back to Basics: What Do You Know Already?
Data Entry Tips and Tricks
Dropping Your Dread of Formulas
Getting to Know the Common Excel Functions
Understanding the Copying Functions
Rolling in the Worksheets
Printing in Excel
Charts, Charts, Charts
Meet the IFSSSSSS family
Co-authoring – Excel will play with more than one person at a time!
Hooray for Dynamic Arrays!
Is it a note? Is it a comment? Er, no, it’s an Understanding AKA Threaded Comments
Keyboard Navigation
Summary
Chapter 2 Getting Your Data Together: Catching Your File
Creating a Spreadsheet List from Scratch
Getting Data from a Data Dump
Sorting and Filtering
No More CSV Nagging
Summary
Chapter 3 Further Cleaning, Slicing, and Dicing
Removing/Completing Blank Columns/Rows/Cells
Cleaning, Combining, and Amending Existing Data
Extracting Specific Pieces of Data from a Cell to Refine a Data Set
Using the Iferror() Function
Summary
Chapter 4 The Vlookup() Function: An Excel Essential
Understanding the Vlookup() Function Syntax
Troubleshooting Vlookup(): Dealing with #N/A Errors
Understanding When to Use Vlookup()
How to Solve Common Vlookup() Problems
Getting to Know Vlookup()’s new sibling - Xlookup()
Summary
Chapter 5 Creating Pivot Tables
Assembling Data for a Pivot Table
Creating Your First Pivot Table
Understanding Summarize Values By
Tidying Up the Numbers in a Pivot Table
Refreshing Data in a Pivot Table
Grouping by Dates
Grouping by Amounts
Showing Values As
Using Filters
Setting Up Slicers (but Only if You Have Excel 2010 or Later)
Changing Pivot Table Layout
Adding a Chart
Adding Conditional Formatting
Adding to the Data Model 
Setting Your Pivot Table Defaults
Troubleshooting Pivot Tables
Summary
Chapter 6 Using Power Query to Quickly Clean Up Data
Cleaning Up an Accounting Data Dump
Converting Unpivoted Data to a Pivoted Format
Creating a Query in Power Query to Merge Data Sets
Cleaning and Extracting Data
Splitting Data Entries onto Separate Columns Rows
Using the Column from Examples Feature to Transform Data
Summary
Chapter 7 Beyond the Pivot Table: Power Pivot
Installing and Locating Power Pivot
Before You Start Using Power Pivot
Getting Your Data into Power Pivot
Linking the Data Sets Together
Creating a Pivot Table from the Combined Data
Recommended Resources
Summary
Chapter 8 Meet Power BI, Your New Superpower
Downloading and Getting to Know Power BI
Case Study: What the Customer Wants 
Summary
Appendix Data Validation Techniques
Restricting Number Sizes
Restricting Date Entries
Restricting Text Length
Extending Data Validation
Applying Data Validation to Another Part of a Sheet
Identifying Duplicate Entries in a List
Simple Normalization (Getting Crossways Data to Go Lengthwise or Vice Versa)
Index