Excel Quick Tip: Text Function - ARRAYTOTEXT 🅰🆎🔡🆑
Excel Quick Tip: Text Function - ARRAYTOTEXT 🅰🆎🔡🆑
JOIN OUR 7 STEPS TO EXCEL SUCCESS VIP CLUB: https://myexcel.club
Learn how to use this new Excel function called ARRAYTOTEXT. It converts an array of data into text that can be made into a list or can be formatted to use in a formula.
This function is only available to members of the Office Insider program. I will explain.
00:00 Start
00:41 Intro
02:06 ARRAYTOTEXT function Page
03:35 Different Types of ARRAY
05:48 Arguments
07:09 Select 2 kinds of Format
08:14 Unhide Columns
8:36 Join Office Insider Program
Let's keep on learning!
💪😃🌴
JOIN OUR 7 STEPS TO EXCEL SUCCESS VIP CLUB: https://myexcel.club
Try it FREE for 3-days then only $7 a month!
🔥15 minute Excel VIP coaching session with a Microsoft Certified Trainer
🔥Over $500 worth of courses
🔥Live Classes
🔥Monthly Live Webinars
🔥Weekly live streams
🔥Private VIP Members Community Forum
🔥Access to all course updates
🔥In-course quizzes to sharpen your skills
🔥Continuosly updated lessons
************************************************************
About Billy Wigley:
As a Microsoft Certified Trainer, Billy “Mr. Aloha” Wigley is a Microsoft Office Expert in Excel. After 5 years of actively traveling throughout the USA and other countries, leading public seminars teaching Excel skills to more than 65,000 professionals in over 100 cities, Billy became an online Premium Instructor in order to help even more Excel learners. With over 25 years of leadership experience, and from having resided in various cities worldwide, Billy Wigley is well-known around the world. With his strong USA and Colombian heritage, and many years residing in Hawaii, Billy Wigley takes pride in his multi-cultural background and being able to reach English, and Spanish speakers around the globe to share his Excel Aloha!
--Billy Wigley always says: "Don't Get Mad…Get Skills!"
************************************************************
#dontgetmadgetskills #textfunctions #arraytotext #exceltips