Tutorials Archives | How To Excel

5 Easy Ways To Create A Data Entry Form In Excel

by John | Dec 24, 2019 | Tutorials | 0 |

Data entry can sometimes be a big part of using Excel. With near endless cells, it can be hard for...

9 Ways to Delete Blank Rows in Excel

by John | Dec 20, 2019 | Tutorials | 0 |

Blank rows of data can be a big annoyance. They’ll make certain things like navigating...

7 Ways To Get The Weekday Name From A Date In Excel

by John | Nov 13, 2019 | Tutorials | 3 |

In this post we’re going to take a look at 5 ways to find the weekday name from a date in Excel.

The Complete Guide To Slicers And Timelines In Microsoft Excel

by John | Aug 12, 2019 | Pivot Tables, Tutorials | 0 |

Do you want to make impressive looking and functioning Excel workbooks without too much effort? Of...

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.

The Complete Guide To Microsoft PowerApps

by John | Jul 5, 2019 | PowerApps, Tutorials | 2 |

Learn about the Microsoft PowerApps drag and drop formula based app building platform. Quickly build useful business apps using the intuitive PowerApps visual builder that doesn’t require traditional coding.

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...

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.