Excel 2016 Time and Date Function Playbook from Pluralsight

In this course, Excel 2016 Time and Date Function Playbook, you'll learn to deal with various scenarios and actions that occur when operating on worksheets containing dates and timestamps.

Microsoft Excel workbooks are seldom found without several cells filled with relevant dates or timestamps. As such, it is important to know how to deal with them, and in this course, Excel 2016 Time and Date Function Playbook, that's exactly what you'll be doing. To effectively compartmentalize all these functions, the course is divided into 5 modules. In the first module, you’ll learn how to reference time and date in excel using the NOW and TODAY functions. Then, you’ll look at comparing date and time in a cell with the current date and time using the NOW and TODAY functions. Next, you'll learn to serialize dates and times before moving on to use several functions such as TIMEVALUE, DATEDIF, and DAYS360, to find the difference between dates and times. Finally, you'll explore how to parse dates and times in Excel with further useful functions.

What's inside

Syllabus

Course Overview

Referencing Current Date and Time

Serializing Dates and Times in Excel

Calculating Differences Between Dates and Times

Finding the Day, Month, Weekday, or Year of a Date

Finding the Hour, Minute, or Second of a Time

Good to know

Know what's good

, what to watch for

, and possible dealbreakers

Tailored for learners who work with dates and timestamps in Excel

Suitable for learners interested in deepening their Excel skills

Taught by Pratheerth Padman, an experienced instructor

Covers essential Excel time and date functions

Can serve as a reference guide for intermediate Excel users

Somewhat technical in nature, requiring prior Excel knowledge

Career center

Learners who complete Excel 2016 Time and Date Function Playbook will develop knowledge and skills that may be useful to these careers:

Data Analyst

Data Analysts use their knowledge of data analysis and statistical techniques to solve business problems. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to manipulate and analyze dates and times in Excel, which is a common task for Data Analysts. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Data Analysts to have.

See salaries and explore the career path for Data Analyst

Business Analyst

Business Analysts use their knowledge of business and technology to help organizations improve their performance. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data and make recommendations. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Business Analysts to have.

See salaries and explore the career path for Business Analyst

Financial Analyst

Financial Analysts use their knowledge of finance and economics to help businesses make informed decisions. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze financial data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Financial Analysts to have.

See salaries and explore the career path for Financial Analyst

Data Scientist

Data Scientists use their knowledge of mathematics, statistics, and computer science to extract insights from data. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Data Scientists to have.

See salaries and explore the career path for Data Scientist

Operations Research Analyst

Operations Research Analysts use their knowledge of mathematics and computer science to solve business problems. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data and make recommendations. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Operations Research Analysts to have.

See salaries and explore the career path for Operations Research Analyst

Quantitative Analyst

Quantitative Analysts use their knowledge of mathematics, statistics, and computer science to develop and implement financial models. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze financial data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Quantitative Analysts to have.

See salaries and explore the career path for Quantitative Analyst

Actuary

Actuaries use their knowledge of mathematics and statistics to assess risk and uncertainty. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data and make recommendations. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Actuaries to have.

See salaries and explore the career path for Actuary

Statistician

Statisticians use their knowledge of mathematics and statistics to collect, analyze, and interpret data. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Statisticians to have.

See salaries and explore the career path for Statistician

Market Researcher

Market Researchers use their knowledge of marketing and research methods to collect and analyze data about consumers. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Market Researchers to have.

See salaries and explore the career path for Market Researcher

Customer Insights Analyst

Customer Insights Analysts use their knowledge of data analysis and marketing to help businesses understand their customers. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Customer Insights Analysts to have.

See salaries and explore the career path for Customer Insights Analyst

Product Manager

Product Managers use their knowledge of product development and marketing to create and launch new products. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Product Managers to have.

See salaries and explore the career path for Product Manager

Project Manager

Project Managers use their knowledge of project management to plan, execute, and close projects. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to track project progress. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Project Managers to have.

See salaries and explore the career path for Project Manager

Consultant

Consultants use their knowledge of business and technology to help businesses improve their performance. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Consultants to have.

See salaries and explore the career path for Consultant

Software Engineer

Software Engineers use their knowledge of computer science to design, develop, and maintain software. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Software Engineers to have.

See salaries and explore the career path for Software Engineer

Data Engineer

Data Engineers use their knowledge of data engineering to design, build, and maintain data pipelines. Excel 2016 Time and Date Function Playbook may be useful for this role as it teaches how to use Excel to analyze data. The course also covers how to use Excel functions to find the difference between dates and times, and how to parse dates and times, which are all useful skills for Data Engineers to have.

See salaries and explore the career path for Data Engineer

Excel 2016 Time and Date Function Playbook

What's inside

Syllabus

Good to know

Save this course

Career center

Reading list

Share

Similar courses