Preparing Data for Analysis with Microsoft Excel
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. No prior skills are needed to be successful in this course. In this course, you’ll learn how to make use of Excel in business scenarios for data analysis.
Monthly Subscription Starting at AED 99 + VAT
- Level Foundation
- Duration 19 hours
- Course by Microsoft
-
Offered by
About
This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. 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 Microsoft Power BI Analyst. After completing this course, you’ll be able to: • Create data in Microsoft Excel and prepare it for data analysis. • Make use of common formulas and functions in a worksheet. • Prepare Excel data for analysis in Power BI using functions.Modules
Welcome to Preparing data for analysis with Microsoft Excel
-
3
Videos
-
6
Readings
-
1
Discussion
1
Discussions
- Discussion prompt: Meet and greet
3
Videos
- Introduction to the program
- Course introduction: Preparing data for analysis with Microsoft Excel
- Day in the life
6
Readings
- Course syllabus: Preparing data for analysis with Microsoft Excel
- How to be successful in this course
- Skills measured in the Microsoft Exam PL300
- How to open an image in a new tab
- How to locate your downloaded files
- Additional resources: Key concepts
Introduction to Generative AI
-
4
Videos
-
2
Readings
-
1
Assignment
1
Assignment
- General Knowledge Quiz
4
Videos
- Welcome to Generative AI for everyone
- Understanding the Capabilities of Generative AI for Business Functions
- Generative AI - Under the hood
- The potential pitfalls and shortcomings of GEN AI
2
Readings
- Generative AI Terminology
- Generative AI in Business
Creating workbook content
-
2
Videos
-
6
Readings
-
2
Assignment
2
Assignment
- Self-review: Adding data to a worksheet
- Knowledge check: Creating workbook content
2
Videos
- Introduction to Microsoft Excel
- Entering and formatting data
6
Readings
- Regional variations in Excel
- Working with rows and columns
- Working with worksheets
- Exercise: Adding data to a worksheet
- Exemplar: Adding data to a worksheet
- Additional resources: Creating workbook content
Working with blocks of data in Excel
-
3
Videos
-
5
Readings
-
1
Discussion
-
4
Assignment
4
Assignment
- Self-review: Sorting data
- Self-review: Filtering data
- Knowledge check: Working with blocks of data in Excel
- Module quiz: Excel fundamentals
1
Discussions
- What features were new to you and which were most useful
3
Videos
- Reading large data blocks
- Sorting and filtering data in Excel
- Module summary: Excel fundamentals
5
Readings
- Exercise: Sorting data
- Exemplar: Sorting data
- Exercise: Filtering data
- Exemplar: Filtering data
- Additional resources: Working with blocks of data in Excel
Formulas in Excel
-
3
Videos
-
5
Readings
-
2
Assignment
2
Assignment
- Self-Review: Calculating profit and margin
- Knowledge check: Formulas in Excel
3
Videos
- What is a formula?
- Controlling calculations
- Controlling calculations in action
5
Readings
- Order of precedence in calculations
- Useful percentage calculations
- Exercise: Calculating profit and margin
- Exemplar: Calculating profit and margin
- Additional resources: Formulas in Excel
Getting started with functions
-
3
Videos
-
4
Readings
-
1
Discussion
-
3
Assignment
3
Assignment
- Self-Review: Preparing a monthly sales report
- Knowledge check: Getting started with functions
- Module quiz: Formulas and functions
1
Discussions
- What features were new to you and which were most useful?
3
Videos
- What is a function formula and how to write it
- Using the INSERT function
- Module summary: Formulas and functions
4
Readings
- The AutoSum shortcut
- Exercise: Preparing a monthly sales report
- Exemplar: Preparing a monthly sales report
- Additional resources: Getting started with functions
Using functions to clean or standardise text
-
1
Videos
-
4
Readings
-
2
Assignment
2
Assignment
- Self-review: Standardizing text-based data
- Knowledge check: Using functions to clean or standardize text
1
Videos
- How inconsistent data can affect data analysis
4
Readings
- Functions which can be used to standardize text data
- Exercise: Standardizing text-based data
- Exemplar: Standardising text-based data
- Additional resources: Using functions to clean or standardize text
Date and time functions
-
2
Videos
-
4
Readings
-
2
Assignment
2
Assignment
- Self-review: Calculating the number of working days remaining in the year
- Knowledge check: Date and time functions
2
Videos
- Why understanding date calculations is important
- Dynamic date and time entries
4
Readings
- Other useful date calculations
- Exercise: Calculating the number of working days remaining in the year
- Exemplar: Calculating the number of working days remaining in the year
- Additional resources: Date and time functions
Logical functions
-
3
Videos
-
5
Readings
-
1
Discussion
-
3
Assignment
3
Assignment
- Self-Review: Adding a data column using the IFS function
- Knowledge check: Logical functions
- Module quiz: Formulas and functions
1
Discussions
- What features were new to you and which were most useful
3
Videos
- Using the IF function
- Using nested IF and IFS function
- Module summary: preparing data for analysis using functions
5
Readings
- AND and OR functions
- IF functions
- Exercise: Adding a data column using the IFS function
- Exemplar: Adding a data column using the IFS function
- Additional resources: Logical functions
Final project and assessment: Preparing data for analysis with Microsoft Excel
-
1
Videos
-
3
Readings
-
2
Assignment
2
Assignment
- Self-review: Creating an executive data summary
- Course quiz: Preparing data for analysis with MS Excel
1
Videos
- Course recap: Preparing data for analysis with Microsoft Excel
3
Readings
- About the final project and assessment: Preparing data for analysis with Microsoft Excel
- Final course project: Creating an executive data summary
- Exemplar: Creating an executive data summary
Wrap-up: Preparing data for analysis with Microsoft Excel
-
1
Videos
-
1
Readings
-
1
Discussion
1
Discussions
- Reflect on learning
1
Videos
- Congratulations
1
Readings
- Next steps
Auto Summary
Embark on your journey to becoming a Microsoft Power BI Analyst with the "Preparing Data for Analysis with Microsoft Excel" course, part of the esteemed Microsoft Power BI Analyst Professional Certificate. Tailored for beginners, this foundational course requires no prior skills and is perfect for those looking to start a career in data analysis within the Data Science & AI domain. Guided by expert instructors on Coursera, you will master the use of Microsoft Excel for data preparation and analysis in various business contexts. Gain proficiency in critical formulas and functions that will enable you to manipulate and prepare data efficiently. By the end of this course, you will confidently create and prepare data in Excel, utilize common formulas, and get your data ready for analysis in Power BI. The comprehensive course spans approximately 1140 minutes and is available with flexible subscription options, including Starter and Professional plans, to suit your learning preferences. Ideal for aspiring data analysts, this course provides the essential skills and knowledge needed to advance towards a rewarding career in data analysis using Microsoft Power BI. Join now to take your first step towards data expertise!
Microsoft