Spreadsheet or a database? The rule of thumb…
When you have a new business requirement or process, e.g. Quoting, should you use a spreadsheet or a database? It i ...
What Is Microsoft Access?
Microsoft Access is the Business Software Design and Database element of Microsoft Office 365.It clever ...
Is Access Database Multi-User?
Microsoft Access is a multi-user program. Multiple members of your team can log in at the same time and share data. ...
Is Access Database Free?
Yes and No! There are two version of Microsoft Access. The full version allows your developer to make design changes ...
Why ask your team to struggle on with spreadsheets?
Is it the best use of their time? Is it the best use of your company's resources? Could your team members be bringin ...
Excel Super User Bundle
Our Super User Bundle will help you start your journey to becoming an Excel Super User and vastly increasing your produc ...
Excel Keyboard Shortcuts – Office keyboard shortcuts
Keyboard Shortcuts are the best way to great increase your productivity. Some keyboard shortcuts work across all MS Office applications.
Excel Keyboard Shortcuts – Values
Some keyboard shortcuts can quickly enter things like today's date or copy the value from the cell above. Keyboard S ...
Excel Keyboard Shortcuts – Deleting
Did you know that you can delete a row or column in Excel using a sequence of keyboard strokes rather than having to re ...
Excel Keyboard Shortcuts – Selection
By learning these powerful Excel keyboard shortcuts for selecting cells, rows and columns you can drastically improve y ...
Excel Keyboard Shortcuts – Inserting
Insert a row, column, cell, chart, symbol quickly and efficiently just be learning these straightforward keyboard short ...
Excel Keyboard Shortcuts – Navigation
Save time by moving around an Excel spreadsheet without having to take your hands off the keyboard and move back and fo ...
Volume Discounts – Nested IF Statements
Do you have more than one discount level depending on volume or quantity? The Simple Excel Volume Discount Tool can hel ...
What is your time worth?
You never get time back... Missing out isn't fun. Whether it is spending more time with family or friends, or having m ...
Adding and Removing VAT in Excel with our VAT Calculator
Excel is the perfect tool if you want to add or remove VAT in your sales and purchasing calculations. Our updated and ...
Keep Your Customers Happy To Grow Your Business
They say it is easier to sell to an existing customer than to attract a new customer. Studies have shown that the cost ...
How To use your Sales Data to drive Targeted Marketing
Capture and analyse sales data To turn sales data into more meaningful information for your business, make it tell you ...
6 Questions to ask yourself before buying Business Software
1. What do I need and want the software to do? It may seem an obvious question! I would really recommend writing it al ...
Spreadsheets vs Database – Round 10: Ability to Adapt & Grow
In the final round we look at which tool is the better long term platform for your business as it adapts and grows. As ...
Spreadsheets vs Database – Round 9: Measure Team Performance
In this penultimate round we look at whether spreadsheets or database are a more effective tool when you want to monitor ...
Spreadsheets vs Databases – Round 8: Task Delegation
In round 8 of 10 we turn to the key element of Task Delegation. In order for a business to grow, work must be delegated ...
Spreadsheets vs Databases – Round 7: Limiting The Damage Caused By Human Error
In round seven we look at how much both of these platforms can defend themselves from human error. In our businesses we ...
Spreadsheets vs Databases – Round 6: Restricting Access by Logon
Moving into the second half of this Spreadsheets vs Database contest we look at how to restrict user access by using log ...
Spreadsheets vs Databases – Round 5: Cut’n’Paste Errors
As we reach half-way in this Spreadsheets vs Databases 10 round bout, we look at the perennial favourite, Cut'n'Paste Er ...
Spreadsheets vs Databases – Round 4: Business Intelligence
The Free Dictionary defines Business Intelligence as '.. a set of theories, methodologies, processes, architectures, and ...
Spreadsheets vs Databases – Round 3: Instant Reporting
In the third round of this comparison of Spreadsheets and Databases we look at Instant Reporting. Computers can compile ...
Spreadsheets vs Databases – Round 2: Task Automation
Continuing our examination of which is more useful in the office, spreadsheets or databases, we look at task automation. ...
Spreadsheets vs Databases – Round 1: Multi-User
The two heavyweights in day-to-day office life are spreadsheets and databases. Most of the software we all use which isn ...
Has Your Team Outgrown Spreadsheets?
Here's how you can tell - Does more than one person need to use it at the same time? Would you like the spreadsh ...
Hell is ‘Sharing a Spreadsheet’…
Sartre and Spreadsheets! To take Jean Paul Sartre's famous "L'enfer c'est les autres" and run with it down many flights ...
How To Get The Reports You Need To Guide Your Business
I have recently been away for a well-earned break by the seaside. It has been a hectic year full of change, technical c ...
10 Reasons to Move Your Business to Custom Business Software
1. Multi-User It seems likely that you'll have come up against the usual spreadsheet complaint of 'Have you finished wi ...
5 ways Spreadsheets could cost your company.
Spreadsheets are used every day in most businesses. Take a look at these five news-worthy tales of how spreadsheet er ...
7 Reasons Your Team Should Drop Spreadsheets
1. Are they any good at it? Even though spreadsheets are easy to get in to, they are also incredibly easy to break. Do ...
Want To Delegate To Your Team? Give Them The Right Tools
When you started out, you were happy to do everything.Now, your business is growing, the workload is increasing and you ...
VAT calculations with two VAT rates
In December of 2008, the Chancellor of the Exchequer reduced VAT from 17.5% to 15%. This created a lot of work for IT pe ...
How to sort data with a macro
As we spend more and more time at the PC nowadays, it makes sense to put it to the best use possible. Computers are very ...
A Simple Excel Timesheet
If you sell your time by the day or by the hour you need a simple and quick way to record your hours and wages. Working ...
How to find number of sales, sales value and average sale by supplier
Want to know which of your suppliers products you are selling the most of? If you've got a long list of sales in your sp ...
How to find sales by product
Faced with a long sales ledger with a month's worth of sales, it can be daunting to find a way to compile the data and g ...
How to analyse sales using pivot tables
Pivot Tables are a very fast, neat way of analysing sales data like this: If you would like a formatted example o ...
How to identify Marketing Prospects from an Excel spreadsheet
Many people who approach Working Data for bespoke software ask for help with marketing data and processes. It is impossi ...
Simple Excel Markup and Margin Tool
A simple Excel tool to help you with markup calculations and margin calculations. Want to get a handle on Pricing, Mar ...
How to tidy mailout data
When you want to do a mailshot to your client list, it is important that you get the information right first time. Any i ...
How to automatically get the website address from an email address
In this month's newsletter we cover the use of Text functions which are often used to analyse and tidy spreadsheet data. ...
How to do mailout salutations
In this third and final part of our three-part series helping you to tidy and prepare an e-mailing list we look at gener ...
How to replace commas in email addresses
In this second in the series of three tips to help you tidy your e-mailing lists, we look at a quick but useful method t ...
How to remove trailing full stops from email addresses
It is important that we communicate effectively with potential and existing clients. One of the increasingly popular met ...
How to flag late invoice payments in an Excel Spreadsheet
A paid and unpaid formula in Excel shows you late invoice payments and will help you with the cash-flow which is crucial ...
How to do Inventory Year End Calculations
Keeping check on inventory; how much has gone out, how much has come in, what value goes down on my tax return? At this ...
How to calculate cumulative discount
In this month's spreadsheet tip, we look at how to apply discounts cumulatively to your price list. This allows you to a ...
How to calculate simple discount
We can set up a Discount Tool in Excel by using arithmetic functions. Follow the steps below to build your own discount ...
How to cross reference spreadsheet data using VLOOKUP in Excel
Need to cross-reference two lists but there's too many to do manually? Excel can help with the vLookup function Wan ...
A Simple Excel Mileage Claim Spreadsheet.
If you travel for your work you will need to keep a track of your mileage. Then you can claim expenses or deduct it fro ...
