Your Excel survival kit : a guide to surviving and thriving in an Excel world

Summary: Provides information for improving Excel skills, covering everything from vlookups, pivot tables, and Power Query to Power BI and Power Pivot.

Record details

ISBN: 9781615470655 (paperback)
Physical Description: print
x, 252 pages : illustrations ; 23 cm
Edition: Second edition.
Publisher: Merritt Island, FL : Holy Macro! Books, [2021]
Copyright: ©2021

Content descriptions

General Note:

Includes index.

Formatted Contents Note:

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.