Excel Magic Trick 540: Extract New Records Not In Old List – Array Formula Method

About this tutorial: Video duration: 8:33 Download Files: See how to check two 2 lists of records and extract only the new records (records that are in new list but not in old list) with array formulas that use SUMPRODUCT, ISNA, MATCH, IF, ROWS, SMALL, INDEX, ROW functions function. Compare Two 2 Lists

Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions)

About this tutorial: Video duration: 6:19 Download Excel Start File: Full Page With All File Links: With Formulas: see how to Count Unique Values, List Unique Value, Concatenate range of values with separator. See the MoreFun Add-in functions COUNTDIFF, UNIQUEVALUES, MCONCAT. Related videos: Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions Excel Magic […]

Excel Magic Trick 558: VLOOKUP to verify if Whole Record is in Table

About this tutorial: Video duration: 6:56 Download Files: See how to check if a record is in a table using VLOOKUP. See how to do this for a 2 column (field) table and a 4 column (field) table. See how to add a concatenated column and concatenate lookup_value in VLOOKUP function. Match. Is record in […]

Excel Formula Tab in Hindi – How To Use Name Manager And Define Name in EXCEL | In Hindi

About this tutorial: Video duration: 12:43 Excel formula tab menu in Hindi – How To Use Name Manager And Define Name in EXCEL 2016 2013 2010/2007/| in Hindi – You can define a name for range or cell on a worksheet and use the defined name in formula directly insted of selecting data range. you […]

Data Validation in Excel [ Hindi ] – Best Ever Explanation

About this tutorial: Video duration: 20:43 data validation in excel – Learn how to use Data Validation tools in Excel 2007 2010 2013 2016 Hindi to improve the accuracy of the data in your spreadsheets. ignore invalid data using data validation Full detailed explanation for data validation Data Validation Part 1: * Data Validation to […]

Create a Dropdown List with a List Box Form Control

About this tutorial: Video duration: 6:13 List boxes are another great tool for creating Excel Dashboards. With a list box you can control a chart or a bunch of charts. In this video tutorial we’re going to create an excel list box of countries to control 2 charts, sales and net sales. Subscribe to my […]

Word 2016 : How to Create a Drop-Down List

About this tutorial: Video duration: 1:3 Creating a Drop-Down List in Word 2016. Incoming search terms:can\t make a drop down list in word2016

Microsoft Outlook 2016: Calendar Groups

About this tutorial: Video duration: 5:19 Microsoft Outlook 2016 training video on how to create Calendar Groups, which is a collection of user calendars to view and compare schedules before scheduling a meeting via the Exchange Server (from Global Address List). All 141 of my Outlook 2016 training videos contain everything you need to help […]

Microsoft Access 2016 Forms: Combo Box

About this tutorial: Video duration: 12:9 Microsoft Access 2016 training video on how to insert or create a Combo Box, or a drop down list of data that is stored within that field. All 131 of my Access 2016 training videos contain everything you need to help pass the Microsoft Access 2016 (77-730) exam and […]

Add a Questionnaire to your MS Access DB

About this tutorial: Video duration: 5:17 This is a follow on video from the videos demonstrating how to create a CheckList in MS Access. In this video I show how to change the check this box to a text box make couple of slight alterations to the VBA code and Away you go you have […]

Introduction to Ms Excel Class 1

About this tutorial: Video duration: 7:40 Introduction to Ms Excel Class 1 My E Tutorial Presents:- Complete course on MS Excel 2013, will brief you how to use it and how to optimize it as per your requirement. he advantages of using Microsoft Excel are that users can maximize the value of their data by […]

Microsoft Access 2010 Tables: Lookup Field

About this tutorial: Video duration: 9:23 Microsoft Access 2010 training video on how to use the Lookup Data Type Field that allows the user to choose from a list when it comes to entering data for that field, or a field list for more accurate data entry. All 142 of my Access 2010 training videos […]

send individual PDF's to a mail list in Excel

About this tutorial: Video duration: 4:3 send individual PDF’s to a mail list in Excel Send unique PDF’s to each email in a list in Excel. Send unique PDF’s to each email in a list in Excel. Send any type of attachment specified to a list of emails in an Excel file. Sub Send_email_fromexcel() Dim […]

MS Access 2013 – 8. Add buttons to the portfolio browser

About this tutorial: Video duration: 17:37 Create a portfolio browser (navigation menu) Create a Search button to filter displayed records Create a text field and name it Create a button Assign a function: Apply filter [projectid] Like “*” & [Forms]![frm_Portfolio]![txt_Search1] & “*“ Keyword search (repeat 3a-c) [projectname] Like “*” & [Forms]![frm_Portfolio]![txt_Search2] & “*” Or [practice] […]

Top 10 Scariest Scenes From IT (2017)

About this tutorial: Video duration: 10:13 Top 10 Scariest Scenes From IT Subscribe: // Have a Top 10 idea? Submit it to us here! IT has the distinction of being one of the scariest movies of 2017, but of all the bone chilling moments, which one scared us the most? WatchMojo presents the Top 10 […]

How to Share Your Lists in Microsoft To-do

About this tutorial: Video duration: 4:10 In this video we look at how to share a list in Microsoft To-Do, and what options we have to manage sharing. If you like this video, you might also find some of our other videos helpful. Check out our channel to see more on Teams, Planner, SharePoint, Flow, […]

Send2 Demo: How to send bulk e-mail to recipients from Microsoft Outlook in a few clicks.

About this tutorial: Video duration: 4:15 Send2 for Outlook demo. HOW TO: send bulk e-mail to recipients from selected folders, e-mails, contacts, meetings, or tasks in one click. Whenever you plan: to send personalized group e-mail messages; to reply to numerous e-mails from the different recipients; to send an e-mail to recipients from selected e-mails, […]

Ace Combat 7: List of All 42 Confirmed Aircraft (2018)

About this tutorial: Video duration: 2:11 Here’s a compilation of all 42 aircraft that have been confirmed to appear in Ace Combat 7 so far and their status: playable or unplayable. It is said the game will have around 30 playable aircraft available at the release. For more videos about Ace Combat 7: ✈✈ FAQ […]

Create an Approval Flow with Microsoft Flow

About this tutorial: Video duration: 22:3 Learn how to automate the approval process using a custom Flow. If you like my videos, please consider buying me a coffee at or donate a dollar via PayPal at Blog:

MW008-Multilevel List in Word|| Microsoft Word 2016 Tutorial in Hindi || Urdu

About this tutorial: Video duration: 9:48 In today video, we will learn how we can implement and customize multilevel list in word. This video tutorial, we will start from a very beginning of Microsoft Word 2016 and try to achieve the professional level. Microsoft Word, a part of Microsoft office, is a widely used and […]