SpreadsheetWeb blog

Practical thinking for spreadsheet-powered teams

Deep guides on Excel, Google Sheets, web applications, product workflows, and the quiet technical traps worth knowing about.

Page 53 of 55 · 1312 articles

Adam · Jun 20, 2017

INDIRECT Formula and Proper Referencing

Indirect function will save you a lot of headache and give your spreadsheets advanced capabilities like preventing user errors, or precision referencing.

Adam · Jun 14, 2017

Excel's Dynamic Charts: A Tutorial On How To Make Life Easier

Thanks to Excel’s dynamic charts, you can ‘build-and-forget’ a dashboard, because it’s going to keep updating automatically, and save you time.

Adam · Jun 5, 2017

Create Your Own Custom Time Cards in Excel

Billing clients or tracking employee hours can differ greatly for various industries and time cards that help this process are rarely one-size-fits-all.

Adam · May 23, 2017

What's New in Version 5.2

What's new in SpreadsheetWEB? This update exclusively focuses on Excel’s conditional formatting feature and adding it is a breeze.

Adam · May 23, 2017

Pagos SpreadsheetWEB Now Supports One of the Most Commonly Used Spreadsheet Features: Conditional Formatting

Read the announcement about pagos SpreadsheetWEB Now Supports One of the Most Commonly Used Spreadsheet Features: Conditional Formatting and the SpreadsheetWeb capabilities introduced in this release.

Adam · May 19, 2017

5 Most Popular Excel Templates

Not all of us are Excel gurus so it’s often a good idea to search online for popular Excel templates when trying to create complicated designs.

Adam · May 18, 2017

Pagos Recognized as One of the 20 Most Promising Insurance Technology Solution Providers by CIO Review

Pagos, an IT solutions company, has been named one of the 20 Most Promising Insurance Technology Solution Providers of 2017 by CIO Review.

Ugur · Apr 14, 2017

Turning Excel Hell into Excel Heaven

A focused overview of turning Excel Hell into Excel Heaven, explaining the main ideas, practical considerations, and relevant examples.

Adam · Mar 23, 2017

Integrating Advanced Calculations into HubSpot using SpreadsheetWEB API

HubSpot is a very powerful and flexible platform for marketing. You can go outside the box by integrating a calculation engine into your HubSpot suite!

Faruk · Mar 20, 2017

Comparing the Performance of Pagos SpreadsheetWEB with Google Sheets and the Microsoft Office 365 Excel API

A focused overview of comparing the Performance of Pagos SpreadsheetWEB with Google Sheets and the Microsoft Office 365 Excel API, explaining the main ideas, practical considerations, and relevant examples.

Adam · Mar 14, 2017

Converted versus Custom UI Applications in SpreadsheetWEB

Explore Converted versus Custom UI Applications in SpreadsheetWEB, with a focused look at development Process, look-and-Feel, and responsive Design.

Adam · Mar 7, 2017

SpreadsheetWeb Gives Financial Modeling a New Platform

Excel is the go-to platform for many businesses when it comes to developing mathematical models. Its reliability, ease of use and flexibility make designing such tools far easier to create as a workbook than using specialized software.

Adam · Mar 3, 2017

Using Database Connections in SpreadsheetWEB

Decoupling database elements from Excel workbooks can result in much smaller files and significantly faster load speeds when deployed on the web.

Adam · Feb 13, 2017

What's New in Version 5.1

Driven by the needs of our users, our goal has always been to evolve SpreadsheetWeb into an easy-to-use platform that everyday business users can utilize.

Adam · Feb 7, 2017

SpreadsheetWEB 5.1 Provides Businesses with better Control over Access to their Spreadsheets

Pagos announces the release of SpreadsheetWEB 5.1 that includes new access control features for better integration with corporate systems.

Ugur · Jan 18, 2017

8 Things to Consider when Building Online Calculators

A focused overview of 8 Things to Consider when Building Online Calculators, explaining the main ideas, practical considerations, and relevant examples.

Adam · Dec 6, 2016

Custom Development versus SpreadsheetWEB: Cost and Time-to-Market Comparison

SpreadsheetWeb offers an alternative to custom development, turning Excel-based tools into web applications with little-to-no programming experience.

Adam · Dec 2, 2016

What's New in Version 5.0

SpreadsheetWeb has seen one if its biggest updates ever. Completely overhauled control panel and a responsive, mobile-enabled platform.

Adam · Nov 30, 2016

With a Completely New Interface, Pagos SpreadsheetWEB 5.0 Makes Transforming Spreadsheets Into Web Applications Easier Than Ever

SpreadsheetWEB gets a complete facelift with 5.0 – featuring a brand new user interface that aims to make it even easier to move spreadsheets to the web.

Daneen · Nov 16, 2016

Helping You Generate Leads with Interactive ROI Calculators

A focused overview of helping You Generate Leads with Interactive ROI Calculators, explaining the main ideas, practical considerations, and relevant examples.

Adam · Aug 24, 2016

SpreadsheetWEB Provides a Convenient Environment for Insurance Quoting Tools

Be it schedule rating, experience rating or retrospective rating; actuaries use data to build complex algorithms to determine premiums and offer customers the best deals available. However, tools that can keep up with an evolving market and...

Adam · Jun 8, 2016

Integrating Complex Spreadsheet Calculations with SalesForce

Repost from Medium Since basically everyone is an Excel user in today’s business world, many companies, naturally rely on spreadsheets to create pricing tools for their sales people. Excel offers thousands of features that makes this process...

Adam · May 5, 2016

Implementing Iterative Calculations with SpreadsheetWEB

Iterative calculations can help solving problems with several variables. They find use in pretty much every field and businesses use this logic in assessing risk or determining general characteristics of a solution pool.

Adam · Mar 11, 2016

What’s New in Version 4.8

Businesses today have to rely on Microsoft Excel for their data tasks, because it has an easy learning curve and tons of readily available tools to create a complicated model. SpreadsheetWEB is the ultimate supplement to Excel; it plugs in...