MS Excel: Formulas and Functions – Listed by Category

Excel formulas and functions including worksheet functions entered in the formula bar and VBA functions used in Macros. Worksheet formulas are built-in functions that are entered as part of a formula in a cell. These are the most basic functions used when learning Excel. VBA functions are built-in functions that are used in Excel’s programming environment called Visual Basic for Applications (VBA). Below is a list of Excel formulas sorted by category. Lookup/Ref Functions ADDRESS (WS) Returns a text representation of a cell address AREAS (WS) Returns the number of ranges in a…

Loading

Read More

MS Excel: How to use the LOOKUP Function

This Excel tutorial explains how to use the Excel LOOKUP function with syntax and examples. Description The Microsoft Excel LOOKUP function returns a value from a range (one row or one column) or from an array. The LOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the LOOKUP function can be entered as part of a formula in a cell of a worksheet. There are 2 different syntaxes for the LOOKUP function:…

Loading

Read More

ONLINE SHOPPING SAFETY TIPS

DOWLOAD PDF! ONLINE SHOPPING SAFETY TIPS Online shopping safety tips These are some really simple ways to shop safely online you can use every day: Research retailers online to make sure they’re legitimate. Make sure the website is secure. Know your rights and the company’s returns policy. Keep software and virus protection up-to-date and use strong passwords for online accounts. Don’t use public Wi-Fi. Your standard data connection is more secure. Pay using a credit card. You will have more protection. Alternatively, online services like PayPal mean scammers will not…

Loading

Read More

WHAT IS SSH AND HOW IT IS USED

What is SSH? The Secure Shell protocol version 2, or SSH2, specifies how a client can connect securely to an SSH server, and then use the resulting secure link to access the server’s resources. Among other things, the client can run programs; transfer files; and forward other TCP/IP connections over the secure link. The SSH2 protocol is a descendant of the SSH v1.x series of protocols. SSH version 2 is standardized at IETF, and the vast majority SSH implementations now support SSH version 2. SSH version 1 is less secure,…

Loading

Read More

ONLINE BUSINESSES YOU CAN START WITH NO MONEY !

The internet is the great equalizer. In business specifically, it has leveled the playing field. Anyone can start a money-making online business—anyone with a computer, that is. But here’s the thing: virtually no technical experience is needed. Today there are plenty of tools you can use to build an online business that makes the technical work a lot easier than it was in the past. You can also live anywhere you want, set your own schedule, and work as little or as much as you want, depending on how fast…

Loading

Read More

HOW TO GET QUICK ACCOUNT APPROVAL BY BROKERS,E-WALLETS AND CRYPTO EXCHANGES

HOW TO  GET QUICK ACCOUNT APPROVAL BY BROKERS,E-WALLETS AND CRYPTO EXCHANGES., HOW TO  GET QUICK ACCOUNT APPROVAL BY BROKERS,E-WALLETS AND CRYPTO EXCHANGES.    Account verification popularly known as KYC (KNOW YOUR CUSTOMER) or AML (Anti-Money Laundering) policies is the first daunting tasks that you will encounter if you want to transact in the digital space. Why do you need to get verified or pass KYC? Most of these entities (brokers, payment processors or crypto exchanges) must comply with global financial and legal regulations from their respective regulators. This means that they are required by law to ask all…

Loading

Read More

Postal Codes in Kenya Starting With Letter I

Ichichi postal code – 10227 Igare postal code – 40209 Igoji postal code – 60402 Igwamiti postal code – 20307 Iiani postal code – 90120 Ikalaasa postal code – 90135 Ikerege postal code – 40415 Ikinu postal code – 904 Ikonge postal code – 40501 Ikutha postal code – 90207 Ikuu postal code – 60405 Ilasit postal code – 214 Ileho postal code – 50111 Imanga postal code – 50112 Ishiara postal code – 60102 Isibania postal code – 40414 Isinya postal code – 1102 Isiolo postal code – 60300…

Loading

Read More

Postal Codes in Kenya Starting With Letter G

Gacharage-ini postal code – 10210 Gachoka postal code – 60119 Gaitu postal code – 60209 Gakere Road postal code – 10109 Gakindu postal code – 10111 Gambogi postal code – 50318 Ganze postal code – 80205 GarbaTulla postal code – 60301 Garissa postal code – 70100 Garsen postal code – 80201 Gatara postal code – 10212 Gathiruini postal code – 239 Gathugu postal code – 240 Gatimbi postal code – 60217 Gatitu postal code – 10114 Gatondo postal code – 10115 Gatugura postal code – 10305 Gatukuyu postal code – 1028 Gatundu postal code – 1030 Gatunga postal code – 60404 Gatura postal code – 1013 Gede postal code – 80208 Gembe…

Loading

Read More