In this course, students will learn the basics of Microsoft Excel. Excel is beneficial to students as it helps them to make accurate calculations, build analytical thinking, visualize data, and more. Proficiency in Excel will help your student be successful in school and beyond. Sign up today.
How to get the most out of Microsoft Excel with Domenico Ruggiero:
- Attentively participate in the live lectures.
- Review the lecture recordings to clarify/solidify topics that may not have been fully captured the first time.
- Limit chat discussions to answering my questions or to have you ask me a question.
- Have your spreadsheet application up and running before the start of class -- each lecture contains live exercises.
- Due to the need to keep to a tight timeline, some questions may not be answered during the live lectures and may be deferred for offline discussion in the course forum.
- Complete the given assignments and practice working with the spreadsheets on items of personal interest
- Once the course is completed to the parent's satisfaction, there is a Certificate of Completion at the end to be filled in for your records.
Total Classes: 8
Duration: 60 minutes
Prerequisite: Students will need to have the Microsoft Excel application installed on their computer. Excel for Windows is covered in the course. Students using Excel for Mac will still benefit from the course, but the user interface may be different at times.
Suggested Grade Level: 7th to 12th grade
Suggested Credit: 1/2 semester Computer Skills or Excel
Instructor: Domenico Ruggiero, MSIE-EM
Instructor Email: domenicoandsonia@gmail.com
Course Description:
Microsoft Excel is a spreadsheet application and one of the core components of the Microsoft Office suite of applications. It is capable of handling simple to advanced calculations, contains various graphing tools, provides pivot tables for data discovery, and utilizes Visual Basic for Applications (VBA) programming. (The topic of VBA programming is studied more deeply in Mr. Ruggiero’s “Microsoft Office Automated Productivity with VBA Programming course” available in Unlimited Access.)
This course focuses on the most utilized functions and capabilities within Excel to perform numerical analysis. Students completing this course will emerge with a firm understanding of the essential elements of Excel which is necessary for anybody that wishes to demonstrate proficiency in computer skills.
Course Outline:
Topics are subject to slight change. These topics will be covered in an interspersed manner throughout the course.
• Getting to know the Excel Interface
• Understanding cell references – Relative, Absolute, and Named Ranges
• Data types and Format options
• Entering formulas -- simple to complex
• Logic conditions (if-this-then-that)
• Goal seeking
• Pivot Tables
• Data Visualization: Charts and Graphs
• Avoiding pitfalls and evaluating equations
Course Materials:
Microsoft Excel application must be installed on the student’s computer. Excel for Windows is covered in the course. Students using Excel for Mac will still benefit from the course, but the user interface may be different at times.
The instructor will provide all other necessary materials free to students. Recommendations for other resources will be provided with no obligation to purchase.
Homework: A few online quizzes will test understanding of the lecture topics. Two Excel files will be turned in (1 per week) that will cover a practical application of their skills.
- Teacher: Domenico Ruggiero