Book
Your Excel survival kit : a guide to surviving and thriving in an Excel world
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. |
Search for related items by subject
| Subject: | Microsoft Excel (Computer file) -- Microsoft Excel (Computer file) Electronic spreadsheets |
Available copies
- 1 of 1 copy available at University College of the North Libraries.
Holds
- 0 current holds with 1 total copy.
Show Only Available Copies
| Location | Call Number / Copy Notes | Barcode | Shelving Location | Holdable? | Status | Due Date |
|---|---|---|---|---|---|---|
| The Pas Campus Library | HF 5548.4 .M523 W348 2021 (Text) | 58500001129121 | Stacks | Volume hold | Available | - |
You are now browsing University College of the North Libraries
|
HF 5548.4 .M523 P743 2013
Chemawawin Public Library at Easterville
|
HF 5548.4 .M523 R418 2008
UCN/Norway House Public Library
|
|
|
HF 5548.4 .M523 S53 2020
The Pas Campus Library
|
HF 5548.4 .M523 W348 2021
The Pas Campus Library
|
HF 5548.4 .M523 W567 2019
The Pas Campus Library
|
|
HF 5548.4 .M525 2001
UCN/Norway House Public Library
|
HF 5548.4 .M525 B47 2020
The Pas Campus Library
|
HF 5548.4 .M525 B47 2020
Thompson Campus Library
|
