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
In this tutorial, you will learn various ways to convert formulas to values in Excel. A good technique to know when you work with volatile/dynamic formulas.| Trump Excel
There are a lot of option to sort data in Excel. In this in-depth tutorial, I will show you all these option to sort in Excel (by date, text, number, color)| Trump Excel
Find and Replace in Excel helped me impress my boss and made me an Excel Whiz in office. Here are 4 tips that can do the same for you| Trump Excel
In this tutorial, learn how to find and remove duplicates in Excel. This can be done easily using conditional formatting to highlight values that repeat| Trump Excel
In this tutorial, learn how the concatenate formula works and how you can quickly concatenate excel range (with or without separators)| 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
Excel Table is an amazing feature to handle tabular data. Excel Table feature makes it super easy to manage data and refer to it in calculations.| Trump Excel
Learn how to create amazing Excel dashboards. It covers the best dashboard practices, useful tools, and do's & don'ts (with Examples & Templates)| Trump Excel
Excel Paste Special options allow you to quickly copy and paste data in Excel. It allows you to copy data, formatting, formulas, etc.| 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
A line break in Excel can be used to end the current line and start a new line in the same cell. Here is a trick to insert Line Breaks in Excel Formulas| Trump Excel
Apart from being an amazing data analysis tool, Excel is the most used tool for entering and storing data. Here are 10 Excel Data Entry Tips you must know.| Trump Excel
In this tutorial, you'll learn how to create a pivot table in Excel. You can easily create a pivot table using a few clicks from the ribbon.| 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
Excel Keyboard Shortcuts can help you shorten your workday and save a lot of time. It also has an enchanting effect on your co-workers and boss.| 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
In this tutorial, you'll learn how to create and use named ranges in Excel. A named range makes it really easy to refer to cell(s) in formulas in Excel| Trump Excel
In this tutorial, you'll learn how to Insert page numbers in Excel Worksheets. These are visible in the Page Layout view and on printed sheets| 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'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, you will learn how to remove spaces in Excel. Trim function can remove leading and trailing spaces in text, double spaces.| Trump Excel
With VBA in Excel, you can easily open one or more Excel files by specifying their location.| 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 article, I wanted to create an overall structure that any Excel user can follow to enhance their basic, intermediate, or advanced Excel skills.| Trump Excel
We all know how important it is to be able to see the data in our spreadsheets clearly.| Trump Excel
In this tutorial, you'll learn how to wrap text in Excel. There are different methods to wrap the text in cells - keyboard shortcut, ribbon option, etc.| Trump Excel
In this tutorial, learn how to merge cells in excel using excel Concatenate function. Instead of using merge and center option, use this technique| Trump Excel
In this tutorial, you'll learn how to find merged cells in Excel. Using the Find and Replace feature, you can easily find/remove/highlight merged cells.| Trump Excel
In this tutorial, you'll learn about Excel Freeze Panes options. It makes the rows/columns headers visible all the time while working with large data sets| 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
Excel Keyboard Shortcuts - A collection of 200+ Excel Keyboard Shortcuts that will make you super fast in Excel. Download Free PDF| Trump Excel
In this tutorial, you will learn 10 tips to speed-up slow excel spreadsheets. Excel spreadsheets tend become heavy and slow as you load it with data.| Trump Excel
Excel file getting too large and heavy? Here are 7 tips that will help you reduce Excel file size and make it easy to share.| 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
In this tutorial, you'll learn how to create and use and Excel Add-in in all the Excel Workbooks. An add-in can be useful when you have to repeat tasks.| Trump Excel