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...