Shopping Cart

Become a Learning.ly Instructor

Master Text, Date and Time in Excel

80 minutes of course content

Review course syllabus

$20.00 (taxes calculated at checkout)

100% money-back guarantee  |  Click here to read more

Share this course:
Facebook Google LinkedIn Pinterest Twitter

Course Description

Master Date, Time and working with Text Strings in Excel. A comprehensive course for those that wish to up skill in Excel and Learn advanced skills with Date, Time and Text.

In This Course You Will Learn How To Extract from a Text String, Clean Text, Find/Replace and Substitute text, Work with Date Math and Time Math, combine Date and Logical functions, Use dates to drive formula and labels and much much more..

Course Overview

This course begins with working with Text, Throughout these lessons we are going to look at extracting characters from text strings using left mid and right, were going to clean text using Trim, Proper, Upper and Lower. We are then going to edit and amend text using Find, Search, Substitute and replace and we are also going to look at joining text using Auto fill, Ampersand and Concatenate.

After this we will move into Date and Time. You will learn how formatting is used to display date and time, and how the serial number behind both of these can be used in formula to carry out date math and more complex calculations.

In addition to the above you will also learn about custom formatting and formatting codes in Excel

By the end of this course you will be able to create dynamic labels, Use a master date to drive all other dates in a workbook, use formatting to display data the way you want and much much more.

This course contains:

Workbook to download

Notes to download

********************************************************************************************

REGISTER NOW and get started with Master Date Time and Text in Excel

*******************************************************************************************

What are the requirements?

  • You should have a basic Excel knowledge

    After taking this course, you will be able to:

      • Extract from a text string
      • Work with clean text
      • Find/Replace and substitute text
      • Work with date math and time math
      • Combine date and logical functions
      • Use dates to drive formula and labels and much, much more!

       

      This course is for professionals within the following business functions:

      • This course is aimed at those that wish to increase their financial knowledge to gain a competitive advantage in their career. 
      • Marketers who want to develop a more effective dialogue with the finance and accounting functions
      • Marketers who want an introduction course in key financial concepts and analyses
      • Marketers who want to refresh their knowledge of financial ratios
      • Marketers who want to improve their marketing decision-making
      • This course is NOT aimed at teaching you how to use finance in marketing, but to equip you with knowledge that could otherwise hold you back as you advance through your career.
      1. Introduction

        1. Mastering Text Date and Time in Excel - Intro
        2. Workbook
        3. Notes for the Course
      2. Text Date and Time

        1. Working with Text in Excel - An Introduction
        2. Working with Text 1
        3. Working with Text 2
        4. Working with Date and Time - An Introduction
        5. Working with Date and Time
        6. Custom Formatting - An Introduction
        7. Custom formatting Examples
        8. More date Math examples
        9. Conclusion

        About the Expert

        Paula Guilfoyle

        Paula Guilfoyle

        Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management, Process improvement, Internal Audit, Group accounts, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has online courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.
        Read more