Want to learn the new Excel 2007/2010 fast but don't have time to take night classes or online tutorials? This guide has almost 150 pages of dealership specific examples, tutorials, and lessons for all levels of Excel users - from beginner to advanced - using data from your DMS system. Along the way, we’ll be covering some topics that will hopefully enlighten you as to some of the capabilities of Excel including Super Formulas -- handy formulas such as OFFSET and multiple-condition AND/OR statements, how to use arrays in formulas, quick little tips on Excel shortcuts, and more. It includes Super workbooks like;
Gross Book Analysis. This workbook will use information from a gross book report file and allow the end-user to view and analyze the performance of the salespeople. We’ll also begin building a salesperson commission workbook which will allow us to enter our commission information in an efficient way by building a workbook with a good foundation and flexibility
Excel and Outlook Sales Commission- a two-part application, where Excel creates workbooks on its own based on a master workbook. We’ll be continuing with our commission workbook and adding some code to it. A simple Outlook macro then takes those newly created spreadsheets and emails them to the designated recipients. What a time-saver!!!
Included is an Excel 2007 simple tutorial that includes a Pivot Table and the AutoFilter with the instructions for both 97-2003 and the new Excel 2007. This enables those of you who are still using the older Excel to have a tutorial, but those of you who are struggling with Excel 2007 – to have “quick start” method to convert to the newer version.
Need to extract from a DMS system?Contains information on getting data out of ADP’s new Web Suite 2007, websuite 1000 (Alliance,) ARG (former EDS,) Arkona, ACS, Auto/Mate, DPC, Dubuque, R+R Eralink, and R+R Power (UCS). There are two versions; a PDF file (eBook) to read on screen and the files that are zipped and emailed (you need to be able to receive a 7MB file) and the regular printed copy and CD containing the files and eBook pdf file. Works with Excel 97-2003 and the new 2007 or 2010 Excel.
Are you tired of trying to use your DMS system's DOC? Do you need better reporting - more visual for your managers? Previously (and currently) included with the Advanced ADP Programming book, the Excel Super DOC is now updated, improved and available as a separate product. Some of the features include:
The DOC page. An overview analysis of your dealership's gross profit. Includes a per-unit analysis for vehicles, and GP snapshots of all departments. A series of charts allow you to instantly see where you are compared to your target and last year's numbers.
The Analysis page. Examines the numbers extracted from your income and expense report. Compares current numbers with last year's and current year targets. Handy feature allows you to switch between actual and estimated expenses, which you can fine-tune, based on your expense expectations!
The Charts page. Here you can see timelines for current year against target and last year for any department or total dealership. Select the department and category (sales, GP, expenses, or net), and all charts on the page instantly update to examine your selection.
Super DOC has the new Department DOC Pages. The Super DOC Plus! includes individualized DOC pages for New Car, Pre-Owned, Parts, Service, and Body Shop.
ADP and Arkona users have an import from standard ADP and Arkona reports. For R+R and other system users, use our easy import template to automate your import.