Flash Fill Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/flash-fill/ Bestselling Excel and Power BI Courses Tue, 19 Dec 2023 15:32:46 +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.

]]> Excel vs. Google Sheets – Is Excel Better? https://www.xelplus.com/excel-vs-google-sheets/ Thu, 01 Oct 2020 09:00:00 +0000 https://www.xelplus.com/?p=10646 These are 10 Excel features that are better than Google Sheets. This post is like a "top 10 tips and tricks" type of post. Even if you're currently using Excel, you might discover new tips you can use.

The post Excel vs. Google Sheets – Is Excel Better? appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel’s Amazing Flash Fill 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 Excel’s Amazing Flash Fill appeared first on Xelplus - Leila Gharani.

]]> Excel shortcut keys you SHOULD know! https://www.xelplus.com/excel-shortcut-keys/ 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 shortcut keys 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.

]]>