Display Search Results in a ListBox – Excel VBA

About this tutorial: Video duration: 25:37 In this video we display search results in a listbox on a userform in Excel VBA. In this scenario, the user is searching for a product. They enter a keyword and the search results are shown in a listbox. They then make a selection and it is added to […]

Format all Milestone Tasks in Gantt Chart Table

About this tutorial: Video duration: 2:18 Format all milestone tasks in the Gantt Chart table to easily distinguish them from other tasks. View more Microsoft Project tips The summary tasks in the Entry table of the Gantt Chart are formatted in a way to distinguish them from others at a glance. However milestone tasks do […]

Create a Heat Map using Conditional Formatting in Excel

About this tutorial: Video duration: 6:35 Create a heat map using Conditional Formatting to visualize a pattern in your data set. In this video tutorial we have a table of rainfall data. Just looking at a table of numbers does not show us much, without intense eyeballing. By applying a heat map and using a […]

5 Excel INDIRECT Function Examples – Learn the Fantastic INDIRECT Function

About this tutorial: Video duration: 18:31 Learn the INDIRECT function of Excel with these 5 INDIRECT function examples. See how to use INDIRECT with named ranges, to reference other worksheets, create R1C1 references and see it used with other functions. Download the file to follow along here – The INDIRECT function is one of the […]

What is Microsoft Flow? – Update Excel Automatically when New Dropbox File Uploaded

About this tutorial: Video duration: 13:50 In this video, we answer what is Microsoft Flow? What does it do, and how is it helpful? During the video, we see a Microsoft Flow example that updates an Excel file whenever a new file is uploaded to a Dropbox folder. This is just one example of how […]

Create a Picture Lookup in Excel

About this tutorial: Video duration: 5:5 Create a picture lookup in Excel. Display a picture dependent upon the contents of another cell. In this video we create a picture lookup so that when a country is selected via a drop down list, the associated flag for the chosen country is returned from a list. Join […]

Recortar imágenes para folleto publisher

About this tutorial: Video duration: 2:20 Puede ser folleto o triptico

How to Create a Booklet in Microsoft Word 2016

About this tutorial: Video duration: 1:32 This Microsoft Word tutorial demonstrates how to set up, combine, and print your documents as a booklet

Power query in Excel in Hindi ||excel for accountant| interview questions|| PIVOT TABLE DASHBOARD ||

About this tutorial: Video duration: 15:55 MOST ASKING QUESTION IN INTERVIEW. WATCH AND APPLY THIS AND BE A UNIQUE EXPLORE YOUR KNOWLEDGE

powerpoint shortcut keys

About this tutorial: Video duration: 59

Create a Searchable Drop Down List Just Like Google – Excel Trick

About this tutorial: Video duration: 27:38 Create a searchable drop down list in Excel just like Google. This trick is fantastic for large lists. Giving the functionality to search within a list goes beyond a standard drop down list. Learn Excel VBA with our online course – This video tutorial will show you how to […]

Creating Visiting Card in Word 2013

About this tutorial: Video duration: 6:22 Label Command in Word 2013

Microsoft Word 2016 Essential Training | Booklet

About this tutorial: Video duration: 1:41 Microsoft Word 2016 Essential Training | Booklet Booklet is like a small book, Booklet allows you to print on paper like printing a book. Making a booklet professionally makes you look like a professional, but not everyone knows how to make a booklet just using this simple method with […]

Count Unique Values in PivotTables in Excel 2013

About this tutorial: Video duration: 3:46 Count unique values in PivotTables in Excel 2013 using the new Distinct Count function. Read the full tutorial When working with PivotTables the count function will count all occurrences of a value. However you may be trying to answer how many unique products were sold in a country, or […]

Insert Degree Symbol in Microsoft Word

About this tutorial: Video duration: 4:6 http://www.computergaga.com/blog/category/word/ Insert the degree symbol into a Word document. Insert the degree sign into your Word docs by using its character code, or by accessing it from the list of symbols. VISIT COMPUTERGAGA FOR LOTS MORE TIPS http://www.computergaga.com CONNECT WITH US! Google+ ► https://plus.google.com/+Computergaga Facebook ► http://www.facebook.com/computergaga Twitter ► […]

Create a Combination Chart in Excel 2010

About this tutorial: Video duration: 5:57 https://www.udemy.com/excel-2010-superhero-course/?couponCode=Excel2010YouTube Create a combination chart in Excel 2010. A combination chart is a chart that combines 2 chart types in one such as a column and line, or column and area chart. Combination charts are used to compare two different data types, or data that varies widely on one […]

SUMPRODUCT Function – A Guide to a Powerful Excel Function

About this tutorial: Video duration: 8:19 A definitive guide to the SUMPRODUCT function in Excel. This function is a hidden gem that always surprises users when they see it. Read the SUMPRODUCT function guide – goo.gl/2GIuBI This video tutorial walks through 3 different examples of the SUMPRODUCT function. It begins with the classic use of […]

Animate Text One Letter at a Time in PowerPoint

About this tutorial: Video duration: 2:37 Animate text one letter at a time in PowerPoint. When animating text in PowerPoint, you can modify the animation effects to make it appear one letter at a time. View more tips – http://www.computergaga.com This video demonstrates how to make your text appear one letter at a time by […]

Create Multiple Dependent Drop Down Lists

About this tutorial: Video duration: 10:40 https://www.udemy.com/excel-2010-superhero-course/?couponCode=Excel2010YouTube Create multiple dependent drop down lists in Excel. It is vital for your Excel reports that data is accurate. Assist users when entering data by providing drop down lists of the possible options. If you have large lists of options then break it down into several cascading drop […]

How to Create a Booklet in Microsoft Word

About this tutorial: Video duration: 6:24 Create a booklet document in Microsoft Word by applying the book fold option. This video tutorial will show you how. http://www.computergaga.com/ This video tutorial will show how to apply the book fold option to a document for printing booklets. The book fold applies multiple pages to your document. You […]