|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-dates-and-times/
课程评论:没有评论
**掌握Excel中的日期和时间 - Excel 365和Excel 2019** 您是否在Excel中进行日期和时间计算时遇到过奇怪的问题?您Excel电子表格中的日期和时间看起来不对吗?您是否需要计算Excel中的日期和时间值,但就是得不到正确的结果?您想精通Excel的日期和时间吗?那么这门课程就是为您准备的! 在这门全面的课程中,您将花一个多小时的时间,学会如何有效地使用Excel的日期和时间,包括: * 了解Excel如何将日期和时间存储为序列号 * 如何格式化日期和时间 * 恰当地格式化日期和时间 * 有效使用日期函数 * 有效使用时间函数 * 计算重复日期,如节假日 * 计算日期之间的差异,包括仅计算工作日 * 以多种方式显示当前日期和时间 * 求和超过24小时的时间,以及更多! **通过实践学习Excel日期和时间** 在本课程中,您可以通过随附的工作表中的大量简洁示例来跟随学习,这些示例将阐明Excel日期和时间的细微差别。此外,我们还提供了练习题,让您将相同的概念应用于另一个数据集,从而确保您已掌握这些概念。 我们是专业的讲师,已帮助数千名学生掌握了Excel的日期和时间,并提高了工作效率。我们诚邀您加入我们,开启一段短暂的旅程,以提升您的职业生涯。立即报名!
Have you done date and time calculations in Excel but keep running into weird problems? Do the dates and times in your Excel spreadsheets look off? Do you need to calculate date and time values in Excel but just aren't getting results? Do you want to master Excel dates and times? This course is for you! Master Excel Dates and Times in this Comprehensive Course In just over an hour you will learn to effectively use Excel dates and times including: Knowing how Excel dates and times are stored as serial numbersHow to format dates and timesAppropriately formatting dates and timesEffective use of date functionsEffective use of time functionsCalculating recurring dates like holidaysCalculating differences between dates including only counting workdaysDisplaying current date and time in a variety of waysSumming times that exceed 24 hoursand more! Learn Excel Dates and Times by Doing Throughout the course, you can follow along with the numerous concise examples that illustrate the nuances of Excel dates and times using the included worksheets. Further, practice problems are provided to allow you to apply these same concepts to another data set so that you can know that you have mastered the concepts. We are professional instructors who have helped thousands of students Master Excel Dates and Times and become even more effective at work. We invite you to join us on a short journey to advance your career. Enroll today!