Office
Lesson 157: Two-way lookup in Excel
To look up a value in a two-way range, use INDEX and MATCH in Excel. Join the channel Telegram of...
Read moreDetailsLesson 156: How to use Index and Match in Excel
Instead of using the VLOOKUP function, you can also use INDEX and MATCH in Excel. Join the channel Telegram of...
Read moreDetailsLesson 154: How to use the Vlookup function in Excel
The Vlookup function is one of the most popular lookup functions in Excel. Join the channel Telegram of the AnonyViet...
Read moreDetailsLesson 155: How to calculate tax in Excel
This article shows you how to calculate income-based tax using the VLOOKUP function in Excel. The following tax rates apply...
Read moreDetailsLesson 153: How to handle substrings in Excel
There is no SUBSTRING function in Excel. Use MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and MAX in Excel...
Read moreDetailsLesson 151: How to use the Text function in Excel
When concatenating text and a number, use the TEXT function in Excel to format that number. Join the channel Telegram...
Read moreDetailsLesson 152: How to use the Concatenate function in Excel
Using the CONCATENATE function in Excel for string concatenation. Instead of using CONCATENATE, you can also use the & operator....
Read moreDetailsLesson 150: Substitute and Replace functions in Excel
3. The SUBSTITUTE function below replaces spaces with empty strings. In other words, this formula removes all spaces. 4. The...
Read moreDetailsLesson 147: How to change the font style in Excel
To change the font style in Excel, use LOWER, UPPER or PROPER. If you don't like using formulas, use Flash...
Read moreDetailsLesson 148: How to remove spaces in Excel
TRIM function in Excel Remove leading, trailing, and trailing spaces. Use the SUBSTITUTE function to remove all spaces or spaces....
Read moreDetailsRecent News
AnonyViet
AnonyViet is a website share knowledge that you have never learned in school!
We are ready to welcome your comments, as well as your articles sent to AnonyViet.