Home
Videos uploaded by user “Trump Excel”
How to Lock Cells with Formulas in Excel
 
04:51
Read More: https://trumpexcel.com/lock-formulas-excel/ Excel formulas are easy to create and edit in Excel. You can easily edit a formula in a cell through the formula bar or directly in the cell. While this makes it convenient to create formulas in Excel, it comes with a few disadvantages as well. Consider this. You are going through a worksheet full of formulas and you accidently hit the delete key, or backspace key, or some other number/alphabet key. Now you’ll be lucky if you’re able to spot the error and correct it. But if you don’t. it may lead to some erroneous results. And let me tell you this, errors in Excel have cost millions to companies (read this or this). The chances of such errors increase multifold when you share a file with colleagues or managers or clients. One of the ways to prevent this to lock the worksheet and all the cells. However, doing this would prevent the user from making any changes to the worksheet. For example, if you’re sending a workbook to your manager for review, you may want to allow him to add his comments or color code cells as his feedback. A better workaround to this is to lock formulas in Excel. In this video, you will learn how to lock cells that have formulas in it. -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 113686 Trump Excel
Picture Lookup in Excel (Step-by-Step Tutorial)
 
06:51
In this video, you will learn how to lookup a picture in Excel. I take an example of the football clubs from English Premier League to show you how the logo appears when you select the club's name from a drop down. Step-by-step written tutorial and download file: http://www.trumpexcel.com/downloads/Picture%20Lookup%20in%20Excel.xls -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 124839 Trump Excel
Create Dynamic Excel Filter - Extract data as you type
 
12:25
In this video tutorial, learn how to create a dynamic Excel filter. This dynamic Excel filter allows you to type the filter text in a text box and instantly extracts the records as you type in the search bar. This Dynamic Excel filter can be created in 3 steps: -- Getting a unique list of items (countries in this case). This would be used in creating the drop down list. -- Creating the search box. Here I have used a Combo Box (ActiveX Control). -- Setting the Data. Here I would use three helper columns with formulas to extract the matching data. You can use this dynamic Excel filter when you have a huge dataset and you want to quickly filter it by entering the text. Since this is dynamic, you can remove the existing filter by simply deleting the text in the text box and type something else to filter based on it. Step-by-step written tutorial and download file: https://trumpexcel.com/dynamic-excel-filter/ You May Also Like the following Tutorials: -- Creating a drop down list in Excel: https://www.youtube.com/watch?v=uREmXWvSuo4 -- Advanced Filter in Excel: https://www.youtube.com/watch?v=ZUFEqjDLM2I -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 289413 Trump Excel
How to Create a Dependent Drop-Down List in Excel
 
05:25
Drop-down lists are very common in the web world and you can also create it easily in Excel. In this video, I will show you how to create a dependent drop-down list in Excel (also known as a conditional drop-down list). What is a Dependent Drop-down List in Excel? While a drop down list allows you select an item from a list, a dependent drop-down list allows you to change the items in a drop down based on what you have already selected. For example, if you have a drop down list that shows products in the company, then selecting any one of the products would enable the dependent drop down to show the version of the selected product only. This means that when you select an item from a drop-down list, another list which is dependent on the first one automatically gets updated. Here is another simple example. You have two drop down lists with the first one showing countries and the second one showing states. You select the US, and all the states in the US appear in the adjacent drop down. And when you select India, all the states in India appear. A step-by-step tutorial and download file: https://trumpexcel.com/dependent-drop-down-list-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel Dependent Drop-down List in Excel | Conditional Drop Down List in Excel | Dependent Drop Down List
Views: 49836 Trump Excel
Extract Data based on a drop down list selection in Excel
 
11:20
In this video tutorial, learn how to extract or filter data in Excel based on a drop down selection. This Excel trick is extremely useful in situations where you have a huge dataset and you want to extract part of it by making a selection. For example, suppose you have the sales transaction records or various products. You can use this technique to select the product item from the drop down list and all the records for that item would get extracted and listed separately. Since this is dynamic, you can change the selection from the drop down, and the results would update. There are three steps in extracting data based on a drop down selection: -- Create a Unique list of items. -- Add a drop down to display these unique items. -- Use helper columns to extract the records for the selected item. It also uses Excel formulas (INDEX, MATCH, ROWS, SMALL) to extract the data based on the drop down selection. It can work for extracting the data on the same or different worksheet in Excel Step-by-step written tutorial and download file: https://trumpexcel.com/extract-data-from-drop-down-list/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 304364 Trump Excel
How to Insert a Watermark in Excel Worksheets
 
04:00
In many situations, you may want to insert watermark in Excel (such as your company’s logo or an image) before sharing it with others. In case you are sharing a WIP (work-in-progress) version of the report, you may want to place a WIP/Draft as the watermark in it. While Excel does not have a dedicated feature to insert watermark in Excel, it can be easily achieved by using the Header & Footer sections in Excel. In this tutorial on inserting watermark in Excel, I will show you: -- How to Insert Watermark in Excel Worksheets? -- How to Reposition the Watermark in Excel? -- How to Resize the Watermark in Excel? -- How to Delete the Watermark in Excel? Read more about it here: https://trumpexcel.com/insert-watermark-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel Insert Watermark in Excel | Excel Watermark | Add watermark in Excel | Delete Watermark in Excel | Headers and Footers in Excel
Views: 33607 Trump Excel
10 Super Neat Ways to Clean Data in Excel
 
18:47
Learn how to clean data in Excel using different ways and techniques. Data forms the backbone of any analysis that you do in Excel. And when it comes to data, there are tons of things that can go wrong – be it the structure, placement, formatting, extra spaces, and so on. Excel can be an amazing tool for data analysis. But we hardly get the data that can be used right away. And a bad data leads to bad analysis. In this video, I will show you 10 simple ways to clean data in Excel. The following topics are covered in this video: -- Get Rid of Extra Spaces -- Select and Treat All Blank Cells -- Convert Numbers Stored as Text into Numbers -- Remove Duplicates -- Highlight Errors -- Change Text to Lower/Upper/Proper Case -- Spell Check -- Delete all Formatting -- Use Find and Replace to Clean Data in Excel Read the full tutorial here: https://trumpexcel.com/clean-data-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 241956 Trump Excel
How to Group Numbers in a Pivot Table in Excel
 
02:50
You can group numbers in Pivot Table to create frequency distribution tables. This helps in analyzing numerical values by grouping it into ranges. A simple example of this could be to analyze how many students scored marks between 40 and 50 and how many got marks between 50 and 60 and so on.. Another example could be to create a frequency distribution of age of a group of people. This would help in identifying how many people fall in the 30-40 age group and how many in 40-50 age group and so on.. In this video, I take an example of retail sales data to see how you can group numbers in Pivot Table in Excel. Read More: https://trumpexcel.com/group-numbers-in-pivot-table/ Click the link below to Subscribe to the Channel: https://www.youtube.com/subscription_center?add_user=trumpexcel -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 10871 Trump Excel
How to Embed a PDF Document in Excel
 
04:33
Sometimes you may have a need to embed a PDF file within the Excel workbook. This could be the case when you are creating a catalog and want to embed product specific PDFs. When you embed a PDF file in Excel, it is inserted as an object that sits above the worksheet cells. The position of the icon would not change if you change the cells below it. In this video, you'll learn: -- How to embed a PDF document in Excel. -- How to fix the document in a cell -- How to rename the document Here are the steps to embed a PDF File in Excel: -- Go to Insert tab and click on the Object icon in the Text group. This will open the Object dialog box. -- In the Object dialog box, select the ‘Create New’ tab and the select ‘Adobe Acrobat Document’ from the list. Note that you need to have Adobe Reader installed on your system for Adobe object to appear in the list. -- Check the option – ‘Display as icon’. -- Click OK. -- Select the PDF file that you want to embed and click on Open. These steps would insert a PDF file in the worksheet. Read More: https://trumpexcel.com/embed-pdf-file-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel Embed PDF in Excel | Embedding PDF in Excel | Embed PDF document in Excel Worksheet | Insert PDF in Excel
Views: 111705 Trump Excel
How to Select Multiple Items From an Excel Drop Down List
 
07:04
Get the VBA code from here: https://trumpexcel.com/select-multiple-items-drop-down-list-excel/ An Excel drop-down list allows you to make one selection at a time. You can not select multiple items from the same drop down list in Excel. However, you can use VBA to make this happen. In this video, I will show you how to use VBA code to select multiple items from a drop down list in Excel. The video will show you how to select multiple items with and without repetition. In addition, it will also show you how to modify the code to make the drop down work in different cells/rows/columns. -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 103525 Trump Excel
Using Excel VLOOKUP Function with Multiple Criteria
 
08:12
In this video, you'll learn how to use VLOOKUP function with Multiple criteria. Excel VLOOKUP function, in its basic form, can look for one lookup value and return the corresponding value from the specified row. But often there is a need to use VLOOKUP with multiple criteria. This video shows two techniques to use the VLOOKUP function with Multiple Criteria - Using helper columns and using the CHOOSE Function. Read More + Download File: https://trumpexcel.com/vlookup-with-multiple-criteria/ Related Video (Using VLOOKUP function in Excel): https://www.youtube.com/watch?v=zGz6QuEaOo0 Click the link below to Subscribe to the Channel: https://www.youtube.com/subscription_center?add_user=trumpexcel -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 132489 Trump Excel
Lookup and Find the 2nd, 3rd, or the Nth Matching Value in Excel
 
12:20
When it comes to looking up data in Excel, there are two amazing functions that I often use – VLOOKUP and INDEX (often in conjunction with the MATCH function). However, these formulas are designed to find the first instance of the lookup value. But what if you want to lookup the second, third, fourth or the Nth matching value. Well, it's doable with a little bit extra work. In this tutorial, I will show you various ways (with examples) on how to look up the second or Nth value in Excel. -- Using Helper Column -- Using Array Formula Using helper column, you can create a unique lookup value. This can be done by appending the number of occurrence of a value in a list. In this video, I explain using the employees and training done by them. You will learn how to find the first, second, or third training done by an employee using formulas (VLOOKUP and INDEX). You can read more about it here + Example file: https://trumpexcel.com/lookup-second-value/ -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel: ► https://www.youtube.com/c/trumpexcel
Views: 83996 Trump Excel
How to Split Multiple Lines in a Cell into a Separate Cells/Columns
 
03:15
In Excel, you can use the Text to Columns functionality to split the content of a cell into multiple cells. You can specify the delimiter (such as a space, comma, or tab) and the Text to Columns functionality would use this delimiter to split the content of the cells. Examples of this include splitting first and last names, or username and domain name in email ids. However, if you have a dataset where the delimiter is a line break (in the same cell), it gets tricky to split these multiple lines in the same cell into separate cells/columns. In this video, I will show you how to make line break a delimiter in the Text to Columns functionality so that you can use line break to split the contents of a cell. Here are the steps: -- Select the entire dataset that you want to split. -- Go to the Data tab.Data -- In the Data Tools group, click on the Text to Columns option. -- In the Text to Columns dialog box, in Step 1 of 3, select Delimited and click ‘Next’. -- In Step 2 of 3, uncheck any existing Delimiters selection, and select the ‘Other’ option. Now Use the keyboard shortcut Control + J (hold the ‘Control’ key and then press the ‘J’ key). You will not see anything in the box except a tiny blinking dot (if you look hard). Also, you will see the expected result in the ‘Data preview’ section (as shown below). Click on Next. -- In Step 3 of 3, change the ‘Destination’ cell to the one where you want the output. -- Click on Finish. -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 34361 Trump Excel
How to Get the List of File Names in a Folder in Excel Spreadsheet
 
08:13
This Excel trick uses an old Excel Function FILES to get the list of all the file names (or specific file names) in a specific folder in Excel. It uses an old excel function FILES that does not work in worksheet, but works in named ranges. All you need is this formula with the folder address. To get the folder address, save the excel file in the same folder and use this formula - =SUBSTITUTE(CELL("filename"),RIGHT(CELL("filename"),LEN(CELL("filename"))-FIND("@",SUBSTITUTE(CELL("filename"),"\","@",LEN(CELL("filename"))-LEN(SUBSTITUTE(CELL("filename"),"\",""))),1)),"*") Here is a step-by-step written tutorial: https://trumpexcel.com/list-of-file-names-from-a-folder-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 134334 Trump Excel
Highlight Active Row and Column in Excel (Based on Cell Selection)
 
09:34
One of the Excel queries I often get is – “How to highlight the Active Row and Column in a data range?” Read more about the tutorial: https://trumpexcel.com/highlight-active-row-column-excel/ Download file: https://www.dropbox.com/s/jxcu38sm4brip8z/Highlight-the-Active-Row-and-Column.xlsm?dl=0 So I decided to crate this video and show how to do this, In this video, I will show you how to use Excel formula and conditional formatting to instanly highlight active row and column as soon as the user makes a selection or changes the selection. To make sure this is dynamic, I have used a very simple VBA code as well (the worksheet change event). Useful Notes: -- This method would not impact any formatting/highlighting you have done manually to the cells. -- Conditional formatting is volatile. If you use it on very large datasets, it may lead to a slow workbook. -- The VBA code used above would refresh the workbook every time there is a change in selection. -- CELL Function is available in Excel 2007 and above version for Windows and Excel 2011 and above for Mac. In case you’re using an older version, use this technique by Chandoo. -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 7019 Trump Excel
Filter the Smart Way – Use Advanced Filter in Excel
 
10:25
Excel Advanced Filter is one of the most underrated and under-utilized features that I have come across. If you work with Excel, I am sure you have used (or at least heard about the regular Excel filter). It quickly filters a data set based on selection, specified text, number or other such criteria. In this video, I will show you some cool stuff you can do using the Excel advanced filter. This video on Excel Advanced Filter covers how to: - To extract a list of unique items - To filter records using multiple AND criteria - such as sales rep name and geography. - To filter records using multiple OR criteria - such as sales rep is Joe OR John - To filter records using wildcard characters - filter records with sales rep name beginning with J - To use numerical conditions - filter records with sales more than 20000 You can read more about Excel Advanced Filter here: https://trumpexcel.com/excel-advanced-filter/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 99596 Trump Excel
How to Embed Youtube Video in an Excel Worksheet
 
03:43
Yes, Youtube video can be embedded in an excel workbook and can be played directly from there. All you need is a good internet connection and this video tutorial. In this video, learn how to Embed a Youtube Video in Excel Worksheet (a step-by-step tutorial). Read the tutorial and get the download file: https://trumpexcel.com/embed-youtube-video-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 9158 Trump Excel
How to Create a Scroll Bar in Excel
 
09:53
In this video tutorial, learn how to create a scroll bar in Excel. If you have a large dataset, you can use this technique to create a scroll bar and a scrollable list to show limited records. This gives the user a flexibility to scroll and go through the entire data. The Excel Scrollbar option is available in the developer tab in Form Controls. To create a scroll bar, you need to use a mix of excel formulas and to create a list that updates when you move the scroll bar. This video has a step-by-step tutorial on how to create a scrollable list in Excel Read more and Download File: https://trumpexcel.com/create-a-scroll-bar-in-excel/ You May also like the following video: -- https://www.youtube.com/watch?v=jMFsA1dcXb8 -- https://www.youtube.com/watch?v=uREmXWvSuo4 -- https://www.youtube.com/watch?v=Egn0nq7G6vs -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 88479 Trump Excel
Using Flash Fill in Excel 2013 and 2016 (6 Examples)
 
06:05
Read More: https://trumpexcel.com/flash-fill-excel/ Flash Fill is an amazing tool that was added in Excel 2013 and is available in all version after that. You can use Flash Fill in Excel to make data entry easy. It’s a smart tool that tries to identify patterns based on your data entry and does that for you. Some simple examples of using Flash Fill could be to get the first name from the full name, get name initials, format phone numbers, etc. In this video, I will show you 6 ways to use Flas Fill in Excel: -- Getting the First Name from Full Name -- Getting Initials from Name -- Combining Names -- Extracting usernames from email ids -- Formatting Phone Numbers -- Extracting State Code from Address In the end, I will also talk about the limitations of Flash Fill and when not to use it. -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 10002 Trump Excel
How to Use Solver in Excel
 
07:58
Solver in Excel can be used to to solve an equation or a business problem when there are many variables as well constraints. For example, want to find out the maximum profit, when you have the constraint of raw material and assembly line. In this video, I take a simple example to showcase the power of Solver. Read Full Tutorial and Download Example File: https://trumpexcel.com/solver-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 26442 Trump Excel
Count Cells Based on Background Color in Excel
 
10:21
In this tutorial, learn how to count cells with a background color in it. It covers 3 methods to do this: -- Using Filter and SUBTOTAL function. -- Using GET.CELL function. -- Using a Custom Function created using VBA. Read More and Download Example File: https://trumpexcel.com/count-cells-based-on-background-color-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 128446 Trump Excel
How to Lock (Protect) Cells in Excel
 
06:17
Sometimes you may want to lock cells in Excel so that other people can’t make changes to it. It could be to avoid tampering of critical data or prevent people from making changes in the formulas. Before we learn how to lock cells in Excel, you need to understand how it works on a conceptual level. All cells in Excel are locked by default. But… It doesn’t work until you also protect these cells. Only when you have a combination of cells which are locked and protected can you truly prevent people from making changes. In this video, you'll learn: -- How to lock all the cells in a worksheet in Excel. -- How to lock some specific cells in Excel. -- How to hide formula from the locked cell. Read More: https://trumpexcel.com/lock-cells-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 7738 Trump Excel
How to Insert and Use a Radio Button (Option Button) in Excel
 
08:11
A Radio Button in Excel (also called the Option Button) can be used to select one of the many choices/options. A radio button allows the user to select an option which updates a dashboard or a report. It can also be used to create a survey where one answer per question can be selected. In this video, you will learn how to insert the radio button (option button) in Excel, how to create copies of it, and how to link it to a cell in Excel. Once a radio button is linked to a cell, whenever you make a selection, the linked cell updates to reflect the selection. This linked cell can then be used to update dashboards and reports/charts. The video also shows how to group radio buttons (option buttons) so that a group of radio buttons is independent of the other group. It also covers an example on how to update a simple column chart based on the radio button selection made by the user. Read More about it here: https://trumpexcel.com/insert-use-radio-button-in-excel/ Related Videos: -- https://www.youtube.com/watch?v=Mrf6uja2j8c -- https://www.youtube.com/watch?v=uREmXWvSuo4 -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel Radio Button in Excel, Option Button in Excel, How to Add a radio button in Excel, How to Insert a radio button in Excel, how to add an option button in Excel
Views: 28655 Trump Excel
How to create a Dynamic Search Suggestion Drop Down List in Excel
 
18:22
In this video tutorial, learn how to create a dynamic Google-type search suggestion drop down list in Excel. This technique uses a mix of Excel Formulas and VBA. You will learn how to create dynamic search bar where it will show a list of all the matching records as you type. Here is a written step-by-step tutorial and Download File: https://trumpexcel.com/excel-drop-down-list-with-search-suggestions/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 258245 Trump Excel
How to Insert a Picture in Excel Cell
 
03:07
In this video, you'll learn how to insert a picture into an Excel cell. When we insert a picture into an Excel cell, it does not move with the cell in case you filter it or hide it. Here are the steps to insert a picture into a cell in Excel: -- Go to the Insert tab. -- Click on the Pictures option (it’s in the illustrations group). -- In the ‘Insert Picture’ dialog box, locate the pictures that you want to insert into a cell in Excel. -- Click on the Insert button. -- Re-size the picture/image so that it can fit perfectly within the cell. -- Place the picture in the cell. A cool way to do this is to first press the ALT key and then move the picture with the mouse. It will snap and arrange itself with the border of the cell as soon it comes close to it. If you have multiple images, you can select and insert all the images at once. Here is a related tutorial on doing picture lookup in Excel: https://www.youtube.com/watch?v=rTyZmSHDLBA Read More -- https://trumpexcel.com/insert-picture-into-excel-cell/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 151359 Trump Excel
How to use Scenario Manager in Excel
 
07:47
Scenario manager is a great tool to analyze the impact on the output when multiple input variables change. It can automatically generate a summary with all the scenarios and the output. In this video, I will show you how to use Scenario Manager by taking a simple example. Read the tutorials and download the example file: https://trumpexcel.com/scenario-manager-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 21050 Trump Excel
INDIRECT Formula in Excel
 
03:22
INDIRECT formula returns the reference specified by the text string Note: - It is a volatile formula (use with caution) - The Reference Text (ref_text) could be: -- A reference to a cell that in-turn contains a cell reference in A1-style or R1C1-style format -- A reference to a cell in double quotes -- A named range that returns a reference Live Example here: https://trumpexcel.com/excel-functions/excel-indirect-function/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 22536 Trump Excel
Format Numbers as Text in a Drop Down List in Excel
 
07:18
Drop down lists are created with the input data that also resides in the workbook. While in most cases we may want the drop down items to look exactly the same as the input range, in some cases you may want it to look different. For example, you may want 1 to look TRUE and 0 to look FALSE. In this video tutorial, I will show you a trick to do this. You will learn how to create a drop-down list in Excel that displays desired text, but when selected, returns a number Read More: https://trumpexcel.com/format-numbers-as-text-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 8417 Trump Excel
How to Insert a Checkbox in Excel to Create Interactive Lists and Charts
 
09:35
In this video, you will learn how to insert and use a checkbox in Excel. A checkbox can be used to create interactive charts and lists. This tutorial on Excel Checkbox covers the following topics: -- How to Get the Developer Tab in Excel Ribbon. -- How to Insert a Checkbox in Excel. -- Creating an Interactive Chart using a Checkbox in Excel. -- How to Insert Multiple Checkbox in Excel. -- How to Fix the Position of a Checkbox in Excel. You need to have the developer tab to insert a checkbox in Excel. If you don't have it, the first step is to enable it. Once you have the Developer tab, you can go to Insert drop down and click on the checkbox (in Form Control) and then click anywhere in the worksheet to insert the checkbox. Read more here: https://trumpexcel.com/insert-checkbox-in-excel/ -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 39423 Trump Excel
Creating Actual Vs. Target Charts in Excel
 
06:18
If you work involves reporting the actual and target data, you may find it useful to present the actual values versus the target values in a chart in Excel. For example, you can show the actual sales values versus the target sales values, or the satisfaction rating achieved versus the target rating. There can be multiple ways to create a chart in Excel that shows the data with Actual Value and the Target Value. In this video, I will show you two methods to create Actual Vs. Target Charts in Excel. The first method uses only columns bars to show the difference by changing the width of the target and actual values. The second method uses markers to create a marker for the target value and the actual value is shown as the bar. Read More and Download the example file: https://trumpexcel.com/actual-vs-target-chart-in-excel/ Actual Vs Target Chart in Excel Achieved Vs Target Chart in Excel Actual Vs Planned Chart in Excel Actual Vs Forecasted Chart in Excel -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 21763 Trump Excel
Excel Tip to Handle Large Data Sets
 
05:05
If you work with large data sets, scrolling right-to-left or up and down could make you slow and inefficient. In this video tutorial, learn baout Excel features such as Split Panes and New Window. These options will make you super efficienct while you work with large data sets in Excel -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 47924 Trump Excel
How to Create a Dynamic TARGET LINE in Excel Chart
 
12:12
Actual Vs Target charts are very popular to compare performance. In this video tutorial, learn how to create a dynamic target line in a bar chart. The target line would allow you to visually show how many data points are above the target and how many are below the target. You can change the target line using a scroll bar. It also shows how to change the color of the bars when the target is met. A cool technique using Error bars in Excel. Read all about it and download a working file from here: - https://trumpexcel.com/dynamic-target-line-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 30618 Trump Excel
5 Powerful Excel Formatting Shortcuts
 
04:50
In this video, you will learn 5 powerful excel formatting shortcuts that will transform your data and make it more readable. Using these shortcuts can make you more efficient and save a lot of time. I often get a lot of data download from colleagues or files from databases that have no formatting to it look raw and ugly. My immediate next step is to apply some basic formatting so that it can further be used. Here are my top five Excel formatting shortcuts: -- CONTROL + B: Applies bold font formatting to headers -- ALT + H + B + A: Applies borders to the cells -- ALT + H + B + T: Gives an outline border to the dataset -- ALT + H + O + W: Autofits column widths -- CONTROL + 1: Opens Format Cells dialog box You can read more about these Excel Formatting Shortcuts here: https://trumpexcel.com/excel-formatting-shortcuts/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 6237 Trump Excel
Creating a Thermometer Chart in Excel (EASY STEP BY STEP)
 
05:46
Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value. A few scenarios when where it can be used is when analyzing sales performance of regions or sales rep, or employee satisfaction ratings vs the target value. In this video, I will show you the exact steps you need to follow to create a thermometer chart in Excel. Note: The thermometer chart is useful when you have one actual value and target value set. In case you have multiple such datasets, you either need to create multiple such thermometer charts, or need to use a different chart type (such as the Bullet chart or the Actual Vs. Target charts). Read More: https://trumpexcel.com/thermometer-chart/ Download File: https://www.dropbox.com/s/035yl0rk73ux0gm/Thermometer%20Chart.xlsx?dl=0 -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 3660 Trump Excel
How to Track Changes in Excel
 
06:23
If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes in Excel can come in handy. You can also use it when you're updating a file and need to keep a track of all the changes you do yourself. This can be helpful when you revisit it sometime later. In this video, I will show you how to track changes in Excel. The video first covers how to enable the track changes functionality in Excel. To do this: -- Go to the Review tab. -- In the Changes group, click on the Track Changes option and select Highlight Changes. -- In the Highlight Changes dialog box, check the option - 'Track changes while editing. This also shares your workbook'. You can also specify the 'When', 'Who', and 'Where' options. For this tutorial, I will go with the default settings (these options are explained later in the article).  -- Click OK. The above steps would enable 'Track Changes' in Excel and now it will highlight any change done to the workbook. The video also covers: -- How to accept/reject changes. -- How to get a list of all the changes listed in a separate tab. -- How to disable track changes in Excel. Read More about track changes in Excel here: https://trumpexcel.com/track-changes-in-excel/ -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 16402 Trump Excel
Creating an Excel Drop Down List (a Step-by-step Guide)
 
09:31
An Excel drop-down list is a great way to give the user an option to select from a pre-defined list. It can be used while getting a user to fill a form, or while creating interactive Excel dashboards. It helps in data entry as you can limit the options that can be added to a cell. It also helps in avoiding misspelled words as the user can simply select from the drop down list in Excel. Drop down lists are quite common on websites/apps and are very intuitive for the user. In this tutorial, you'll learn how to create an Excel drop down list (it only takes a few seconds to create one). The video on Excel drop down list covers: -- Creating an Excel drop down list from source data in worksheet -- Creating an Excel drop down list by manually entering options/items -- Selecting all cells containing drop down lists -- Caution while copy pasting when there are drop down lists -- Using OFFSET Function to create an Excel drop down list -- Creating dynamic drop down list in Excel Read More: https://trumpexcel.com/excel-drop-down-list/ Video: https://www.youtube.com/watch?v=uREmXWvSuo4 -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 68592 Trump Excel
How to use FIND Formula in Excel
 
03:01
Excel FIND function can be used when you want to locate a text string within another text string and find its position. It returns a number that represents the starting position of the string you are finding in another string. ADDITIONAL NOTES: -- If the start number is not specified, then it starts looking from the beginning of the string. -- Excel FIND function is case-sensitive. If you want to do a case-insensitive search, use Excel SEARCH function. -- Excel FIND function can not handle wildcard characters. If you want to use wildcard characters, use the Excel SEARCH function. -- It returns a #VALUE! error if the searched string is not found in the text. Read More - https://trumpexcel.com/excel-functions/excel-find-function/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 20600 Trump Excel
3 ways to select visible cells in Excel
 
04:49
What do you do when you have to copy a range of cells in Excel and paste it somewhere else? In most cases, the below three steps get the work done: Select the cells that you want to copy. Copy the cells (Control + C). Select the destination cell and paste these cells (Control + V). But what if you have some hidden cells in the dataset? Then – these above three steps are not enough. In that case, you need to first select the visible cells in the dataset, and then copy paste this data only. In this video, I will show you 3 ways to select visible cells in Excel: -- Using the keyboard shortcut (ALT + ; for windows and CMD + SHIFT + Z for mac) -- Using the Go To Special dialog box. -- Using the Select Visible Cells command in the Quick Access Toolbar You can read more about this here: https://trumpexcel.com/select-visible-cells/ -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 7286 Trump Excel
Search and HIghlight Data in Excel Using Conditional Formatting
 
09:31
Conditional Formatting in Excel can be used to create a searchable database. In this video tutorial, I will show you how to create a search bar, such that it highlights the matching entry as soon as you type and press enter. All we will use is conditional formatting and some Excel formulas. Read the Tutorial and Download the example File: https://trumpexcel.com/search-highlight-using-conditional-formatting/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 19957 Trump Excel
How to handle Data Gaps in Charts in Excel
 
02:55
When you work with data in Excel. sometimes you may have some gaps due to unavailability of data or delays in data collection. With such data gaps, it becomes difficult to plot it on Excel charts. Fortunately, there are options in Excel that allow you to choose how to want Excel charting to treat such data gaps. You can leave it as a gap in the chart, make the value of these gaps 0, or connect these with a line. In this video, I will show you how to handle these data gaps in Excel Charts and select the best possible way to represent your data. Read FULL Tutorial: https://trumpexcel.com/data-gaps-in-excel-charts/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 6191 Trump Excel
Combine Multiple Workbooks In Excel using Power Query (Part 1 of 3)
 
09:29
Part 2 of 3 - Video Link: https://www.youtube.com/watch?v=YOA_3zceq00 Part 3 of 3 - Video Link: https://www.youtube.com/watch?v=GlvobgBD-xs Power Query (aka Get & Transform) can be of great help when you want to combine multiple workbooks into one single workbook. For example, suppose you have the sales data for different regions (East, West, North, and South). You can combine this data from different workbooks into a single worksheet using Power Query. If you have these workbooks in different locations/folders, it’s a good idea to move all these into a single folder (or create a copy and put that workbook copy in the same folder). In this video, I will show you how to combine data from multiple workbooks in Excel, when the data is in an Excel Table, and the name of the table is same across all workbooks. A few things to know: -- If you select an Excel Table as the template/key, Power Query will use the column names in this Table to combine the data from other Tables. If other Tables have additional columns, those will be ignored. In case those other Tables don’t have a column, which is there in your Template Table, Power Query would just put ‘null’ for it. -- The columns don’t need to be in the same order as Power Query uses column headers to map columns. -- Since you have selected Table1 as the key, Power Query will look for Table1 in all the workbooks, and combine all these. In case it doesn’t find an Excel Table with the same name (Table1 in this example), Power Query will give you an error. You can read more about this here: https://trumpexcel.com/combine-data-from-multiple-workbooks/ -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel Power Query, Excel Power Query, Get & Transform, Excel Get & Transform, Combine Data in Excel, Combine Data from Multiple Workbooks, Combine Data in Excel, Consolidate Data from Multiple Workbooks, Consolidate Data in Excel, Consolidate Data using Power Query, Consolidate Data using Get & Transform,
Views: 13186 Trump Excel
OFFSET Formula in Excel
 
05:55
OFFSET formula returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. Live Example here: https://trumpexcel.com/excel-functions/excel-offset-function/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 12407 Trump Excel
How to Insert Page Numbers in Excel
 
07:51
If your work involves printing your Excel worksheets, it’s a good idea to insert page numbers in it. Inserting page numbers in Excel takes a little more work as compared with other Microsoft applications such as MS Word or MS PowerPoint. In this video, you'll learn: -- How to Insert Page Numbers in Excel using the using the Page Layout View. -- Insert Page Numbers in Excel Using the Page Setup Dialogue Box. -- Start Page Numbering with the Desired Number. -- Change the Order in which pages are numbered. -- Remove Page Numbers from the Excel Worksheets. It also covers how to have a different footer for the first page, while having the page numbers of all the other pages of the Excel worksheet. Read more about inserting page numbers in Excel: https://trumpexcel.com/how-to-insert-page-numbers-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 91111 Trump Excel
Combine Multiple Workbooks In Excel with Power Query (Part 3 of 3)
 
08:56
Part 1 of 3 - Video Link: https://www.youtube.com/watch?v=qbMW0iSgH4I Part 2 of 3 - Video Link: https://www.youtube.com/watch?v=YOA_3zceq00 In the previous two videos, I have covered how to combine data from multiple workbooks in Excel using Power Query (aka Get & Transform). In the first video, I shared how to do this when data is in Excel Tables and each table has the same name. In the second video, I covered how to combine data when there are no Excel Tables, but the sheet names are the same. But what if neither the sheet names nor the Excel tables are same. Then you need to use the Excel.Workbook function in Power Query to fetch the data, sort the object type, and then combine the sorted object types. In this video, I will show you exactly how to do this. Note – this technique will give you the combined data even when there is a mismatch in column names. For example, if in East.xlsx, you have a column that has been misspelled, you will end up 5 columns. Power Query will fill data in columns if it finds, and if it can not find a column, it will report the value as ‘null’. Similarly, if you have some additional columns in any of the tables worksheets, these will be included in the final result. Now if you get more workbooks from which you need to combine data, simply copy paste it into the folder and refresh the Power Query -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel Power Query, Excel Power Query, Get & Transform, Excel Get & Transform, Combine Data in Excel, Combine Data from Multiple Workbooks, Combine Data in Excel, Consolidate Data from Multiple Workbooks, Consolidate Data in Excel, Consolidate Data using Power Query, Consolidate Data using Get & Transform,
Views: 3267 Trump Excel
How to Create a Milestone (Timeline) Chart in Excel
 
11:39
Milestone Chart (aka Timeline chart) is a widely used project management tool. It is a great way to plan a project and show the progress through milestones. It visually shows a timeline where you can specify key milestones, deliverables, and checkpoints. In this video tutorial, learn how to create a milestone chart in Excel. All you need to do is plug-in the data and it will be ready for use. Written Tutorial and Download File: https://trumpexcel.com/milestone-chart-in-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 95654 Trump Excel
How to Group Dates in Pivot Tables in Excel
 
08:09
In this tutorial, you'll learn how to group dates in pivot tables in Excel. You can group dates by years, quarters, months, weeks, days, hours, minutes, and seconds. Read More here: https://trumpexcel.com/group-dates-in-pivot-tables-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 4448 Trump Excel
How to Merge Two or More Excel Tables with Power Query
 
09:53
Power Query can be really useful when you want to merge different Excel tables. Now I am not talking about tables with the same structure. With Power Query, you can merge different tables as long as there is a common column. Earlier, this could have been done with lookup formulas or VBA, but that's too much effort when you can do it in seconds with Power Query. In this video, I will show you the exact steps you need to follow to combine three tables that have different columns (with only one matching column in each table). You can read more about it here: https://trumpexcel.com/merge-tables/ -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 3307 Trump Excel
Get a List of File Names from Folders & Sub-folders in Excel (using Power Query)
 
06:28
You can use Power Query to get a list of file names in Excel from folders and subfolders. If you're using Excel 2016, you already have Power Query options in the Data tab (under the Get & Transform group). If you're using Excel 2010 or 2013, you will need to download, install and activate Power Query. Note that Power Query and Get & Transform refer to the same thing. For Excel 2010/2013, you need to install the Power Query add-in to use it (steps described below). -- Click here to download the Power Query add-in. Make sure you are downloading 32-bit if your Excel is 32-bit and 64 bit if your Excel is 64 bit. -- Install the Power Query add-in. -- Open Excel. If you see a Power Query tab, skip the remaining steps. If not, move to the next step. -- Go to File and click on Options. -- In the ‘Excel Options’ dialog box, click on Add-in in the left pane. -- From the Manage drop-down, select COM Add-ins, and click on Go. -- In the list of available add-ins, select Power Query and click OK. -- Close the Excel Application and restart Excel. The above steps would install and activate the Power Query for your Excel. In this video, I will show you the exact steps to get the list of file names from folders and subfolders. I will also show you how to edit the data in Power Query Editor to add more meta columns to the file name data. Read more about this here: https://trumpexcel.com/list-file-names-power-query/ Related Video Tutorial: https://www.youtube.com/watch?v=OSCPVBWOqwc -~-~~-~~~-~~-~- Find Amazing Excel Tips & Tutorials: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ Youtube Channel ► https://www.youtube.com/c/trumpexcel
Views: 10446 Trump Excel
How to Start a New Line in  Excel (within cell and formula)
 
03:39
In this video, you will learn how to start a new line in the same cell in Excel. You will also learn how to insert a line break in a formula result. The keyboard shortcut to start a new line in Excel is ALT + ENTER. Read More: https://trumpexcel.com/start-a-new-line-in-excel-cell/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 12245 Trump Excel
Creating a Dynamic Heat Map in Excel Using Scroll Bar
 
06:06
In this video, you'll learn how to create a dynamic heat map in Excel using conditional formatting and scroll bar. This type of heat maps can be useful when you are creating dashboards or reports and want to save space on the worksheet. While it takes less space, it still allows the user to access the entire data set. Read More + Download File: https://trumpexcel.com/heat-map-excel/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 14927 Trump Excel

7 eleven employment application online
Busse admissions essay
How to start a cover letter when you don't know the recipient
Rn cover letter tips that actually got
Investment banking cover letter sample analyst interview