How to Customize Ribbon and Add a New Tab in Excel 2016

About this tutorial: Video duration: 5:21 This video explains how a new tab can be added to ribbon in Excel 2016

Microsoft Accesss in 30 Minutes: Access Made Easy by Sali Kaceli

About this tutorial: Video duration: 30:27 This is the concise version of the Microsoft Access 2016 tutorial. Explore it for your next job application. It covers most areas of what one needs to know to be familiar with databases in a business environment. Learn more at The tutorial starts with the very basics and continues […]

How to Merge Cells in Excel 2016

About this tutorial: Video duration: 4:29 Learn how to merge cells in excel 2016

Excel Cell References – Relative, Absolute, and Mixed Referencing

About this tutorial: Video duration: 6:55 Ever have issues with cell references in Excel? This video covers using relative, absolute, and mixed cell references in Excel. Using a combination of these references in Excel can really help you carry out the tasks you are trying to accomplish. BELOW ARE ADDITIONAL RESOURCES RECOMMENDED READING EXCEL Microsoft […]

Create a Quick Access Toolbar Specific to a File

About this tutorial: Video duration: 50 To create a quick access toolbar specific for a particular file, click the down arrow to the right of the Quick Access toolbar. Select “More commands”. Then click on “Quick Access Toolbar” on the left-hand menu. (In 2007, select “Customize” on the left-hand menu.) From the drop down box […]

5 Amazing Excel Tips Tricks Speed up Work Efficiency Microsoft Excel

About this tutorial: Video duration: 5:49 In this video you will learn 5 Excel Tips & Tricks which help you to Veer Tutorial Ki publish की हुई playlist इस प्रकार हैं ________________________________________________ EXCEL Tutorial in HINDI ► EXCEL Tutorial in ENGLISH ► TallyERP9 Tutorial ► Pivot Table Tutorial ► MS Access ► HTML5 & CSS3 […]

Excel 2016 Advanced

About this tutorial: Video duration: 2:38:45 Purchase a Live Public Class: Use Promo Code for 75% Off One Class: YOUTUBE75 Request a Private Class: Exercise Files: Manuals: Username: manuals Password: password Named Ranges 0:03 Creating Named Ranges from Selection 5:24 Named Ranges (Continued) 8:31 IF Functions 11:15 Formula Auditing Tools 19:26 IF Functions (Continued) 26:05 […]

Advanced Excel Training -3

About this tutorial: Video duration: 29:7 Advanced Excel Training Center For More Details Log on www.iptindia.com and Call – +91 8826828093, +91 8802579388 +91 9968811487 Skype ID – advexcel1 Mail us – Kumar@iptindia.com How can Join Advanced Excel Class Online From Computer with Sujeet Kumar How Can Join Advanced Excel Class from Mobile Phone with […]

Excel Logical Functions

About this tutorial: Video duration: 31:50 All Excel users should know the 3 most powerful Logical Functions: IF, AND, OR. Logical functions allow you to test your data against various conditions and return text or values that will be useful for you.

XLShare – Excel 2016 Real-time Collaboration, Sharing and Co-Authoring Spreadsheets

About this tutorial: Video duration: 11:14 A detailed tutorial on how to set up real-time collaboration, sharing and co-authoring spreadsheets in Excel 2013, 2016, Office 365 and Excel 2016 for Mac. See for the follow up video which shows you how to share your own spreadsheet. Visit: for more information

Excel TRIM Function, How to Remove Empty Spaces, Advanced Excel Tips and Tricks 2019

About this tutorial: Video duration: 7:1 In This Data Cleaning in Excel Tutorial, we learn How To Remove Spaces In Excel With TRIM Function. This Tutorial is part of Advanced excel essential training Series. This advance Tips and Tricks 2019 tutorial is applicable to ms excel 2016 and Microsoft excel 2013 as well. Checkout Some […]

Microsoft Excel Tutorial – Beginners Level 2

About this tutorial: Video duration: 22:11 This video tutorial will show you how to use Microsoft Excel for beginners level 2. Click here to go to level 1 for beginners Microsoft Excel is a powerful spreadsheet tool that is part of Microsoft Office. This is a detailed beginners tutorial, the below timestamps will help you […]

Excel 2016 – Insert Screenshots

About this tutorial: Video duration: 2:10 This Microsoft Excel 2016 tutorial shows you how to insert screenshots into an MS Office 365 workbook. This tutorial shows you how to add a screenshot to your worksheet. I also show you how to insert a portion of the screen using the screen clippings tool. Here is a […]

Advanced Excel Class – Day-1

About this tutorial: Video duration: 29:35 Advanced Excel Training Center For More Details Log on www.iptindia.com and Call – +91 8826828093, +91 8802579388 +91 9968811487 Skype ID – advexcel1 Mail us – Kumar@iptindia.com How can Join Advanced Excel Class Online From Computer with Sujeet Kumar How Can Join Advanced Excel Class from Mobile Phone with […]

Excel Sum(ifs) between dates, sum month & sum with multiple criteria

About this tutorial: Video duration: 8:44 Use the Excel SUMIFS formula to sum values between two dates. Here you’ll need to use the greater than & less than operators inside the SUMIFS formula. You’ll also learn how to sum values within a month. For example, your data set contains dates and you’d like to create […]

Excel 2016 – Create a Chart with Data in an Excel Worksheet

About this tutorial: Video duration: 7:13 This Microsoft Excel 2016 tutorial shows you how to create a chart in MS Office 365. I show how to add a pie, column, and bar chart in this tutorial using the recommended charts feature, then I show how to customize charts based off of your selected data. Here […]

Excel 2016 – Insert and Move a Page Break in a Worksheet

About this tutorial: Video duration: 7:59 In this Microsoft Excel 2016 tutorial shows you how to insert, move, and remove page breaks from you documents. I also show how to reset all default page breaks as well. This works well for printing a multiple page file. This tutorial is for beginners who are preparing for […]

How to use DB formula to calculate depreciation in Excel? depreciation calculate karna? (Hindi) 101

About this tutorial: Video duration: 11:48 This is a basic Hindi tutorial of Microsoft Excel 2016/2013/2010/2007. In this video, you will learn an easy way to calculate depreciation with the help of the DB formula. DB means fixed-declining balance method. With this method, we can calculate the depreciation of an asset or object for a […]

Course Introduction – Advanced Excel Training

About this tutorial: Video duration: 35:16 Advanced Excel Training Center For More Details Log on www.iptindia.com and Call – +91 8826828093, +91 8802579388 +91 9968811487 Skype ID – advexcel1 Mail us – Kumar@iptindia.com How can Join Advanced Excel Class Online From Computer with Sujeet Kumar How Can Join Advanced Excel Class from Mobile Phone with […]

Set POP or IMAP datafile as default with Outlook.com

About this tutorial: Video duration: 1:19 How to set a POP3 pst or IMAP ost files as default data file when using an Outlook.com or Exchange account in Outlook 2013/2016.