Excel Basics Archives

7 Easy Ways to Calculate Average Rating in Excel

March 22, 2023 Excel Basics

In this article, I'll show you three excellent methods how to calculate average rating in Excel. Furthermore, these strategies will allow you to ...

3 Quick Ways to Copy Formula and Paste as Text in Excel

February 5, 2023 Excel Basics

In this article, I'll show you three excellent methods for how to copy formula and paste them as text in Excel. Furthermore, these strategies will ...

5 Ways to Extract Filtered Data into Another Excel Sheet

February 5, 2023 Excel Basics

Yesterday, the honorable CEO Mr. Oliver Queen called the Regional General Manager Mr. Ronald Koeman of Amigo Super Store. Basically, Mr. Oliver is ...

2 Approaches to Add Primary Minor Vertical Gridlines in Excel

February 16, 2023 Excel Basics

There are two kinds of gridlines in chart: Horizontal and Vertical gridlines. These gridlines help us to visualize the data more effectively. There ...

5 Approaches to Reset Cell Size to Default in Excel

February 16, 2023 Excel Basics

This lesson will demonstrate 5 different approaches to reset cell size to default in Excel. Moreover, these techniques will enable you to solve the ...

2 Approaches to Print Borders at Page Break in Excel

February 1, 2023 Excel Basics

If you are putting a page break in the middle of your data set, you might want to add a border around that page break so that it appears more ...

8 Approaches to Remove Currency Symbol in Excel

February 16, 2023 Excel Basics

There are different formats available for data in cells of Excel. We can apply them to a cell when we’re working with it. Currency format is one of ...

5 Ways to Add Cell Borders in Excel Inside and Outside

February 4, 2023 Excel Basics

Let's say you want to set internal and external cell borders in your Excel data set. Several Excel features make this very easy to accomplish. You ...

4 Approaches to Capitalize All Letters in Excel Without Formula

February 4, 2023 Excel Basics

You do not need to use any formulas in order to make all of the letters in your Excel dataset capitalized. Excel comes with a number of ...

4 Approaches to Align Shapes in Excel

February 4, 2023 Excel Basics

Do you know that you can easily align the shapes in your Excel data? It may seem difficult when you are manually changing the alignment of the ...

3 Approaches to Calculate 5 Star Rating Average in Excel

March 22, 2023 Excel Basics

5 star rating is a popular phrase, we come across in our day-to-day life. You can face it in restaurants, mobile applications, academic reports, ...

5 Ways to Add Gridlines After Highlighting in Excel

February 16, 2023 Excel Basics

Gridlines are the horizontal and vertical lines that are present among cells in Excel. These gridlines help us to navigate the position of each cell ...