Master Date,Time and Text in Excel

Extract Text, use Date Math, Calculate Time, Custom Formatting....learn it now in Excel

Master Date, Time and Text functions and formula in Excel. A comprehensive course for those that wish to up skill in Excel and Learn more advanced skills.

In This Course You Will Learn How to Clean Text, Extract Text, Replace Text, Carry out Date and Time Math and Apply Custom Formatting

Do you need to understand and carry out date or time math in Excel? Do you need to know how to sort out a text string? Do you need to create Excel Workbooks that are date driven? Then this course is for you!

Course Overview

This course begins with working with Text, where you will learn:

•  How to extract text using Left, Right and Mid and also learn how to clean text

• How to amend text using Find, Search and Replace

We will then move on to Date and Time and you will learn how:

• To calculate the different between two dates/times,

• To use dates in financial models to drive spreadsheets and create an age debtors or creditors using date math combined with IF statements.

• To use the Mod function with time calculations

• Extract dates and time from Strings of Text

• Use Date Functions such as Date, Yea, Month and EOMonth

In addition to all of this you will also learn about custom formatting.

Who Should Attend?

This course is suited to those with an interest in Excel and Reporting. This course is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.

• This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.

• This course is for you if you are looking to improve your Excel skills and increase efficiency

• This course is not for you if you don’t have a basic working knowledge of Excel

What’s included?

Instruction by an expert

12 months access 24/7

Certificate of completion

How long will it take?

Completion Time 2 Hours

Intended Audience: Bookkeepers, Accountants, Finance Staff

Course notes and workbook
Introduction to working with Text
Working with Text 1
Working with Text 2
Introduction to working with Date and Time in Excel
Date and Time in Excel
More Date Math
Introduction to Custom Formatting in Excel
Custom Formatting

What's included

  • 8 Video Lessons
  • 1 Text Lesson

  • Works on all devices
  • Certificate of completion

Paula Guilfoyle

Instructor

My Name is Paula, and I am a qualified CPA with over 15 years’ experience in Accounting and Business. I have worked across a broad range of industries and levels of seniority. During this time I used Excel as my spreadsheet tool of choice, attending many courses and regularly updating my skills. It was my love for Excel that started my journey as an e-learning educator. As a manager and an Accountant, I noticed a skills gap amount Accountants and finance staff in Excel. In 2010 I launched www.theexcelclub.com with 1 course aimed at this market. I am now author and presenter of many online courses and can boast that I have thought over 10,000 students!

In addition to being an Accountant and an Online Educators I am also a wife and a mother of two, my youngest is 2 and eldest is 7. I currently work as an Accountant for a global company, which makes family life very very busy. I am always stuck for time, and finding a balance is very difficult. I’m sure all working parents understand the pressures involved.