Excel

One of the major annoyances when working in Excel is having dates, fractions, or other values automatically re-format. It can cause the data to look confusing to just plain wrong. We’ll explain a number of different methods that you can bring data into Excel without it converting dates to numbers or creating other issues. Excel […]

Merging cells together in Excel is a method to make one large cell out of two or more smaller ones. It’s a common way to give spreadsheets headers, titles, and present large amounts of text without having it get cutoff or wrap inside of a single cell. We’ll explain what merged cells are, how to

There are a number of issues that can arise with how Microsoft Excel displays spreadsheets and the Power Query Editor on high resolution monitors. We’ll show you how to quickly fix these problems when they arise. Other issues can occur when launching Power Query for Excel where buttons don’t align and some of the items

Microsoft Excel has been the backbone of accounting, financial analysis, data analysis and many other careers for nearly 30 years. We’ll explain why Excel is still relevant and is worth investing time into learning even as the world moves towards bigger datasets and more advanced data management solutions. Microsoft Excel was first introduced on September

XLOOKUP is one of the most anticipated and useful updates to Excel in years. It fixes many of the challenges that Excel professionals have found when using the more traditional VLOOKUP formula. We’ll explain what these changes are, how to use the formula, and why people are so excited. The Excel XLOOKUP formula is utilized

The ability to add dynamic subtotals and totals into an Excel worksheet is a massive time saver. It’s particularly useful for finance and accounting use cases but fundamental to much of the analysis performed in spreadsheets. Fortunately, Excel provides several different methods to create them. We’ll explain the different ways to create totals and subtotals

Power Query Merge and Append are two functions in Power Query used to combine multiple tables or files together. However, they serve two very different purposes. We’ll explain the difference and show what it looks like when datasets are merged or appended. Deciding whether to merge or append will largely depend on your dataset and

Power Query gives users a number of ways to skip rows and promote headers, from skipping a set number of rows to more dynamic solutions for times when header data isn’t as consistent as you would like it to be. The combination of skipping rows at the top of a document and promoting the remaining

Understanding how Pivot and Unpivot work in Power Query can be super useful. Pivot will convert rows to columns while Unpivot converts columns to rows. We recognize that it’s not exactly intuitive but we’ll provide examples of what each one does to help make it easier to understand. Pivot and Unpivot are two very common

Combining Columns in Power Query can be done a number of ways. You can use the Merge Columns feature, formulas to concatenate, and you can combine columns using the column from example feature that uses AI to generate Power Query formulas on your behalf. If you’ve concatenated columns in Excel, the formula method may be