General Archives | How To Excel

7 Ways To Find And Remove Duplicate Values In Microsoft Excel

by John | Jul 13, 2019 | General, Tutorials | 0 |

In this tutorial we are going to look at 7 easy methods to find and remove duplicate values from your data.

Everything You Need To Know About Flash Fill In Microsoft Excel [15 Examples]

by John | Jun 24, 2019 | General, Tutorials | 4 |

In this post you’re going to learn everything you need to know about Flash Fill in Microsoft...

An Introduction to Microsoft Forms for Excel

by John | Jun 10, 2019 | General | 2 |

Learn how to use Microsoft Forms to quickly and easily create surveys, quizzes and polls.

The Complete Guide to Rich Data Types in Excel

by John | May 9, 2019 | General, Tutorials | 0 |

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.

Sending Emails from Excel with Microsoft Flow

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

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.