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 by
Difficulty Level
Intermediate
Completion Time
14h48m
Language
English
About Book
Who Is This Book For?
This book is for intermediate to advanced excel users working in diverse roles such as business users, accountants, project managers and business analysts among others. The more time that you spend in excel the more time this book will save you. You will be able to maximize your productivity by learning spreadsheet interactivity, accessibility and automation. This clear step-by-step explanation and detailed example workbook will help you to try out new techniques firsthand and leverage them for your business's advantage in no time.
Exploring Microsoft Excel’s Hidden Treasures
- About Book
- Who Is This Book For?
- Book Content
Book content
chapters • 14h48m total length
Implementing Accessibility
Disaster Recovery and File-Related Prompts
Quick Analysis Toolbar Treasures
Conditional Formatting
Data Validation and Form Controls
What-If Analysis
Automating Tasks with the Table Feature
Custom Views
Excel Quirks and Nuances
Lookup and Dynamic Array Functions
Names, LET, and LAMBDA
Power Query
Related Resources
Access Ready-to-Use Books for Free!
Get instant access to a library of pre-built books—free trial, no credit card required. Start training your team in minutes!