Texts, Time & Dates

Summary

Text, times, & dates are often poorly understood even by experienced Excel users.   This course will introduce the most popular functions (e.g. TRIM, MID) that enable you to write formulas with text strings, times and dates. You’ll apply key concepts through case-study style learning, with concise lessons and applied assessments.  This course was created & customized for Chartered Accountants Ireland by kubicle.com

Venue details:  
Online, ,
Start date & time:  
03 December 2018 00:00
End date & time:  
01 January 2020 00:00
Price: €75.00  (€75.00 Member price)
By registering for this course you have accepted the terms and conditions
Training ticket cost:  
3.00
CPD hours:  
3.00
Speaker details
No speakers have been associated with this event.

Description

Product type:  
CPD online course
Category:  
Information technology

Who Should Attend?

This course is suitable for beginner learners who are already familiar with Excel but not proficient analyzing these 3 different types of data. It is best suited to accountants, management consultants, analysts and other business professionals.

Course Overview

This Kubicle course contains 15 lessons, 4 exercises and 1 Exam. It covers the following topics:

  • Understanding text, time and dates
  • Combining, chopping and splitting strings of text
  • Searching and modifying text in a dataset
  • Converting dates from text into values
  • Adding / subtracting times and dates
  • Compiling weekly totals
  • Analysing data within time intervals

Key Outcomes

Once you have completed this course you will have a greater understanding of how text can be cleaned, manipulated and analysed in Excel. This will dramatically improve your ability to analyse text-based data. Separately, you’ll learn how dates and times are stored in Excel, and how to include these data types in a variety of different formulas to perform time-based analysis.