Working With Dates and Times in Excel (2022)
Published 11/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 27 lectures (2h 46m) | Size: 2.31 GB
Unleash the power hidden in Excel dates and times
What you'll learn
How to unearth A GOLDMINE OF VALUABLE INSIGHTS hidden in Excel date-and-time data.
Develop SERIOUS PROFESSIONAL EXCEL SKILLS by practicing use cases involving dates and times.
Enrich your analytical skills by learning how to QUICKLY SOLVE ALMOST ANY PROBLEM involving date and time calculations in Excel.
How to quickly clean and transform dates and times in your datasets for further analysis.
Fresh new strategies for data management and analysis based on the LATEST EXCEL FEATURES AND FUNCTIONS.
Wrap your mind around POWERFUL CALCULATIONS you can create by creatively combining date-&-time functions.
How to create YOUR OWN CUSTOM FUNCTIONS to speed up and SIMPLIFY YOUR WORKFLOW.
Immediately identify and fix common problems with Excel dates so you can continue your analysis.
Absolute understanding and control of dates and times in Excel.
Requirements
Desire to develop seriously impressive Excel skills.
Updated Excel with Microsoft 365 subscription.
Description
Are you aware that a simple column of dates in an Excel spreadsheet conceals a goldmine of valuable information? When unearthed, it can enrich reports and provide fresh new perspectives on data?
A handful of savvy analysts stand out from the crowd by having rich skill sets to uncover this goldmine and tap into the power of date-and-time data.
However, a vast majority of business and data analysts just "wing it" and fail to take full advantage of dates and times in spreadsheets. Which is a shame because these skills truly expand the horizon of available options for data analysis.
Fortunately, this class helps...
Read more
Continue reading...