In this tutorial, you'll learn how to use Find and Replace to quickly find hyperlinks in Excel. You can find all the hyperlinks or the ones that contain a specific text.| Trump Excel
If you want to find external links (references) in Excel, use the steps shown in this tutorials. You can use Find and Replace or Edit Links option.| Trump Excel
In this tutorial, learn how to use Excel COUNTIF function. COUNTIF function counts the number of cells within a range that meets the given criteria| Trump Excel
In this tutorial, you will learn how to show formulas in Excel instead of the calculated values. You can use the keyboard shortcut Control + `| Trump Excel
In this tutorial, you will learn how to COPY and PASTE formulas in Excel without changing the cell references. Learn how to copy exact formulas.| Trump Excel
In this tutorial, learn how to use Excel OR Function. OR function returns TRUE if any one of the arguments is TRUE and FALSE if all the arguments are FALSE| Trump Excel
In this tutorial, learn how to use Excel DATE function. DATE function returns the serial number of a particular date using the year, month and day values| Trump Excel
In this tutorial, I'll show you 3 ways to quickly select visible cells in Excel - using a keyboard shortcut, 'Go To Special' dialog box, and a QAT command.| 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
In this tutorial, you will learn how to use Excel TRIM function to remove extra spaces in Excel. It is one of the best ways to clean data in Excel.| Trump Excel
VLOOKUP is the most popular Excel function. Here are 10 VLOOKUP Examples that will make you a VLOOKUP pro + a FREE VLOOKUP Ebook| Trump Excel
In this tutorial, learn how to use Excel MATCH Function. MATCH function looks for a value or string in a list and returns its position in that list| Trump Excel
In this tutorial, learn how to use Excel IF function. If Function is best suited when you want to test a condition and return a result based on it| Trump Excel
Learn how to split cells in Excel (split a cell into multiple columns) using Text to Column, text functions or Flash Fill| Trump Excel
In this tutorial, you will how to quickly find and highlight blank cells in Excel. You can do this using conditional formatting, Go to Special, or VBA.| Trump Excel
Learn how to spit multiple lines in a single cell into different cells using Text to Columns functionality. You need to use Control J to specify line break.| Trump Excel
In this tutorial, you'll learn how to combine cells in Excel using CONCATENATE function, ampersand sign, and custom function using VBA| Trump Excel
In this tutorial, you will learn how to lock formulas in Excel. This is a great way to make sure no one accidently changes/deletes your formulas.| Trump Excel
In this tutorial, you'll learn how to lock cells in Excel. By default all the cells are locked and you need to protect these cells to prevent changes.| Trump Excel
In this tutorial, you will learn how to quickly copy formatting using format painter in Excel. You can find it in the Home tab in the clipboard group.| Trump Excel
In this tutorial, you'll learn various ways to run a macro in Excel. You can assign it to a button or shape, run the macro code directly from the VB Editor, or use a VBA Event to do it.| 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
In this tutorial, you'll learn how to remove gridlines in Excel. You'll also learn how to change the default color and print these gridlines in Excel.| Trump Excel
Learn how to insert & use a radio button in Excel (also called the Option button). It covers how to insert, use, group, and format radio buttons.| Trump Excel
In this tutorial, you will learn how to remove spaces in Excel. Trim function can remove leading and trailing spaces in text, double spaces.| 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
In this tutorial, you'll learn how to embed a PDF file in an Excel Worksheet. Once you embed the file, you can filter/sort it with the cells.| Trump Excel
In this tutorial, you'll learn how to print comments in Excel. By default, comments are not printed. You can Print comments as displayed or at the end| Trump Excel
In this tutorial, you'll learn how to Set the Print Area in Excel Worksheets. Print Areas could be helpful if you want to print only a part of a report| 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