Ablebits Blog
1,991 FOLLOWERS
Excel tutorials, functions and free formula examples, Outlook tips, tricks and how-to articles for dummies and advanced users.
Ablebits Blog
1y ago
Finding all combinations of values that add up to a given sum is a common problem in data analysis. For example, you may want to know all possible combinations of items that can be purchased with a given budget, or all possible ways to allocate resources to meet certain requirements ..read more
Ablebits Blog
1y ago
The Styles add-on for Google Docs has been a popular tool for customizing the appearance of your documents. We're excited to announce its next version: Styles 2.0! Come explore its new features and improvements and how they will enhance your experience with Google Docs ..read more
Ablebits Blog
1y ago
Whether you're an experienced user or just starting to learn about your favorite spreadsheet program, knowing how to quickly identify if a specific value is present or absent in a given range can save much time and effort in your data analysis ..read more
Ablebits Blog
1y ago
Table Styles add-on has been a part of our Google Sheets arsenal for a long time. The time has come: the time for a major upgrade :) Version 2.0 brings a fresh simplified design (way better and user-friendlier looks) and opens up new possibilities to format your Google tables ..read more
Ablebits Blog
1y ago
A drop-down menu in Excel makes data entry easier, faster and less prone to errors. Once a drop-down list is created, you may need to change it for a variety of reasons. For example, you may want to update the list with new options, insert the same picklist in other cells, or remove it from the sheet entirely ..read more
Ablebits Blog
1y ago
Meet the brand new version of our Merge Sheets add-on – 2.0! New features and improvements to make your merge in Google Sheets even more precise and tailored to your liking ..read more
Ablebits Blog
1y ago
Sorting text and numbers separately in Excel is as easy as ABC or 123 :) But re-arranging values that have both letters and digits in them such as employee IDs, SKU's and the like may cause problems. If you want to have more control over how alphanumeric stings are sorted, read this tutorial ..read more
Ablebits Blog
1y ago
Microsoft Excel provides a variety of functions to calculate dates. When it comes to adding or subtracting months to/from a given date, EDATE is the function to use. Additionally, it can help you calculate expiration dates, anniversary dates, due dates, and a lot more ..read more
Ablebits Blog
1y ago
Imagine that you are working with a dataset of hundreds or thousands of columns. Obviously, some columns are more important than others, and naturally you may want to read their data first. Excel 365 offers a perfect function for the job, named CHOOSECOLS ..read more
Ablebits Blog
1y ago
Suppose you have an Excel worksheet with hundreds of rows from which you want to extract some specific ones. Do you already feel annoyed at the thought of copying and pasting the data manually or writing a VBA code to automate the task? Simply, use the CHOOSEROWS function ..read more