spacer


New Products


 

     
 
   Especially Designed to learn Microsoft Excel as you analyze your business.





This product is designed for Excel 97/2003/2007/2010/2013. 


One of several email suggestions that made an impact on us and prompted the creation of Systakon™.

Hi JaxWorks Team,
   

I am fairly new to Excel and have been plugging along with a sales analysis report at a crawl. Whenever I need to do something, like enter a forecast formula, I have to stop and research for the answer through ginormous help files and hardback references.
   
It would really help if there was an Excel reference manual built right into one of your analysis products.
   
Please Help!!!
                                                                                                                                             
 RJJ, Topeka, Kansas
 

Systakon™ is 2 systems in one.

     1) It is a Comprehensive Excel Training Tutorial and a

     2) Comprehensive Business Analysis System.

      The Systakon™ Excel Tutorial is an Adobe Acrobat PDF document that is only a click away from any worksheet within the
      Systakon™ Business Analysis System.

The Systakon™ Excel Tutorial
You have instant access to a 918 page Excel 97/ 2003 PDF Tutorial System for easy referencing to all key Excel features, and hyperlinked through Systakon™ Business Analysis System. Using the PDF built-in search function (Control-F) you can find the topic you need and how
to do it Step-by-Step.

Details: The tutorial is hyperlinked from its table of contents to all key features and functions of Excel for easy search. It starts at the very basics of Excel 97/2003 and gradually increases in rigor toward more advanced Excel features.

The Systakon™ Business Analysis System
You can customize Systakon™ analysis system with the click of a few buttons:
     1) Click the number of financial periods that you desire for posting: 4 through 12 periods.
     2) Click a Z-Score class: Public, Private, Non-manufacturing.
     3) Click a business category: Manufacturing, Service, Retail, Wholesale, or Job Shop.
     4) Set up as "C" corp. or "S" corp.
     5) Choose Year, Month, or Quarter configurations.
     6) Click this button on any worksheet to activate the The Systakon™ Excel Tutorial.

In seconds you are setup to analyze almost any business the way you want it and print an over 80 page report .

You will need the Adobe Acrobat Reader installed for the tutorial.

Click this Button to Download and install >


Minimum System Requirements:
Microsoft's Minimum Requirements For Office Excel 2003
CPU
500-megahertz (MHz) processor or higher; 1 gigahertz (GHz) required for Outlook with Business Contact Manager
Memory
256 megabytes (MB) of RAM or higher; 512 MB recommended for graphics features, Outlook Instant Search, Outlook with Business Contact Manager, Communicator, and certain advanced functionality
Hard disk
3.5 gigabyte (GB) available disk space
Display
1024 × 768 or higher-resolution monitor
Operating system
Windows XP with Service Pack (SP) 3 (32-bit), Windows Vista with SP1 (32-bit or 64-bit), Windows Server 2003 R2 (32-bit or 64-bit) with MSXML 6.0 installed, Windows Server 2008 or later (32-bit or 64-bit), Windows 7 (32-bit or 64-bit). Terminal Server and Windows on Windows (WOW) (which allows installing 32-bit versions of Office 2010 on 64-bit operating systems) are supported
 

TOC and Screen Shots From The Systakon™ Tutorial

Systakon™ Tutorial Table of Contents
918 pages - 57 Chapters - All Indexed For Searching and Hyperlinked For Fast Chapter Access
CHAPTER 1 - EXPLORING EXCEL
CHAPTER 2 - WORKING WITH THE OFFICE ASSISTANT
CHAPTER 3 - USING BASIC WORKBOOK SKILLS
CHAPTER 4 - WORKING WITH RANGES
CHAPTER 5 - CREATING SIMPLE FORMULAS
CHAPTER 6 - COPYING AND MOVING DATA
CHAPTER 7 - PRINTING
CHAPTER 8 - USING PAGE SETUP
CHAPTER 9 - FORMATTING NUMBERS
CHAPTER 10 - FORMATTING TEXT
CHAPTER 11 - WORKING WITH COLUMNS AND ROWS
CHAPTER 12 - FORMATTING CELLS
CHAPTER 13 - USING ONLINE HELP
CHAPTER 14 - USING AUTOMATIC FORMATTING AND STYLES
CHAPTER 15 - WORKING WITH DATA SERIES
CHAPTER 16 - USING CONDITIONAL AND CUSTOM FORMATS
CHAPTER 17 - USING LARGE WORKSHEETS
CHAPTER 18 - WORKING WITH MULTIPLE WORKSHEETS
CHAPTER 19 - MANAGING WORKSHEETS
CHAPTER 20 - WORKING WITH OUTLINES
CHAPTER 21 - USING PASTE SPECIAL
CHAPTER 22 - WORKING WITH LABELS IN FORMULAS
CHAPTER 23 - MANAGING FILES
CHAPTER 24 - MANAGING DATA
CHAPTER 25 - USING MULTIPLE WORKBOOKS
CHAPTER 26 - WORKING WITH DATABASES
CHAPTER 27 - WORKING WITH THE DATA FORM
CHAPTER 28 - USING AUTOFILTER
CHAPTER 29 - WORKING WITH ADVANCED FILTERS
CHAPTER 30 - USING HTML FILES
CHAPTER 31 - EXPORTING AND IMPORTING DATA
CHAPTER 32 - CREATING CHARTS
CHAPTER 33 - FORMATTING CHARTS
CHAPTER 34 - ADVANCED CHARTING
CHAPTER 35 - DRAWING AN OBJECT
CHAPTER 36 - USING ADDITIONAL EFFECTS AND OBJECTS
CHAPTER 37 - USING AUTOSHAPES AND DIAGRAMS
CHAPTER 38 - USING OTHER FUNCTIONS
CHAPTER 39 - USING RANGE NAMES
CHAPTER 40 - USING ADVANCED FUNCTIONS
CHAPTER 41 - USING DATA TABLES
CHAPTER 42 - USING MACROS
CHAPTER 43 - RECORDING MACROS
CHAPTER 44 - EDITING MACROS
CHAPTER 45 - USING CUSTOM TOOLBARS AND MENUS
CHAPTER 46 - CREATING A MACRO BUTTON
CHAPTER 47 - USING WORKSHEET PROTECTION
CHAPTER 48 - CUSTOMIZING EXCEL PREFERENCES
CHAPTER 49 - USING TEMPLATES
CHAPTER 50 - CREATING/REVISING PIVOTTABLES
CHAPTER 51 - WORKING WITH COMMENTS
CHAPTER 52 - WORKING WITH VIEWS
CHAPTER 53 - SOLVING PROBLEMS
CHAPTER 54 - USING SCENARIOS AND GOAL SEEKING
CHAPTER 55 - USING AUDITING TOOLS
CHAPTER 56 - SHARING WORKBOOKS
CHAPTER 57 - CONSOLIDATING WORKSHEETS
INDEX
    
 
 
 
 
 
 
 
 
 

Table of Contents and Screen Shots From
The Systakon™ Business Analysis System

Systakon™ Business Analysis System - Table of Contents
90 Worksheets - Prints 180 Page Financial REport - All  Hyperlinked For Fast Worksheet Access
Average Collection Period
BE Adjusted
Breakdown of Costs
Breakeven Analysis (1)
Breakeven Analysis (10)
Breakeven Analysis (11)
Breakeven Analysis (12)
Breakeven Analysis (2)
Breakeven Analysis (3)
Breakeven Analysis (4)
Breakeven Analysis (5)
Breakeven Analysis (6)
Breakeven Analysis (7)
Breakeven Analysis (8)
Breakeven Analysis (9)
Break-Even Applied
Breakeven Summary
Cash Flow 4 Periods
Cash Flow 8 Periods
Cash Flow Data Entry
Cash Flow Sensitivity Analysis
Cash Flow Sensitivity AR
Comp. Balance Sheet
Comp. Income Statement
Copyright
Corporate Headcount Analysis
Cover Sheet
Current Ratio
Current Summary Chart
Dashboard
Debt Ratio
Earnings Per Share
Equity Ratio
Executive Summary
Expanded Ratios
Expense Analysis
Expense Budget
Financial Summary
Forecast Analysis
G&A Expenses Chart
Gross Profit Margin
Industry Analysis
Introduction
Inventory Turnover Ratio
Labor Expenses Chart
License Agreement
Logit Analysis
Market Value Analysis
Market Value Explained
Master Data Entry
Master Index
Materials Cost Chart
Net Profit Margin
Optimal Performance
Ownership Chart
Payroll Analysis
Profit Chart
Proforma Balance
Proforma Income
Quick Ratio
Ratios Introduction
Return on Assets
Return on Equity
Return-on-investment analysis
Sales Performance Chart
Sales Projection Chart
Sales vs. Expense
SB Headcount Analysis
Snapshot
Snapshot (10)
Snapshot (11)
Snapshot (12)
Snapshot (2)
Snapshot (3)
Snapshot (4)
Snapshot (5)
Snapshot (6)
Snapshot (7)
Snapshot (8)
Snapshot (9)
Snapshot Summary Chart
Springate
Stock Valuation
Summary Analysis
Times Interest Earned Ratio
Total Expenses Chart
Z-Score Analysis (1)
Z-Score Analysis (2)
Z-Score Analysis (3)
Z-Score Explained
 
 
 
 
 
 -
 
 
 
 
 
 
 
 
 
 
 




Go To Top
 
 

© Copyright, 2013, JaxWorks, All Rights Reserved.  | Privacy Statement | Terms of Use