Sigline Guides

Step-by-step guides — Excel formula walkthroughs, email signature guides, examples, troubleshooting, and practical tools.

How to Write a SUMIF Formula in Excel (2026 Guide)

SUMIF, explained plainly: the syntax, 5 real examples (text, numbers, dates, wildcards, SUMIFS), and the 4 mistakes that break it.

Read the guide →

VLOOKUP vs XLOOKUP: Which One Should You Use? (2026 Guide)

The honest comparison: syntax, what each one can and cannot do, when to keep VLOOKUP, and when XLOOKUP wins — with real examples.

Read the guide →

How to Use INDEX and MATCH Together in Excel (2026 Guide)

What each one does alone, the lookup that replaces VLOOKUP, a two-way lookup, and the 3 mistakes that break it.

Read the guide →

Excel IF Formula: How to Write One, With Examples (2026 Guide)

The IF syntax once, then five examples that cover nearly every IF you will ever write — pass/fail, grades, IFS, AND/OR, IFERROR.

Read the guide →

How to Combine Text in Excel: CONCAT, TEXTJOIN and & (2026 Guide)

Three ways to glue text together — when to use each, with real examples for full names, addresses, and lists, and the mistakes that break them.

Read the guide →

Why Is My Outlook Signature Not Showing Images? (Fix Guide)

Broken image icons or red X in Outlook? Six real fixes: public image hosting, download settings, size limits, and the recipient-side problem.

Read the guide →

Email Signature Size Guide: Photo, Logo & Banner Dimensions

Exact dimensions for headshots, logos, banners, and social icons — plus formats, retina rules, and file-size limits that keep signatures fast.

Read the guide →

How to Convert a Bank Statement PDF to Excel (2026 Guide)

Four methods compared — Excel's built-in import, copy-paste, online converters, and a free tool that never uploads your file. Plus the 2-minute sanity check.

Read the guide →

How to Add an Email Signature in Gmail (2026 Guide)

Step-by-step: create a Gmail signature on desktop and mobile, paste a formatted signature, and fix images. Free generator included.

Read the guide →

How to Add an Email Signature in Outlook (2026 Guide)

Add a signature in Outlook on Windows, Mac, and the web: exact steps for classic and new Outlook, plus defaults for replies.

Read the guide →

7 Professional Email Signature Examples for Realtors

Realtor email signature examples with photos, listings links, and compliance lines — plus what to include and what to skip.

Read the guide →

How to Add a Photo or Logo to Your Email Signature

Add a headshot or logo to your Gmail or Outlook signature: hosting, sizing, and step-by-step instructions that actually work.

Read the guide →

How to Add a GIF to Your Email Signature (2026 Guide)

Add an animated GIF to your Gmail or Outlook signature — steps, size limits, the Outlook first-frame gotcha, and fun-but-professional ideas.

Read the guide →