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!
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
Instruction by an expert
12 months access 24/7
Certificate of completion
How long will it take?
Completion Time 2 Hours