Go to Course: https://www.coursera.org/learn/data-for-business-analysts-using-microsoft-excel
Gain insight into the steps involved in preparing data for analysis using Excel functions.
Learn to use formulas and functions in Excel for data analysis purposes.
Understand how Excel is applied in business scenarios for data analysis and apply these skills to real-world tasks.
Excel Fundamentals
This module introduces essential Excel elements and techniques begininning with the creation and formatting of worksheets. It explores the Excel features that are useful when viewing large data blocks and explains how to create accurate calculations.
Formula and functionsThis module introduces formulas and functions in Excel. It explores how these are important to data analysis and how these are used in business scenarios.
Preparing data for analysis using functionsThe module introduces common functions that help prepare Excel data for analysis in tools such as PowerBI.
Working with PivotsIn this module, you will learn essential skills in Microsoft Excel to enhance data manipulation and reporting capabilities. You’ll discover how to create dynamic data blocks using tables, allowing for flexible data organization and analysis. Additionally, you’ll learn how to create PivotTables, a powerful feature for summarizing and analyzing large datasets efficiently. Furthermore, you'll explore how to leverage PivotTables and slicers to create dynamic reports, providing insights and visualizations that adapt to changing data inputs. These techniques will empower you to efficiently manage and analyze data, enhancing your productivity and decision-making abilities in Excel.
Final project and assessment: Preparing data for analysis with MS ExcelIn this module, you will be assessed on the key skills covered in the Course.
In this course, you’ll learn how to make use of Excel in business scenarios for data analysis. You’ll also learn how to utilize formulas and functions for data analysis. Specifically, this course will help you gain knowledge and skills for preparing data for analysis using Microsoft Excel and take you one step closer to becoming a Business Analyst. After completing this course, you’ll be able to: • Identify and explain the steps involved in preparing data for analysis using Excel functions
Course is very good in terms of content and presentation. Course material is full of typos.
course was quite interesting and engaging throughout
It has been a good refresher course for me. Also learned a few more things I did not know.
Learned a great deal of info and refreshed some old details.
This course was very informative and I'll use the new skills I have acquired.