In this updated edition for Excel 2021, Microsoft 365, and previous versions, this book reveals the secrets of Excel through practical examples in a quick reference format. It includes new chapters on data analytics and shortcut keys, making it an essential resource for both beginners and experienced users. The book is designed to help you understand, create, and apply formulas efficiently.
The journey begins with an introduction to formulas, followed by chapters on logical, text, date, and time functions. You will explore statistical, mathematical, and financial functions, along with database, lookup, and reference functions. The book also delves into conditional formatting, dynamic array formulas, special solutions, and user-defined functions, providing step-by-step instructions and ready-to-use Excel screenshots.
By the end of the course, you will have mastered Excel's advanced formulas and functions, enabling you to perform complex data analysis and enhance your productivity. Companion files include video tutorials, over 250 worksheet examples, and all figures from the text, ensuring a comprehensive learning experience.

Osoby które kupowały "Microsoft Excel Functions and Formulas. Master Excel Formulas and Functions for Efficient Data Management With Excel 2021/Microsoft 365", wybierały także:

• Windows Media Center. Domowe centrum rozrywki 66,67 zÅ‚, (8,00 zÅ‚ -88%)
• Ruby on Rails. Ćwiczenia 18,75 zÅ‚, (3,00 zÅ‚ -84%)
• Przywództwo w Å›wiecie VUCA. Jak być skutecznym liderem w niepewnym Å›rodowisku 58,64 zÅ‚, (12,90 zÅ‚ -78%)
• Scrum. O zwinnym zarzÄ…dzaniu projektami. Wydanie II rozszerzone 58,64 zÅ‚, (12,90 zÅ‚ -78%)
• Od hierarchii do turkusu, czyli jak zarzÄ…dzać w XXI wieku 58,64 zÅ‚, (12,90 zÅ‚ -78%)

Spis treści

Microsoft Excel Functions and Formulas. Master Excel Formulas and Functions for Efficient Data Management With Excel 2021/Microsoft 365 eBook -- spis treści

• 1. Formulas in Excel
• 2. Logical Functions
• 3. Text Functions
• 4. Date and Time Functions
• 5. Basic Statistical Functions
• 6. Mathematical Functions
• 7. Basic Financial Functions
• 8. Database Functions
• 9. Lookup and Reference Functions
• 10. Conditional Formatting with Formulas
• 11. Working with Dynamic Array Formulas
• 12. Special Solutions with Formulas
• 13. User-Defined Functions
• 14. Examples
• 15. Other Features
• 16. Data Analytics Using Excel
• 17. Shortcut Keys