Have a personal or library account? Click to login
Exploring Microsoft Excel's Hidden Treasures Cover

Exploring Microsoft Excel's Hidden Treasures

Turbocharge your Excel proficiency with expert tips, automation techniques, and overlooked features

Paid access
|Sep 2022

Table of Contents

  1. Implementing Accessibility
  2. Disaster Recovery and File-Related Prompts
  3. Quick Analysis Toolbar Treasures
  4. Conditional Formatting
  5. Data Validation and Form Controls
  6. What-If Analysis
  7. Automating Tasks with the Table Feature
  8. Custom Views
  9. Excel Quirks and Nuances
  10. Lookup and Dynamic Array Functions
  11. Names, LET, and LAMBDA
  12. Power Query
PDF ISBN: 978-1-80323-309-3
Publisher: Packt Publishing Limited
Copyright owner: © 2022 Packt Publishing Limited
Publication date: 2022
Language: English
Pages: 444

People also read