This is coming out early because some very good specials have been launched by Autodesk for their third quarter. This makes us feel warmer than this late Winter chill is making everyone!
One of the many free items on the Software Africa website is the Bank Account Reconciliation Spreadsheet. You copy the new lines from your bank's on-line statement, paste into the spreadsheet, click a button, and the data is rearranged and checked.
Recently, First National Bleep Bank sabotaged (they call it "improved") their web site so that data pasted from the on-line statement no longer works: It all ends up in one column. Despite our vociferous complaints, the bank that advertises "how can we help you" shows no sign of fixing this abortion. Consequently we have had to modify our spreadsheets to cater for it.
Do you use the Bank Reconciliation Spreadsheet for FNB, and want us to put the new code into it too? If so, are you willing to pay R200 + VAT to encourage us to do it soon? Yes? Then please e-mail Rick.
This position is open for an person who has Access and VB.Net training but not much practical experience. Please send your CV to Rick and he will send you our test. If you score over 50% on all sections, he will probably ask you to come for an interview.
All new seats are discounted from now until 18th October 2013:
AutoCAD Verticals and Standalone products are discounted by 10%
The Design Suites are discounted as follows:
With two exceptions - Factory and Product Design Suites are only discounted at the Ultimate level.
AutoCAD LT excluding the Mac version is now R10,828.86 inc VAT but excluding subscription.
Please contact Judith or Willy for quotes.
These give real value to your Autodesk product users. They include the following:
For more information go to https://360.autodesk.com/landing and http://www.autodesk.com/subscription/overview.
Remember that Total Garages have recycling bins for you to drop off your recyclables. This guarantees that they do not go to land fill.
Now is the time to destroy invasive plants and have a day or two cleaning your local rivers with a community team!
Although this is not a cheap option, you can have your QuickBooks (excluding Simple Start) hosted on the web. For more information please contact Judith email@example.com or Willy firstname.lastname@example.org
If hanging on for a reply from QuickBooks Support is not your cup of tea, rather e-mail email@example.com. The turnaround is very good.
Where do I find the licence number and the key when installing QuickBooks? Answer: You'll find it on the back of your CD box!
In addition to selling you your QuickBooks or Quick Payroll, we also offer installation and telephone support. Depending on where you are situated, the cost of installation is low, but travel may add to it.
We continue looking at the "Data" tab on Excel 2010's Ribbon, in the "Data Tools" group. After "Data Validation", which we looked at in Tip #113, comes "Consolidate". This function allows you to combine figures from different sheets --or even different workbooks-- in various ways. The data on the various sheets should have a similar structure. In the example below we have two sheets, for a company's branches in Joburg and Hotazel, selling slightly different sets of products. We want to add the quarterly sales quantities from the two branches to arrive at the totals:
Once the Joburg and Hotazel sheets are set up, we add a blank sheet for Total, and click in cell A1. On the Data" tab, in the "Data Tools" group, click "Consolidate". The dialog box shown above, opens. "Function" is already set to "Sum" (there are also Count, Average, Max, Min, and some statistical functions). In the Reference box, click the "Collapse Dialog" button (circled in red, just to the left of the "Browse" button); select all the data (not just headings!) in one sheet; press Enter; click Add. Repeat for the other data range. In our case we have labels both in the top row and the left column, so tick both of these. Your dialog should then look as shown above.
Click OK. The results should look as shown for the Total sheet above right. Since only Joburg sells Thingamajigs, and only Hotazel sells Dinguses, we have an extra row in the totals. The order of the items does not matter; the names do. Notes:
The next item in the "Data Tools" ribbon is "What-If", which we will look at in the next issue.
How did people waste time before Facebook was invented?
All the Best from the team!
Judith and Rick
Members, Communication in Action cc trading as Software Africa
"Empowering African Business with custom PC programs, databases, and templates using Microsoft technologies"
Reg. 2009/007863/23 ~ VAT No 4500104387 ~ 126 Kelvin Drive, Morningside Manor, Sandton, 2191 South Africa.
Tel: 011 802-2685 / 011 802-6440/1 ~ Fax: 011 802-4576 and 086-635-7902/3 ~ Cell: 082 389-3481/2 ~ e-mail: firstname.lastname@example.org
This entire newsletter is Copyright ©
Communication in Action
cc t/a Software Africa. All rights reserved. Information may be reproduced in full context as long as credit is given.