Microsoft Excel 中階--公式與函數

During this course, students will learn to utilize formulas and functions within Microsoft Excel. In order to benefit from this course, students only need a basic understand of Excel, like how to type in cells and select/highlight cells with their cursor/mouse.

𝗛𝗼𝘄 𝗗𝗼𝗲𝘀 𝘁𝗵𝗶𝘀 𝗦𝗲𝗹𝗳-𝗣𝗮𝗰𝗲𝗱 𝗖𝗹𝗮𝘀𝘀 𝗪𝗼𝗿𝗸?
This self-paced class features four 30-minute recordings and four 10-minute review activities. Each recording includes a hands-on Excel project, where I will share my screen to demonstrate tasks. Students should follow along on their computers for practical experience. We will imagine managing an online book and movie store, using a provided Excel file to create formulas and make business decisions. After each lesson, a review activity will reinforce the skills learned. I'll also discuss how the formulas and functions apply to other scenarios.

If this class is purchased individually (not part of Outschool Unlimted), students have access to the teacher to ask questions and will receive feedback on all questions and submitted work.
 
Please see the "𝙎𝙮𝙡𝙡𝙖𝙗𝙪𝙨" section for a detailed breakdown of what is included in each lesson.

𝗧𝗼𝗽𝗶𝗰𝘀 𝗰𝗼𝘃𝗲𝗿𝗲𝗱 𝘄𝗶𝗹𝗹 𝗶𝗻𝗰𝗹𝘂𝗱𝗲:
•	Excel vocabulary (cell, column, row, worksheet, formula, function, static, cell reference)
•	Math vocabulary (exponent, median, mode, sum)
•	Formulas (addition, subtraction, multiplication, division, exponents, change)
•	Functions (SUM, AVERAGE, MEDIAN, MODE, RANK, LENS, &, YEAR, MONTH, DAY, DATE, SUMIF, COUNTIF, VLOOKUP)