Modern data analytics in Excel

• Titel: Modern data analytics in Excel
• Mitwirkende: Mount, George [MitwirkendeR]
• Institutionen: O'Reilly (Firm), [Verlag]
• Ausgabe: [First edition].
• Verlagsort: [Sebastopol, California]
• Verlag: O'Reilly Media, Inc.
• E-Jahr: 2023
• Jahr: [2023]
• Umfang: 1 online resource (1 video file (3 hr., 20 min.))
• Illustrationen: sound, color.
• Fussnoten: Online resource; title from title details screen (O’Reilly, viewed June 24, 2024)
• Datenträger: Online-Ressource
• Sprache: eng
• Sach-SW: Tableurs ; Logiciels
• Sach-SW: Instructional films
• Sach-SW: Nonfiction films
• Sach-SW: Internet videos
• Sach-SW: Films de formation
• Sach-SW: Films autres que de fiction
• Sach-SW: Vidéos sur Internet
• K10plus-PPN: 1892755475
• K10plus-PPN:
  Universitätsbibliothek
• Lokale URL UB: Zum Volltext
• Lokale URL UB: Bibliothek der Medizinischen Fakultät Mannheim der Universität Heidelberg
• Bibliothek/Idn: UW / m4544401925
• Lokale URL Inst.: Zum Volltext

Abstract

This advanced course shows intermediate Excel users how to harness features like Power Query, Power Pivot, dynamic arrays, and the integration of Python and AI to elevate their data analysis capabilities. Learners will master building repeatable data-cleaning pipelines, developing dynamic reports and measures, using dynamic array functions to clean and analyze their data, and more. Designed for data-driven professionals including data analysts, financial analysts, and accountants, this course demystifies complex tools and features that are crucial for modern data tasks from directly within spreadsheets. Learners will gain the ability to automate and optimize their data processes, utilize advanced analytical techniques, and integrate Excel seamlessly with other analytics tools in the BI tool ecosystem.