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 47 of 55 · 1312 articles
How to hide formulas in Excel using the Protect Sheet feature
This article shows how to hide formulas in Excel using the Protect Sheet feature to prevent users from editing or seeing your formulas.
How to use a wildcard in Excel formula
Excel supports wildcard characters in formulas. Let us show you how to use a wildcard in Excel formula to find data that is partially known.
What's New in SpreadsheetWEB 6.4
In SpreadsheetWEB 6.4, we’ve added a completely new way to interact with input grids and a new way to bring visualizations to life.
SpreadsheetWEB 6.4 Now Available
Pagos, Inc. today announced the release of SpreadsheetWEB 6.4 version, featuring form-based grids, and enhanced visualization capabilities.
With Autofill Excel Shows Its Smarts and Saves You Time
Copy-paste tasks to automatically creating entire tables, with autofill Excel will save you a ton of headache and time.
Data Validation: Excel Doing the Data Cleaning for You
Data validation Excel doing your data cleaning for you by preventing data entry errors before they happen.
How to delete blank rows in Excel using Power Query
There are various methods to do this, but in this article we're going to focus on how to delete blank rows in Excel using Power Query.
How to remove blank rows in Excel using sorting
In this article, we're going to show you one of the easiest methods for organizing data and how to remove blank rows in Excel using sorting.
The crux of organizing your data: How to sort in Excel
In this article, we’re going to show you the best ways to organize data, how to sort in Excel, and walk you through available tools.
How to calculate standard deviation in Excel
In this article, we're going to show you how to calculate standard deviation in Excel using the STDEV.S and STDEV.P functions.
How to calculate mean in Excel
Learn how to calculate mean in Excel. This practical guide covers the formula syntax, setup steps, and how the result is calculated in Excel.
How to stop excel from changing numbers to dates
Excel changes numbers or strings into dates to be "user-friendly". We're going to show you how to stop Excel from changing numbers to dates.
How to Disable Excel Automatic Calculations
In this article we're going to show you how todisable excel automatic calculations and avoid recalculating at every step.
How to merge cells in excel without losing data
Merge & Center feature removes cell data. In this article, we're going to show you how to merge cells in Excel without losing your data.
Connect Your Data Sources and Automate Updates with Excel Data Connection
Periodically updating spreadsheet data can be time consuming. Data connection features establish links with other data sources.
A Guide to Custom Sorting in Excel
Say you want to sort data starting with "Low", then "Medium", and "High". Let us show you how to sort in Excel in a custom order.
How to copy a formula in Excel between workbooks without links using a text editor
In this article we're going to show you how to copy a formula in Excel between workbooks without links, in a hassle-free fashion.
How to create a year-by-year average calculator
AVERAGEIF(S) functions lack array abilities. Let us show you How to create a year-by-year average calculator using the SUMPRODUCT function.
How to count cells in Excel by year
Grouping or counting items by date can be challenging. Learn how to count cells in Excel by year using SUMPRODUCT, YEAR and N functions!
How to use DAX Functions in Pivot Tables
DAX functions help manage and transform your data in Microsoft's data analysis tools like PowerPivot and Power BI Desktop.
Utilizing Web Services in Excel Using Formulas
User inputs, data exports, and even web services can provide data for your workbooks. Let us show you how to consume data using formulas.
What’s New in SpreadsheetWeb 6.3
the new dashboard platform is also included in all licenses of SpreadsheetWEB. This new tool features 12 charts, 25 diagrams, 7 maps, 4 gauges, and 2 data tables, each offering a unique and intuitive way to present your data.
Pagos Announces the Release of SpreadsheetWEB 6.3 Featuring a New Dashboard Module and Improved Calculation Engine
With this update, SpreadsheetWEB introduces a brand new dashboarding tool, an improved calculation engine, and Excel export.
Data Analysis in Excel: PivotTables versus COUNTIFS, SUMIFS, AVERAGEIFS formulas
Data analysis in Excel can be done by using formulas, but Excel’s PivotTables make it a breeze organizing and presenting data.