↓ Skip to Main Content

Excelabcd

Main Navigation

  • Excel functions
    • Excel Functions
    • Exercise
      • COUNT Functions Exercise
      • SUM Functions Exercise
      • LOOKUP Functions Exercise
  • Excel Features
    • Protect Workbook
    • Hyperlink
    • Text to Columns
    • Freeze Panes
    • Conditional Formatting
    • Charts
    • PivotTable
    • Filter
    • Data Validation
    • Format Cells
  • Excel++
    • Shortcuts
    • 100+ formulas
    • Short Tips
    • Free Sample Excel Data
    • Excel Templates
      • Calculator Templates
      • Misc Templates
  • VBA
    • What is VBA?
    • Learn VBA step by step
    • Posts related VBA
  • Blog
  • Buy Resources
    • Buy Ebook
    • Buy Premium Templates
  • Excel Courses
    • Basic Excel Course

Author: Puspendu Roy Karmakar

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Lesson#99: Formula to separate words from a full name

By Puspendu Roy Karmakar Posted on August 20, 2018 Posted in Excel Funtions, Excel Tricks No Comments Tagged with FIND, IFERROR, LEFT, LEN, MID, RIGHT
Lesson#99: Formula to separate words from a full name

OK. I am back again with some crazy formula. Here in this post, I will show you how to make a formula to separate words from a full name. Here in this above picture, I have a list of names …

Lesson#99: Formula to separate words from a full name Read more »

Lesson#98: How to customize the axis of a chart

By Puspendu Roy Karmakar Posted on August 20, 2018 Posted in Excel Features No Comments Tagged with CHART
Lesson#98: How to customize the axis of a chart

So I have discussed creating a chart and what type of data is suitable for what type of chart. Now I am going about a detailed discussion about the features and options behind the chart. These are very important when …

Lesson#98: How to customize the axis of a chart Read more »

Lesson#97: Examples for column and bar chart

By Puspendu Roy Karmakar Posted on August 19, 2018 Posted in Excel Features No Comments Tagged with CHART
Lesson#97: Examples for column and bar chart

Here I will show you some examples for column charts and bar charts as well. Column charts can be used to represent data or values graphically which are arranged in categories. Here we are having a whole year of average …

Lesson#97: Examples for column and bar chart Read more »

Short Tips#0040: AND, OR, XOR,NOT functions

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments Tagged with AND, NOT, OR, XOR
Short Tips#0040: AND, OR, XOR,NOT functions

Short Tips#0039: How to print rows and columns?

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments Tagged with PRINT
Short Tips#0039: How to print rows and columns?

Short Tips#0038: Freeze both row and column

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments Tagged with FREEZEPANE
Short Tips#0038: Freeze both row and column

Short Tips#0037: Use of Freeze Panes

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments Tagged with FREEZEPANE
Short Tips#0037: Use of Freeze Panes

Short Tips#0036: Type digits as text

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments Tagged with TEXT
Short Tips#0036: Type digits as text

Short Tips#0035: Shortcut to see auto complete list

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments Tagged with SHORTCUTS
Short Tips#0035: Shortcut to see auto complete list

Short Tips#0034: Useful tips for Find and Replace

By Puspendu Roy Karmakar Posted on August 15, 2018 Posted in Excel short tips No Comments Tagged with FIND&REPLACE
Short Tips#0034: Useful tips for Find and Replace

Posts pagination

Previous 1 … 21 22 23 24 25 … 36 Next
  • AI Prompt techniques (2)
  • Excel Features (65)
  • Excel for Office (24)
  • Excel Funtions (99)
  • Excel general tips (58)
  • Excel News (3)
  • Excel short tips (84)
  • Excel Tricks (55)
  • Premium Products (3)
  • Review check (1)
  • stock market (4)
  • VBA and Macro (50)
  • Video Notification (5)

Buy This Ebook from Amazon

Archives

Microsoft365 for Business

AND CALCULATOR CHART CONDITIONAL FORMATTING COUNT COUNTBLANK COUNTIF COUNTIFS DATA VALIDATION DATE DAY FILTER FIND FORMAT CELLS HOUR IF IFERROR INDEX LEFT LEN MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW PIVOTTABLE PROTECT SHEET recover RIGHT ROUND SECOND SHORTCUTS SUBSTITUTE SUM SUMIF SUMIFS TEXT TEXT TO COLUMNS TODAY VLOOKUP YEAR

Footer Menu

  • Home
  • About
  • Contact
  • Privacy Policy
Copyright © 2025 Excelabcd | Powered by Responsive Theme
Loading…