Excel Power UserGet better control over your spreadsheet models, secure your data and reduce the clutter of files
What is XLhub?
- XLhub is an Excel add-in for data management
- It enables the creation of complex spreadsheet models and simplifies reporting.
- With XLhub, data in spreadsheets can be saved to a central repository (hub). From the hub, it can be retrieved into other spreadsheets or reports.
- When data is saved, the user’s ID and a timestamp is also saved
- Only users with the appropriate permissions can retrieve other people’s data into their spreadsheet.
What Problems Does It Solve?
From an IT Manager’s perspective, XLhub solves the following problems:
- Files clutter up the network and email system because each snapshot of the data is saved with a different file name (using “File Save As”)
- Confidential data is exposed because permissions are hard to manage with Excel files cluttered about Inboxes, local folders and thumb drives
- The business creates “homegrown” applications using Microsoft Excel or Access, resulting in islands of data
- The business purchases software products that are not compliant with IT standards, and the IT department has to play gatekeeper
- Reporting on data spread across multiple files requires manually copying/pasting data
- It is hard to compare the contents of different files and see what changed
- Spreadsheets with complex models become brittle due to links and references across sheets
What Can I Do With It?
- Rapidly provide applications to the business that are based on tools you already have (Microsoft Excel, SQL Server)
- Implement security with Active Directory (XLhub supports both Windows Authentication and SQL Server Authentication)
- Integrate Excel into your Enterprise Architecture
- Easily create reports from multiple spreadsheets
- Make complex spreadsheet models maintainable and extensible
- Reduce Excel file clutter. Each snapshot of the data can be saved to the hub instead of “File Save As” with a new file name.
What Kind of Applications Can I create Using Excel?
Do you have situations where several co-workers modify data in Excel, and then reports have to be created with the combined data? See our App Store for “ready-to-go” examples. Below are some applications that XLhub was designed for:
- Time Tracking – Enable your employees to submit their timesheets from Excel. Automatically consolidate the submissions, create invoices, create reports, and flag exceptions
- Sales Reporting – Track sales reports from multiple regional sales reps. Easily slice and dice the data
- Budgeting – Create a multi-user budgeting application, preserve all versions of budgets requested and approved)
Is It Easy to Implement?
- Yes. Benefits can be realized within hours.
- Sample application and training videos are available on this site
- No programming skills are required to be up and running
- Applications built with XLhub can be highly customized with SQL knowledge (stored procedures)
Where Can I Get More Information?
- See videos, white papers on this website
- See our FAQ
- Best of all, contact us by chat right now.
XLhub and SQL Server Extend the Capabilities of Excel
|With Excel:||With Excel and XLhub:|
|Data is locked inside spreadsheet files||Make data in spreadsheets accessible to other spreadsheets and applications|
|Multi-user sharing often involves time-consuming re-entry and cutting/pasting||Prevent routine cutting and pasting from multiple sources|
|Workbooks can only be edited by one user at a time||Allow simultaneous multi-user access to data|
|Files are duplicated excessively to track versions and to share spreadsheets between multiple users||Eliminate the need to duplicate files|
|Changes to the data are difficult to track||Add a full audit trail to your data|
|No version control||Use versioning to roll back changes to any particular version|
|Security and access control are difficult to provide||Add a security and access layer to Excel|
XLhub Offers Full Integration with SQL Server
XLhub is designed to fully integrate Excel with SQL Server, allowing two-way data transfer. If you depend on Excel and need to save your data to SQL Server, make XLhub your simple solution and extend the capabilities of Excel even further.