Have a personal or library account? Click to login
Power Excel with MrExcel Cover

Power Excel with MrExcel

Master Pivot Tables, Subtotals, VLOOKUP, Power Query, Dynamic Arrays & Data Analysis

Publisher:Packt Publishing Limited
By: MrExcel's Holy Macro! Books and  Bill Jelen  
Paid access
|Oct 2024
Product purchase options

Master Excel 2019 and Office 365 with MrExcel's expert tips, updated for the latest features. Learn real-world strategies to solve problems and improve productivity.

Key Features

  • Updated version for Excel 2019 & Office 365
  • Enhanced course with reader suggestions
  • A combination of alternate strategies and common pitfalls

Book Description

Excel 2019 is more than just a spreadsheet tool; it's a powerful platform for solving complex data challenges. In this guide, MrExcel takes you through the essentials of Excel 2019, incorporating the latest features from Office 365. You'll start by mastering the Excel interface before moving on to advanced calculation techniques that streamline your workflow. The guide emphasizes data wrangling, teaching you how to transform raw data into meaningful insights with ease.

Beyond calculations, you'll learn to create visually appealing spreadsheets that communicate your data effectively. MrExcel's approach combines problem-solving strategies with real-world scenarios, ensuring you gain practical skills that apply directly to your work. Reader-sourced tips and solutions to common user pitfalls are integrated throughout the guide, offering a personalized learning experience.

By the end of this book, you'll have a solid understanding of Excel 2019's capabilities, enabling you to work faster, make informed decisions, and present your data professionally. Whether you're looking to enhance your existing skills or learn new techniques, MrExcel's expert guidance will help you master Excel and elevate your data analysis game.

What you will learn

  • Solve Excel problems efficiently
  • Apply new Excel 2019 features
  • Master Office 365 updates
  • Improve spreadsheet aesthetics
  • Streamline data wrangling
  • Employ faster formula techniques

Who this book is for

The ideal audience includes Excel users from beginners to advanced professionals looking to improve their efficiency in Excel 2019 and Office 365. A basic understanding of Excel is recommended to get the most out of this book.

Table of Contents

  1. The Excel Environment
  2. Calculating
  3. Wrangling Data
  4. Making Things Look Good
PDF ISBN: 978-1-83664-818-5
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2024
Language: English
Pages: 611
Related subjects:
Computer sciences,
Computer sciences, other

People also read

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
Your Excel Survival Kit
Book

Your Excel Survival Kit

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

Microsoft 365 Excel: The Only App That Matters

Books, MrExcel's Holy Macro!, Girvin, Mike
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
Don't Fear the Spreadsheet
Book

Don't Fear the Spreadsheet

Books, MrExcel's Holy Macro!, Jones, Kevin, Nash, Tyler, Urtis, Tom, Jelen, Bill
Excel Power Moves
Book

Excel Power Moves

Books, MrExcel's Holy Macro!, Umlas, Bob
Microsoft Excel Professional 2021 Guide
Book

Microsoft Excel Professional 2021 Guide

Singh Mehta, CA Manmeet
All-in-One:: Master the new features of Excel 2019
Book

All-in-One:: Master the new features of Excel 2019

Lalwani, Lokesh