There are a few cases in Excel when you need to return the column letter from an Excel cell. For example, when you use the INDIRECT function. Retrieving the number of a cell is quite simple using the =COLUMN() function. But the letter? Here is how to do that! Summary In a hurry? Copy and… Continue reading How to Return the Column Letter (Not Number) With Excel Function
Knowledge Area
How to Change Proofing Language in the Whole PPT Presentation
Often, after working with Excel, you want to present your results in PowerPoint. The problem, especially when working internationally with different language settings involved: The proofing language often seems to have its own life. It’s often troublesome to continuously tell PowerPoint which language to use. Here are three simple (and two of them very fast)… Continue reading How to Change Proofing Language in the Whole PPT Presentation
How to See an Excel File in Two Windows Side by Side
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
Excel Facts: The Most Interesting Fun Facts for Excel Users!
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!
How to Prevent Users to Restore PivotTable Source Data
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
How to Restore All Raw Source Data From PivotTable
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.
How to Insert Week Number & Deal With Different Week Systems
You might want to use numbers of weeks especially when you create timelines, schedules or calendars. The formula is called WEEKNUM().
Excel Functions: What is new? Can I use this function?
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?
Compare Sheets: How to See Differences of Two Excel Sheets
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.
XLOOKUP, VLOOKUP or INDEX/MATCH? Big Lookup Functions Guide!
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!