Conditional Formatting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/conditional-formatting/ Bestselling Excel and Power BI Courses Tue, 05 Dec 2023 13:31:21 +0000 en-US hourly 1 https://www.xelplus.com/wp-content/uploads/2022/10/cropped-site-icon-32x32.png Conditional Formatting Archives - Xelplus - Leila Gharani https://www.xelplus.com/tag/conditional-formatting/ 32 32 Excel’s Checkboxes Are Incredibly Cool! Here’s why https://www.xelplus.com/excel-checkboxes/ Tue, 21 Nov 2023 16:18:58 +0000 https://www.xelplus.com/?p=19747 Excel's new Checkbox feature makes lists and interactive reports easier than ever. See how to add, customize, and use the new checkbox feature in a creative and interesting ways.

The post Excel’s Checkboxes Are Incredibly Cool! Here’s why appeared first on Xelplus - Leila Gharani.

]]> How to Fix Slow Excel Spreadsheets https://www.xelplus.com/how-to-fix-slow-excel-spreadsheets/ Mon, 06 Nov 2023 17:50:39 +0000 https://www.xelplus.com/?p=13496 Poor design slows down your spreadsheets. There are several frequent offenders to watch out for. Find out what they are and how you can optimize your workbooks.

The post How to Fix Slow Excel Spreadsheets appeared first on Xelplus - Leila Gharani.

]]> Excel Find and Highlight Duplicates https://www.xelplus.com/excel-find-and-highlight-duplicates/ Thu, 24 Aug 2023 15:12:21 +0000 https://www.xelplus.com/?p=17558 Learn to locate duplicate values in a list, between multiple lists, as well as duplicate rows in a table. Generate a report that lists all duplicates.

The post Excel Find and Highlight Duplicates appeared first on Xelplus - Leila Gharani.

]]> 10 Power BI Tips & Tricks https://www.xelplus.com/power-bi-tips-tricks/ Thu, 03 Feb 2022 10:00:00 +0000 https://www.xelplus.com/?p=9491 Power BI can do THAT? Learn 10 quick tips to enhance your Power BI dashboards: Conditionally format charts, create a separate measures table, customize your own tool tips and a lot more.

The post 10 Power BI Tips & Tricks appeared first on Xelplus - Leila Gharani.

]]> How to Use Checkboxes in Excel https://www.xelplus.com/how-to-use-checkboxes-in-excel/ Thu, 15 Jul 2021 08:00:00 +0000 https://www.xelplus.com/?p=9954 Quickly learn how to create a checkbox in Excel. You can also easily create multiple checkboxes. It's important to learn how to use the outcome of the checkbox in formulas or conditional formatting - for example to get a strikethrough effect. Find out in this comprehensive tutorial.

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

]]> Excel Advanced Pivot Table Techniques for Serious Data Analysts https://www.xelplus.com/excel-advanced-pivot-tables/ Thu, 08 Apr 2021 08:00:00 +0000 https://www.xelplus.com/?p=10162 These 10 advanced Excel Pivot Table tips are going to help you analyze your data faster. PivotTables are one of Excel's most important tools. Not everyone knows these Pivot Table tricks though. Make sure you do!

The post Excel Advanced Pivot Table Techniques for Serious Data Analysts 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.

]]> Too Many Emails? Here’s How to Take Control of Your Inbox https://www.xelplus.com/email-strategy-to-manage-your-inbox-with-outlook-tips/ Sun, 07 Feb 2021 09:38:00 +0000 https://www.xelplus.com/?p=10325 Manage your inbox so you can be more productive and less stressed! I'll share email management techniques that help you get organized. You'll also learn time management techniques to instantly put more time in your day and easily manage your Outlook Inbox.

The post Too Many Emails? Here’s How to Take Control of Your Inbox appeared first on Xelplus - Leila Gharani.

]]> Excel Stock Data Type to Get Real-Time Stock Metrics https://www.xelplus.com/excel-stock-data/ Thu, 31 Dec 2020 10:38:00 +0000 https://www.xelplus.com/?p=10387 Get the latest stock data in Excel with Excel Data Types. You don't have to worry about the right formula. Everything gets written for you automatically. In this tutorial I show you how to set up your own stock portfolio in Excel from scratch.

The post Excel Stock Data Type to Get Real-Time Stock Metrics appeared first on Xelplus - Leila Gharani.

]]> How to Use Excel Conditional Formatting with Formulas https://www.xelplus.com/excel-conditional-formatting-rows/ Thu, 03 Dec 2020 10:00:00 +0000 https://www.xelplus.com/?p=10404 Discover how to properly conditionally format rows in Excel with a Formula. This way you can highlight entire rows. I also share the secret to get it right every time.

The post How to Use Excel Conditional Formatting with Formulas appeared first on Xelplus - Leila Gharani.

]]>