Excel VBA InStr function can be used to find the position of the first occurrence of a substring within a string. For example, the position of x in Excel.| Trump Excel
I'm a huge fan of using shortcuts in Excel to speed up my work| 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
In this tutorial, I'll show you two ways to quickly select 500 cells/rows at one go in Excel. You can use the Name box or VBA to do this.| Trump Excel
Want to delete every other row in Excel? In this tutorial, I'll show you a couple of ways to delete alternate rows/columns in Excel (using formula/VBA/sort)| 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
Learn how to remove duplicate rows based on one column in Excel using three easy methods: 'Remove Duplicates' feature, VBA code, and filters with the COUNTIF function.| Spreadsheet Planet
Most of my time working in Excel is spent cleaning data that I get from different sources.| Trump Excel
Learn how to quickly remove line breaks in Excel with a few simple techniques (using Find and Replace, a formula method, and VBA)| Trump Excel
Here is a simple VBA code that can be handy when you have to combine multiple Excel files into one single Excel workbook...| Trump Excel
Learn some simple ways to insert new columns in Excel (by using a keyboard shortcut and VBA). It also covers how to insert adjacent and non-adjacent columns| 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 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
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
New to Excel VBA? Here is a detailed article on all you need to know about the Visual Basic editor (also called the VB Editor).| Trump Excel
Get your hands on some useful Excel macro examples that you can instantly use to save time. Even if you're a VBA novice, you can easily use these codes.| Trump Excel
In case you're prepping up for your next job interview and have listed Excel on your resume, here are 100+ Excel interview questions to make you ready.| Trump Excel
With VBA in Excel, you can easily open one or more Excel files by specifying their location.| Trump Excel
Learn how to Print Multiple Sheets in Excel. You can print all the sheets at one go or you can select multple sheets and then print only those| Trump Excel