Skip to content
SimplifyLearn
  • Excel
  • AI Tools
  • Productivity
  • Small Business
  • Templates
  • Cheat Sheets
  • About

Excel & Sheets

Excel for Beginners: 15 Things You Need to Know First

October 26, 2026October 23, 2026 by SimplifyLearn Team
Spreadsheet illustration for an Excel beginners guide

New to Excel? Start with these 15 essentials: workbooks and cells, entering data, formulas, AutoFill, cell references, formatting, sorting, filtering, tables, charts and shortcuts.

Categories Excel & Sheets Leave a comment

How to Split First and Last Names in Excel (4 Easy Ways)

November 9, 2026October 22, 2026 by SimplifyLearn Team
Spreadsheet illustration for splitting names into columns

Split full names into first and last name columns in Excel using Flash Fill, Text to Columns, TEXTSPLIT, or formulas. Includes tips for middle names and Google Sheets.

Categories Excel & Sheets Leave a comment

How to Freeze Rows and Columns in Excel and Google Sheets

November 11, 2026October 21, 2026 by SimplifyLearn Team
Spreadsheet illustration for freezing rows and columns

Keep headers visible while you scroll. Learn how to freeze the top row, first column, or several rows and columns at once in Excel and Google Sheets, and how to unfreeze them.

Categories Excel & Sheets Leave a comment

How to Calculate Percentage Change in Excel (Increase and Decrease)

November 11, 2026October 20, 2026 by SimplifyLearn Team
Spreadsheet illustration showing a +25% percentage change

Learn the simple formula for percentage change in Excel, plus percentage of total, adding or removing a percentage, and how to avoid #DIV/0! errors. With copyable examples.

Categories Excel & Sheets Leave a comment

Why Is My Excel Formula Showing as Text? 5 Quick Fixes

November 11, 2026October 19, 2026 by SimplifyLearn Team
Spreadsheet with a formula displayed as text instead of a result

Excel showing the formula instead of the result? Here are the 5 causes, from Show Formulas mode and Text-formatted cells to a missing equals sign, and how to fix each one.

Categories Excel & Sheets Leave a comment

Google Sheets Formulas Cheat Sheet (Free PDF)

November 11, 2026October 19, 2026 by SimplifyLearn Team
Google Sheets Formulas Cheat Sheet (Free PDF)

Download a free printable Google Sheets formulas cheat sheet: 50+ formulas with examples, including Sheets-only tools like QUERY, IMPORTRANGE, ARRAYFORMULA, GOOGLETRANSLATE and REGEX.

Categories Excel & Sheets Leave a comment

Excel Formulas Cheat Sheet: 52 Formulas for Everyday Work (Free PDF)

November 11, 2026October 19, 2026 by SimplifyLearn Team
Excel Formulas Cheat Sheet: 52 Formulas for Everyday Work (Free PDF)

Download a free 2-page printable Excel formulas cheat sheet: 52 essential formulas with examples (SUMIFS, XLOOKUP, IF, TEXT, dates, FILTER), plus common errors and must-know tips.

Categories Excel & Sheets Leave a comment

How to Use IF, AND, and OR Together in Excel (With Examples)

November 11, 2026October 18, 2026 by SimplifyLearn Team
Spreadsheet illustration for an IF, AND and OR tutorial

Learn the IF function in Excel and how to combine it with AND and OR to test several conditions. Real examples for bonuses, pass/fail grades, overdue invoices and more.

Categories Excel & Sheets Leave a comment

INDEX and MATCH in Excel: The Lookup Combo Explained

November 11, 2026October 17, 2026 by SimplifyLearn Team
Spreadsheet illustration for an INDEX and MATCH tutorial

Learn how INDEX and MATCH work together in Excel to look up values in any direction. Step-by-step examples, two-way lookups, and how it compares to VLOOKUP and XLOOKUP.

Categories Excel & Sheets Leave a comment

Excel Numbers Stored as Text: 6 Ways to Convert Them

November 11, 2026October 16, 2026 by SimplifyLearn Team
Spreadsheet illustration showing text converted to a number

Numbers stored as text break SUM, VLOOKUP and sorting in Excel. Learn how to spot them and 6 quick ways to convert text to numbers, including Text to Columns and VALUE.

Categories Excel & Sheets Leave a comment
Older posts
Newer posts
← Previous Page1 Page2 Page3 Page4 Page5 Next →

Latest guides

  • Microsoft 365 Business Email Setup: Step-by-Step with Your Own Domain
  • Google Sheets for Beginners: Everything You Need to Get Started
  • Google Workspace Email Setup: Step-by-Step for Your Business Domain
  • AI Note Taker for In-Person Meetings: 5 Easy Options
  • AI Note Taker for Microsoft Teams: Copilot, Intelligent Recap and Free Options

Topics

  • AI Tools
  • Excel & Sheets
  • Free Templates
  • Productivity Apps
  • Small Business Tech
  • Privacy Policy
  • Terms
  • Affiliate Disclosure
  • Contact
  • SimplifyDatabase
© 2026 SimplifyLearn • Built with GeneratePress