Button Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/button/ Bestselling Excel and Power BI Courses Mon, 20 Jan 2025 10:10:22 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Button Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/button/ 32 32 How to Add a Slicer in Power BI https://www.xelplus.com/power-bi-slicers/ Wed, 21 Dec 2022 10:42:00 +0000 https://www.xelplus.com/?p=8862 Power BI Slicers add interactivity to your reports. Managers love to slice and dice. But which Power BI slicers are available? Which should you choose? This tutorial will make you a master in Power BI slicers.

The post How to Add a Slicer in Power BI appeared first on Xelplus - Leila Gharani.

]]> Power BI – How to add Drill Through to Reports https://www.xelplus.com/power-bi-drill-through/ Thu, 17 Nov 2022 10:00:00 +0000 https://www.xelplus.com/?p=9171 Power BI’s Drill Through is a special filter that takes you from the overview page to the cross-filtered details page of the report. Learn how to set it up so that you're never taken by surprise during a presentation with requests to drill deeper into data.

The post Power BI – How to add Drill Through to Reports appeared first on Xelplus - Leila Gharani.

]]> How to Use Power Automate in Excel https://www.xelplus.com/power-automate-in-excel/ Thu, 18 Mar 2021 10:00:00 +0000 https://www.xelplus.com/?p=10189 Learn to combine Microsoft Excel with Power Automate and get more done! We'll look at two practical examples: Record your working hours in Excel by clicking a button on your phone - AND - Post on LinkedIn from the comfort of your Excel file.

The post How to Use Power Automate in Excel appeared first on Xelplus - Leila Gharani.

]]> How to use the Message Box in Excel VBA https://www.xelplus.com/vba-message-box/ Sun, 10 Feb 2019 23:24:00 +0000 https://www.xelplus.com/?p=12878 Learn the correct Excel VBA syntax to be able to create a message box in Excel. It's easy to create a standard message box or a "yes", "no" message box where the user needs to make a decision before proceeding.

The post How to use the Message Box in Excel VBA appeared first on Xelplus - Leila Gharani.

]]> Excel VBA: Loop Through Cells Inside the Used Range (For Each Collection Loop) https://www.xelplus.com/excel-vba-loop-cells-inside-used-range/ Sat, 05 Jan 2019 16:54:00 +0000 https://www.xelplus.com/?p=9251 Learn how to use the FOR EACH Collection Loop in Excel VBA. This way you can quickly loop inside a specific range, manipute the data or check for a condition. In this example we count the number of cells that contain formulas in the UsedRange.

The post Excel VBA: Loop Through Cells Inside the Used Range (For Each Collection Loop) appeared first on Xelplus - Leila Gharani.

]]> Excel VBA FIND Function https://www.xelplus.com/excel-vba-find-function/ Thu, 12 Jul 2018 07:55:00 +0000 https://www.xelplus.com/?p=10494 Find out how to use the FIND function in Excel VBA. This can be more effective than looping through large data ranges. VBA also results in error if the value is not found. How can you overcome this error? Find out in the article.

The post Excel VBA FIND Function appeared first on Xelplus - Leila Gharani.

]]>