MS Excel: How to Use Count and Countif Function with 7 Examples

About this tutorial: Video duration: 9:40 In this video I will show you how to use #Count and #Countif #Function in Microsoft Excel. In this video I will teach you 7 examples about count and Countif #Formula. This video tutorial is completely in Urdu language. I hope, after watching this video you will be able […]

Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)

About this tutorial: Video duration: 21:35 Highline College Busn 216 Class: Computer Applications taught by Michael Girvin. Download Excel Start File: Download Excel Finished File: Download Excel VLOOKUP File: Download Full Written Notes:

Excel 2010 Creating Links and Linking Data in Excel

About this tutorial: Video duration: 4:48 In this video, you will learn how to copy and link data using the Copy/Paste Options and using the Right drag-and-drop methods. When you link data, that data will automatically change when the original, or source data, changes. Linking data makes it easier and more accurate to show and […]

How to change Excel 2007 Chart Scale

About this tutorial: Video duration: 1:58 Learn how to change the scale of a chart in Microsoft Excel In this video tutorial we will show you how to change excel chart scale. In order to change excel chart scale, open your excel document. Select a column with data. Go to the “Insert” tab. Click on […]

Imaginary Numbers Function in MS Excel 2019

About this tutorial: Video duration: 10:57 Happy me with two click 1 subscribe click 2 press bell icon Follow me Whatsapp

Excel CONCAT Function & TEXTJOIN Function To MERGE Data From Different Cells: Excel Tips 2019

About this tutorial: Video duration: 7:43 Learn Excel CONCAT & TEXTJOIN Function To Combine Data From Different Cells. How to use excel advance CONCAT and TEXTJOIN formulas to merge data from multiple cells inside Microsoft excel 2019. This Tutorial is applicable to excel 2016, ms excel 2013 as well. 馃敼馃敼馃敼馃敼馃敼馃敼馃敼馃敼馃敼馃敼 鉁旓笍How To Locate and Extract […]

Excel Power User Beginner Tutorial

About this tutorial: Video duration: 1:43:33 Excel Power User Beginner Tutorial Purchase a Live Class: Use Promo Code for 75% Off One Class: YOUTUBE75 Request a Private Class: Manuals: Username: manuals Password: password VLOOKUP 0:03 Range Lookup 7:45 Autofilling Lookup 10:41 Defining Names 14:06 Using Named Ranges to Retrieve Data 17:18 INDEX 22:11 MATCH 27:41 […]

How to quickly remove all subtotal in MS Excel 2019 Office 365

About this tutorial: Video duration: 27 Raw data for excel practice download : This video shows you how to quickly remove all subtotal in MS Excel 2019 Office 365. 450 Excel functions with examples : Top 60 widely using most useful excel functions : 50+ Important excel functions with examples : Creative & advanced Excel […]

Understanding Concatenate and Ampersand (&) in Excel – Their similarities, differences and usage

About this tutorial: Video duration: 9:29 #excelhacks #exceltricks #excelfunctions The question troubles many times why we have both CONCATENATE and AMPERSAND while they serve the same purpose. Watch this video to understand how both of them are useful Concatenate and Ampersand (&) both serve the same purpose but it is all about the type of […]

Repeat ROW and COLUMN Headers on Each page in Excel

About this tutorial: Video duration: 2:10 In this video, I will show you how to repeat row and column headers for each page in Excel. This is especially useful when you’re printing a report that has a lot of data. You can use the method shown in this video to make sure the rows and […]

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

Excel 2016 Intermediate

About this tutorial: Video duration: 2:36:27 Public Class: Use Promo Code for 75% Off One Class: YOUTUBE75 Private Class: Exercise Files: Manuals: Username: manuals Password: password Flash Fill 0:03 List Design & Single Level Sorting 2:28 Multi-Level Sorting 4:52 Custom Sorting 8:20 Filtering 11:33 Multi-Level Filtering 15:40 Search Filtering 17:34 Format as Table 21:47 Table […]

How to convert Vlookup in array function to search multiple data simultaeously in MS Excel ?(Hindi)

About this tutorial: Video duration: 8:49 In this easy Hindi tutorial of Microsoft Excel 2016/2013/2010/2007, you will learn how to use vlookup formula as an array function. In this video, we will show you how to convert vlookup into an array function to search multiple values simultaneously from a big database. Microsoft Excel 2016/2013/2010/2007 ke […]

Data validation breaking trick in MS Excel 2019 Office 365

About this tutorial: Video duration: 2:17 Raw data for excel practice download : This video shows you how to break Data validation using simple trick in MS Excel 2019 Office 365. 450 Excel functions with examples : Top 60 widely using most useful excel functions : 50+ Important excel functions with examples : Creative & […]

How to rename sheet in excel? | How to change tab color in excel ? | Shortcut keys | English

About this tutorial: Video duration: 1:32 How to rename sheet in excel? | How to change tab color in excel ? | Shortcut keys | English About this Video: Watch the video to learn How to rename a sheet/tab in Excel. Also learn How to change the tab color in Excel. The method works in […]

Excel Tips & Tricks: Cell referencing, AutoSum & Percent

About this tutorial: Video duration: 6:57 Excel Tips and Tricks: Part 4: Cell referencing, AutoSum and Percent In this video, you can learn about cell referencing to different sheets in Microsoft Excel. I have explained how to make autosome in MS Excel and doing some calculations like percent in MS Excel. To watch video on […]

Excel Power User Advanced

About this tutorial: Video duration: 1:31:8 Purchase a Live Class: Use Promo Code for 75% Off One Class: YOUTUBE75 Request a Private Class: Manuals: Username: manuals Password: password Introduction to Dynamic Range Charts 0:03 Dynamic Range Chart Data 3:36 Defining Dynamic Named Ranges 9:11 Defining Dynamic Legend Entries 14:45 Defining Dynamic Category Labels 18:58 Dynamic […]

Freeze Panes to Lock Rows and Column | MS Excel Tutorial

About this tutorial: Video duration: 2:24 Content Freeze or lock Top row Freeze or lock first column Freeze or lock Rows and Columns Follow Us// MS Office Training Center Excel,Word,Power Point,Outlook,One Drive,One Note,Share Point,Microsoft Teams,Yammer

Create an Excel Burndown Chart in Simple Steps

About this tutorial: Video duration: 5:44 $10 ONE TIME OFFER! Get the Full Udemy Course ONLY for $10 !! Click the link: ****************************************************************** Hello Excel Funs, in this video tutorial we are going to build a Burndown Chart in Excel. Until now we learned how to create a Gantt Chart, helpful for a project progress. […]

Speak Cells on Enter | data entry validation trick in MS Excel 2019 Office 365

About this tutorial: Video duration: 1:16 Raw data for excel practice download : This video shows you how to enable Speak Cells on Enter for data entry validation through quick access toolbar in MS Excel 2019 Office 365. 450 Excel functions with examples : Top 60 widely using most useful excel functions : 50+ Important […]