Excel for Beginners: Basic Functions

This 1-hour, project-based course introduces learners to basic spreadsheet functions. We’ll be using Excel on the Web in this project, which is the free spreadsheet program 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: - Review basic functions: sum, min, max, average - Introduction to date-based functions: today, year, month, day, datedif - Trying out conditional functions: if, iferror, countif, sumif - Applying string-manipulation functions: find, replace, proper, concat, textjoin Please Note: If you don't have a free Microsoft account, you will need to create one to be able to complete the content

• Summarize raw data with functions like SUM and AVERAGE
• Improve readability using conditional functions like IF, IFERROR, and COUNTIF
• Manipulate text strings using FIND and REPLACE functions

• Basic familiarity with spreadsheet software or workflow
• Ability to follow step-by-step instructions in English