Article Database

Search results: 51 article(s) found in topic: Software - keyword: Excel tips

Sorted by checked relevancepublication date


Using Excel’s MOD function when drawing up budgets

You’re drawing up revised budgets and forecasts and need to allocate amounts across months. Using Excel’s MOD function can help simplify the process. How does it work? More...


Asking Excel a question

Microsoft has just introduced a natural language feature to Excel which will enable you to ask Excel questions almost like it’s a person. But will you get a meaningful answer? More...


Working together in Excel

Having multiple users working on the same Excel file can be very frustrating. Only one person at a time can edit, with everyone else in read-only mode. Could a new workbook-sharing feature of Office 365 solve this problem? More...


VLOOKUP wildcards

You’re using Excel to tie up cheque payments with a list of cleared transactions from the bank. The problem is that the cheque number on the bank’s record is embedded in the transaction code. How can you use VLOOKUP to match it? More...


Using macros for Text to Columns

You receive a spreadsheet from sales every day with new customer details. This includes two data fields in the same column. What’s the quickest way in Excel to split these out? More...


How to filter faster in Excel

You’re probably familiar with how the COUNTIF function works to easily count cells in your data table based on single or multiple criteria. But there’s a clever trick to speed the filtering process by using these criteria. How does it work? More...


Presenting in Excel

If your presentations are going to consist almost entirely of tables, data and numbers, is there really any point in copying all that data into PowerPoint? How can you spruce up your Excel spreadsheets to make them presentation-ready? More...


New SORT and SORTBY functions in Excel

A new set of powerful array functions is being rolled out to Office 365 subscribers. Three useful ones are SORT, SORTBY and FILTER. What’s the advantage of using these and how do they work? More...


How to deal with the rounding problem

You’re preparing a summary of the company’s month-end financials using Excel and want to round the figures to the nearest thousand for presentational purposes. What’s the best way to do this? More...


Excel’s artificial intelligence

In the first quarter of 2018 Microsoft added an artificial intelligence (AI) feature to Excel called Insights. How do you access this new feature and what can you use it for? More...
Last updated: 03.07.2020

More from Indicator - FL Memo Ltd