1. Building Information Systems with Excel Server

Organization, Roles, and Users

The core purpose of an information system is to "connect the right people with the right information at the right time." Such systems are designed for collaboration across various organizational roles, each holding distinct responsibilities and data access permissions. Within Excel Server, the "Management Console" module allows effortless configuration of organizational structures (departments), roles (functional duties), and individual user accounts.

Organization, Roles, and Users

2. Information Systems Composed of "Forms"

An information system manages all types of organizational data, including business documents, statistical reports, ledgers, and index cards. This data must be stored centrally, shared collaboratively, routed systematically, and utilized effectively. In Excel Server, all managed data entities are unified under the fundamental concept of "Forms."

Core Concept: Form = Interface Template + Data Processing Rules

Sales Order Form Example
Figure 1-2: Defining the layout and template for a form

With this form defined, authorized users can enter business data according to the layout and save it directly into the central database:

Data entry via form saved to database
Figure 1-3: Entering data via "Forms" and storing it into the central database

Beyond spreadsheet layouts, you can flexibly configure additional rules for Forms:

  • Form Permissions: For instance, sales representatives can only view orders they created, while sales managers and executives can access all order records.
  • Workflows: Define routing logic and approval flows across different roles.
Graphical Workflow Definition
Figure 1-4: Defining workflows visually using graphical flowcharts
  • Data Input Validation: Automatically generate order numbers, default the creator's name to the logged-in account, or restrict field entries using drop-down lists.
  • Cross-Table Formulas: Reference and pull data seamlessly across different forms (e.g., populating customer names from a "Customer Registration Form").

3. Operating via a Familiar Spreadsheet Interface

Building an information system in Excel Server begins by designing template layouts. And there is no better tool for designing tables than spreadsheet software like Microsoft Excel!

Operating through familiar Excel interface
Figure 1-5: Operating systems seamlessly through the familiar Excel interface

By leveraging familiar spreadsheet interactions, end users can master system operations with minimal training. This eliminates user resistance, slashes training costs, and drastically improves the success rate of enterprise digital transformation.

4. Excel Server ≠ Standalone Excel

Excel Server is neither a simple Excel add-in nor a direct replacement for Excel. Although it utilizes Excel spreadsheets as its desktop client interface, Excel Server is a full-fledged enterprise management software system:

Purpose & Scope

Excel is a desktop tool for personal or small group productivity. Excel Server builds enterprise-wide management information systems.

Extended Features

Includes user role permissions, automated workflows, web access, SMS/Email notifications, and external system integrations.

Data Management

Data is no longer scattered in individual `.xlsx` files; all information is stored centrally in an industrial-grade database (e.g., MS SQL Server).

Architecture

Built on a robust three-tier architecture, allowing operation through client applications or web browsers.

5. Empowering Users with Independent Information Control

The core philosophy of Excel Server is "User Autonomy." It empowers business managers and key domain experts to lead digital initiatives without relying entirely on external developers or IT specialists:

  • Self-Defined Requirements: System features are tailored directly from real-world business needs rather than forcing companies to adapt to rigid software packages.
  • No-Code Development: Building forms and logic requires no programming skills. Designing system modules becomes a natural extension of regular business management work.
  • Agile Implementation: Organizations can digitize workflows step by step, continuously optimizing and refining systems without disrupting ongoing operations.