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

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

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

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Spreadsheet Date and Time Formulas for Professionals · LearnSpace
Назад в каталог
courseraАнализ данных

Spreadsheet Date and Time Formulas for Professionals

Курс от EDUCBA
Уровень не указан≈ 6 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

Master Excel date and time functions to boost productivity and accuracy in real-world tasks. Learn how Excel handles dates, deadlines, and time calculations like a pro. This course is designed to help you understand and apply Excel’s powerful date and time functions in business scenarios. You’ll begin with the fundamentals of date systems and serial numbers, then progress to essential functions such as DATE, TODAY, and WORKDAY. As you advance, you’ll explore powerful tools like EOMONTH, DAYS360, and NETWORKDAYS.INTL to handle financial calculations and working day analysis. The course also covers time functions, duration calculations, and time zone conversions for global applications. By the end of the course, you’ll be able to automate calculations, reduce errors, and confidently use Excel for reporting, scheduling, and analysis. Whether you're a student, analyst, or professional, this course equips you with practical, job-ready Excel skills.

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

Microsoft ExcelExcel FormulasSpreadsheet SoftwareBusiness ReportingAnalysisFinancial AnalysisBusinessFinancial SystemsBusiness AnalysisJob AnalysisBusiness SystemsSchedulingCalendar ManagementFinancial ReportingProductivityBusiness Systems Analysis

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

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

01Foundations of Excel Date Intelligence10 материалов

Getting Started with Excel Dates

Introduction to Master Excel Dates and TimesВидеоDate Format in Serial NumbersВидеоGetting Started with Excel DatesЗадание

Understanding Date Systems & Core Functions

Date System in ExcelВидео

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

EDUCBA

Преподаватель курса

Spreadsheet Date and Time Formulas for Professionals
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 6 ч

3 модулей

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

Часть программы вашего университета
Date FunctionsВидео
Date Functions ContinuesВидео
Understanding Date Systems & Core FunctionsЗадание
Applying Excel Date Logic to Fix Real-World Data ErrorsDIALOGUE
Foundations of Excel Date IntelligenceЗадание
Fixing Date Format and Function Errors in Excel ReportsDIALOGUE
02Mastering Advanced Date Calculations8 материалов

Essential Date Functions in Practice

Function which are use in ExcelВидеоBackground function and Work DayВидеоEssential Date Functions in PracticeЗадание

Advanced Date Calculations & Business Logic

Example of Eomonth Function of ExcelВидеоFunction of Days 360 in ExcelВидеоNETWORKDAY.INTL in ExcelВидеоAdvanced Date Calculations & Business LogicЗаданиеMastering Advanced Date CalculationsЗадание
03Working with Time & Real-World Applications9 материалов

Time Functions & Creation Techniques

Time FunctionВидеоCreating Time in ExcelВидеоTime Functions & Creation TechniquesЗадание

Practical Applications & Time Conversions

Applications Tips and Tricks in ExcelВидеоCalculating Method using Excel FormulaВидеоConvert time to Time Zone in ExcelВидеоPractical Applications & Time ConversionsЗаданиеWorking with Time & Real-World ApplicationsЗаданиеResolving Business Reporting Errors Using Excel Date and Time FunctionsDIALOGUE