TEXT Function in Ms Excel and Google Sheets with over 10 examples
🌟🌟NEW FREE ENGLISH QUIZZES🌟🌟
https://whizbusters.teachable.com/p/e...
💰2000 questions
💰Basic, Intermediate, Advanced Level
💰Word Quizzes + Sentence Quizzes
💰Video Solutions for each answer
💰No login required
💰Enhanced your English vocabulary anywhere and anytime
***************************************************************************************************** This is a comprehensive tutorial with 10 + examples on how to convert NUMBERS and DATES to TEXT in Ms Excel and Google Sheets with the TEXT Function.
It can be very helpful in your dashboard.
Time Stamps
00:00:00 Objective, purpose and output
00:00:43 Syntax of the TEXT function
00:01:22 16 examples of using the TEXT function on dates
00:02:02 Convert the DAY of the week to TEXT from a DATE with the TEXT Function
00:03:40 Convert the MONTH to TEXT from a DATE with the TEXT Function00:04:24 Convert the YEAR to TEXT from a DATE with the TEXT Function
00:04:38 Convert the HOUR and SECONDS to TEXT from a DATE with the TEXT Function
00:05:04 Example to create a customized sentence with a date or today’s date
00:06:47 Example to convert number to decimal places with TEXT Function
00:08:47 Example to convert number to fractions with TEXT Function
00:09:42 Example to convert percentage to decimal places with TEXT Function
00:11:25 Example to convert thousands to shortened form of K with TEXT Function
00:11:56 Example to add padded zeros to a number and make it n digits with TEXT Function
Other helpful links of playlists include
Functions: • Playlist
Problems: • Playlist
Organize Data: • Playlist
Let’s connect on social:
Instagram: /
LinkedIn: / whiz...
Twitter: / whizbusters
Facebook: / whizbusters
www.whizbusters.com
Documentation: https://support.google.com/docs/answe...
#GoogleSheets #MsExcel #englishlanguage #worddefinition #learnenglish #englishvocabulary #pronunciationguide #languagelearning