by Oluwaseun | Oct 13, 2022 | Project Management Tutorials and Articles
The Excel LOWER function converts a text string to all lowercase letters. Numbers, punctuation, and spaces are not affected. Purpose Convert text to lower case Return value Text in lower case. Syntax =LOWER (text) Arguments text –...
by Oluwaseun | Oct 11, 2022 | Project Management Tutorials and Articles
Sorting data is an integral part of Data Analysis. You can arrange a list of names in alphabetical order, compile a list of sales figures from highest to lowest, or order rows by colors or icons. Sorting data helps you quickly visualize and understand your data...
by Oluwaseun | Oct 10, 2022 | Project Management Tutorials and Articles
The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string. For example, RIGHT(“apple”,3) returns “ple”. Purpose Extract text from the right of a string Return value One or...
by Oluwaseun | Oct 10, 2022 | Project Management Tutorials and Articles
The Excel LEFT function extracts a given number of characters from the left side of a supplied text string. For example, LEFT(“apple”,3) returns “app”. Purpose ...
by Oluwaseun | Oct 9, 2022 | Project Management Tutorials and Articles
HLOOKUP Function HLOOKUP stands for Horizontal Lookup and can be used to retrieve information from a table by searching a row for the matching data and outputting from the corresponding column. While VLOOKUP searches for the value in a column, HLOOKUP searches for the...