Skip to main content
Have a personal or library account? Click to login
Slaying Excel Dragons Cover

Slaying Excel Dragons

A Beginner's Guide to Conquering Excel's Frustrations and Making Excel Fun

Publisher:Packt Publishing Limited
By:  and    
Paid access
|Mar 2025
Product purchase options
This title is not yet available for download
Description

A comprehensive guide to mastering Excel with shortcuts, data analysis, and advanced formulas. Perfect for all skill levels.

Key Features

  • Comprehensive coverage of Excel features and functions
  • Practical examples and step-by-step instructions
  • Focus on efficiency with keyboard shortcuts and advanced techniques

Book Description

This comprehensive guide is designed to elevate your Excel skills from beginner to advanced. Starting with the fundamentals, you'll learn how to navigate Excel's interface, use essential keyboard shortcuts, and manage data efficiently. As you progress, you'll dive into complex features like PivotTables, dynamic ranges, and advanced formatting, gaining the ability to handle intricate data tasks with ease.

The guide also covers powerful formulas and functions, including VLOOKUP, INDEX/MATCH, and logical tests. These tools will empower you to automate calculations, perform detailed analyses, and streamline your workflow. Additionally, you'll explore Excel’s data analysis features, such as sorting, filtering, and creating dynamic charts, enabling you to present your data clearly and effectively.

By the end of this book, you'll have a deep understanding of Excel's capabilities, equipped with the skills to tackle any spreadsheet challenge. Whether you're preparing for advanced data analysis or seeking to optimize your day-to-day tasks, this guide provides the knowledge and practical experience to make Excel work for you.

What you will learn

  • Master Excel's keyboard shortcuts
  • Apply advanced formulas and functions
  • Create and customize PivotTables
  • Utilize data analysis features
  • Format cells with conditional logic
  • Create and edit complex charts

Who this book is for

This book is perfect for Excel users of all levels who want to improve their efficiency and data analysis skills. A basic understanding of Excel is recommended, but the book starts with foundational topics and builds to advanced features, making it accessible to beginners and valuable to advanced users alike.

Table of Contents

  1. How Excel Is Set Up
  2. Keyboard Shortcuts
  3. Data in Excel
  4. Style Formatting and Page Setup
  5. Formulas and Functions
  6. Data Analysis Features
  7. Charts
  8. Conditional Formatting
  9. Find and Replace and Go To Features
PDF ISBN: 978-1-83664-532-0
Publisher: Packt Publishing Limited
Copyright owner: © 2024 Packt Publishing Limited
Publication date: 2025
Language: English
Pages: 578
Related subjects:
Computer sciences,
Computer sciences, other
BISAC subjects:
COM054000,
COM018000,
COM021000
Thema subjects:
UFC,
UNC,
GPH,
UN

People also read