Book

Exploring Microsoft Excel’s Hidden Treasures

This book will equip you with new features, techniques, and shortcuts that will transform your experience in Excel. Accessibility and code-free automation are explored from several perspectives. Underused features and nuances that blindside Excel users are also discussed throughout the book, along with a special emphasis on data integrity.

Offered byPackt Logo

Difficulty Level
Intermediate
Completion Time
14h48m approx.
Language
English
Certification
Not available

About Course

Book Content

chapters 14h48m total length

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

On this page

Ready to Train Your Team?

Need training for your whole team? Get bulk pricing, LMS integration, and dedicated support.

Trusted by Leading Organizations Worldwide

Join thousands of companies that trust Calibr to power their learning and development initiatives.

Chalet Hotels logo
Pernod Ricard logo
ProMobi logo
Metrique logo
K Raheja Corp logo
Spyne.AI logo
VuNet Systems logo
Procurement Partners logo
vEngage.AI logo
1218 Global logo
TRADEJINI logo
Oben Electric logo
IIT STartups logo
EdTech Digit logo
MindSkillz logo
NewportMed logo

Request Access For Your Organization

Start training your team in minutes!

No credit card required

Related Resources