Tutorials Archives | How To Excel

Sending SMS Text Messages From Excel

by John | Nov 16, 2018 | Microsoft Flow, Tutorials | 4 |

In this post we are going to learn how to send SMS text messages from Excel… because why...

Importing and Exporting Data from SharePoint and Excel

by John | Oct 2, 2018 | Tutorials | 2 |

Learn how to import and export data from SharePoint and Excel using built in export features or using power query.

4 Ways to Remove Unwanted Space Characters

by John | Sep 27, 2018 | Functions, Power Query, Tutorials, VBA | 2 |

Learn how to remove unwanted space characters from text data in Excel using various methods.

Sending Emails from Excel with Microsoft Flow

by John | Aug 9, 2018 | General, Microsoft Flow, Tutorials | 5 |

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.

5 Ways to Concatenate Data with a Line Break in Excel

by John | Jul 23, 2018 | General, Tutorials | 0 |

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.

7 Ways to Add Running Totals in Excel

by John | Jul 6, 2018 | General, Tutorials | 1 |

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.

Everything You Need to Know About Excel Tables

by John | Mar 18, 2018 | Tutorials | 1 |

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.