Your Excel Survival Kit 2nd Edition : Your Guide to Surviving and Thriving in an Excel World.

Format:

Book

Author/Creator:

Walsh, Anne.

Language:

English

Subjects (All):

Business--Computer programs.

Electronic spreadsheets.

Microsoft Excel (Computer file).

Physical Description:

1 online resource (267 pages)

Edition:

1st ed.

Other Title:

Your Excel Survival Kit 2nd Edition

Place of Publication:

Chicago : Holy Macro! Books, 2020.

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 the program in an accessible way-everything from vlookups, pivot tables, and Power Query to Power BI and Power Pivot. The Excel Survival Kit is small enough to slip into your purse and carry with you to the office.

Contents:

Intro

_GoBack

OLE_LINK5

OLE_LINK6

OLE_LINK1

OLE_LINK2

OLE_LINK32

OLE_LINK33

Keyboard_Nav

Recurring_list_creation

OLE_LINK38

OLE_LINK39

text_to_columns

Text_To_Columns_in_situ

OLE_LINK40

OLE_LINK41

OLE_LINK42

OLE_LINK3

OLE_LINK4

a

OLE_LINK45

OLE_LINK46

OLE_LINK9

OLE_LINK10

OLE_LINK11

OLE_LINK12

trim

OLE_LINK13

OLE_LINK14

Left

OLE_LINK15

OLE_LINK16

iferror

OLE_LINK28

OLE_LINK29

OLE_LINK17

OLE_LINK18

OLE_LINK24

OLE_LINK25

OLE_LINK19

OLE_LINK26

OLE_LINK27

OLE_LINK49

OLE_LINK50

OLE_LINK7

OLE_LINK8

Solution_1

OLE_LINK51

OLE_LINK52

OLE_LINK20

OLE_LINK21

OLE_LINK23

OLE_LINK60

OLE_LINK22

OLE_LINK53

OLE_LINK54

OLE_LINK30

OLE_LINK31

Refresh

OLE_LINK69

OLE_LINK70

OLE_LINK56

OLE_LINK57

OLE_LINK55

OLE_LINK71

OLE_LINK72

OLE_LINK67

OLE_LINK68

PasteSpecial

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

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

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

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()

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

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

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

Chapter 8 Meet Power BI, Your New Superpower

Downloading and Getting to Know Power BI

Case Study: What the Customer Wants

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.

Notes:

Description based on publisher supplied metadata and other sources.

ISBN:

9781615471515

1615471510

OCLC:

1251449191