Microsoft Excel 중급 수준 - 수식 및 함수
이 4과 자기 주도 과정은 Excel에 대한 기본적인 이해가 있는 학습자에게 Excel 수식과 함수를 가르칩니다. Sum, Average, Date, If, Vlookup 등과 같은 함수를 배우기 위해 실제 사례를 살펴보겠습니다.
Colleen Smith
평균 평점:
5.0
수강 후기 수:(328)
인기 선생님
무엇이 포함되어 있나요?
사전 녹화된 수업 8개
4 주
교사 지원 기간(주)1년
학습 내용 이용 기간Homework
주당 1시간. Homework will be completed as part of the recorded lessons. Recordings are 30-32 minutes, but may take longer if paused to complete steps. Review lessons will take about 10 minutes.채점
I provide feedback on all submitted work, but please let me know if you need specific grading.보고계신 지문은 자동 번역 되었습니다
수업 소개
영어 수준 - 알 수 없음
미국 8학년 - 11학년 학년
레벨 Intermediate
✨New to Outschool? Use code ColleenSmi20 to save $20 on any of my classes!✨ ✨Not new to Outschool? Use code SCHOOL40 to receive 40% off this course!✨ (Expires 8/31/24. Codes can't be combined.*) 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 simulate 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)
학습 목표
Students will learn Excel vocabulary and skills (cell, column, row, worksheet, formula, function, static, cell reference, sorting).Students will learn to create formulas and functions within Microsoft Excel, including SUM, AVERAGE, MEDIAN, MODE, RANK, LENS, &, YEAR, MONTH, DAY, DATE, SUMIF, COUNTIF, and VLOOKUP.
강의 계획서
8 레슨
4 주 이상레슨1:
The Basics and Math Formulas: Video and Follow-Along
I'll begin by briefly discussing real-world uses for Excel and related vocabulary. I'll define "static" and "cell reference" formulas and discuss the benefits of cell reference formulas. We'll then dive in and begin using the program. We'll create basic math formulas, including addition, subtraction, multiplication, division, and exponents. I'll then discuss how "dragging" a formula effects the formula and how the formula can be changed to allow for auto-populating. We'll use the SUM function. 레슨2:
Quick Review Exercise: Adding Lines and Extending Formulas
For additional practice, learners will share a book that is not already in our bookstore "inventory" and add it to their inventory spreadsheet. 레슨3:
More Summarizing Formulas: Video and Follow-Along
We'll continue to use our "business's" sales data to practice using formulas. We'll use the COUNT function to total transactions, and the RANK function to rank our most popular items. We'll use Excel functions to calculate our average transaction size. We'll also determine the MEDIAN and MODE transaction values and I'll discuss why these formulas would be helpful. We'll look at a customer birthday list and use date functions to split information into different cells. 레슨4:
Quick Review Exercise: Uses of Excel
The learner will share in what other ways they may need to use an Excel function or formula. 그 외 세부 사항
수업 자료
Students should have Microsoft Excel on their computer prior to starting class, so they can use the program and follow along as I teach the class.
등록 시 1개의 파일을 볼 수 있어요.
Outschool 외 필요 앱/웹사이트
아웃스쿨 사이트의 기능 외 별도의 앱이나 웹 사이트를 사용할 필요가 없습니다.
가입일: September, 2021
5.0
328수강 후기
인기 선생님
교사 전문성 및 자격증
학사 학위 Bucknell University부터
I have virtually taught over 1,300 young learners on Outschool, but prior to that I enjoyed a thirteen-year corporate career, where I used Excel to make my work more efficient and effective on a daily basis. I hold a Bachelor's of Science in Business Administration from Bucknell University. 리뷰
자율 학습 과정
매주
US$13
지불 또는 모든 콘텐츠를 US$50에 이용8 사전 녹화 레슨
4 교사 지원 기간(주)
시작일 선택 가능
1년간 콘텐츠 이용 가능
19 명의 학생이 수업을 완료함
시작일 선택 가능
연령: 12-18
