weekly
or for all content
Excel |初學者 | 09週SP |使用 Excel 探索數據 - 成為數據忍者
由 48 位學習者完成
年齡 13-18
自訂進度課程
9 預錄課程
9 教師支援週
自行選擇何時開始
1 年內容存取權
立即報名,隨時開始
按照自己的步調走
您的學習者可以在他們想要的時候開始學習,並以最適合他們的速度進步。當你想要的時候開始。
按照自己的步調學習
訪問一整年的課程材料。
獲得老師的實際支持。
包含什麼
9 預錄課程
9 週
教師的支持1 年訪問權
到內容作業
每週 1 小時. Students will be given a small assignment each week to practice what they have learned. Feedback will be provided the following week.我們無法翻譯此文,請刷新頁面並再試一次。
課堂經歷
Understanding data is a superpower for the future. In this flex course, students will receive weekly detailed videos and examples (on average, around 1 hour of video per week) and practice fun and interesting data sets that go through various topics in Microsoft Excel, which can proceed at the learners own pace. Students can watch the videos, or follow along with the videos and the provided Excel sheets. The course will scaffold those topics to build an understanding of how to analyze data. Students will work on a small weekly homework task and submit it before the next class for feedback. We will start from scratch and cover topics from an overview of Excel, conditional formatting, formulas, and functions. Each week we will discuss new ways to look at data, learn additional functions, and explore the program. We will cover logical statements, tables, pivot tables, macros, formatting, math, formulas, forecasting, cell referencing, named cells, and many other topics. This is a great course for both beginners and those who have some background in Excel. In addition to weekly videos and feedback, students will be presented with summaries and links that review the topics we cover each week. Students can use either Mac or PC versions of Excel, and we will try to feature both in the course and show the differences between them.
學習目標
Students will learn many aspects of Microsoft Excel, and find ways to quickly sort through large data sets. The goal of the course is not only to learn how to use the tools, but to understand the data, and what tools can be used to sort through it. We will cover a lot of topics in the course, with the goal that students will understand how to use Excel, and learn a lot of neat tips and tricks to make them data analysis ninjas.
教學大綱
9 課程
超過 9 週課 1:
Excel Basics
Introduction to the course and Excel basics. Includes familiarization with Excel interface and basic functions. Covers setting up simple spreadsheets and inputting data.
課 2:
Formatting Data
Formatting data in Excel. Covers cell formatting, conditional formatting, and working with basic charts and graphs. Focuses on enhancing visual data representation.
課 3:
Intermediate Functions
Intermediate Excel functions. Introduces functions like SUM, AVERAGE, and other common Excel formulas. Focuses on creating more complex spreadsheets with calculated data.
課 4:
Advanced Topics
Advanced Excel topics. Explores concepts like data validation, defined names, and worksheet protection. Focuses on creating and managing structured data within Excel.
其他詳情
父母的引導和規範
Microsoft Excel is recommended for this course. It may be possible to complete most of the course using other software (such as Google Sheets) but in this course we will be working with Excel.
供應清單
Students will need Microsoft Excel to follow along. Office versions 2016, 2019, 365, and other newer versions should all work. Older versions of Excel (2013, 2010, 2003, 2007) may be lacking some features but many or most of the formulas should still work.
外部資源
除了 Outschool 教室外,本課程也使用:
提供自
教師專業知識和證書
I teach Excel, PowerBI, Sheets, and many other spreadsheet programs to various levels of students. I find that exploring data can be fun and exciting, particularly when you find unknown or new connections or conclusions you were unaware of in the data.
評論
Sidney - KidsSpeakCode 建議接下來的課程...
Python 程式設計 |初學者
Sidney - KidsSpeakCode
4.8
(1,187)
每班
Sidney - KidsSpeakCode的其他課程
Sidney - KidsSpeakCode的其他課程
其他家長也喜歡
1:1 Microsoft Office(適合初學者)
Ms. Katrena
每堂課
電腦技能選修:Microsoft Word、Powerpoint 和 Excel 2 級
Thrive Virtual Academy by Patch Kulp
4.9
(636)
每班
下次會議在 8 PM Thu 4/3
電腦技能選修:Microsoft Word、Powerpoint 和 Excel 第 1 部分
Thrive Virtual Academy by Patch Kulp
4.9
(636)
每班
下次會議在 9 PM Thu 2/20
微軟PowerPoint簡介
Brandon
4.9
(30)
每班
下一堂課今天 8 PM
Adobe 爆炸:私人課程!
Bethanie Jones
4.8
(622)
每堂課
微軟Excel簡介
Brandon
4.9
(30)
每班
下一堂課明天 10:30 PM
一對一 Microsoft PowerPoint 學習課程
Motivational Mario
5.0
(1)
每堂課
適合初學者的 Google 表格
Dan Hartman
4.9
(573)
每班
下一堂課明天 6 PM
Google 地球:如何導航和使用工具
Megan Decker
5.0
(6)
每班
下次會議在 9 PM Wednesday
掌握 Canva 學校計畫:高中生的 1:1 指導
Dr. Bridget Prichard
每堂課
微軟Word簡介
Brandon
4.9
(30)
每班
下次會議在 3:30 PM Mon 2/10
掌握 Excel:逐步指南
Pauline
5.0
(1)
每堂課
簡報...(等等,我需要幻燈片!) - 格式化投影片的 6 條規則
Ms. Diosa, MEd.
每班
下次會議在 12 AM Friday
Microsoft Word、PowerPoint 或 Excel 私人輔導
Colleen Smith
5.0
(333)
每堂課
Adobe Illustrator 一對一
Calvin McMurray
每堂課
PowerPoint 等級 1:學習 PowerPoint 基礎:我最喜歡的動物項目
Miss Sammi, ACE Educator
5.0
(56)
每班
下次會議在 8 PM Wed 2/12