This is a real time-saver: You can see the same Excel file side by side in two windows. Of course, this works also for different Excel files. And the best: It does not only work for Microsoft Excel, but for all other Office programs, such as PowerPoint, Word or Outlook. Here is how to do… Continue reading How to See an Excel File in Two Windows Side by Side
Microsoft Excel is one of the most used software products in the business world. It’s extremely flexible and seems to have a solution to every problem. With more than 1.2 billion users (see Excel fact #4 below), a loooot of people have at least heard of it. So, I have written more than 200 articles… Continue reading Excel Facts: The Most Interesting Fun Facts for Excel Users!
In a “normal” PivotTable (without changing any of the default settings), other Excel users can easily restore the source data. Also, when you copy and paste the PivotTable into a new Excel file without the data. But what, if you want to prevent other users to see all the data? Here is how to do… Continue reading How to Prevent Users to Restore PivotTable Source Data
You have received an Excel file with a PivotTable in it. Unfortunately, the file does not have the raw source data of the PivotTable. Or has it? Here are the steps for easily restoring the raw source data of the PivotTable.
You might want to use numbers of weeks especially when you create timelines, schedules or calendars. The formula is called WEEKNUM().
When I create Excel files for my clients, one of my first questions is “Which Excel version do you use?”. The reason for this question is that I want to know which formulas and functions of Excel I can use and will work on my clients computer. For example: Can I use the more special… Continue reading Excel Functions: What is new? Can I use this function?
You have sent an Excel sheet to a co-worker for revision and received it back. The problem: You don’t know what has changed. Here is how to compare two Excel sheets.
One of the most often used functions when creating an Excel model is consolidating data from different sources. Traditionally, there were 3 major functions for combining data from different tables or worksheets: VLOOKUP, SUMIFS and INDEX/MATCH. Now, Microsoft has introduced XLOOKUP. So what is the difference between these four lookup functions and which one should… Continue reading XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!
Does this sound familiar? You work on an Excel sheet and are almost done with it. Now, you just want to “brush it up” a bit. But: It seems that the formatting takes even longer than working on the calculations. In this article we look at techniques to apply a format with as few clicks… Continue reading How to Format Excel Cells Perfectly With One Click
You have received an Excel file and somebody has highlighted text with a different font color? If you are talking about a few cells only – no problem. But what, if you file has hundreds of rows? How do you return the fore color from the text (or number) cells? ContentsMethod 1: Do it manually… Continue reading How to Return the Font Color From Excel Cell