Learn all about rich data types in Excel and how to use them to get more from your data such as current financial data, currency rates, cryptocurrency values and geographical data with just a couple clicks.
Read More
Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.
Read More
In this post we are going to learn how to send SMS text messages from Excel… because why...
Read More
Learn how to import and export data from SharePoint and Excel using built in export features or using power query.
Read More
Learn how to remove unwanted space characters from text data in Excel using various methods.
Read More
Learn how to build an automated process that schedules and sends emails from Outlook based on the data in an Excel file using Microsoft Flow.
Read More
Learn 5 ways to concatenate the data and separate each item with line breaks. Combine many different cells into one but keep each on its own line in the cell.
Read More
In this post we’ll cover multiple ways to calculate a running total in Microsoft Excel. We’ll explore how to use worksheet formulas, pivot tables, power pivot with DAX and power query for running totals. We’ll also explore what happens to the running total calculation when inserting or deleting rows of data and how to update the results.
Read More
