AutoFilter Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/autofilter/ Bestselling Excel and Power BI Courses Wed, 12 Jun 2024 08:04:45 +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 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 Separate Names in Excel 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 How to Separate Names in Excel 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.

]]>