Windows 7 Recent Items ( How to delete history of recent documents )

About this tutorial: Video duration: 4:57 Check my blog here: Recent Items are different files/ documents available from a quick list of the Start Menu. This is useful to locate a recently browsed file easily and we can avoid browsing the file through folder structure. Different topics that are covered in this tutorial are: 1. […]

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

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

Excel Magic Trick #170: Conditional Format To Hide Items

About this tutorial: Video duration: 2:39 See how to use conditional format to hide or show items in a list using a TRUE FALSE formula. Incoming search terms:conditional fomat to hide items

Format and Import Item List in Excel for QuickBooks Desktop

About this tutorial: Video duration: 17:23 Hector Garcia shows you how to import an item list into QuickBooks from excel. also a few neat tricks using =CONCATENATE() function to clean-up the list Topics covered in this video: 00:00:25 – Introducing item list (item code, product category, color, size, cost, sales price). 00:01:30 – Formula =CONCATENATE […]

Importing Invoices into QuickBooks Accountant from Excel or any spreadsheet

About this tutorial: Video duration: 19:37 Importing Sales Receipts into QuickBooks Desktop: Topics contained in this video: 00:00:00 – Introduction 00:00:24 – Scenarios to import invoices 00:01:46 – Enter QuickBooks Desktop 00:02:34 – Batch enter transactions (checks, deposits, bills, invoices) and select invoices 00:03:00 – Example spreadsheet (excel) multiple or single lines 00:04:22 – Customize […]

Excel VBA Introduction Part 29.12 – Filtering Outlook Items using Restrict

About this tutorial: Video duration: 24:17 By Andrew Gould – This video explains how to filter the items in the Outlook inbox using the restrict method. You’ll learn about the basic syntax of Jet filters in Outlook and how to apply them to filter a list of emails using a variety of properties such as […]

Return Multiple Items with One Lookup Value

About this tutorial: Video duration: 9:41 Check out my Blog: How to lookup one value and return multiple values associated with it. This is an array function that needs to be entered with the keyboard combination CTRL+SHIFT+ENTER, which essentially enters it as an array formula.

How to Group Pictures in MS Word

About this tutorial: Video duration: 1:56 How to Group/Ungroup Images, Shapes or Other Objects in Microsoft Word Group or ungroup pictures, shapes or objects. Hold CTRL/SHIFT and select the shapes or other objects that you want to group. Under Drawing Tools, on the Format tab, in the Arrange group, click . If you do not […]

Microsoft Office 2010 Tips and Tricks 1 of 7

Topics covered in this webinar 1. Quick Access Toolbar 2. Recovering Deleted Items – Microsoft Outlook 3. Customize the Ribbon 4. Show the Margins 5. File Save As Visit us by going to our website http://www.1on1technologies.com

Windows 10 – Run an App

About this tutorial: Video duration: 4:8 This video shows you 3 different ways to run (or open) an app or application in Microsoft Windows 10. After showing the 3 ways, I explain the pros and cons of each way and eventually go into how to organize your desktop in a way that best fits your […]

Excel Magic Trick 608: Array Formula To Return Multiple Items – List Students With Free Periods

About this tutorial: Video duration: 11:6 See a formula that can lookup and return all the student names based on the blanks in a different column using the functions COUNTIF, IF, ROWS, INDEX, SMALL, ROW and an array formula. Also see: Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for […]

Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functions

About this tutorial: Video duration: 6:29 Download file: http://people.highline.edu/mgirvin/ Learn how to lookup an item when multiple lookup items are in a single cell with the LOOKUP and SEARCH functions.

Setting Display and Value of ComboBoxes (EASY TRICK) (Visual Basic Express 2010)

About this tutorial: Video duration: 5:40 This is a simple way of setting different text value of items in a combobox oppose to what is displayed in the combobox. Hope this helps.

How to Create Drop Down Menu in Microsoft Word 2010

About this tutorial: Video duration: 1:27 Some Microsoft Word users find the need to add drop down menu in their Word document. This option is available in the “Developer” tab of Microsoft Word, which is hidden by default. Learn how to make the tab visible and also learn how to create a drop down menu […]

Stopping Duplicate Sent Items with Microsoft Outlook

About this tutorial: Video duration: 1:17 Are you using your Googlemail, Yahoo! Mail or Hotmail with Microsoft Outlook? You may notice that your sent items are storing twice, this video will show you how to stop that.

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

About this tutorial: Video duration: 8:24 Duplicate Lookup or Lookup 1 value, return many for a row Part 3. See a formula that looks up one value and returns multiple items. One To Many Relationship. See an array formula that uses the functions: COUNTIF, IF, COLUMNS, INDEX, SMALL and ROW. Related Videos: Excel Excel Magic […]

Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

Duplicate Lookup or Lookup 1 value, return many for a row Part 3. See a formula that looks up one value and returns multiple items. One To Many Relationship. See an array formula that uses the functions: COUNTIF, IF, COLUMNS, INDEX, SMALL and ROW. Related Videos: Excel Excel Magic Trick 359: Part 2: Return Multiple […]

Stopping Duplicate Sent Items with Microsoft Outlook

Are you using your Googlemail, Yahoo! Mail or Hotmail with Microsoft Outlook? You may notice that your sent items are storing twice, this video will show you how to stop that. Incoming search terms:Stopping Duplicate Sent Items with Microsoft Outlook

How To Add Remove Shortcut Items From The Quick Access Toolbar In Microsoft Office A Tutorial

How To Add Remove Shortcut Items From The Quick Access Toolbar In Microsoft Office A Step By Step Tutorial