Recent Posts

Posted in Power BI

Top features in Tabular Editor 3 to boost your Power BI development!

Beginning this year, Microsoft’s announcement on the general availability of Read/Write XMLA endpoints, widely opened the door to many external tools intended to provide additional…

Continue Reading... Top features in Tabular Editor 3 to boost your Power BI development!
Posted in Power BI

Magic tables in Power BI

Tables, tables, tables…Love them, or hate them, we, Power BI developers, can’t live without them. Our users too. How many times did you hear from…

Continue Reading... Magic tables in Power BI
Posted in Excel tips

Thousands or Millions in Excel: How to Change the Number Unit

When you calculate with large numbers in Excel, you might want to only show the values as thousands or millions. 2,000 should be shown as…

Continue Reading... Thousands or Millions in Excel: How to Change the Number Unit
Posted in Excel 2021

INDIRECT: How to Use Text as a Cell Reference in Excel

Usually you type =A1 for referring to the cell A1 in Excel. But instead, there is also another method: You could use the INDIRECT formula….

Continue Reading... INDIRECT: How to Use Text as a Cell Reference in Excel
Posted in Excel 2021

Data Table to Normal Range: How to Convert an Excel Table

Data Tables (or “Excel Tables”) were introduced in Excel 2007. They were supposed to simplify the work with data in Excel. But in the reality…

Continue Reading... Data Table to Normal Range: How to Convert an Excel Table
Posted in Excel tips

Merge Excel Files: How to Combine Workbooks into One File

You have several Excel workbooks and you want to merge them into one file? This could be a troublesome and long process. But there are…

Continue Reading... Merge Excel Files: How to Combine Workbooks into One File
Posted in Excel tips

Unhide All Rows or Columns in Excel at the Same Time

Let’s assume the following situation: You’ve received an Excel workbook from a colleague, client or anyone else but you have the feeling, that some rows…

Continue Reading... Unhide All Rows or Columns in Excel at the Same Time
Posted in Excel tips

XLSX, XLSM or XLSB: Which File Type Is the Best for You?

Probably 99% of all Excel workbooks are saved in the XLSX file type these days. But there are various other file extensions available: For example…

Continue Reading... XLSX, XLSM or XLSB: Which File Type Is the Best for You?
Posted in Budget

How to Make a Budget in Excel Using Premade Templates

Let’s face it: The COVID-19 pandemic has turned into a financial nightmare for many of us. With many people losing jobs and others taking a…

Continue Reading... How to Make a Budget in Excel Using Premade Templates
Posted in Excel 2021

How To Add Best Fit Line/Curve And Formula In Excel?

For example, you have been researching in the relationship between product units and total cost, and after many experiments you get some data. Therefore, the…

Continue Reading... How To Add Best Fit Line/Curve And Formula In Excel?