For nearly all businesses, from the specialist sole traders and partnerships through SMEs to the large international corporations, Microsoft Excel is the indispensible tool for analysing, summarising and forecasting financial information. Excel is also employed for many non-financial uses from analysing test results, managing product configurations, and even the more human aspects of business such as objective setting and follow up, swot analysis, the list of applications is almost endless. Using Excel isn't confined to just business, but also education, hobbyists, and to homeowners managing their personal finances.
Cygnus Prime is a small development company based in North Hampshire UK, specialising in providing support in using Microsoft Excel within a business environment. Let Cygnus Prime help you get more from Excel.
For more information click on the links below.
19-Sep-2013 Excel Article: Excel Tables (Part 6) - Preserving Entry Order
25-Jun-2013 Excel Article: Excel Tables (Part 5) - Running Totals
12-Jun-2013 Excel Article: Excel Tables (Part 4) - Totals
31-May-2013 Excel Article: Excel Tables (Part 3) - Structured References
31-May-2013 Excel Article: Excel Tables (Part 2) - Creating an Excel Table
21-May-2013 Excel Article: Excel Tables (Part 1) - An Introduction
25-Apr-2013 Design Article: Questions to ask before designing a spreadsheet solution
11-Apr-2013 Excel Article: Sumif and Sumifs. Conditional summation
1-Mar-2013 Excel Article: What is that dollar in the formula? Relative and absolute references
27-Feb-2013 Excel Article: How to get graphs to update automatically when new data is added to a plain table
26-Feb-2013 Excel Article: How to get formulas to update automatically when new data is added to a plain table
"reducing the amount of cross checking needed and the time it takes to produce the report from several days to about one hour"
"reduced the work load significantly for creating product specific configurations"
Read more at Recommendations