CompararHojasdeCalculo, Author at Comparar Hojas de Cálculo

How to split text into columns in Excel: names, addresses and codes

Three ways to split names, addresses and codes into several columns: Text to Columns, Flash Fill and formulas such as TEXTBEFORE or TEXTSPLIT.

We look at the advantages and limits of comparing spreadsheets by hand, with formulas, with built-in Excel features and with free online tools.

Best practices for naming, storing and comparing versions of your Excel workbooks so you always know who changed what and when.

Learn how to use FILTER, SORT and UNIQUE to extract, sort and clean up data with a single formula that updates itself.

AutoFilter, multi-level sorting, Advanced Filter and the FILTER and SORT functions: when to use each one, with examples and mistakes to avoid.

What each Excel error means, why it appears and how to fix it with formula examples, without hiding everything behind IFERROR.

With Ctrl+T you turn a list into a table that grows by itself, copies formulas and totals only filtered rows. Here is how to get the most out of it.

Column, line, pie, scatter or combo: learn how to choose the Excel chart that best tells the story of your data and avoid the most common mistakes.

Extract prefixes, names, domains or parts of a code and join text with separators using Excel’s text functions, with practical examples.

Learn how to subtract dates, calculate months and ages with DATEDIF, add deadlines and count working days in Excel, with examples you can copy.