8 Awesome New Excel Formulas for 2023 | Do you know them?
Jun 19, 2023 5:30 AM

8 Awesome New Excel Formulas for 2023 | Do you know them?

External YouTube Channel

Learn 8 awesome new formulas in Excel to boost your productivity in 2023.

8 Awesome New Excel Formulas for 2023 | Do you know them? Learn 8 awesome new formulas in Excel to boost your productivity in 2023. 

In this video, we'll go over new excel functions that you can use in 2023. These formulas include the:

  1. VSTACK: This function combines arrays vertically into a single array. Each subsequent array is appended to the bottom of the previous array

  2. HSTACK: This function combines arrays horizontally into a single array. Each subsequent array is appended to the left of the previous array

  3. TEXTSPLIT: This function splits a text string with a given delimiter into multiple values. The output from TEXTSPLIT is an array that will spill into multiple cells in the workbook

  4. TEXTBEFORE: This function extracts text that occurs before a given delimiter. When multiple delimiters appear in the text, TEXTBEFORE can return text that occurs before the nth instance of the delimiter

  5. TEXTAFTER: This function extracts text that occurs after a given delimiter. When multiple delimiters appear in the text, TEXTAFTER can return text that occurs after the nth instance of the delimiter

  6. IMAGE function: This function inserts images into cells from a source location along with alternative text. You can then move and resize cells, sort and filter, and work with images within an Excel table

  7. Converting images to tables: With the Data from Picture feature, you can insert data from a screen capture on your clipboard, or an image file from your computer. Excel then attempts to analyze the image and convert the data into editable form in Excel

  8. TOCOL: This function transforms an array into a single column. By default, TOCOL will scan values by row, but TOCOL can also scan values by column.

Master the New Excel Formulas for 2023

Keep up with the latest advancements in Excel by mastering these new formulas for 2023. Not only will they speed up your workflow, but they will also make your data analysis tasks more efficient. By familiarizing yourself with these powerful functions, you'll be able to tackle complex data cleaning tasks and make the most of your data within Excel. Stay ahead of the curve and supercharge your productivity by mastering these new Excel functions for 2023

 

Learn about 8 Awesome New Excel Formulas for 2023 | Do you know them?

In 2023, Excel users can use 8 new formulas to increase productivity. These formulas include Vstack, Hstack, textsplit, textbefore, textafter, image function, converting images to tables, TOCOL, TOROW, Take, Drop, and Expand functions. With these new formulas, data cleaning on Excel will be more efficient and effective. Additionally, Excel users can learn Power BI for Business Analytics and The Complete Finance & Valuation Course to further improve their knowledge and skills.

More links on about 8 Awesome New Excel Formulas for 2023 | Do you know them?

Top Excel formulas you should know in 2023
Apr 23, 2022 — Excel formulas are very useful and help you to perform a wide range of calculations. Learn more with the help of the blog.
Top 25 MS Excel Formulas One Must Know
May 3, 2023 — Excel formulas enable you to perform calculations such as addition, subtraction, multiplication, and division. In addition to these, you can ...
Top 2022 blog posts on Excel's new formulas
Sep 9, 2022 — In this blog, we'll get to know six new Excel formulas that will help you save time in Excel, along with some useful resources to master them.
10 Advanced Excel Formulas You Must Know
Aug 6, 2019 — These advanced Excel formulas are critical to know and will take your financial analysis skills to the next level. Download our free Excel ...
Microsoft Excel formulas with examples
Mar 21, 2023 — The tutorial explains the very basics of Excel formulas with detailed steps on how to write and use them. It also shows how to make advanced ...

Keywords

Microsoft Excel Formulas, Microsoft Excel Functions, Microsoft Excel 2023, Microsoft Excel Productivity, Microsoft Excel Data Cleaning, Microsoft Power BI, Microsoft Finance Course, Microsoft Valuation Course