Excel

Do you just use Excel to add up columns of figures ?

At Anchor Business Computing Ltd we can develop spreadsheets to simplify your daily workload saving you time and money.

Do you know the other things that Excel could do for you ?

• Change cell colours when the entered values stray outside set limits.
       ( Conditional Formatting )
• Fix column heading so they stay at the top of the page when you scroll down.
       ( Freeze Panes )
• Quickly select all rows of data which have set values in specified columns.
       ( Auto Filter )
• Summarise all of your data in seconds to see trends and patterns.
       ( Pivot Tables )

Using Excel and all its features could save you time.

• Have macros do repetitive tasks to save you time and effort.
• Use advanced functions to manipulate your data so that you only need to enter the very basic data and let Excel automatically do all your calculations.
• Use lookup and reference functions to find and collate data from many worksheets into a single report.
• Use logic function to enable Excel to carry out different operations dependent on calculated values. ( Highlight when a customer exceeds their credit limit while you are entering the details. )