Technology Hub

10/09/2021

What is a Proper Function in Excel?
PROPER function is considered as String or Text function in excel. The PROPER function converts the first character to the upper case and rests to the lower case.
How to use Proper Function?
Why do we use Proper function in Excel?
The TODAY function was introduced in 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 simple and easy to use.
Things to remember about the PROPER Function
1. The first letter of every word, letters following numbers, or other punctuation are converted to uppercase by the PROPER function. It may be in places that we may not expect. For example, the function converts the “s” in the text string “the Republic of albania” to uppercase (i.e. “The Republic Of Albania”).
2. Numbers and punctuation characters are not affected but Formatting is lost.

Follow on Youtube: https://www.youtube.com/channel/UCQ1qOODodpF7FroUn2e8aDg
Follow on Instagram: https://www.instagram.com/Technology_hub21/

04/05/2021

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 course for beginners like Layout, the difference between workbook and worksheets, Cell name, formula bar, ribbon.

Follow on Youtube: https://www.youtube.com/channel/UCQ1qOODodpF7FroUn2e8aDg

Follow on Instagram: https://www.instagram.com/Technology_hub21/

28/04/2021

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 Applications (VBA).
It has been a very widely applied spreadsheet for these platforms, Excel forms part of the Microsoft Office suite of software.
Free Microsoft Excel tutorial for beginners.
Learn everything in this Microsoft excel course for beginners like Layout, the difference between workbook and worksheets, Cell name, formula bar, ribbon.

Follow on Youtube: https://www.youtube.com/channel/UCQ1qOODodpF7FroUn2e8aDg

Follow on Instagram: https://www.instagram.com/Technology_hub21/

02/04/2021

Learn in this video how to make an inventory management system in Microsoft Excel for your small busines

https://youtu.be/DoY7uu29Dtw

26/02/2021

In this video tutorial, learn how to extract or filter data in Excel based on a drop-down list selection.

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. Create a Unique list of items.
2. Create a drop down to display these unique items.
3. Use helper columns to extract the records for the selected item.

https://www.youtube.com/channel/UCQ1qOODodpF7FroUn2e8aDg

24/02/2021

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. Let’s take a look!

18/02/2021

Learn Vlookup in Excel. I have explained 7 ways of using Vlookup in Excel so that you can learn this important formula of excel.
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

https://www.youtube.com/channel/UCQ1qOODodpF7FroUn2e8aDg

10/01/2020

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.

Packet Tracer does not require physical equipment . It creates a virtual network with an almost unlimited number of devices, encouraging practice, design scenarios testing and troubleshooting.

Packet Tracer Download Link – Link

Below is step by step procedure on installing Packet tracer on Windows PC –

STEP 1 –
Once we have downloading the Packet Tracer exe file , Click on the exe file downloaded. Once below Window will appears, click “Next”how-to-install-packet-tracer-on-windows-system

STEP 2 –
On next screen, select “I accept the agreement” and click on “Next”.

how-to-install-packet-tracer-on-windows-system

STEP 3 –
Setup will show the folder in which the program’s shortcuts will be created. If you want to change the folder, you can change it. Click on “Next”.how-to-install-packet-tracer-on-windows-system

STEP 4 –
Then the program will ask whether to create a Desktop icon and create a Quick Launch icon. Make your choice and click on “Next”.how-to-install-packet-tracer-on-windows-system

STEP 5 –
The summary of the settings we selected is displayed. Click on “Install”.how-to-install-packet-tracer-on-windows-system

STEP 6 –
The installation starts as shown below.how-to-install-packet-tracer-on-windows-system

Installation gets completed and the below screen is shown. Click on “Finish”.

Click “OK” on next popup asking you to close or restart your computer.how-to-install-packet-tracer-on-windows-system

STEP 8 –
Packet Tracer is installed and ready to be used

What is Packet tracer? Packet Tracer is a very useful Cisco network simulation tool which allows network administrators and students to experiment with Cisco...

07/01/2020

What is Network?

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

06/01/2020

Learn Vlookup in Excel. I have explained 7 ways of using Vlookup in Excel so that you can learn this important formula of excel.
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

01/01/2020

How to create data entry form in Microsoft excel.

Learn how to create Data Entry form in Microsoft Excel.

01/01/2020

https://youtu.be/z8vTW_9r7y8

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...