Your Excel Survival Kit: Your Guide to Surviving and Thriving in an Excel world
by: Anne Walsh
ISBN-10: 161547045X
ISBN-13: 9781615470457
Released: 2016-06-01
Pages: 160
Book Description
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.
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
Roling inthe Wortkshets
Rolling in the Worksheets
rTinting in Excel
Charts,Charts,Charts
Keyboard Navigation
ummay
Chapter 2 Getting Your Data Together: Catching Your File
Creating a Spreadsheet List from Scratch
Getting 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
Using the lferrorO Function
Summary
Chapter 4 The VlookupO Function: An Excel Essential
Understanding the Vlookup) Function Syntax
Troubleshooting VlookupO: Dealina with #N/A
Understanding When to Use VlookupO
How to Solve Common VlookupO Problems
summay
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 Report Filters
Setting Up Slicers (but Only if You Have Excel 2010 or Later)
Chanaing pivot Table 1avout
Changing Pivot lable Layout
Ac0lng a alL
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 Format
Creating a Query in Power Query to Merge Data Sets
Summary
Chapter 7 Beyond the Pivot Table: Power Pivot
Instaling and Locating Power Pivot
Before You Start Using Power Pivot
Gettina Your Data into Power Pivot
Linking the Data Sets Together
Creating a pivot Table from the
Creating a Pivot Table from the Combined Data
Recommended Resources
ummay
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)
Your Excel Survival Kit Your Guide to Surviving and Thriving in an Excel world 9781615470457. zip[/erphpdown]
