Microsoft Excel Introduction I 4 Quick Lessons
Learn the basics of using Microsoft Excel 2019 through self-paced schedule in just 1 hour (4 fifteen minute lessons) to create charts, add up numbers, use some shortcuts, create a table, freeze bars, and more!
Emily Culbertson | Italian Teacher & Italian Tutor
Average rating:
4.9
Number of reviews:(516)
Popular
What's included
4 pre-recorded lessons
4 weeks
of teacher support1 year access
to the contentHomework
1 hour per week. There is optional homework that helps review the material. You or your student can message me any questions.Certificate of Completion
A certificate of completion can be given if desired.Class Experience
Beginner - Intermediate Level
In this class, we learn the basics of using Microsoft Excel 2019. Having the ability to keep a record such as an agenda in a table format (homework schedule, client details, etc.), organize numbers to quickly add up (for marketing purposes, budgeting, paying bills, etc.), and showing charts and tables based on the math and interweaving the numbers of different columns together into an understandable way is very helpful for homework, school, businesses, and as an adult! -------- Each recording will be 15 minutes to which you can pause and go back to whenever you want during the time of the course. There will be a total of 4 lessons. I will post the link to the new lesson each week. You'll have the whole week to look at the material and video at a time that works for you. You will have activities/ discussions posted in the classroom that you can participate in if desired. --------- Lesson 1-2: Basics of Using Microsoft Excel 2019 Learning the basics of Excel including tabs, ribbons, sheets, wrapping text, setting up a budget chart, using the sum function to add a column, resizing and changing fonts, underlining, adding borders to cells and columns, typing (font, size, italics, bold, etc.), extending columns, etc Creating a table, deleting or adding rows or columns to create a table, and discuss some shortcuts Lesson 3-4: Using Microsoft Excel 2019: Continue but in more detail of using shortcuts to subtract, multiple, add, etc. Using shortcuts and formulas such as adding, subtracting, and multiplying in the form of a chart for income, taxes, and donations to understand totaling and subtracting where money went for a business, self-employment, or personal use. We also went over ways to drag a formula to other cells and how to change cells from round to including decimals. Learning how to recall or copy/paste information from other sheets to a new sheet and reviewing --------------------------------------------------------------------------------------------------------- Homework will be to try what has been taught and is optional.
Learning Goals
To gain confidence in a basic understanding of Microsoft Excel
Syllabus
2 Units
4 Lessons
over 4 WeeksUnit 1: Basics
Lesson 1:
All the Basics
Learning the basics of Excel including tabs, ribbons, sheets, wrapping text, setting up a budget chart, using the sum function to add a column, resizing and changing fonts, underlining, adding borders to cells and columns, typing (font, size, italics, bold, etc.), extending columns, etc. Lesson 2:
Tables, Rows, Columns, and More
Creating a table, deleting or adding rows or columns to create a table, and discuss some shortcuts Unit 2: Formulas and Shortcuts
Lesson 3:
Formulas to subtract, multiple, add, etc.
Using shortcuts and formulas such as adding, subtracting, and multiplying in the form of a chart for income, taxes, and donations to understand totaling and subtracting where money went for a business, self-employment, or personal use. We also went over ways to drag a formula to other cells and how to change cells from round to including decimals. Lesson 4:
Adding sheets, copying, and pasting
Learning how to recall or copy/paste information from other sheets to a new sheet and reviewing Other Details
Parental Guidance
No external services, programs, website, or apps have to be used or accounts created. However if students want to practice what they learned, below are some options (but this is optional and not mandatory homework):
Excel can be bought through Microsoft website (though students do not have to do the optional homework: therefore, you do not have to purchase it if you are just listening and watching to understand the skills better vs practicing it yourself).
Mac computer's "Numbers" or (the free) Gmail account's "Sheets" is very similar and could be used to practice (though some things will be different instructions than Microsoft Excel). I'm specifically using Microsoft Excel 2019.
Supply List
Excel can be bought through Microsoft website (though students do not have to do the optional homework: therefore, you do not have to purchase it if you are just listening and watching to understand the skills better vs practicing it yourself). Mac computer's "Numbers" or (the free) Gmail account's "Sheets" is very similar and could be used to practice (though some things will be different instructions than Microsoft Excel). I'm specifically using Microsoft Excel 2019.
External Resources
Learners will not need to use any apps or websites beyond the standard Outschool tools.
Joined December, 2018
4.9
516reviews
Popular
Teacher expertise and credentials
Bachelor's Degree from North Carolina State University
Using technology is embedding into our society and having the tools to understand how to confidently use it is important for self-confidence, school, daily use, and the workplace. I have experience in using Microsoft Windows 10 laptops and PCs, HP and Lenovo, and Apple Mac. I have used Word, PowerPoint, Excel, and video maker to enhance celebrations (birthday videos) and become teaching and school tools (PowerPoints with fun transitions to click once the answers have been guessed & Word to create matching worksheets, reports, and flyers). Using Wix, I have created websites for individuals and small businesses. I know use Google Sheets, Mac's Numbers, and Canva weekly. However, just having these tools available on a computer or online isn't truly helpful: knowing how to confidently use a computer and applications allow people of all ages to believe in themselves more. And that is my goal.Reviews
Self-Paced Course
$8
weekly or $32 for all content4 pre-recorded lessons
4 weeks of teacher support
Choose your start date
1 year of access to the content
Completed by 3 learners
Choose your start date
Ages: 8-14
