Skip to content

XYOLogic

  • Home
  • Excel Basics
  • Formulas
  • Functions
  • Blog

XYOLogic

  • Home
  • Excel Basics
  • Formulas
  • Functions
  • Blog
How to Separate Names in Excel

How to Separate Names in Excel: 5 Quick and Easy Ways

by Jabed Hasan

Extracting different parts of a full name is a familiar task for any Excel user. If you have only five or … Read more

Excel XLOOKUP

Excel XLOOKUP: From Basic To Advanced Use Including Visual Examples

by Nafiur Ahmed

If you’re looking for ways to walk past countless hours of skimming through large data sets only to find out something … Read more

How To Freeze 2 Rows In Excel

How to Freeze 2 Rows in Excel: 5 Smart Methods to Save Time

by Jabed Hasan

Have you been in a situation where you realized that knowing how to freeze 2 rows in Excel would have made … Read more

How to Merge Two Rows in Excel

How to Merge Two Rows in Excel: Easiest Ways to Do it

by Samin Yasar Nafi

Microsoft Excel as we know it provides a lot of options and functions. While using it, we might come across the … Read more

Excel VLOOKUP

Excel VLOOKUP: Easy Ways To Find Data From Large Sets

by Nafiur Ahmed

Excel VLOOKUP is one of those functions in Excel that keeps on creating demand to be used while sorting or analyzing … Read more

VBA In Excel: Automate Your Workflow & Save Your Time Easily!

by Nafiur Ahmed

I’ve come across a lot of Excel users who are terrified of the term VBA in Excel. What I’ll say is, … Read more

Ctrl Y in Excel

Ctrl Y in Excel: What Does it Actually Do?

by Samin Yasar Nafi

As we all know, there are multiple handy shortcuts in Excel. Among all of these, the undo and redo shortcuts are … Read more

How to Turn on Spell Check in Excel

How to Turn on Spell Check in Excel with 8 Handy Approaches

by Jabed Hasan

Excel works like a mess when it comes to checking misspellings. It does not detect and underline misspelled words automatically as … Read more

How to Remove Filter in Excel: The Fastest Ways

by Nafiur Ahmed

Adding and applying Filter in Excel might not be too challenging. As we all know, the AutoFilter feature is used to … Read more

How to Alphabetize in Excel: 9 Perfectly Working Methods

by Jabed Hasan

In any data analysis work, knowing how to alphabetize in Excel is one of the fundamental requirements. If your data is … Read more

How to Add Filter in Excel

How to Add Filter in Excel: Easy Ways to Do it

by Samin Yasar Nafi

Working in big companies or large institutions may often lead to dealing with large number of datasets. In these cases, it’s … Read more

Excel Dashboard

Excel Dashboard: Create Advanced Dashboards (With Template) In Just A Few Minutes!

by Nafiur Ahmed

Knowing how to create Excel dashboards is one of the highest-selling skills in the current job market. Not a lot of … Read more

Older posts
Newer posts
← Previous Page1 Page2 Page3 … Page6 Next →
Follow Us
  • Facebook
  • Twitter
  • LinkedIn
  • YouTube

Quick Links

  • Contact Us
  • About Us
  • Privacy Policy
  • Sitemap

Disclaimer

XYOLogic is a website that specializes on MS Excel & its relevant functions, starting from the basics to the more complex problems like data sorting, analyzing and other VBA-related issues. Our solutions encompass everyone from personal to professional sphere for a better Excel aptitude.
© 2023 xyologic.com