Learn how to bulk convert negative or positive numbers in Excel using two methods. Discover the first method that uses a formula to create another set of numbers and the…
Convert text date to datetime format in Crystal Reports with these two methods - DateValue and cDate. Learn how to convert text date fields into usable date fields for better…
Learn how to easily calculate the financial year from a date in Crystal Reports using this simple formula. This code works for the Australian financial year starting from July to…
The #DIV/0! error occurs when a formula tries to divide a number by zero. Learn about the cause and solution for this error in Microsoft Excel 2016 with the IFERROR…
Learn how to create named cell references in Excel 2016 with our step-by-step guide. Discover how to use words instead of letters and numbers in your formulas, while adhering to…
Learn how to use the LOOKUP function in Excel 2016 to calculate age groups based on a given age. Find out how to create a formula that will categorize ages…
This tutorial shows how to use alternative line shading in Crystal Reports by applying a light grey color to every second row in the 'Details' section of the report using…