Ce que vous devez savoir avant
Vous commencez
Débute 4 June 2026 01:29
Se termine 4 June 2026
Excel Power Tools for Data Analysis
Macquarie University
30 Cours
L'Université Macquarie est une université de classe mondiale située à Sydney, en Australie, avec plus de 40 000 étudiants, proposant des diplômes dans un large éventail de disciplines allant des sciences humaines à la science et à l'ingénierie. Elle se concentre sur l'excellence de la recherche, une vie étudiante dynamique et des partenariats industriels.
Non spécifié
Amélioration optionnelle disponible
Tous niveaux
Progressez à votre rythme
Free
Amélioration optionnelle disponible
Aperçu
Unlock the full potential of Excel for data analysis with Excel Power Tools for Data Analysis, a comprehensive four-week course offered by Macquarie University on Coursera. Dive deep into the advanced features of Excel including Power Query, Power Pivot, and Power BI, designed to enhance your data transformation, analysis, and presentation capabilities.
Excel's upgrade to include these tools addresses its limitations with handling "big" data and streamlines data importing and cleaning processes.
Throughout this course, participants will master the automation of data preparation with Power Query, harness the analytical power of Power Pivot for complex data analysis within Excel, and explore Power BI for creating interactive reports and dashboards. These tools, available exclusively on the Windows platform, bring a revolutionary edge to data handling, making it essential for participants to have access to Windows through Bootcamp or a Virtual Machine if using a Mac.
This course is the third installment in our specialization series on Data Analytics and Visualization, building upon the fundamentals covered in previous courses such as Excel Fundamentals for Data Analysis and Data Visualization in Excel.
It is ideal for learners who have completed these foundational courses or possess similar experience in data preparation, visualization, and dashboard creation.
Note:
Power Query and Power BI Desktop are compatible with Excel 2016 and later versions, including Office 365, to ensure participants gain the most current and optimized learning experience. Join us at Macquarie University and Coursera for this exciting journey into Excel Power Tools for Data Analysis and elevate your data analysis skills to new heights.
Categories:
Data Analysis Courses, Data Visualization Courses, Microsoft Excel Courses.
Enseigné par
Nicky Bull and Dr Prashan S. M. Karunaratne
