Excel Crash Course
eBook - ePub

Excel Crash Course

PivotTables, Power Query, charts, essential functions with Python and Copilot for modern AI analysis (English Edition)

  1. 444 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Excel Crash Course

PivotTables, Power Query, charts, essential functions with Python and Copilot for modern AI analysis (English Edition)

About this book

Description
Excel is a powerful tool for data management and analysis, and mastering its tools is vital for anyone aiming to boost productivity in a data-driven world. This book is designed to help you master Excel's vast capabilities, guiding you from fundamental skills to advanced techniques for data analysis, visualization, and data management.

In the beginning, we cover basics like data entry, formatting, essential formulas, sorting, filtering, using tables, handling duplicates, and visualizing data with charts. Then, we dive into PivotTables, cleaning and transforming data, managing large datasets, named ranges, Excel shortcuts, templates, sharing and protecting data, and handling errors. You will learn modern Office 365 features, including the PY function for Python integration and Microsoft Copilot for AI-powered prompting.

By the end of this book, you will be well-equipped to transform raw data into professional dashboards and possess a practical understanding of advanced Excel logic. You will become confident in Excel skills to analyze data, optimize workflows, and create compelling reports, making this book your essential guide to mastering Excel.

What you will learn
? Understand formulas and functions confidently.
? Analyze data with PivotTables and dynamic dashboards.
? Automate data cleaning via Power Query and nested text functions.
? Boost productivity with Excel shortcuts, tips, and best practices.
? Integrate Microsoft Copilot AI prompts and Python-based PY function analysis.
? Work faster, analyze smarter, and deliver insights.

Who this book is for
This book is designed for everyday Excel users, data analysts, finance professionals, business executives, and managers who want to enhance their productivity, find answers quickly, analyze data, and get work done efficiently.

Table of Contents
1. Introduction to Excel
2. Quick Data Input and Formatting
3. Formulas and Functions
4. Managing Data
5. Create Amazing Charts and Visualize Data
6. Unlocking the Power of PivotTables for Data Analysis
7. Working with Large Datasets
8. Data Cleaning Made Easy
9. Boost Productivity in Excel
10. Troubleshooting Excel Files
11. Advanced PivotTable Mastery
12. Excel Formatting Unleashed
13. Advanced Excel Formulas
14. Using Power Query to Transform Data
15. Excel Best Practices
16. Latest Functions and Tools in Excel
17. Applying Artificial Intelligence with Excel Copilot

Trusted by 375,005 students

Access to over 1.5 million titles for a fair monthly price.

Study more efficiently using our study tools.

Information

Publisher
BPB Publications
Year
2026
Topic
Computer Science
eBook ISBN
9789365895636
Subtopic
Data Mining
Index
Computer Science

Table of contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication Page
  5. About the Author
  6. About the Reviewer
  7. Acknowledgement
  8. Preface
  9. Table of Contents
  10. 1. Introduction to Excel
  11. 2. Quick Data Input and Formatting
  12. 3. Formulas and Functions
  13. 4. Managing Data
  14. 5. Create Amazing Charts and Visualize Data
  15. 6. Unlocking the Power of PivotTables for Data Analysis
  16. 7. Working with Large Datasets
  17. 8. Data Cleaning Made Easy
  18. 9. Boost Productivity in Excel
  19. 10. Troubleshooting Excel Files
  20. 11. Advanced PivotTable Mastery
  21. 12. Excel Formatting Unleashed
  22. 13. Advanced Excel Formulas
  23. 14. Using Power Query to Transform Data
  24. 15. Excel Best Practices
  25. 16. Latest Functions and Tools in Excel
  26. 17. Applying Artificial Intelligence with Excel Copilot
  27. Index

Frequently asked questions

Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn how to download books offline
Perlego offers two plans: Essential and Complete
  • Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
  • Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.5M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Both plans are available with monthly, semester, or annual billing cycles.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1.5 million books across 990+ topics, we’ve got you covered! Learn about our mission
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more about Read Aloud
Yes! You can use the Perlego app on both iOS and Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app
Yes, you can access Excel Crash Course by Vinai Prakash in PDF and/or ePUB format, as well as other popular books in Computer Science & Data Mining. We have over 1.5 million books available in our catalogue for you to explore.