| Description |
1 online resource (179 pages) |
| Physical Medium |
polychrome |
| Description |
text file |
| Contents |
Front Cover; Title Page; Copyright; Table of Contents; 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; Keyboard Navigation; Summary; Chapter 2 Getting Your Data Together: Catching Your File. |
|
Creating a Spreadsheet List from ScratchGetting Data from a Data Dump; Sorting and Filtering; 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; Summary. |
|
Chapter 5 Creating Pivot TablesAssembling 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 Report Filters; Setting Up Slicers (but Only if You Have Excel 2010 or Later); Changing Pivot Table Layout; Adding a Chart; Adding Conditional Formatting; 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 FormatCreating a Query in Power Query to Merge Data Sets; 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; 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 ListSimple Normalization (Getting Crossways Data to Go Lengthwise or Vice Versa); Unpivoting Data; Index; Back Cover. |
| Summary |
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 in an easy accessible way-vlookups, pivot tables, Power Query, and Power Pivot. The Excel Survival Kit is small enough to slip into your purse. |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
Microsoft Excel (Computer file)
|
|
Microsoft Excel (Computer file) |
|
Microsoft Excel (Computer file) |
|
Business -- Computer programs.
|
|
Business -- Computer programs. |
|
Electronic spreadsheets.
|
|
Electronic spreadsheets. |
| Genre/Form |
Electronic books.
|
| Other Form: |
Print version: Walsh, Anne. Your Excel Survival Kit : Your Guide to Surviving and Thriving in an Excel world. : Holy Macro! Books, ©2016 9781615470457 |
| ISBN |
9781615472291 (electronic book) |
|
1615472290 (electronic book) |
|
9781615473526 (electronic book) |
|
1615473521 (electronic book) |
|
9781615470457 |
|
