US$30
for 2 classes包含什麼
2 現場會議
1 小時 40 分鐘 上課時間我們無法翻譯此文,請刷新頁面並再試一次。
課堂經歷
This two-day course will teach learners how to create Microsoft Excel pivot tables in order to summarize and analyze larger amounts of data in different ways. We will use scientific and financial data set examples. I will share my screen so that students can see what I am doing in Excel. Students should use Excel on their laptop or computer in order to follow along and get hands-on experience during class. 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. Day 1: I will upload an Excel file to the classroom that can be downloaded. The file contains mock sales data for a food truck. We will use the file to subtotal and categorize the food truck's sales. The file also contains average temperature data for cities throughout the world. The data will be shown in Fahrenheit and Celsius and inches and centimeters. We will examine the data and create formulas/functions with Excel. We will then create a pivot table to easily summarize the data. Day 2: I will upload another downloadable Excel file to the classroom. The file contains average salary information by industry. We will examine the data, which will be on two separate work sheets. We will use functions to combine the data into one worksheet. We will use the combined worksheet to create a pivot sheet. We will use the pivot table to summarize and analyze the data. Topics covered will include: • Pivot Tables • Conditional Formatting • Functions (SUM, AVERAGE, REPLACE, VLOOKUP) In order to maximize class time for all students, please ensure your learner is signed into Excel before class begins. Students do not need much experience with Excel, but should have basic desktop or laptop knowledge, such as the ability to use a mouse, use a keyboard and open a program. They should be able to type in an Excel cell and select it with their mouse or cursor. This class can be, but does not have to be, taken after any of my "Microsoft for Beginner" one-time, multi-day, or Flex classes. Troubleshooting during class: Occasionally, learners may need additional help in completing a task in Excel. I am able to give students the ability to share their screen so that I can see exactly what they are looking at. This works very well, and I am able to talk learners through the task. (I will not be able to see a learner's screen if they are using Excel on a separate device than their Outschool class.) If the learner is still not able to complete the task, they are able to grant me remote access so that I can complete the task for them in Excel. This allows us to cover all material in the class. At the end of class, I will revisit the skipped step and further practice with the learner.
其他詳情
父母的引導和規範
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. We will not be using any external websites or apps.
供應清單
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 工具以外的任何應用程式或網站。
來源
認識老師
教師專業知識和證書
學士學位 由 Bucknell University
I have virtually taught over 600 young learners on Outschool and another platform, 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 often trained colleagues in how to use Excel to increase their efficiency. I hold a Bachelor's of Science in Business Administration from Bucknell University.
評論
Colleen Smith 建議接下來的課程...
Microsoft Excel 中級:公式與函數,3 週課程
Colleen Smith
5.0
(333)
US$17 每班
團體課
3 週, 1/週, 50 分鐘
12-16
Colleen Smith的其他課程
Colleen Smith的其他課程
其他家長也喜歡
1:1 Microsoft Office(適合初學者)
Ms. Katrena
US$55 每堂課
一對一輔導
依需求開班
11-14
MS PowerPoint 技能巡遊 - 中學 - 營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 3 PM Mon 3/10
團體課
1 週, 4/週, 50 分鐘
10-13
MS Excel 技能巡遊 - 高中和大學預科 - 營
Ms. Ryan, M.S.
5.0
(62)
US$18 每班
下次會議在 2 PM Mon 3/10
團體課
1 週, 5/週, 50 分鐘
14-18
MS Word 技能巡遊 - 第 1 部分 - 中學營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 3 PM Mon 3/10
團體課
1 週, 4/週, 50 分鐘
10-13
MS Excel 技能巡遊 - 中學第 1 部分 - 訓練營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 3 PM Mon 3/10
團體課
1 週, 4/週, 50 分鐘
10-13
MS Word 技能巡遊 - 高中和大學預科 - 夏令營
Ms. Ryan, M.S.
5.0
(62)
US$19 每班
下次會議在 2 PM Mon 3/10
團體課
1 週, 5/週, 50 分鐘
14-18
電腦技能選修:Microsoft Word、Powerpoint 和 Excel 第 1 部分
Thrive Virtual Academy by Patch Kulp
4.9
(637)
US$20 每班
下次會議在 9 PM Thursday
團體課
6 週, 1/週, 45 分鐘
12-16
電腦技能選修:Microsoft Word、Powerpoint 和 Excel 2 級
Thrive Virtual Academy by Patch Kulp
4.9
(637)
US$20 每班
下次會議在 8 PM Thu 4/3
團體課
4 週, 1/週, 45 分鐘
12-16
微軟PowerPoint簡介
Brandon
4.9
(30)
US$10 每班
下次會議在 12 AM Tuesday
團體課
1 週, 1/週, 55 分鐘
13-18
Adobe 爆炸:私人課程!
Bethanie Jones
4.8
(622)
US$86 每堂課
一對一課程
依需求開班
10-15
微軟Excel簡介
Brandon
4.9
(30)
US$10 每班
下次會議在 10:30 PM Tuesday
團體課
1 週, 1/週, 55 分鐘
12-17
一對一 Microsoft PowerPoint 學習課程
Motivational Mario
5.0
(1)
US$50 每堂課
一對一課程
依需求開班
13-18
適合初學者的 Google 表格
Dan Hartman
4.9
(574)
US$15 每班
下次會議在 5 PM Sat 2/22
團體課
1 週, 1/週, 30 分鐘
9-14
掌握 Canva 學校計畫:高中生的 1:1 指導
Dr. Bridget Prichard
US$25 每堂課
一對一課程
依需求開班
15-18
微軟Word簡介
Brandon
4.9
(30)
US$10 每班
下次會議在 2 PM Monday
團體課
1 週, 1/週, 55 分鐘
12-16
掌握 Excel:逐步指南
Pauline
5.0
(1)
US$30 每堂課
一對一課程
依需求開班
11-18