К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Everyday Excel, Part 3 (Projects) · LearnSpace
Назад в каталог
courseraПрограммирование

Everyday Excel, Part 3 (Projects)

Курс от University of Colorado Boulder
Продвинутый≈ 14.1 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

"Everyday Excel, Part 3 (Projects)" is a continuation of "Everyday Excel, Parts 1 and 2". It is a capstone, projects-based course in which you will apply what you've learned previously to more complex, somewhat open-ended projects (open-ended with respect to the fact that they can be solved in multiple ways). Each learner must complete 3"warm-up" projects (chosen from 3), 3 intermediate projects (chosen from 6), and 3 main (more difficult) projects (chosen from 5). The projects have been created to span a wide range of interests and topic areas and are anticipated to appeal to diverse learner backgrounds. It is hoped that this project-based courses will dramatically reinforce the application of Excel tools, techniques, and functions to real-world projects.

Навыки, которые вы освоите

Microsoft ExcelExcel FormulasData ValidationSpreadsheet SoftwareData IntegrityAnalysisData Management

Программа курса

5 модулей · 104 учебных материалов

01Introduction and General Course Information15 материалов

Basic Course Information

Course Updates and Accessibility SupportЧтениеCourse Overview and IntroductionВидеоIs This Course For You?ЧтениеOffice 365 is Required For This Course!Чтение

Учитесь у экспертов

Charlie Nuttelman

Teaching Professor

Everyday Excel, Part 3 (Projects)
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 14.1 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Французский, Бенгальский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Нидерландский, Корейский, Немецкий, Пушту, Урду, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Дари, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Take Your Time!Чтение
For Mac UsersЧтение
The Importance of a Course Certificate and the Future of Higher EducationЧтение
How to Switch Sessions of the CourseВидео
How to get helpЧтение
If you enjoy Excel... you'll love VBA!Чтение
How to Unlock the Course FilesЧтение
Opening macro-enabled workbooksЧтение
Unlock Quiz for Course FilesЗадание
Course FilesЧтение
(OPTIONAL) What about you?Обсуждение
02WARM-UP PROJECTS (Choose Three)21 материалов

Nearest Eighth of an Inch

Nearest Eighth of an Inch Problem StatementЧтениеNearest Eighth of an Inch PreviewВидеоNearest Eighth of an InchОбсуждениеNearest Eighth of an Inch Submission QuizЗадание

World Bank Lookup

World Bank Lookup Problem StatementЧтениеWorld Bank Lookup PreviewВидеоWorld Bank LookupОбсуждениеWorld Bank Lookup Submission QuizЗадание

Dynamic Amortization Schedule

Dynamic Amortization Schedule Problem StatementЧтениеDynamic Amortization Schedule Hints and PreviewВидеоIntroduction to Dynamic Array FunctionsВидеоDynamic Amortization ScheduleОбсуждениеDynamic Amortization Schedule Submission QuizЗадание

Longest Ladder Around the Corner

Longest Ladder Around the Corner Problem StatementЧтениеLongest Ladder Around the Corner PreviewВидеоLongest Ladder Around the CornerОбсуждениеLongest Ladder Around the Corner Submission QuizЗадание

Dynamic Temperature Lookup

Dynamic Temperature Lookup Problem StatementЧтениеDynamic Temperature Lookup PreviewВидеоIntroduction to Dynamic Array FunctionsВидеоDynamic Temperature Lookup Submission QuizЗадание
03INTERMEDIATE PROJECTS (Choose Three)27 материалов

Sensitivity Analysis

Sensitivity Analysis Problem StatementЧтениеHow to Perform a Sensitivity AnalysisВидеоSensitivity Analysis Hints and PreviewВидеоSensitivity AnalysisОбсуждениеSensitivity Analysis Submission QuizЗадание

Friday the 13th

Friday the 13th Problem StatementЧтениеFriday the 13th PreviewВидеоFriday the 13thОбсуждениеFriday the 13th Submission QuizЗадание

Dynamic Data Cleaning

Dynamic Data Cleaning Problem StatementЧтениеDynamic Data Cleaning Preview and HintsВидеоIntroduction to Dynamic Array FunctionsВидеоDynamic Data CleaningОбсуждениеDynamic Data Cleaning Submission QuizЗадание

Historical Weather Lookup (Part A)

Historical Weather Lookup (Part A) Problem StatementЧтениеFiltering for Multiple CriteriaВидеоHistorical Weather Lookup (Part A) PreviewВидеоHistorical Weather Lookup (Part A)ОбсуждениеHistorical Weather Lookup (Part A) Submission QuizЗадание

Bakery Shopping List

Bakery Shopping List Problem StatementЧтениеBakery Shopping List PreviewВидеоBakery Shopping List Submission QuizЗадание

Dinner Sign-Up

Dinner Sign-Up Problem StatementЧтениеDinner Sign-Up previewВидеоAn Introduction to Dynamic Array FunctionsВидеоDinner Sign-UpОбсуждениеDinner Sign-Up Submission QuizЗадание
04MAIN PROJECTS (Choose Three)32 материалов

Distance Calculator

Distance Calculator Problem StatementЧтениеDistance Calculator PreviewВидеоDealing with Multiple Table LookupsВидеоHow to Reset Conditional Drop-Down ListsВидеоDistance CalculatorОбсуждениеDistance Calculator Submission QuizЗадание

Rental Center Inventory

Rental Center Inventory Problem StatementЧтениеRental Center Inventory PreviewВидеоAn Introduction to Dynamic Array Functions ВидеоDynamic Filtering for Multiple ConstraintsВидеоHow to Reset Conditional Drop-Down ListsВидеоRental Center InventoryОбсуждениеRental Center Inventory Submission QuizЗадание

Real-Time Regression

Real-Time Regression Problem StatementЧтениеMatrix Approach to Regression, Part 1ВидеоMatrix Approach to Regression, Part 2ВидеоReal-Time Regression PreviewВидеоDynamic Array Hints for Real-Time Regression ВидеоHow to Calculate Standard Error and Adjusted R-SquaredВидео

Amortization Schedule with Extra Payments

Amortization Schedule with Extra Payments Problem StatementЧтениеAmortization Schedule with Extra Payments, Part 1ВидеоAmortization Schedule with Extra Payments, Part 2ВидеоAmortization Schedule with Extra Payments PreviewВидеоAmortization Schedule with Extra PaymentsОбсуждениеAmortization Schedule with Extra Payments Submission QuizЗадание

Historical Weather Lookup (Part B)

Historical Weather Lookup (Part B) Problem StatementЧтениеHistorical Weather Lookup (Part B) PreviewВидеоHistorical Weather Lookup (Part B)ОбсуждениеHistorical Weather Lookup (Part B) Submission QuizЗадание

Expand your repertoire of Excel skills with VBA!

To Get You Pumped Up for VBA (Preview for My Specialization "Excel/VBA for Creative Problem Solving")Видео
05For Honors!9 материалов

For Honors

How to Earn an Honors CertificateЧтениеFrancesca's French Bakery Problem StatementЧтениеFrancesca's French Bakery PreviewВидеоFrancesca's French BakeryОбсуждениеTop Hat Consolidator Problem StatementЧтениеTop Hat Consolidator PreviewВидеоHow to Calculate Column Averages of Dynamic ArraysВидеоTop Hat ConsolidatorОбсуждениеHonors Submission QuizЗадание
Real-Time RegressionОбсуждение
Real-Time Regression Submission QuizЗадание