I love using Conditional Formatting in Excel. It allows me to quickly highlight and format cells based on specified conditions.| Trump Excel
Remove asterisk (*) symbol In Excel is a little tricky as it's a wildcard character and you cannot just use fine and replace to remove an ace risk symbol.| Trump Excel
Removing duplicates is a common task for most data workers.| Trump Excel
In this short tutorial, I'm going to show you three straightforward ways you can use to quickly highlight cells with formulas in Excel.| Trump Excel
Many times, I have a need to select every other row in Excel so that I can highlight or delete them.| Trump Excel
Most of the time, when working with Excel, you need to restructure your data before you can start any kind of analysis.| Trump Excel
In this tutorial, you'll learn how to refresh pivot table in Excel. You can either refresh the data, change the data source, or use a macro to do this.| Trump Excel
In this video, learn some quick and easy ways to remove the first character from a text string in cells in Excel (using formulas, Text to Columns, & VBA)| Trump Excel
Most of my time working in Excel is spent cleaning data that I get from different sources.| Trump Excel
In this tutorial, I will show you some really simple ways to insert a blank row after every row in the existing dataset (or every nth row).| Trump Excel
Want to delete rows based on a cell value or a condition? In this tutorial, I cover multiple ways to do this - including filters, sorting, and VBA| Trump Excel
https://www.youtube.com/watch?v=4dW7XymP0IM| Trump Excel
Sometimes, when you're organizing data, creating charts, or analyzing information, you may need to swap two cells (i.e., change the position of two cells).| Trump Excel
Want to unhide all sheets in Excel in one go? While there is no in-built way to do this, in this article I will show you some ways to unhide sheets at once| Trump Excel
Want to learn Excel VBA? You're at the right place. Here you'll find a collection of useful VBA tips and tutorials that will help you understand the concepts and VBA and how to use these to automate your work in Excel.| Trump Excel
In this tutorial, you'll learn how to unhide columns in Excel. You can use the keyboard shortcut, options on the ribbons or change the column width.| Trump Excel
Learn how to easily insert and/or delete comments in Excel. It covers how to insert, navigate, copy and delete comments/notes in Excel| Trump Excel
Have you used immediate window in Excel VBA? It's a great tool and cab be used to do things quickly. Here are five awesome ways to use it in Excel| Trump Excel
In this tutorial, you'll learn how to get the Excel developer tab in the Ribbon. By default, it is not visible in the ribbon and needs to be enabled.| Trump Excel
In this tutorial, I will show you how to automatically open specific Excel files when Excel starts. You can open a specific file or all files in a folder| Trump Excel
Filling a background color in a cell or range of cells is a common task that most of Excel users have to do on a daily basis.| Trump Excel
Page orientation can be important when planning to print your work in Excel.| Trump Excel
In this tutorial, I cover all the possible ways you have to recover unsaved Excel FIles, as well as some precautions you can take to avoid losing your work| Trump Excel