Excel for Beginners: Advanced Functions
This 1-hour, project-based course introduces learners to more-advanced spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft.
Buy Now Free
- Level Foundation
- المدة 4 ساعات hours
- الطبع بواسطة Coursera Project Network
-
Offered by
عن
This 1-hour, project-based course introduces learners to more-advanced spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program offered by Microsoft. However, all of the concepts that you will learn in this project will be applicable to other spreadsheet programs, such as LibreOffice Calc and Google Sheets. We will cover the following concepts in a hands-on manner: - Advanced conditional functions: countif, sumif, averageif - Easy searching and matching of data with reference functions: vlookup, xlookup, index & match Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content.الوحدات
Your Learning Journey
-
1
Readings
-
1
Plugin
-
1
Lab
-
1
Assignment
1
Assignment
- Assess Your Knowledge
1
Labs
- Excel for Beginners: Advanced Functions
1
Readings
- Project Overview
Auto Summary
Unlock advanced Excel functions in just 1 hour with this beginner-friendly course by Coursera. Focused on personal development, learners will explore conditional functions like countif, sumif, and averageif, as well as reference functions such as vlookup, xlookup, and index & match. Utilize Excel on the Web, with concepts also applicable to LibreOffice Calc and Google Sheets. Ideal for those new to spreadsheets, this project-based learning experience is free and requires a Microsoft account.
Edward Falzon