Course Overview
2h 37m | 15 Videos | 62251 Views | 
Beginner Date and Time Functions Excel Training:
Excel is by far the world’s most popular spreadsheet program and is useful for everything from maintaining simple household budgets to building sophisticated financial models or designing complex dashboards. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the maximum, rather than focusing on individual Excel functions and features.
wbcr_snippet
Through this course, you will learn how to calculate the dates and times in a range of scenarios.
The training will help you learn about
- How Excel dates and times are stored as serial numbers
- How to format dates and times
- Effective use of date functions
- Effective use of time functions
- Calculating recurring dates like holidays
- Calculating differences between dates including only counting workdays
- Displaying current date and time in a variety of ways
- Summing times that exceed 24 hours
Target Customers:
- Students
- Working Professionals
- Data Analysts
- Business Analysts
- Anyone who wants to learn more features and functions of Microsoft Excel 2016
Pre-Requisites:
- Basic computer knowledge
- Familiarity with the Microsoft Office work environment
