Your Excel Survival Kit - Second Edition


March 2021

Your Excel Survival Kit - Second Edition

Promoted into a job that requires more Excel skills than ever?

If you are floundering, drowning in a sea of spreadsheets, this book is for you.


category: Spreadsheets
covers: Office 365, Excel 2019

Product Details
  • 249 Pages
  • Publisher: Holy Macro! Books
  • ISBN: 978-1-61547-065-5
  • PDF ISBN: 978-1-61547-151-5

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace. Don't forget, Excel is used by more than 750 million people around the world - that means it's one of the most portable skills you will ever learn. Small enough to fit in your purse or handbag.

Updated since the first edition:

Funnel charts, waterfall charts, box & whisker charts, treemap charts, map charts, Countifs function, Sumifs function, Co-authoring, Dynamic arrays, threaded comments, Xlookup function, Pivot tables using the Data Model, pivot table defaults, Formatting and extracting in Power Query, Split by delimiter to rows in power query, Columns from example in Power Query, plus a new Chapter 8 on Power BI.

  • 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
    • 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

Where to Buy

MrExcel Bookstore

eBook from MrExcel.

MrExcel Bookstore

Print book from MrExcel.


Other Editions


Your Excel Survival Kit

June 2016

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.


Related Products


Don't Fear the Spreadsheet

June 2012

If you are heading to a job interview this afternoon where you have to "Know Excel", read chapter 9 this morning to get the lingo down. You will have familiarity with the important features in Excel.