Tricky: Find Excel Duplicates Based on Two Columns – 2283

About this tutorial: Video duration: 2:45 If you work in Accounts Payable, check out the great resources at Today’s question from a recent webinar that I did for the AP-Now members: Given an Excel worksheet of payments made by accounts payable, how can you look for duplicate payments. My solution involves the new TEXTJOIN function, […]

CONVERT CSV TO EXCEL WITH OFFICE 2016

About this tutorial: Video duration: 2:8 HOW TO IMPORT AND CONVERT YOUR CSV FILE TO EXCEL FILE WITH OFFICE 2016. ITS VERY EASY, JUST IN 01 MINUTE. See also : How To Delete Columns From CSV and Convert it on Excel : Create Calendar in Excel 2016 without coding. The Secret ? :

How to use Scenario Manager in Excel

About this tutorial: Video duration: 7: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 […]

Comparing and Combining Documents in Microsoft Word

About this tutorial: Video duration: 2:39 Learn how to compare and combine documents in Microsoft Word.

How to Add or Turn on the Developer Tab in Excel 2016

About this tutorial: Video duration: 3:11 In this Video We learn how to add new Menu Tab (Developer Tab) in Excel Step by step tutorial in Hindi. If you want to learn developer tab basic please comment below. Please like,share and comment If you are new in my channel please subscribe channel. For More Video-: […]

Learn to build a logic in Excel formula by solving real job query

About this tutorial: Video duration: 8:16 इस वीडियो में आप सीखने वाले है Real job v-lookup query in excel, with this example you will learn how to build a logic in excel using excel formulas, i know that you are good in excel but if you got unique problem you stuck with problem so i […]

How to Create INVOICE in Microsoft Excel : Excel Tips and Tricks [Urdu / Hindi]

About this tutorial: Video duration: 5:53 In this tutorial i am going to teach you how to create sales invoice in microsoft excel and why we use this invoice. Suppose you are exporting product to other country you need to create sales invoice and packing list along with this product. How to Create INVOICE in […]

Excel VBA – How to Import Data From a Text File

About this tutorial: Video duration: 3:23 Excel VBA – How to Import Data From a Text File Visit my website If you are into traveling, also check out my travel channel which capture the places I’ve been to with my camera

Excel 2013 Tutorial: Data Entry With Fill Series in Microsoft Excel

Excel 2013 Tutorial: Data Entry With Fill Series in Microsoft Excel Here you will learn some tips and tricks using the Fill-Handle or fill series in Excel. Enter data in Excel – the right way! This is, actually, a lecture from one of my Excel courses on Udemy. You can easily enroll into this and […]

Using scroll bars and spin buttons in forms | Excel Tips | lynda.com

About this tutorial: Video duration: 10:12 Learn how to incorporate two popular form controls—scroll bars and spin buttons—into your Excel forms and charts. Watch more Excel tutorials at This tutorial is from the Excel Tips Weekly series presented by lynda.com author Dennis Taylor. The complete course is a weekly series that offers a new Excel […]

Why Does Power Query Work So Well? Automate Excel Dasbhoards without VBA – Power Query, Pivot Tables

About this tutorial: Video duration: 13:33 In this video you will learn how the structure of an Excel Dashboard using Power Query (aka Get and Transform), Tables, Pivot Tables and Pivot Charts is the secret that will enable you to build dynamic Excel Dashboards which are fully automated without having to write and Excel VBA […]

Navigating Within an Excel Spreadsheet – 2018 Tutorial

About this tutorial: Video duration: 5:13 Learn how to quickly and efficiently navigate within an Excel spreadsheet by using some keyboard shortcuts and other Excel features. When working with a large spreadsheet, it can be easy to get lost or to have problems quickly getting to the end or beginning of your spreadsheet. These Excel […]

Advanced Excel – Using the IF Function in Excel to Program Your Spreadsheets

About this tutorial: Video duration: 5:43 Learn how to use the IF function in Excel to “program” your spreadsheets to show you certain data. You can create If ________ then _______ statements that can produce powerful results in Excel. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***:

Learn Excel – Force gmail to open attachments in Excel – Podcast #1847

About this tutorial: Video duration: 2:6 Google docs still does not render all Excel files correctly. If you have particular formatting, there is a chance that your gmail recipients will simply preview the file in gmail, which renders using Google Docs, which means they won’t see the right version of the spreadsheet. In today’s episode, […]

Simple Explanation of Excel SUMIFS, COUNTIFS & AVERAGEIFS (Multiple Criteria)

About this tutorial: Video duration: 14:4 Quickly learn how SUMIFS & COUNTIFS formulas work – and why they are better than SUMIF & COUNTIF formulas. Download the workbook here: Get the full course: The inclusion of the “IFS” formulas since Excel 2007 was a major gain for Excel users. Why? Because they allow you to […]

Learn Excel =INFO(“Directory”) to find – Podcast 1876

About this tutorial: Video duration: 2:54 You want to use some VBA to save a file to the desktop. But what is the real path to the desktop? It is not C:Desktop. In this episode, an arcane function = INFO to return the path of the current workbook.

Learn Excel 2010 -“Dynamic Chart Labels”: #1426

About this tutorial: Video duration: 3:2 Today we will learn how to replace Numeric Chart Labels with a Formula using the method Bill gives in Episode #1426. Also learn to vary Colors by Point AND “Making Excel Columns Wider” using Gap Width. Learn Excel 2007 through Excel 2010 from MrExcel

How to Calculate time in MS-Excel-bangla-এক্সেলে কিভাবে সময় গণনা করতে হয়

About this tutorial: Video duration: 1:35 #Truetips How to Calculate time in MS-Excel-bangla-এক্সেলে কিভাবে সময় গণনা করতে হয় time formula in excel কিভাবে এক্সেলে কাজ করতে হয় এক্সেলের কাজ কম্পিউটার এক্সেল এম এস এক্সেল এক্সেল কি এক্সেল টিউটোরিয়াল এক্সেল ২০০৭ টিউটোরিয়াল এক্সেল টিপস Calculating time in MS-Excel Calculate time in MS-Excel …

Learn Excel – Create an Invoice Register – Podcast 1808

About this tutorial: Video duration: 10:28 This follow-up video to episode 1505 shows how to automatically create an invoice register as your are using one of the Invoice Templates from Excel. Incoming search terms:how to create a invoice in excel register

Extract Unique Values using Advanced Filter using VBA | Excel VBA Tutorial

About this tutorial: Video duration: 6:5 Buy Me a Coffee? Your donation will help me to make more tutorial videos! This Excel video tutorial explains how to use Advanced Filter object to extract unique values using VBA. There are a lot of Excel books out there but below are the books I personally recommended For […]