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...
by Oluwaseun | Oct 7, 2022 | Project Management Tutorials and Articles
The Excel UNICODE function returns a number (code point) corresponding to a Unicode character. Unicode is computing standard for the unified encoding, representation, and handling of text in most of the world’s writing systems. Purpose Get number...
by Oluwaseun | Oct 7, 2022 | Project Management Tutorials and Articles
The Excel UNICHAR function returns a Unicode character based on a given number. Purpose Get Unicode character by number Return value Unicode character Syntax =UNICHAR (number) Arguments number – Code point for a Unicode character in...