Skip to content
Analytics Empire Logo
  • Excel Basics
  • Graphs & Charts
  • Excel Functions & Formulas
  • Excel Troubleshooting
  • Advanced ExcelExpand
    • Pivot Tables
    • Macros/VBA
  • About Me
Analytics Empire Logo

Author: Ahsanul Haque

Hi! I'm Ahsanul Haque, a graduate student majoring in marketing at Bangladesh University of Professionals. And I'm here to share what I learned about analytics tools and learn from you.
Excel Basics

How to insert a picture in Excel header

ByAhsanul Haque February 3, 2024February 4, 2024

Sometimes, we might need to insert pictures in the Excel header for many reasons. It could be a company logo or any title in an image format. So, how to insert a picture in Excel header? Well, go to the “Insert” ribbon. Click on the drop-down arrow of the  “Text” option. Click on the “Header…

Read More How to insert a picture in Excel headerContinue

f4 not working in excel
Excel Troubleshooting

F4 not working in Excel [Fixed]

ByAhsanul Haque February 3, 2024February 10, 2024

F4 is not working in Excel because the Function (Fn) key is locked. First, you need to unlock it by pressing the “Fn + Esc” key for 2 seconds and then press “F4,” and it will work. You can also use “Fn + F4” as an alternative or manually insert dollar ($) signs in front…

Read More F4 not working in Excel [Fixed]Continue

Excel Basics

How to delete Formatting in Excel

ByAhsanul Haque February 2, 2024February 4, 2024

To delete formatting in Excel, select the data range. If your data range is the whole sheet, select any blank cell and press “Ctrl + A.” Go to the “Home” ribbon, then click on the “Clear” menu under the “Editing” section. Select the “Clear Formats.” Or, after selecting the data range, press “Alt + H…

Read More How to delete Formatting in ExcelContinue

How to use quick analysis tool in Excel
Excel Basics

How to use quick analysis tool in Excel

ByAhsanul Haque January 23, 2024February 2, 2024

The primary purpose of using Excel is to do the data-related work more effectively and efficiently. Excel does that very well. But when you are just starting to learn Excel and see all the options, tabs, and ribbons might seem complicated to understand.  To do a specific type of work, you might get lost in…

Read More How to use quick analysis tool in ExcelContinue

Excel Functions & Formulas

How to remove year from date in Excel

ByAhsanul Haque January 23, 2024February 3, 2024

We need to know how to remove year from date in Excel for many reasons. For example, we have a list of customer payable dates. And we want to know only the date and sort them.  Another example could be you want to send each of your customers birthday wishes. Now, you have a long…

Read More How to remove year from date in ExcelContinue

Excel Basics

How to screenshot on Excel

ByAhsanul Haque January 23, 2024February 2, 2024

You might need to take a screenshot in Excel many times. For example, screenshot a particular data set range or table. And add it to a presentation slide or somewhere. In another scenario, copy the data in a workbook and paste it into another worksheet as a picture.  Whatever the reason is, you can always…

Read More How to screenshot on ExcelContinue

Excel Basics

How to distribute columns evenly in Excel

ByAhsanul Haque January 23, 2024February 3, 2024

You might be facing some issues with fixing the width or height of a column. Sometimes, we see “######” in a cell. This means that particular cells do not have enough space to show all the data. So, we might need to distribute columns evenly in Excel.  You might be wondering how to distribute columns…

Read More How to distribute columns evenly in ExcelContinue

Excel Basics

How to stop Excel from calculating

ByAhsanul Haque January 23, 2024February 3, 2024

You might need to stop Excel from calculating in a few more scenarios. But most of us do not know how. But the steps are very easy.  So, you might be asking how to stop Excel from calculating.  Well, the easiest way is to go to the “Formulas” ribbon. You will find a “Calculation Options”…

Read More How to stop Excel from calculatingContinue

Excel Basics

How to set the default font in Excel

ByAhsanul Haque January 23, 2024February 3, 2024

When you open a new workbook, it opens with a default font. The default font is Calibri, and the font size is 11.  It’s a great font with good readability. But you might need to change your workbook’s font and overall looks and feels.  But every time you open a new workbook, it will open…

Read More How to set the default font in ExcelContinue

Excel Basics

How to hide unused cells in Excel

ByAhsanul Haque January 23, 2024February 3, 2024

There are many reasons you might need to hide unused cells. One of the reasons could be that you need to focus on a particular part or data range. If you keep getting distracted, your work will not be effective and efficient.  So, do you want to know how to hide unused cells in Excel?…

Read More How to hide unused cells in ExcelContinue

Graphs & Charts

How to extend a trendline in Excel

ByAhsanul Haque January 23, 2024February 2, 2024

Your company wants to compare this year’s sales revenue with the forecasted data. Based on the result, the company will predict next year’s data. You already have a trendline, but now you want to extend it slightly. We have our data, which shows sales from 2013 to 2017.  Now, we already made a trendline with…

Read More How to extend a trendline in ExcelContinue

Excel Basics

How to change Language in Excel

ByAhsanul Haque January 19, 2024February 2, 2024

You can change language in Excel in 3 simple steps. Go to the “File” ribbon > Click on the “Options” > Click on “Language” > Choose your preferred language. If you can not find the language you are looking for, click on “Add a language.” Choose a language, Install it > Click on the  “Set…

Read More How to change Language in ExcelContinue

Page navigation

1 2 3 Next PageNext

Copyright ©2025  | Powered by AnalyticsEmpire

  • Contact
  • About Me
  • Privacy Policy
  • Excel Shortcuts
DMCA.com Protection Status
Facebook Twitter Instagram Pinterest TikTok
  • Excel Basics
  • Graphs & Charts
  • Excel Functions & Formulas
  • Excel Troubleshooting
  • Advanced Excel
    • Pivot Tables
    • Macros/VBA
  • About Me
Search