How to Delete Sheets in Excel (Shortcuts)
When working with Excel, you spend most of your time on the worksheet (which is the area that has all the cells and everything that happens there).| Trump Excel
When working with Excel, you spend most of your time on the worksheet (which is the area that has all the cells and everything that happens there).| Trump Excel
Here are two really simple ways to stop Excel from changing numbers to dates automatically. You can simply change the format of the cell or use apostrophe| Trump Excel
Learn five easy ways to insert the Pi symbol (π) in Excel (using keyboard shortcut, Symbol dialog box, formula, auto-correct trick, and copy paste)| Trump Excel
In this tutorial, you'll learn how to insert a cent symbol in Excel. You can use a keyboard shortcut, the CHAR Function, or the autocorrect feature.| Trump Excel
If you work with data related to engineering, manufacturing, or designing, you may have a need to use the diameter symbol in Excel.| Trump Excel
Excel autocorrect allows you to automatically correct mispelled words. You can also use this feature to insert symbols quickly or to write formulas faster.| Trump Excel
I love using Conditional Formatting in Excel. It allows me to quickly highlight and format cells based on specified conditions.| Trump Excel
Want to add a trendline in a chart in Excel? Learn all about different types of trendlines and how to work with it in Excel| Trump Excel
Strikethrough in Excel can be applied by a simple shortcut. Here you will learn 3 ways to access strikethrough in excel and 3 examples where it can be used.| Trump Excel
Excel is a great tool when it comes to data manipulation. There are many functionalities and functions in Excel that allow you to modify your data to get the| Trump Excel
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
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
In this tutorial, I will show you five simple ways to sum a column in Excel. You can use the autosum shortcut, use a formula, or convert data to Table.| Trump Excel
I'm a huge fan of using shortcuts in Excel to speed up my work| Trump Excel
Most of the time, the data in Excel is arranged in columns, and it is more common to split the text in a cell into multiple columns rather than rows.| Trump Excel
It's easy to extract usernames from Email Ids in excel. You can either you a formula and make it dynamic, or use Text to Column and do it quickly| 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
In this tutorial, learn how to use formulas to get unique items from a list in Excel. A combination of INDEX, MATCH and COUNTIF can easily do this.| Trump Excel
Removing duplicates is a common task for most data workers.| Trump Excel
Dealing with duplicates is a regular task for people working with data in Excel.| 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
Excel is an amazing tool to store and analyze data. And many of the times, you will have to deal with text data types such as names, regions, departments, or| Trump Excel
As a part of my full-time job a few years ago, one of the things I had to deal with was to combine data from different workbooks shared by other people.| Trump Excel
Sometimes you may have dates in one column and time values in another column and you want to combine these to get one single date and time value in a cell.| Trump Excel
Power Query can be of great help when you want to combine data from multiple workbooks into one single worksheet. Here is a step-by-step guide on how to do this in Excel. You can combine data when it's stored in an Excel table, or even when it's not formatted as a table.| 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 short tutorial, I'm going to show you three straightforward ways you can use to quickly highlight cells with formulas in Excel.| 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
It's not uncommon for many people to protect worksheets in their Excel files and then forget the password.| Trump Excel
Do you know you can track changes in Excel - just like MS Word. Learn how to enable and use this option while collaborating with others.| 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
Learn how to create an Excel drop down that shows suggestions as you type. A step-by-step tutorial to create an Excel Drop Down List with Search Suggestions| 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
A standard deviation value tells you how much the dataset deviates from the mean value. Learn to calculate standard deviation in Excel.| Trump Excel
You can easily merge tables in Excel using Power Query (aka Get & Transform). In this tutorial, I will show you how to merge two or more tables in Excel| 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
Selecting a cell is one of the most basic things users do 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
Among the many awesome features in Excel, Name Box doesn't get talked about enough.| Trump Excel
Learn how to quickly deselect cells in Excel (specific cells or columns). This functionality is only available in Office 365| Trump Excel
While Excel is an amazing tool for data analysis, many people use it for basic arithmetic calculations such as addition, subtraction, multiplication, and| Trump Excel
Once you're done using formulas to get the desired results, you may want to remove the formulas and keep the data you got as a result of these formulas.| Trump Excel
In this tutorial, learn how to Multiply in Excel Using Paste Special option. It comes in handy when you want to quickly multiply without using formulas.| Trump Excel
If you must learn something new today, learn these 5 Excel formatting shortcuts. These would save you a lot if time every day.| Trump Excel
In this tutorial, you'll learn the techniques to transpose data in Excel. You can use the Paste Special option, Transpose Function or a Custom Macro.| Trump Excel
In this tutorial, you'll learn how to calculate and format percentages in Excel. You easily apply the percenatage format using the ribbon or the dialog box| Trump Excel
Search and Highlight Data in Excel with Conditional Formatting - highlight matching cells, rows, and even make it dynamic (highlight as you type).| Trump Excel
Copying and Pasting a cell or a range of cells is one of the most common tasks users do in Excel.| Trump Excel
Conditional Formatting allows you to add a visual layer to your dataset and make it easier to understand.| Trump Excel
Conditional formatting allows you to apply a format to a cell based on the value in it. in most cases, you will apply conditional formatting to the same cell| Trump Excel
Conditional formatting in Excel allows you to format cells based on the values in the cells.| Trump Excel
In this blog post, learn 2 ways to quickly select a Far-off Excel Cell or Range - Using Watch Window and using Excel temporary memory| Trump Excel
Sometimes you may have the need to highlight the active row and column in a data set. Learn how to do this easily in Excel.| Trump Excel
Learn how to number rows in Excel in a few easy steps. In this tutorial, I'll show you 7 methods to insert rows numbers (aka serial numbers) in a dataset.| 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 tutorial, I will show you ways to hide zero values in Excel and one method to select and remove all the zero values from the dataset.| Trump Excel
Deleting a row or deleting multiple rows is a regular part of most Excel users.| Trump Excel
When I was working as a data analyst years ago, part of my job was to download data from financial databases and then clean this data.| Trump Excel
If you want to count filtered rows in Excel, you can do that using the SUBTOTAL function.| Trump Excel
Want to quickly remove comma from cells in Excel? Here are some really simple (& quick) methods to remove comma from numbers and text strings in Excel| Trump Excel
Cells are the building blocks of a worksheet in Excel.| Trump Excel
Want to insert the delta symbol in Excel? In this tutorial, I cover the best and easiest ways to insert delta symbol in Excel| Trump Excel
In this Excel tutorial, i will show you how to select non-adjacent cells in Excel using simple methods such as using the mouse, keyboard, name box, etc.| Trump Excel
When you're working with the data set that has hidden rows, and you select and copy the cells in this dataset, it is going to copy the visible cells as well| 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 one of my previous articles, I discussed how to unprotect worksheets in Excel, and many people asked me how they can do the same when they have an Excel| Trump Excel
In statistical analysis and scientific reporting, the X-bar symbol (X̅) is frequently used to represent the mean (average) of a sample.| Trump Excel
Excel chart data labels are quite boring. While there is not much you can do with these, a bit of excel trickery can add some glamour to it.| Trump Excel
While Excel is predominantly used as a data storage and data analysis tool, it also supports inserting and using symbols.| Trump Excel
In this tutorial, you'll learn how to insert and use slicers in Excel. It also covers slicers formatting and other useful features.| Trump Excel
In this tutorial, you'll learn how to replace blank cells with zeroes in Excel Pivot Tables. This can easily be done using Pivot Table Options.| 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
Pivot tables are used by hundreds of thousands of people every day to analyze and summarize large amounts of data.| Trump Excel
Pivot Cache is snapshot (a non-visible copy) of the pivot table data that is used to create the pivot table. Here are somethings you need to know about it| Trump Excel
In this tutorial, you'll learn how to group numbers in Pivot Table in Excel. Grouping numbers is helpful when you want to create frequency distribution| Trump Excel
In this tutorial, you'll learn how to group dates in Pivot Tables in Excel. The dates can be grouped by years, months, weeks or days.| Trump Excel
In this tutorial, you'll learn how to filter data in a Pivot Table in Excel. You can filter data based on value, label, or using the search box.| Trump Excel
Excel Pivot Table Calculated Field can easily be added to make calculations in a Pivot Table. Use this Step by Step guide to add and use a Calculated Field.| Trump Excel
Applying Conditional Formatting to a Pivot Table in Excel can be a bit tricky. Learn how to make sure it is applied on the correct range & adjusts with data| Trump Excel
Learn how to use different ways to slice and dice text data (separate first and last name in Excel). It uses formulas, FLash Fill, Text to Columns, & more..| Trump Excel
Learn a couple of ways to remove the time from date in Excel. You can use a formula or Find and Repalce to Text to Columns to remove time from timestamp| 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
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
It's time to put the age old debate to an end. Is VLOOKUP the best lookup and reference formula in Excel? Or does INDEX-MATCH combo has an upper edge?| Trump Excel
INDEX MATCH is a powerful combination that allows you to do simple and advanced lookups in Excel. In this article, I'll show you 10 examples of using this.| 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
Conditional formatting in Excel highlights cells that meet a specified condition. Here is a guide on using conditional formatting in Excel.| Trump Excel
Use the steps in this tutorial to highlight every other row in Excel using conditional formatting. You can extend this to highlight every nth row/column.| Trump Excel
Learn all about the new Excel XLOOKUP Function. It's way better than VLOOKUP or INDEX/MATCH. Here you will find 10 XLOOKUP examples + download file| Trump Excel
One area that often troubles Microsoft Excel users is working with dates.| Trump Excel
Working with a large Excel workbook that has multiple sheets could be challenging. Even advanced Excel users feel overwhelmed when trying to switch between| Trump Excel
In this Excel tutorial, I will show you how to remove formatting from cells in Excel. You can clear formatting from all cells, blanks, or specific cells.| Trump Excel
Excel has some really useful features that can help you be a lot more efficient in your day-to-day work.| Trump Excel
Learn how to insert the degree symbol in Excel in seconds. This tutorials shows 4 easy methods of doing this - shortcut, formula, symbol, and autocorrect!| Trump Excel
Learn how to quickly remove table formatting in Excel. You can remove the formatting from an existing table to convert the table to range.| Trump Excel
Most of my time working in Excel is spent cleaning data that I get from different sources.| Trump Excel
