Category: Tutorials
Sending Emails from Excel with Microsoft Flow
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
5 Ways to Concatenate Data with a Line Break in Excel
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
7 Ways to Add Running Totals in Excel
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
Everything You Need to Know About Excel Tables
Learn everything there is to know about Excel Tables. This post will tell you about all the awesome features Excel Tables have and why you should start using them.
Read More
How To Build Your Pivot Tables
What questions do we want to answer about our data? Let’s create pivot tables to answer...
Read More
How To Create A Pivot Table
In this tutorial, we’ll take you through the steps to create a new Pivot Table. It’s...
Read More
