How To Insert Index In Ms-Word | एमएस वर्ड मे इंडेक्स कैसे बनाए

About this tutorial: Video duration: insertindexmsword #msword #thesis #projects If there is any doubt comment below, I’ll help you! अगर किसी भी प्रकार का डाउट हो तो नीचे…

How to Filter for Unique Values & Remove Duplicates in Microsoft Excel

About this tutorial: Video duration: Learn how to find and remove duplicates​, count unique values among duplicates​, and use the new unique function. At the end, I cover how to use Excel for …

Cozy Plaid Inspired Makeup Tutorial | Red Green and Gold

About this tutorial: Video duration: 14:5 Hey guys! I’m sooo excited to share this plaid inspired look with you today!! It really turned out awesome in my opinion! I wish I’d had somewhere to wear it to though…would have loved to see people’s reaction to it! 🥰❤️ Links to videos mentioned: White Mistletoe Inspired HOLIDAY […]

Excel Magic Trick 368: Count Unique Items With More Than One Criteria

About this tutorial: Video duration: 14:2 Download Files: Amazing use of the FREQUENCY and MATCH functions! Array formula for counting unique items in a column with criteria in a second column. See 1 formula for counting numbers and 1 for counting words. Formulas use the functions: SUM, IF FREQUENCY, MATCH, ROW, and ISNUMBER in an […]

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 […]

How to compare two Excel Spreadsheets for differences

About this tutorial: Video duration: 2:37 The tutorial shows how to compare two Excel files /sheets for differences : – Excel’s compare feature – Via formulas and conditional formatting

SQL with Microsoft Access 2016 lecture 14 UNIQUE Keys

About this tutorial: Video duration: 4:3 In this lesson we Learn how to use UNIQUE KEY using SQL Statement Step by Step With Prof: Muhammad Safdar Dogar

Excel Dynamic Arrays (How they will change EVERYTHING!)

About this tutorial: Video duration: 7:1 Excel Dynamic Array formulas are new to Excel Office 365 (Insider for now). After this, everything will change! Complex tasks will be done with simple Excel formulas. Everything you wished Excel could do, can now be done! ★★ Link to complete Excel Dynamic Arrays Course: If you have Office […]

Microsoft Access 2010 Queries: Unique Values or Records in Query

About this tutorial: Video duration: 5:1 Microsoft Access 2010 training video on how to find unique values or records in a query. Unique Value is used to omit records with duplicate data in the fields displayed in the datasheet view. Unique Record is used to return on unique records based on all fields in underlying […]

How to make special birthday banner using Microsoft Publisher 2016

About this tutorial: Video duration: 13:7 This video teaches how to make special birthday banner using Microsoft Publisher 2016. Special since different with the usual banner. Easy to follow, this birthday banner is best for children. Incoming search terms:how to make a happy birthday banner in microsoft publisher

12 useful Pivot Tables Tips & Tricks everyone should know

About this tutorial: Video duration: 14:36 Helpful Pivot table tips and tricks that everyone should know. Handle pivots in simple and creative way. Incoming search terms:useful pivot table tips office 2016

Access 2007: Query Unique Values Or Records

About this tutorial: Video duration: 4:27 Access 2007 tutorial on eliminated duplicate records in your query by using either the Unique Values, or Unique Records feature. All 136 of my Access 2007 training videos contain everything you need to help pass the Microsoft Access 2007 (77-605) exam and become certified! PATREON: Kirt Kershaw & Dream […]

How to easily make custom numbered Raffle Tickets with MS Word and MS Excel

About this tutorial: Video duration: 15:52 This step by step tutorial walks you through created numbered raffle tickets using nothing but MS Excel and MS Word. Learn how to easily create as many numbered raffle tickets in a few minutes!

Connect to MS SQL Server Using ODBC From MS Access

About this tutorial: Video duration: 4:17 A short tutorial video on how to configure your ODBC connection and create connection data source to MS SQL Server database in MS Access. Please subscribe as I’ll be posting more videos weekly! For any question, please email me at JJYouTubeChannel@Outlook.com

Access 2016 – Learn the Guidelines for Designing Databases and Setting Field Properties

About this tutorial: Video duration: 7:15 In this video, I show you the basics of how to set up a database. Setting up databases in Access can be intimidating for new users, so this list of tips and tricks should help get you started. Here is a full list of tutorial videos available on my […]

Microsoft Word 2016: How to Insert Different Headers on Each Page

About this tutorial: Video duration: 2:9 A tutorial on how to insert different headers and footers on each page of a document in Microsoft Word 2016. Read the text tutorial: Incoming search terms:microsoft word different header on each page word 2017

Access 2007: Primary And Composite Keys

About this tutorial: Video duration: 8:37 Access 2007 tutorial on assigning a primary key to a field, that uniquely identifies a record; and that primary key field never contains blank values, or allow duplicates. Two or more primary keys are known as Composite keys as you’ll learn more about in this Access training video. All […]

Excel Magic Trick 432: Find & Extract Duplicate Records

About this tutorial: Video duration: 3:28 See how to use the COUNTIF function, Sort, Advanced Filter Extract Unique Records to find and extract duplicate records from a data set.

Excel Magic Trick 473: Extract Unique Records with Formula (Complex Array Formula)

About this tutorial: Video duration: 17:44 See how to: 1)Extract a unique list of records with a formula and display in a column using the functions IF, ROWS, INDEX, SMALL, FREQUENCY, MATCH, ROW, SUMPRODUCT and COUNTIF. 2)Extract a unique list of numbers only with a formula and display in a column with the extra function […]

Excel Magic Trick 577: Find Duplicates, Then Extract Unique Records

See how to use SUMPRODUCT and the Join Symbol (& Ampersand) to group duplicates and then see how to use Advanced Filter Unique Records to extract unique list from duplicates. Incoming search terms:Excel Magic Trick 577