
- English
- ePUB (mobile friendly)
- Available on iOS & Android
About this book
If you're using Excel, this is the all-in-one manual you need—brimming with solutions for every conceivable task! Learn how to design tables, use formulas to perform calculations, create analyses, graphically present your data, and share your results. With detailed coverage of both basic functions and advanced features, this book provides guidance for beginners and serves as a reliable reference if you're already familiar with Excel. Up to date for Excel 2024 and Microsoft 365!
In this book, you'll learn about:
a. Excel Fundamentals
Follow a workflow that guides you through Excel's user interface, introduces basic concepts, and demonstrates the core features for working with tables, diagrams, and files.
b. All Your Excel Tasks
Dive into everything Excel has to offer. Master spreadsheet functions, formula usage, and table design. Get step-by-step instructions for analyzing, visualizing, and publishing your data; then see how to automate and customize your tasks with macros and VBA.
c. Practical Examples
See Excel's features in action. Detailed examples and annotated screenshots guide you through each and every spreadsheet function, table design and analysis, data model management, and more.
Highlights include:
1) Mastering basic features
2) Creating spreadsheets
3) Working with formulas
4) Evaluating what-if analyses
5) Designing charts and diagrams
6) Visualizing data with sparklines
7) Organizing data in tables
8) Exporting, importing, and exchanging data
9) Automating tasks with macros
10) Using Visual Basic for Applications (VBA)
Frequently asked questions
- 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.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Notes on Usage
- Preface
- 1 Basic Knowledge for Working with Excel
- 2 The Structure of Spreadsheets
- 3 Working with Formulas
- 4 Designing Worksheets
- 5 Analysis and Forecasting
- 6 Optimization
- 7 Presenting Data Graphically
- 8 Using Charts Effectively
- 9 Data Visualization with Sparklines
- 10 Refining Worksheets with Graphics
- 11 Preparing Documents for Publishing
- 12 Publishing Workbooks
- 13 Excel Data on the Web
- 14 Collaborating on Workbooks
- 15 Table Functions
- 16 Organizing and Managing Information as Tables
- 17 Data Queries and Data Extracts
- 18 PivotTables and Charts
- 19 Working with External Data
- 20 Export and Import of Files
- 21 Exchanging Data with Other Applications
- 22 Automating Routine Tasks with Macros
- 23 Visual Basic for Applications
- 24 Preview
- A Function Keys, Keys, and Keyboard Shortcuts
- B The Author
- Index
- Service Pages
- Legal Notes