Flash Fill Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/flash-fill/ Bestselling Excel and Power BI Courses Wed, 09 Oct 2024 06:49:08 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Flash Fill Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/flash-fill/ 32 32 How to Add Text to Cell values in Excel – Add Text to Beginning or End of Cell values https://www.xelplus.com/excel-add-text-to-values/ Thu, 02 Sep 2021 08:00:00 +0000 https://www.xelplus.com/?p=9825 You can easily add text to your cell values in Excel. You don't have to do this manually. You have 3 easy options to choose from. The 3rd one will surprise you. You can use it in many other circumstances as well.

The post How to Add Text to Cell values in Excel – Add Text to Beginning or End of Cell values appeared first on Xelplus - Leila Gharani.

]]> Best Excel Features for Accountants https://www.xelplus.com/top-excel-features-for-accountants/ Thu, 18 Mar 2021 08:18:00 +0000 https://www.xelplus.com/?p=10203 Learn the 10 most important Excel features for accountants. This list is not just for those that work in accounting but also anyone who uses Excel for data analysis. You'll discover new Excel tips and tricks that will make your working life a lot easier.

The post Best Excel Features for Accountants appeared first on Xelplus - Leila Gharani.

]]> How to Use Google Sheets Smart Fill https://www.xelplus.com/smart-fill-in-google-sheets/ Tue, 10 Nov 2020 13:00:00 +0000 https://www.xelplus.com/?p=10541 With SmartFill in Google Sheets you get to auto fill a column based on a pattern. For example, if you'd like to grab the first name of a person, you don't have to write the formula. Just write the end result and Sheets will fill down with the correct formula.

The post How to Use Google Sheets Smart Fill appeared first on Xelplus - Leila Gharani.

]]> How to Use Flash Fill in Excel https://www.xelplus.com/excel-flash-fill/ Thu, 07 Nov 2019 10:00:00 +0000 https://www.xelplus.com/?p=11790 Excel's Flash Fill feature can save you a ton of time! Check out how you can automatically split names, get the initials, email addresses and more with Excel's amazing Flash Fill feature. No more writing complex formulas.

The post How to Use Flash Fill in Excel appeared first on Xelplus - Leila Gharani.

]]> Excel Shortcuts You SHOULD know! https://www.xelplus.com/excel-shortcuts/ Sat, 13 Apr 2019 00:02:00 +0000 https://www.xelplus.com/?p=12534 Are you using all of these 20 Excel keyboard shortcuts in your daily work? They range from data navigation to auto sum, inserting the date and time and even moving rows of data and dropping them between other rows.

The post Excel Shortcuts You SHOULD know! appeared first on Xelplus - Leila Gharani.

]]> How to Change Letter Case in Excel (3 ways including NO Formulas) https://www.xelplus.com/excel-change-case-of-text/ Fri, 05 Apr 2019 20:03:00 +0000 https://www.xelplus.com/?p=12753 Learn 3 ways to quickly change the case of text in Excel. For example, change lower case to upper case or vice versa - or clean up text to proper case. We use formulas, as well as non-formula techniques to get his done. You'll also find a list of free Fonts you can install.

The post How to Change Letter Case in Excel (3 ways including NO Formulas) appeared first on Xelplus - Leila Gharani.

]]>