Your Excel Survival Kit 2nd Edition

Name: Your Excel Survival Kit 2nd Edition | Your Guide to Surviving and Thriving in an Excel World
Brand: Holy Macro! Books
Price: 16.99 EUR
Availability: OnlineOnly

Your Guide to Surviving and Thriving in an Excel World

Anne Walsh(Autor*in)

Holy Macro! Books (Verlag)

Erschienen am 1. April 2020

267 Seiten

E-Book

ePUB mit Adobe-DRM

Systemvoraussetzungen

978-1-61547-151-5 (ISBN)

16,99 €inkl. 7% MwSt.

Systemvoraussetzungen

für ePUB mit Adobe-DRM

E-Book Einzellizenz

Als Download verfügbar

Beschreibung

Weitere Details

Weitere Ausgaben

Inhalt

Intro
_GoBack
OLE_LINK5
OLE_LINK6
OLE_LINK1
OLE_LINK2
OLE_LINK32
OLE_LINK33
Keyboard_Nav
OLE_LINK1
OLE_LINK2
Recurring_list_creation
OLE_LINK38
OLE_LINK39
text_to_columns
Text_To_Columns_in_situ
OLE_LINK40
OLE_LINK41
OLE_LINK42
_GoBack
OLE_LINK3
OLE_LINK4
a
OLE_LINK45
OLE_LINK46
OLE_LINK9
OLE_LINK10
OLE_LINK11
OLE_LINK12
OLE_LINK1
OLE_LINK2
trim
_GoBack
OLE_LINK13
OLE_LINK14
Left
OLE_LINK15
OLE_LINK16
OLE_LINK3
OLE_LINK4
iferror
OLE_LINK28
OLE_LINK29
OLE_LINK17
OLE_LINK18
OLE_LINK24
OLE_LINK25
OLE_LINK19
OLE_LINK26
OLE_LINK27
OLE_LINK49
OLE_LINK50
a
OLE_LINK7
OLE_LINK8
Solution_1
OLE_LINK51
OLE_LINK52
OLE_LINK20
OLE_LINK21
OLE_LINK9
OLE_LINK10
OLE_LINK23
OLE_LINK60
OLE_LINK22
OLE_LINK24
OLE_LINK25
_GoBack
OLE_LINK7
OLE_LINK8
OLE_LINK11
OLE_LINK12
OLE_LINK13
OLE_LINK14
a
OLE_LINK53
OLE_LINK54
OLE_LINK26
OLE_LINK27
OLE_LINK30
OLE_LINK31
Refresh
OLE_LINK1
OLE_LINK2
_GoBack
a
OLE_LINK28
OLE_LINK29
OLE_LINK2
OLE_LINK3
OLE_LINK69
OLE_LINK70
OLE_LINK5
OLE_LINK6
OLE_LINK56
OLE_LINK57
OLE_LINK1
OLE_LINK4
OLE_LINK7
OLE_LINK30
OLE_LINK31
OLE_LINK32
OLE_LINK33
a
OLE_LINK8
OLE_LINK55
OLE_LINK17
OLE_LINK5
OLE_LINK6
OLE_LINK71
OLE_LINK72
_GoBack
OLE_LINK67
OLE_LINK68
a
a
PasteSpecial
_GoBack
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
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

Systemvoraussetzungen

Als PDF speichern Als Link merken