Have a personal or library account? Click to login
Your Excel Survival Kit Cover

Your Excel Survival Kit

A Guide to Surviving and Thriving in an Excel World

Publisher:Packt Publishing Limited
By: MrExcel's Holy Macro! Books and  Anne Walsh  
Paid access
|Dec 2024
Product purchase options

Level up your Excel skills with practical insights on formulas, data cleaning, visualization, and analysis tools like Power Query and Power BI.

Key Features

  • Clear guidance on Excel tools, from basics to Power Query and Power Pivot.
  • Modern Excel features like XLOOKUP, dynamic arrays, and threaded comments.
  • Practical scenarios showing real-world problem-solving and reporting.

Book Description

This book starts off with the basics of data entry, formulas, and charts, it provides practical tips to simplify workflows and create clear visuals. Progress to advanced techniques like data cleaning, handling missing entries, and using logical functions, including modern dynamic arrays.

Learn to summarize and visualize data with pivot tables, troubleshoot common issues, and customize layouts. Explore VLOOKUP, XLOOKUP, and methods for tackling common challenges. Advanced chapters introduce Power Query for data merging, automation, and quick insights, while Power Pivot enables combining multiple datasets for detailed reports.

Finally, unlock Power BI to create professional-grade dashboards and visualizations. Designed for beginners and advanced users alike, this book equips you with the skills to streamline processes, analyze data effectively, and make informed decisions.

What you will learn

  • Master data entry techniques and functions
  • Create error-free pivot tables efficiently
  • Utilize Power Query for complex data clean-up
  • Explore Power BI for professional data visualization
  • Enhance productivity using keyboard shortcuts
  • Troubleshoot VLOOKUP and learn XLOOKUP

Who this book is for

This book is perfect for office workers, data analysts, and anyone looking to improve Excel skills. It is suitable for beginners with basic computer knowledge, though familiarity with Excel basics will be helpful.

Table of Contents

  1. Introduction
  2. Back to Basics: What Do You Know Already?
  3. Getting Your Data Together: Catching Your File
  4. Further Cleaning, Slicing, and Dicing
  5. The VLOOKUP() Function: An Excel Essential
  6. Creating Pivot Tables
  7. Using Power Query to Quickly Clean Up Data
  8. Beyond the Pivot Table: Power Pivot
  9. Meet Power BI, Your New Superpower
https://packt.link/Drc6u
PDF ISBN: 978-1-83702-216-8
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2024
Language: English
Pages: 266
Related subjects:
Computer sciences,
Databases and data mining

People also read

Power Excel with MrExcel
Book

Power Excel with MrExcel

Books, MrExcel's Holy Macro!, Jelen, Bill
Excel Outside the Box
Book

Excel Outside the Box

Books, MrExcel's Holy Macro!, Umlas, Bob
More Excel Outside the Box
Book

More Excel Outside the Box

Books, MrExcel's Holy Macro!, Umlas, Bob
Don't Fear the Spreadsheet
Book

Don't Fear the Spreadsheet

Books, MrExcel's Holy Macro!, Jones, Kevin, Nash, Tyler, Urtis, Tom, Jelen, Bill
Guerrilla Data Analysis Using Microsoft Excel
Book

Guerrilla Data Analysis Using Microsoft Excel

Books, MrExcel's Holy Macro!, Soleil, Oz du, Jelen, Bill
Slaying Excel Dragons
Book

Slaying Excel Dragons

Books, MrExcel's Holy Macro!, Girvin, Mike
Excel Insights
Book

Excel Insights

Books, MrExcel's Holy Macro!, MVPs, 24 Excel
Microsoft 365 Excel: The Only App That Matters
Book

Microsoft 365 Excel: The Only App That Matters

Books, MrExcel's Holy Macro!, Girvin, Mike
Microsoft Excel Professional 2021 Guide
Book

Microsoft Excel Professional 2021 Guide

Singh Mehta, CA Manmeet
Excel Basics
Book

Excel Basics

Hsu, Jeffrey, Bronson, Gary