When downloading reports from a system, sometimes dates are not recognised by Microsoft Excel. However, you can still convert them into the proper date format.
For repetitive tasks in Microsoft Excel you could record your tasks as Vba Macro code, just once. Thereafter, just run this code ad infinitum.
Use Freeze Panes so as to keep seeing your column headings as you navigate to the outer reaches of your spreadsheet.
Hello everyone! Did you know…a column chart in Microsoft Excel is the most popular graph or chart type.
You can use keys on your keyboard - Shift key, Control key and End key - to navigate and select.
NOW, DATE and WEEKNUM - just some of the useful functions to use in your Date formulas.
To find duplicate rows, first join up the cells on each row and then deploy the COUNTIF function. If count is greater than 1, then a particular row is a duplicate row.
To get an average of a range of numbers, either do a Microsoft Excel average formula or better still, use the Microsoft Excel AVERAGE function.
Hello everyone! Did you know……If you want to lookup multiple values then use INDEX MATCH, "&" and an array formula.
For MATCH INDEX special formula use MATCH to look up and get position number which is then used within INDEX to return the corresponding value from the data range.