Technology Hub
Technology Hub
  • Видео 15
  • Просмотров 404 430
How to use Proper Function Excel |Why we use Proper Function in Excel|Capitalize Each Word in Excel.
What is a Proper Function in Microsoft excel Excel?
How to use Proper Function in Microsoft Excel?
Why do we use Proper functions in Microsoft Excel?
PROPER function is considered as String or Text function in Microsoft excel. The PROPER function converts the first character to the upper case and rests to the lower case.
The TODAY function was introduced in Microsoft Excel 2007 and is available in all subsequent Excel versions.
PROPER Formula in Excel =PROPER(Text)
Text is the required argument. The text needs to be enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.
PROPER function in excel is very simpl...
Просмотров: 5 124

Видео

Microsoft Excel course for Beginners Part1 || Free Microsoft Excel Tutorial for Beginners4:16Microsoft Excel course for Beginners Part1 || Free Microsoft Excel Tutorial for Beginners
Microsoft Excel course for Beginners Part1 || Free Microsoft Excel Tutorial for Beginners
Просмотров 2,9 тыс.3 года назад
In this excel tutorial of Microsoft excel course for beginners part 1 Excel Layout. There are several objectives we are going to cover in this course 1 the difference between a workbook and a worksheet. Learn in this Microsoft excel course for beginners Workbook, worksheets, Formula, etc. Free Microsoft Excel tutorial for beginners part 1 Excel Layout. Learn everything in this Microsoft excel c...
Microsoft Excel course for Beginners || Free Microsoft Excel Tutorial for Beginners2:29Microsoft Excel course for Beginners || Free Microsoft Excel Tutorial for Beginners
Microsoft Excel course for Beginners || Free Microsoft Excel Tutorial for Beginners
Просмотров 2,2 тыс.3 года назад
This is an introduction to a Microsoft excel course for beginners. Learn in this Microsoft excel course for beginners Formula, functions, shortcuts, etc. Microsoft Excel is a spreadsheet program developed by Microsoft for Windows, macOS, Android, and iOS. Microsoft Excel provides multiple features calculation, graph tools, pivot tables, and a macro programming language called Visual Basic for A...
How to make Transformer less power supply 5V || AC to DC Power supply8:20How to make Transformer less power supply 5V || AC to DC Power supply
How to make Transformer less power supply 5V || AC to DC Power supply
Просмотров 1303 года назад
In this video learn How to make Transformerless power supply 5V. IT can be used in Torch, Search Lights, LED, Battery Charger, etc. Transformerless power supply 5V low-cost project, AC to DC power supply transformerless power supply 5V, How to Make AC to DC power supply with components 4 diodes 560K Resistor 105j/400v Capacitor 220uf 16v capacitor Zenner 5V
How to Calculate Age || Using a Date of Birth in || Urdu || Hindi || Microsoft Excel6:43How to Calculate Age || Using a Date of Birth in || Urdu || Hindi || Microsoft Excel
How to Calculate Age || Using a Date of Birth in || Urdu || Hindi || Microsoft Excel
Просмотров 7323 года назад
This video step-by-step guide on how to calculate age using a date of birth in Excel. You will be able to find out the exact number of years, Months and Days that passed from date of birth until now. google excel Let’s take a look!
How to Extract Data based on a Drop-Down List selection In Microsoft Excel11:27How to Extract Data based on a Drop-Down List selection In Microsoft Excel
How to Extract Data based on a Drop-Down List selection In Microsoft Excel
Просмотров 12 тыс.4 года назад
In this video tutorial, learn how to extract or filter data in Excel based on a drop-down list selection. How to Extract Data based on drop-down list selection in Microsoft excel This Excel trick is extremely useful in situations where you have a huge dataset and you want to extract part of it by making a selection. There are three steps in extracting data based on a drop-down selection: 1. Cre...
Inventory Management System Stock Highlights || Microsoft Excel6:58Inventory Management System Stock Highlights || Microsoft Excel
Inventory Management System Stock Highlights || Microsoft Excel
Просмотров 2,8 тыс.4 года назад
Learn in this video how to make inventory management system stock highlights as you enter sales Qty more then purchase qty in Microsoft Excel.
CCNA 200-125 Training|| Lecture # 2|| Installation of Packet Tracer4:57CCNA 200-125 Training|| Lecture # 2|| Installation of Packet Tracer
CCNA 200-125 Training|| Lecture # 2|| Installation of Packet Tracer
Просмотров 4744 года назад
What is Packet tracer? Packet Tracer is a very useful Cisco network simulation tool which allows network administrators and students to experiment with Cisco network device behavior. Packet Tracer provides simulation and visualization capabilities which facilitates the lab testing and learning of complex scenarios and concepts. CCNA 200-125 Training|| Lecture # 2|| Installation of Packet Tracer...
Network fundamentals|| Introduction of network|| CCNA (R&S)200-1256:55Network fundamentals|| Introduction of network|| CCNA (R&S)200-125
Network fundamentals|| Introduction of network|| CCNA (R&S)200-125
Просмотров 6934 года назад
in this video we discuss basic of network,what is network,what are pros&cons of a network.why we create network.all these things discuss in this video Introduction of netwrk Network fundamentals Network fundamentals|| Introduction of network|| CCNA (R&S)200-125
7 Ways to Use Vlookup9:487 Ways to Use Vlookup
7 Ways to Use Vlookup
Просмотров 3,5 тыс.4 года назад
Learn Vlookup in Excel. I have explained 7 ways of using Vlookup in Excel so that you can learn this important formula of excel. vlookup formula in excel example 7 Ways to Use Vlookup in Excel are 1 Normal Vlookup 2 Vlookup From Different Sheet 3 Vlookup From Different Workbook 4 Copy Vlookup Formula 5 Vlookup Multiple Values At Once 6 Vlookup Smallest Value 7 Vlookup Largest Value Connect with...
How to create Data Entry Form in Excel-Microsoft Office5:21How to create Data Entry Form in Excel-Microsoft Office
How to create Data Entry Form in Excel-Microsoft Office
Просмотров 8194 года назад
Learn how to create Data Entry form in Microsoft Excel.
Inventory Management System || Microsoft Excel40:31Inventory Management System || Microsoft Excel
Inventory Management System || Microsoft Excel
Просмотров 369 тыс.4 года назад
Learn in this video how to make an inventory management system in Microsoft Excel. small business spreadsheet for income and expenses Its my new channel ruclips.net/channel/UCX9TweFdw4uG0BFhFNSDP5g
CCNA || R&S || Training || 200-125 || Introduction.9:11CCNA || R&S || Training || 200-125 || Introduction.
CCNA || R&S || Training || 200-125 || Introduction.
Просмотров 8794 года назад
Welcome to our CCNA Training (R&S) 200-125 series in Urdu. CCNA stands for Cisco Certified Network Associate. R&S means Routing & Switching. The Exam Code of this course in 200-125. It's the basic course of CCNA track. If you want to start any certification like CCNA Security then you must pass the exam of CCNA R&S first. The exam time of this course is 90-120 mints. Here 90 mints time is for E...
How to insert images in Word in Table7:36How to insert images in Word in Table
How to insert images in Word in Table
Просмотров 5964 года назад
In this video we learn how a draw Table in MS word and How to insert images in Table. How to insert images in word
how to create Eye-Catching power point slides7:32how to create Eye-Catching power point slides
how to create Eye-Catching power point slides
Просмотров 2,6 тыс.4 года назад
how to create Eye-Catching power point slides