AutoFilter Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/autofilter/ Bestselling Excel and Power BI Courses Mon, 27 Mar 2023 07:06:38 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png AutoFilter Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/autofilter/ 32 32 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.

]]> 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.

]]> VLOOKUP Not Working? Convert Text to Date? (Excel Text to Columns) https://www.xelplus.com/excel-text-to-columns/ Thu, 31 Jan 2019 16:46:00 +0000 https://www.xelplus.com/?p=12953 A simple solution can be Excel's Text to Columns feature. With 4 clicks you can format your values as numbers and convert numbers or text to dates.

The post VLOOKUP Not Working? Convert Text to Date? (Excel Text to Columns) appeared first on Xelplus - Leila Gharani.

]]> Excel Filter: Basic to Advanced https://www.xelplus.com/excel-filter-basic-to-advanced/ Thu, 08 Mar 2018 16:36:00 +0000 https://www.xelplus.com/?p=11038 How does Excel Filter & Advanced Filter work? In this quick tutorial I show you many examples. You'll learn how to use wildcards in your filter criteria. How to use the criteria range in advanced filter. How to search for OR, AND or BETWEEN conditions and much more...

The post Excel Filter: Basic to Advanced appeared first on Xelplus - Leila Gharani.

]]>