文件名称：Your Excel Survival Kit: Your Guide to Surviving and Thriving in an Excel world
文件大小：10.66MB
文件格式：PDF
更新时间：2022-01-27 12:48:44
EXCEL
Your Excel Survival Kit: Your Guide to Surviving and Thriving in an Excel world By 作者: Anne Walsh ISBN-10 书号: 161547045X ISBN-13 书号: 9781615470457 出版日期: 2016-06-01 pages 页数: 160 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 pages 页数 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