Excel Basics Archives

How to Add, Change and Format Cell Borders in Excel [Ultimate Guide]

Sep 26, 2023

In this Excel tutorial, you will learn how to add, change, format, draw, remove, and create custom styles for cell borders in Excel, and even how to ...

How to Add, Change and Format Cell Borders in Excel [Ultimate Guide]

How to Use Excel Screenshot Option (Take, Edit and Copy)

Sep 4, 2023

In this article, we are going to demonstrate how to take an Excel screenshot without taking any help from any third-party app. There are three ways ...

How to Use Excel Screenshot Option (Take, Edit and Copy)

How to Link PowerPoint Chart to Excel (Step by Step)

Sep 21, 2023

In this article, we will link a PowerPoint chart to Excel using the simple copy-and-paste method. But this time, you need to paste the chart using ...

How to Link PowerPoint Chart to Excel (Step by Step)

How to Return All Rows That Match Criteria in Excel

Sep 4, 2023

In this article, we’ll be showing different methods to return all rows that match the criteria in Excel. It is a very important feature considering ...

How to Return All Rows That Match Criteria in Excel

How to Make House Estimate Format in Excel (5 Easy Steps)

Aug 16, 2023

The house estimation allows us to create a reasonable budget, which will eventually lead to a proper path toward managing the construction of a house ...

How to Make House Estimate Format in Excel (5 Easy Steps)

How to Make Good Excel Color Combinations

Sep 20, 2023

In the analysis and presentation of data, Excel spreadsheets are indispensable. When organizing and analyzing data, we frequently neglect the ...

How to Make Good Excel Color Combinations

[Solved!] Excel Themes Option Is Not Working (5 Easy Fixes)

Sep 20, 2023

Excel Themes offer a professional look to your spreadsheets, allowing you to enhance the overall aesthetic appeal of your data. Problems with Excel ...

[Solved!] Excel Themes Option Is Not Working (5 Easy Fixes)

How to Apply Bottom Double Border in Excel (3 Easy Ways)

Sep 17, 2023

In this article, we will present 3 ideal methods of applying Bottom Double Border in Excel. We will also discuss the process of creating a custom ...

How to Apply Bottom Double Border in Excel (3 Easy Ways)

How to Remove Trace Dependents in Excel (3 Swift Ways)

Aug 10, 2023

In this article, we are going to show you how to remove trace dependents in Excel. We will know about some Excel features, keyboard shortcuts, and ...

How to Remove Trace Dependents in Excel (3 Swift Ways)

Excel Conditional Formatting with Named Range (3 Examples)

Aug 9, 2023

In this article, you will learn to use Excel conditional formatting with named range. You will see the use of named range in conditional formatting ...

Excel Conditional Formatting with Named Range (3 Examples)

How to Merge Cells in Excel to Word Document (2 Ways)

Aug 7, 2023

This article provides two easy examples of how to merge cells in Excel to a Word document. We will show the way to merge cells in an Excel file with ...

How to Merge Cells in Excel to Word Document (2 Ways)

How to Insert Calendar in Excel Cell (2 Quick Methods)

Aug 7, 2023

Inserting a calendar into an Excel cell allows you to easily track dates and schedule events. Because in some cases, it's got bothering to insert ...

How to Insert Calendar in Excel Cell (2 Quick Methods)

Data Analysis and Visualization with Excel (A Complete Guideline)

Aug 6, 2023

In this article, we will show you how to perform data analysis and visualization with Excel. There are three stages in data analysis and ...

Data Analysis and Visualization with Excel (A Complete Guideline)

[Fixed!] Trace Dependents Is Not Working in Excel (3 Solutions)

Aug 3, 2023

In this article, I am going to present some possible solutions to fix the Excel Trace Dependents not working problem. The Trace Dependents is a very ...

[Fixed!] Trace Dependents Is Not Working in Excel (3 Solutions)

How Do You Link Sheets in Excel with Index (3 Swift Ways)

Aug 2, 2023

In this article, we are going to show you how you link sheets in Excel with an index. We will apply the HYPERLINK link function, VBA macro, and also ...