Clients First USA
Clients First knows their software, but they are also astute business people, and they really understand manufacturing and distribution in particular.
Jimmy Witcher, COO, Merrick
Read More
About UsService OfferingsProduct OfferingsIndustries ServedDownloadsBlog
 
 

‘Tech Tips’ Category

Free Introduction to Excel training at Sage University

Friday, August 27th, 2010

excel I don’t think there is any fee to sign up with Sage University.  This particular course covers the basics of Excel 2007 and is ideal for new employees.  Here is the link to Register.  You may have to first register with the site:

Click ME

Here is the course description:

EOS2DIS1 – Discovering Excel Course

Anytime Learning Course
Course Level: Beginning Course Instructional Method: Self-paced Internet-based
Estimated Course Length: 7+ hours Number of Topics: 10
Course Content:

This Anytime Learning course provides an all around understanding of how Microsoft Excel works. You will learn how to develop spreadsheets using formulas and formatting and create charts ensuring you leave with a comprehensive knowledge of how to make Excel work for you.
Topics covered in ATL Topics include:

  • Understanding Microsoft Excel and working with Workbooks and Worksheets.
  • Managing and using multiple worksheets and creating multiple views.
  • Formatting and editing worksheets as well as printing and page setup.
  • Working with formulas and using functions and charts.

Schedule Id: 36557
Anytime Learning – ACS

Anytime Learning offers the convenience of Internet-based recorded sessions that are available whenever you are. All you need is a computer, speakers, and high-speed Internet connection. Anytime Learning is an ideal way to review material, acquaint new hires with basic software skills, and train your staff in remote offices.
Anytime Learning sessions offer an unlimited number of viewings during the subscription period.

Course Fee: $0.00 (USD)

Sage MAS 90 and MAS 200: Error 12 SWCOCX 130, "A DLL is either corrupt, not been properly registered, or incorrect version…", when printing graphical forms or Crystal reports

Tuesday, September 1st, 2009

Error 12 SWCOCX 130, "A DLL is either corrupt, not been properly registered, or incorrect version. Please contact your System Administrator" when printing graphical forms.

Possible Resolutions:

Notes:

  • Use extreme caution when editing the Registry. If the Registry is edited incorrectly, Windows may not function properly or may not run at all. Sage Software Support is not responsible for assisting with editing the Registry. Always back up the Registry before accessing it. If necessary, seek the assistance of a qualified computer technician.
  • Sage Software Customer Support is not responsible for assisting with workstation permission issues and takes no responsibility for changes made to your system or for errors in these instructions. Consult your network administrator before making changes.

(more…)

How to use Pivot Tables in Excel

Friday, July 17th, 2009

Here is an ‘oldie but a goodie’ from our original site that we’ve had people ask for often.  This is more relevant for Microsoft Office 2003.  These can be used nicely with all our ERP packages including:

  • Microsoft Dynamics NAV (Navision)
  • Microsoft Dynamics AX (Axapta)
  • Microsoft Dynamics GP (Great Plains)
  • Microsoft Dynamics SL (Solomon)
  • Sage MAS90, MAS200, MAS500 (MAS 90, MAS 200, MAS 500)
  • SAP Business One

PivotTable Reports 101

Let’s suppose you’ve compiled a large list of data – for example, sales figures for every product your company makes. But now you’re ready to distill some meaningful information from the data. For example, you might want to answer the following questions:

· What is the total sales for each product by region?

· Which products are selling best over time?

· Who is your highest-performing salesperson?

For these and other questions, you can create a PivotTable® report – an interactive table that automatically extracts, organizes, and summarizes your data. You can then use the report to analyze the data – for example, make comparisons, detect patterns and relationships, and analyze trends.

pic1

Read on to discover what you can do with a PivotTable report.

(more…)

Office 2010…Clippy Returns…

Wednesday, July 15th, 2009

image I give Microsoft credit.  They are pulling out all stops in their new campaign to generate buzz around the forthcoming Office 2010 suite.  There is a full site called www.office2010themovie.com and we’ve got one of the ‘trailers’ here!

Enjoy!

 

 

 

Windows 7 Upgrade for Free?? Yes it’s Possible.

Thursday, July 9th, 2009

Yes, it is possible to essentially get the Windows 7 upgrade for free. You can now buy a ‘pre-order’ upgrade of Windows 7 premium for less than half price at forPre-Order windows 2 copies now, sell one later and have a net cost of $0. $49.99.  When the deal expires it will cost $119.

The trick is this, just buy two copies now.  Then when it starts shipping (October 22, 2009), sell your extra copy on ebay, craigs list or whatever.  Of course you can’t sell it for the $119 list, but sure you could get $100 bucks.  Right now, upgrade copies of Vista go for $100 on ebay, so surely you can get the same soon after the product is released.

About your only cost is the time value of the extra $50.

Ok, you can call me a cheapskate now.. :)