PivotTables, functionalities, databases, graphs, Power Pivot, Power Query, ... When we hear these words, only one thing springs to mind: Excel. But the tool actually packs much more power: you can use it to boost your efficiency and productivity. Does that sound tempting? Become an Excel wizard with the inspiring tips and tricks in this blog. Our tips are useful for beginners as well as advanced users.
As an HR, marketing or operational team member, you may have been confronted with situations where you need to set up individual Teams sessions for a series of colleagues.
Wouldn’t it be nice if you could just create and describe those sessions in an Excel table and use that table to create all sessions automatically in Teams at the push of a button?
Well… you can! Power Automate makes it easy to set up automations like this one.
Did you know? Sheet Views have been around for a while in the online version of Excel, but now they are also being added to the Excel desktop app.
We are increasingly working together on documents. This means that we more frequently open and edit documents at the same time. Sheet Views allow different users to use their personal filtering and sorting simultaneously. And yes, without affecting your colleagues.
In fact, we’re talking about specific ‘views’ here. In order to use them, the file in question must be stored on OneDrive or SharePoint.
If a worksheet contains rows upon rows of numbers, things can look quite cluttered.
As you can see in the example above, the large number of zero values draws the eye away from the fields that contain actual data.
One of the tricks to make the worksheet look less chaotic is by simply not showing the zero values. There are several ways to do this in Excel.
Excel has multiple functionalities that combine text from several cells into one big text. This is called ‘text concatenation’. In the examples below, we’ll assume our table includes the following columns: Street, Number, Postal Code and City.
As an Excel user, you undoubtedly know that you can use the $ sign to block a row or column in a formula. This creates an ‘absolute address’. Excel offers another method to block a cell or a cell range: by naming the cell(s).
Every Excel cell has its own address: a letter that identifies the column and a number that indicates the row. Did you know that you can rename a cell? Discover how naming cells in Excel can help you in this blog post.
In this blog post, I’ll let you in on a date formatting trick. I’m not talking about date formatting through Format Cells, but about the date format you enter manually when using the TEXT function.
Can’t get enough of Excel? Good! In this blog post, we’ll teach you another Excel trick. When Microsoft introduced tables in Excel in 2007, it became impossible to use the dollar sign ($) to lock rows or columns. This isn’t much of a problem for rows, but what about columns? Read on – I’ll explain how you can still lock these.
This is the seventh and last blog post in our series about how you can speed up data transformation in Excel VBA. In this blog post, we’ll discuss how you can merge two tables and add them to one recordset.
This is the sixth in a series of 7 blog posts that delve deeper into how you can speed up data transformation in Excel VBA. In the previous blog post, we explained how you can save data in a recordset. This time, we’ll show you how to use this technique to open all files in a folder and transfer their data to a target file.
Subscribe for our monthly newsletter and receive: