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...
by Oluwaseun | Oct 5, 2022 | Project Management Tutorials and Articles
The Excel IF function runs a logical test and returns one value for a TRUE result, and another for a FALSE result. For example, to “pass” scores above 70: =IF(A1>70,”Pass”,”Fail”). More than one condition can be tested by nesting...
by Oluwaseun | Oct 4, 2022 | Project Management Tutorials and Articles
Excel Data Analysis – Subtotals with Ranges If you have a list of data that you want to group and summarize, you can use Excel Subtotal and Outline to display summary rows or columns. You can use PivotTable also for this purpose,...
by Oluwaseun | Oct 4, 2022 | Project Management Tutorials and Articles
The Excel TIMEVALUE function converts a time represented as text into a proper Excel time. For example, the formula =TIMEVALUE(“9:00 AM”) returns 0.375, the numeric representation of 9:00 AM in Excel’s time system. Numeric time values are more useful...
by Oluwaseun | Oct 4, 2022 | Project Management Tutorials and Articles
The Excel DATEVALUE function converts a date represented as a text string into a valid excel date. For example, the formula =DATEVALUE(“3/10/1975”) returns a serial number (27463) in the Excel date system that represents March 10, 1975. Proper Excel...