Skip to content

XYOLogic

  • Home
  • Excel Basics
  • Formulas
  • Functions
  • Blog

XYOLogic

  • Home
  • Excel Basics
  • Formulas
  • Functions
  • Blog

Excel Basics

XLSB vs XLSX

XLSB vs XLSX: Choose the Right Excel File Format

by Jabed Hasan

Excel lets you save files in more than 20 formats. Each format offers something unique but comes with some limitations as … Read more

Random 4 Digit Number Generator in Excel

Random 4 Digit Number Generator in Excel: 5 Easy Methods

by Jabed Hasan

In everyday situations, casual Excel users write numbers manually in the cells when they need to create random four-digit numbers. It … Read more

How to Remove Excel’s Fixed Objects

How to Select Non-Adjacent Cells in Excel: 5 Incredible Techniques

by Jabed Hasan

Selecting a range of touching cells in Excel is a regular experience for any user. You may simply click and drag. … Read more

How to Remove Excel’s Fixed Objects

Excel Fixed Objects will Move Error: 7 Working Solutions

by Jabed Hasan

The Fixed objects will move error in Excel puts you in one of the most annoying situations. Sometimes, it just keeps … Read more

How to remove leading zeros in Excel

How to Remove Leading Zeros in Excel: 10 Effective Methods

by Jabed Hasan

Leading zeros in a cell value or text string in Excel help maintain data integrity in certain systems. However, those zeros … Read more

Applications of Ctrl Shift Enter in Excel

How to Strikethrough in Excel: 6 Nifty Ways to Get Things Done

by Jabed Hasan

Strikethrough is a much-used and interesting option that is not a part of the default ribbon layout in Excel. It makes … Read more

Applications of Ctrl Shift Enter in Excel

Top 7 Applications of Ctrl Shift Enter in Excel

by Jabed Hasan

Performing single calculations in Excel is straightforward. There is no complication at all. But when multiple calculations are involved, the experience … Read more

XLOOKUP vs VLOOKUP

XLOOKUP vs VLOOKUP: Which One Prevails Over The Other?

by Nafiur Ahmed

An avid Excel user must look for ways to upgrade their workflow and produce efficient results in the shortest possible time … Read more

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

Older posts
Page1 Page2 … Page5 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