Your Excel Survival Kit : A Guide to Surviving and Thriving in an Excel World
Level up your Excel skills with practical insights on formulas, data cleaning, visualization, and analysis tools like Power Query and Power BI. Key Features: Clear guidance on Excel tools, from basics to Power Query and Power Pivot ; Modern Excel features like XLOOKUP, dynamic arrays, and threaded c...
Enregistré dans:
| Hovedforfatter: | |
|---|---|
| Format: | Livre numérique |
| Sprog: | Anglais |
| Udgivet: |
Birmingham :
Packt Publishing
2024.
Paris : Cyberlibris |
| Online adgang: | Accès Université d'Orléans et IFPM |
| Kommentar: |
Couverture. https://static2.cyberlibris.com/books_upload/136pix/9781837022168.jpg Cyberlibris (ScholarVox) corpus Informatique |
| Autres localisations: | Voir dans le Sudoc |
| Edition sous un autre format: | • Your Excel Survival Kit, A Guide to Surviving and Thriving in an Excel World, Anne Walsh, Birmingham, Packt Publishing, 2024, 1 vol. (266 p.), 978-18-3702-217-5 |
| Summary: | Level up your Excel skills with practical insights on formulas, data cleaning, visualization, and analysis tools like Power Query and Power BI. Key Features: Clear guidance on Excel tools, from basics to Power Query and Power Pivot ; Modern Excel features like XLOOKUP, dynamic arrays, and threaded comments ; Practical scenarios showing real-world problem-solving and reporting. Book Description: This book starts off with the basics of data entry, formulas, and charts, it provides practical tips to simplify workflows and create clear visuals. Progress to advanced techniques like data cleaning, handling missing entries, and using logical functions, including modern dynamic arrays. Learn to summarize and visualize data with pivot tables, troubleshoot common issues, and customize layouts. Explore VLOOKUP, XLOOKUP, and methods for tackling common challenges. Advanced chapters introduce Power Query for data merging, automation, and quick insights, while Power Pivot enables combining multiple datasets for detailed reports. Finally, unlock Power BI to create professional-grade dashboards and visualizations. Designed for beginners and advanced users alike, this book equips you with the skills to streamline processes, analyze data effectively, and make informed decisions. What you will learn: Master data entry techniques and functions ; Create error-free pivot tables efficiently ; Utilize Power Query for complex data clean-up ; Explore Power BI for professional data visualization ; Enhance productivity using keyboard shortcuts ; Troubleshoot VLOOKUP and learn XLOOKUP. Who this book is for: This book is perfect for office workers, data analysts, and anyone looking to improve Excel skills. It is suitable for beginners with basic computer knowledge, though familiarity with Excel basics will be helpful |
|---|---|
| Emne beskrivelse: | Couverture. https://static2.cyberlibris.com/books_upload/136pix/9781837022168.jpg Cyberlibris (ScholarVox) corpus Informatique |
| ISBN: | 9781837022168 |
| Adgang: | L'accès en ligne est réservé aux établissements ou bibliothèques ayant souscrit l'abonnement. Cyberlibris |