Article Database
Search results: 44 article(s) found in topic: Software - keyword: Excel tips
relevanceSPREADSHEETS
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...
SPREADSHEETS
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...
SPREADSHEETS
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...
SPREADSHEETS
Using Excel to detect fraud
Benford’s Law is often used by internal auditors to detect fraud by identifying unusual data patterns. How can you easily and effectively apply Benford’s Law to your company’s data using Excel?
More...
SPREADSHEETS
Re-ordering a trial balance automatically
You’ve moved to a new accounting package which has a different chart of accounts. You’re now faced with the prospect of manually re-sorting the trial balance (TB) to get it into your management accounts template. Is there a quicker way?
More...
SPREADSHEETS
Tips for working with bank statement CSV files in Excel
To import a bank statement into your accounting software, you first need to download it as a CSV file into Excel. You then have to spend time editing the data in Excel before importing it. How can you do this more effectively?
More...
SPREADSHEETS
New feature for setting pivot table defaults
Pivot tables are a great way to summarise data but you can sometimes spend as much time cleaning up the table as you can creating it. Could the latest Excel feature solve this problem?
More...
SPREADSHEETS
Resolving #VALUE! errors
It’s very frustrating when #VALUE! errors thwart your simple spreadsheet. While sometimes the problem is obvious, often it’s not. How can you track down the culprits?
More...
SPREADSHEETS
Excel: more new functions
To entice more users to subscribe to Office 365, the February 2016 Excel update included a number of new calculation functions. What are the main ones and are they any use to everyday users?
More...
SPREADSHEETS
Dealing with poorly formatted dates
The date column in a spreadsheet you’ve received contains dates without forward slashes. You’re trying to reformat the dates but Excel won’t allow you to do so. What’s the problem and how can you fix it?
More...
