Basic Excel Fundamentals

Learn the basic building blocks of Excel:

Basic Excel Functions

Learn Excel Formula which are very basic to run Excel for Everyday Life:

  • Combining text (Concat,Text Join, Concatenate, Ampersand)
  • Upper lower and Proper
  • Text Extracting Functions
  • How to Use INDEX and MATCH with Multiple Criteria in Excel
  • Simplifying Complex Calculations with SUMPRODUCT and IF in Excel
  • How to Do a Left Lookup in Excel with VLOOKUP
  • Lookup Function Array Function
  • TEXT Function in Microsoft Excel: A Comprehensive Guide to Number Formats
  • Types of Lookup Functions in Excel
  • Excel DATE Function Guide: Syntax, Arguments and Examples
  • Mastering Excel's WORKDAY.INTL Function
  • Excel's Volatile Functions
  • Excel Empowerment: Harnessing the Potential of the SUBSTITUTE Function
  • VLOOKUP vs XLOOKUP - Choosing the Right Formula

    • বাংলা ব্লগ

    বাংলায় প্রকাশিত সকল ব্লগসমূহ:

  • এক্সেলে জটিল গণনাকে সহজ করুন: SUMPRODUCT ফর্মুলার ব্যবহার
  • কিভাবে এক্সেলে একাধিক ক্রাইটেরিয়ার জন্য INDEX এবং MATCH ব্যবহার করবেন ?
  • কীভাবে Excel-এ VLOOKUP ব্যবহার করে বাম দিকে লুকআপ করবেন
  • Substitute function কী এবং এর ব্যবহার
  • IF Function
  • Vlookup থেকে #N/A Error কিভাবে Ignore করা যায়।
  • MIN Function
  • Max Function
  • Average Function
  • Sum Function
  • VLOOKUP Function
  • Excel Formulas and Functions
  • How to Create Custom Series
  • Excel 365 ব্যবহারের সুবিধা
  • Data Validation
  • Autofill-Options of Fill Handle
  • Fill Handle
  • Conditional Formatting
  • Format Spreadsheet
  • Copy and Paste With Transpose
  • Working With Multiple worksheets

    • Excel Data Management

    Learn how Excel Manage data:

  • How to Use Data Validation in Excel

    • Excel for Analysis

    Learn how to use Excel for analysis

  • What-If Analysis and the Solver Tool in Excel

    • Excel 365 Functions

    Learn Excel 365 and avobe functions

  • Simplify Your Formulas with Excel's LET Function!
  • SEQUENCE Function: A Comprehensive Guide

    • Everyday Excel Formula Problems

    Exploring Everyday Excel formulas and their Solution:

  • Excel Challange 1:Solving the Monthly Summation Problem
  • Excel Challange 2:The One-Formula Cumulative Sum Challenge
  • Excel Challange 3:Excel Email Automation Challenge
  • Excel Challange 4:Case-Sensitive Substring Count Without Extra Columns
  • Excel Challange 5: Fixing "Numbers as Text" for Overtime Calculation
  • Excel_Challenge_6- Can You Create a Dynamic Tally?
  • Excel_Challenge_7 - Count Unique Styles Per Buyer!
  • Dynamic Calendar in 7 Minutes with Tutorial Video

    • Need Help With Excel?

    Submit your questions using the form below: