Microsoft excel professional 2021 guide : a complete excel reference, loads of formulas and functions, shortcuts, and numerous screenshots to become an excel expert /
by CA Manmeet Singh Mehta
- London : BPB Publications, 2023
- 1 online resource (495, pages) : color illustrations.
https://portal.igpublish.com/iglibrary/ is required to read this e-book.
Includes index
1. What is new in excel 2021 -- 2. Excel basics -- 3. Transforming and managing data -- 4. Achieving data consistency -- 5. Manipulating data -- 6. Power of tables -- 7. Introduction to formulas and functions -- 8. Text and other functions -- 9. Date functions -- 10. Logical and lookup functions -- 11. Array functions -- 12. Formula auditing -- 13. PivotTables -- 14. What-if analysis --15. Protection and security -- 16. Conditional formatting -- 17. Charting data -- 18. Excel hacks and tips – the practical side -- 19. The way forward
Do you struggle with handling Excel data?
Do you waste a lot of time figuring out which formulas and functions to use for your day-to-day office work?
Even so, do you still want to become a master of Excel's most advanced features and techniques?
This book will teach you the fundamentals and most beneficial uses of Microsoft Excel through various examples, practical illustrations, and good shortcuts to make your life easier with it. To begin, we'll look at the numerous features every professional needs to manage enormous volumes of data. The reader will discover how to import data from various sources and cleanse and arrange it.
You'll learn how to use Excel's formulas and functions, as well as how to analyse data in a variety of ways. This book will demonstrate how Excel's new capabilities combine AI and ML to improve and simplify data visualisation straightforwardly. This book will teach you how to solve business problems using Excel's built-in functions.
9789355510464 (e-book)
Industries land use labor Management industrial management