|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/working-with-date-and-time-functions-intermediate-excel/
课程评论：没有评论
**课程名称：** Excel 日期和时间函数进阶 **课程概述：** 本课程由 Microsoft Excel 专家讲授，旨在帮助您精通 Excel 中的日期和时间函数，这是处理电子表格数据的关键技能。您将学习如何进行日期计算、管理时间相关数据，并熟练掌握 **TODAY**、**WORKDAY**、**NETWORKDAYS** 等强大的 Excel 函数。 **课程内容亮点：** * **自定义日期格式：** 掌握应用自定义日期格式，使您的电子表格更加专业和清晰。 * **日期和时间函数应用：** 学习运用多种日期和时间函数，精准管理数据。 * **日期差值与年龄计算：** 准确计算日期之间的差值，并确定年龄。 * **工作日计算：** 深入理解并运用 **WORKDAY** 和 **WORKDAY.INTL** 函数计算工作日。 * **业务日计算：** 掌握 **NETWORKDAYS** 和 **NETWORKDAYS.INTL** 函数，用于计算业务日。 * **日期序列操作：** 学习使用 **EDATE** 和 **EOMONTH** 函数进行日期规划和报告。 **课程形式：** * 包含可下载的讲师文件和练习文件，供您同步学习。 * 52分钟的视频教程，分为10个独立的视频讲座。 * 完成课程后可获得结业证书。 **适合人群：** 无论是初学者希望打牢基础，还是有经验的用户希望提升 Excel 技能、更高效地处理时间敏感型数据，本课程都将为您提供必要的知识和实践技能。 **通过本课程，您将能够：** * 熟练运用 Excel 日期和时间函数，提高数据处理效率。 * 根据实际业务场景，精确地操作和应用日期数据。 * 创建功能性强且具有专业视觉效果的电子表格。
**This course includes downloadable course instructor files and exercise files to work with and follow along.**Welcome to Microsoft Excel Intermediate training! This course will help you enhance your Excel skills by focusing on date and time functions, which are critical tools for anyone working with spreadsheets. You will learn to calculate dates, manage time-based data, and utilize powerful Excel functions like TODAY, WORKDAY, NETWORKDAYS, and many more. Whether you're a beginner looking to strengthen your foundational skills or an experienced user aiming to refine your techniques, this course will give you the knowledge to work efficiently with date-related data.Throughout the lessons, you will explore how Excel stores and handles dates and how you can apply custom date formats to make your spreadsheets look polished and professional. You'll gain practical experience calculating date differences and ages and using advanced functions such as WORKDAY.INTL and NETWORKDAYS.INTL for business-specific calculations.By the end, you'll have the skills to accurately manipulate dates and apply them to real-world business scenarios, ensuring your spreadsheets are functional and visually appealing. This training is perfect for anyone looking to improve their Excel proficiency and use it to its full potential for managing time-sensitive data.You will learn how to:Apply custom date formats for clear and professional presentations.Utilize various date and time functions to manage data with precision.Calculate date differences and accurately determine ages.Use WORKDAY and WORKDAY.INTL functions to calculate workdays.Leverage NETWORKDAYS and NETWORKDAYS.INTL to calculate business days.Apply EDATE and EOMONTH to manipulate dates for scheduling and reporting.This course includes:52 minutes of video tutorials10 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion
