Top 99+ Useful Excel Macro [VBA] Codes Examples
VBA
In Excel, macro code is a programming code which is written in VBA (Visual Basic for Applications) language. The idea behind using a macro code is to automate an action which you perform manually in Excel, otherwise. For example, you can use a code to print only a particular range of cells just with a single click instead of selecting …
Excel Data Validation, Filters, Grouping
Excel
In this tutorial, we are going to cover the following topics. Data validation Data validation is very important in the sense that it helps us avoid mistakes that can be avoided. Let’s assume you are recording student exam marks and you know the minimum is 0 and the maximum is 100. You can take advantage of validation features to ensure …
How to Use Excel: 18 Simple Excel Tips, Tricks, and Shortcuts
Excel
Sometimes, Excel seems too good to be true. All I have to do is enter a formula, and pretty much anything I’d ever need to do manually can be done automatically. Need to merge two sheets with similar data? Excel can do it. Need to do simple math? Excel can do it. Need to combine information in multiple cells? Excel …
12 custom woocommerce functions that will make you stand out
WordPress
WooCommerce is the most popular ecommerce platform in the world and there is a reason for this – it is highly customizable, easy to use and completely free. While it gives you an awesome standardized solution, which you may use to build a complete online store, sometimes you may want to expand your WordPress website functionalities and further customize it …
20 excel formulas you should start using now
Excel
MS Excel is one of the most popular data analysis tools in the world. More and more companies greatly depend on this software and quite a lot of people are using it on a daily basis. However, from my experience, not many are taking full advantage of the opportunities that the program can offer. Here is my list of the …
18 ready to use vba codes that will save your day
Excel
In this article, I am going to show you some of the most amazing VBA Excel codes that you can use to optimize your work. VBA is a programming language, which can be used to extend the capabilities of MS Excel and other MS Office applications. It is extremely helpful for MS Excel users, because it can be used to …
The 100 Definitive most useful Excel tips?
Excel
After 30 years, Microsoft Excel remains ubiquitous in business. The world’s quarter of a billion knowledge workers on average spend half an hour in the application every day. But despite this, Excel’s full capabilities are still poorly understood. Of 100,000 workers we’ve tested over the past three years, less than half know what Conditional Formatting – an essential feature – …
Slicing based on OR and XOR conditions in Power BI
Excel
Slicers on a report page in Power BI are an effective way to slice and dice your data under different conditions. But one situation that can be challenging to implement effectively is being able to apply multiple slicers, and show the rows that satisfy one condition or the other, not just the rows that satisfy both. In this blog post, …
How to make Histograms in Power BI to answer business questions
Power BI
A histogram is a common tool in statistics to describe the distribution of values across a dataset. They can show you the most common values, the outliers, and the spread of your values, all at a single glance. Histograms can be useful not just within statistics, but also for answering business questions. However it’s not immediately obvious how to set …