Notice: Function _load_textdomain_just_in_time was called incorrectly. Translation loading for the boomdevs-toc domain was triggered too early. This is usually an indicator for some code in the plugin or theme running too early. Translations should be loaded at the init action or later. Please see Debugging in WordPress for more information. (This message was added in version 6.7.0.) in /home/zlm0ahcg2s4c/public_html/wp-includes/functions.php on line 6131

Warning: Undefined array key "offset_from_top" in /home/zlm0ahcg2s4c/public_html/wp-content/plugins/top-table-of-contents/public/class-boomdevs-toc-public.php on line 517
Excel Functions and Formulas Archives - Excellopedia
Skip to content

Excellopedia

  • Blog
  • Introduction & Basics
    • Excel Introduction & Basics
    • Word Basics
  • AI in MS Office
  • Keyboard Shortcuts
    • Excel Keyboard Shortcuts
    • Word Keyboard Shortcuts
  • Glossary
    • Glossary of Excel Terms
    • Glossary of Word Terms

Excellopedia

  • Blog
  • Introduction & Basics
    • Excel Introduction & Basics
    • Word Basics
  • AI in MS Office
  • Keyboard Shortcuts
    • Excel Keyboard Shortcuts
    • Word Keyboard Shortcuts
  • Glossary
    • Glossary of Excel Terms
    • Glossary of Word Terms

Category: Excel Functions and Formulas

Excel functions and formulas help you perform calculations and analyze data in Microsoft Excel. They are used to add numbers, find averages, apply conditions, and solve real-world problems.

This section includes simple tutorials on basic and advanced Excel formulas. You will learn functions like SUM, AVERAGE, IF, VLOOKUP, and more with step-by-step examples.

These guides are useful for beginners and professionals who want to improve their Excel skills and work more efficiently

Standard Deviation in Excel: STDEV.S vs STDEV.P Explained Simply

Excel Cell References – Relative, Absolute and Mixed

Ranking in Excel: RANK, RANK.EQ, RANK.AVG, and Dense Rank Explained

LARGE & SMALL Functions in Excel – Find the Kth Largest and Smallest Values

MAX & MIN Functions in Excel – Find the Largest and Smallest Values Easily

COUNTBLANK Function in Excel – Count Empty Cells Easily

 COUNTIFS Function in Excel – Count With Multiple Conditions

COUNTIF Function in Excel – Count With One Condition Easily

COUNTA Function in Excel – Count All Non-Empty Cells

Posts pagination

1 2 3 >

Recent Posts

  • What Is AI in Excel? (Copilot, Formulas, and Smart Features Explained)
  • Standard Deviation in Excel: STDEV.S vs STDEV.P Explained Simply
  • Excel Cell References – Relative, Absolute and Mixed
  • Ranking in Excel: RANK, RANK.EQ, RANK.AVG, and Dense Rank Explained
  • LARGE & SMALL Functions in Excel – Find the Kth Largest and Smallest Values

Categories

  • Excel Basics
  • Excel Formatting
  • Excel Functions and Formulas
  • Excel Keyboard Shortcuts
  • Excel to Word
  • Function Keys in MS Office
  • Microsoft Excel
  • Microsoft Word
  • Word Keyboard shortcuts

Quick links

Email: excellopedia@gmail.com

  • Contact
  • Privacy Policy

Learn

  • Excel
  • Excel Keyboard Shortcuts:
  • Excel Introduction & Basics
  • Basic Text Editing in Microsoft Word
  • Glossary of Excel Terms:
  • Mastering Excel Formatting:
  • Microsoft Word Hub – Excellopedia
  • Microsoft Word Basics and Getting Started Guide
  • Microsoft Word Keyboard Shortcuts for Efficient Editing
  • Glossary of Microsoft Word Terms
  • Excel Ribbon Tabs & Groups – A Complete Guide
  • Basic Formulas & Functions in Excel – Complete Guide
  • Basic Tables in Excel: A Complete Guide
  • Conditional Formatting in Excel – A Complete Guide for Beginners
  • Pivot Tables in Excel – A Complete Beginner’s Guide
  • Artificial Intelligence (AI) in Microsoft Office
  • Advanced Functions in Excel – Complete Guide

Follow Me

  • Facebook
  • Twitter
  • YouTube
  • Instagram

← Back

Thank you for your response. ✨

© 2026 Excellopedia.