Get Domain From URL in WPS Spreadsheet: Three Formulas
Extract the domain from a URL column in WPS Spreadsheet with one formula, plus the fallback for older builds, the root-domain version, and a count by domain.
Read more ›Excel Resources
Discover practical techniques and clear examples to handle data, formulas, and charts more effectively in Excel.
Latest
439 ResourcesWildcards in Excel: How to Use *, ? and ~ (With Examples)
Excel wildcards explained: use * for any characters, ? for one, and ~ to escape them in COUNTIF, SUMIF, VLOOKUP, XLOOKUP and Find & Replace, with copy-ready formulas.
Read more ›Bulk Barcode Generator: Create Hundreds of Barcodes From a Spreadsheet
Generate barcodes in bulk: clean the SKU column, pick Code 39, Code 128 or EAN-13, print labels at 100% scale, and scan-test before the full run.
Read more ›Percent to Goal Calculator in Excel: Formula + Free Template
Build a percent to goal calculator in Excel with one formula, percent formatting, data bars, and free template steps that work in WPS Spreadsheet.
Read more ›How to Open, Convert, and Create ETT File
An ett file is a WPS Spreadsheets template used to start new workbooks. Learn how to open one, convert it to Excel, and save your own reusable sheet layout.
Read more ›How to Create an Answer Key for Tests in Excel or WPS Spreadsheet
Learn how to create an answer key for tests in Excel or WPS Spreadsheet: build the key once, handle shuffled test versions with INDEX and MATCH, and grade automatically.
Read more ›How to Make a Donut Chart: When to Use It Instead of a Pie Chart
Learn how to make a donut chart in WPS Spreadsheet, how a donut chart differs from a pie chart, and when a donut chart is the clearer choice for your data.
Read more ›Delta Symbol in Excel: How to Insert Δ in 4 Easy Ways
Insert the delta symbol in Excel in 4 easy ways: the ALT shortcut, a formula, the symbol dialog, and a custom number format, all working free in WPS Spreadsheet.
Read more ›How to Make a Construction Quote Template (Free Download)
Build a construction quote template step by step: header details, itemized materials and labor, tax and totals, plus free templates to edit in WPS Spreadsheet.
Read more ›Weighted Mean Calculator in Excel: Formula and SUMPRODUCT
Build a weighted mean calculator Spreadsheet with SUMPRODUCT: list values and weights, divide by total weight, and avoid common grade-average mistakes.
Read more ›Income Statement Format: Single-Step and Multi-Step Layouts
Choose an income statement format that shows gross profit or a simple net total, then build the rows and formulas in a spreadsheet you can share.
Read more ›How to Use the INT Function in Excel to Round Down Numbers
Learn how to use the INT function in Excel to round down numbers, with syntax, examples, INT vs TRUNC differences, and how it works in WPS Spreadsheet.
Read more ›How to Create an Order Form in Excel (Step-by-Step Guide)
Learn how to create an order form in Excel step by step, from table setup and drop-down lists to auto-calculated totals and a reusable template.
Read more ›How to Make a Trump Approval Rating Graph in Excel (Step-by-Step)
Build a Trump approval rating graph in Excel with free polling data: import, clean, and chart approval vs disapproval over time, then keep it updating.
Read more ›Trend Analysis in Excel: Use the TREND Function (With Examples)
Run trend analysis in Excel with the TREND function: fit a trend line to your data, project future values, and compare TREND with FORECAST, trendlines, and moving averages.
Read more ›Cash Denomination Calculator in Excel: Count Bills and Coins
Break a cash total into bills and coins in Excel: set up the denomination row, use INT with SUM to count each one, and check the result adds back to the exact amount.
Read more ›Stock Price Tracker: Build a Free Portfolio in Excel
Build a stock price tracker in Excel or WPS Spreadsheet: lay out the columns, refresh prices from a CSV, and let formulas show profit, loss, and allocation.
Read more ›Data Points in Excel: How to Find, Label, and Highlight One
Point out a single data point in an Excel or WPS chart: look up the value behind it, add it as its own series, recolor it, and label it with a name.
Read more ›Try what you just learned
Download WPS Office free and open Word, Excel, PowerPoint, and PDF files in one lightweight app.