Your Excel Survival Kit: A Guide to Surviving and Thriving in an Excel World

  • 2h 19m
  • Anne Walsh
  • Tickling Keys
  • 2016

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.

In this Book

  • Introduction
  • Back to Basics—What Do You Know Already?
  • Getting Your Data Together—Catching Your File
  • Further Cleaning, Slicing, and Dicing
  • The Vlookup() Function—An Excel Essential
  • Creating Pivot Tables
  • Using Power Query to Quickly Clean up Data
  • Beyond the Pivot Table—Power Pivot

YOU MIGHT ALSO LIKE

Book Microsoft Excel Professional 2021 Guide: A Complete Excel Reference, Loads of Formulas and Functions, Shortcuts, and Numerous Screenshots to Become an Excel Expert
Course Performing data analysis and forecasting in Excel 365
Rating 4.5 of 319 users Rating 4.5 of 319 users (319)
Book Excel for Finance and Accounting: Learn How to Optimize Excel Formulas and Functions for Financial Analysis

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Software Design and Development: Software Engineering & SDLC Phases
Rating 4.6 of 4717 users Rating 4.6 of 4717 users (4717)
Course Working with tables in Excel 365
Rating 4.5 of 2242 users Rating 4.5 of 2242 users (2242)
Audiobook Improve Your Communication Skills