Your Excel Survival Kit, 2nd Edition: A Guide to Surviving and Thriving in an Excel World
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
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.