Excel 4 Accounting & Bookkeeping - Master Date,Time & Text
3.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
15 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel 4 Accounting & Bookkeeping - Master Date,Time & Text to your Wishlist.

Add to Wishlist

Excel 4 Accounting & Bookkeeping - Master Date,Time & Text

Extract Text, use Date math, Calculate time, custom formatting....learn it now in Excel
3.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
15 students enrolled
Created by Paula Guilfoyle
Last updated 6/2016
English
Curiosity Sale
Current price: $10 Original price: $35 Discount: 71% off
30-Day Money-Back Guarantee
Includes:
  • 1 hour on-demand video
  • 3 Articles
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Extract, Sort, Correct and Replace Text in Excel
  • Calculate the difference between 2 dates or times
  • Use dates to drive financial models
  • Extract date and time from text string
  • Use Custom formatting in Excel to display your data the way you want it
  • Create an age debtors or creditors using date and time math
View Curriculum
Requirements
  • You will need a basic level of Excel such as that thought in the Udemy course Basic Excel for Basic Bookkeeping
Description

Excel for Accounting and Bookkeeping - Master Date, Time and Text. 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? Then this course is for you!

Course Overview

This course begins with with working with Text, where you will learn how to deal with text in Excel, Sorting, Cleaning, Extracting and replacing. We will then move on to date and time and you will learn how to calculate the different between two dates/times, use dates in financial models and create an age debtors or creditors.  In addition to all of this you will also learn about custom formatting.

This course contains:

Workbook to download  - Use this workbook to practice along 

Certificate of Completion

******BONUS****** FREE Join a community of other learners where you can interact with each other and with the instructor.

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

REGISTER NOW and get started with Excel for Accounting and Bookkeeping - Master Date Time and Text.

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

Your purchase is 100% RISK FREE with a 30 day money-back guarantee. If you don't learn anything new from this course, simply request a refund within your 30 day period for your money back, no questions asked.

Who is the target audience?
  • This course is NOT for you if you do not have a basic knowledge of Excel
  • This course is for you if you want to improve you basic Excel Skills to a more expert level using Date, Text and Time
  • All Bookkeepers and Accountants SHOULD know how do use date time and text in Excel
  • Any Excel User that wants to save time and become more proficient in Excel
Students Who Viewed This Course Also Viewed
Curriculum For This Course
12 Lectures
01:07:48
+
Working with Date, Time and Text in Excel
12 Lectures 01:07:56

This is a quick introduction as to what you will find this course

Preview 01:24

Course resource and activities
00:06

There are a number of reasons you might be working with Text in Excel or google sheets.  In this lesson you will be introduced to working with text

Preview 01:27

In this lesson we will look at working with Text examples

Preview 09:15

In this lesson we will be looking at more ways that you can work with text in excel

Working with Text in Excel 2
10:43

Do you understand how date and time work in Excel?  Do you know that both date and time are just numbers to excel?

Understanding Date and TIme
01:32

In this lesson you will see some working and practical examples of working with date and time in Excel

Working with Date, Time in Excel 1
15:55

Did you know that you can have content of a cell displayed in a number of formats, including custom formatting.  In this lesson you will get an overview of custom formatting

What is custom formatting in Excel
00:46

Lets look at custom formatting in excel in a lot more detail

Custom Formatting
18:15

In this lesson we will delve deeper into date and time and look at more examples

More Date and Time
07:15

A quick wrap up

Conclusion
00:12

Bonus
01:05
About the Instructor
Paula Guilfoyle
4.3 Average rating
1,447 Reviews
21,582 Students
19 Courses
CPA Accountant, Online Educator & Life Long Learner

Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, 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 Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.