Excel Basics

How to Resize All Rows in Excel (6 Different Approaches)

While working in Excel, we often need to adjust row size. There are many ways in Excel to resize all rows. In this article, I am going to discuss 6 ...

Average Attendance Formula in Excel (5 Ways)

The AVERAGE function is part of the Excel Statistical functions category. The AVERAGE function in Excel computes the average (arithmetic mean) of two ...

How to Calculate Centered Moving Average in Excel (2 Examples)

This article illustrates how we can calculate a centered moving average in Excel with 2 step-by-step examples. The centered moving average is heavily ...

How to Determine Triple Exponential Moving Average in Excel

The Triple Exponential Moving Average (TEMA) indicator was familiarized in an article in the Technical Analysis of Stocks & Commodities magazine: ...

[Fix] Excel Sort by Date Not Working (2 Causes with Solutions)

Sort by Date is not working in your Excel worksheet? Here in this article, we will discuss two fixes to this. Excel Sort by Date Not Working: ...

How to Move Rows Up in Excel (2 Quick Methods)

In this article, we will illustrate the process of how to move rows up in Excel. While working with a dataset a lot of times we have to move any ...

How to Group Rows in Excel with Expand or Collapse (5 Methods)

While making a report for a large dataset the report reader can want to see the summary instead of detailed rows and can want to expand specific ...

How to Calculate Percentage above Average in Excel (3 Easy Ways)

In this article, we will learn how to calculate the percentage above average in Excel. Sometimes, we need to calculate the average and find the ...

How to Use the Arrows to Move Screen Not Cell in Excel (4 Methods)

Sometimes in Excel, we like to use the 4 arrow keys to move between cells if we are working with a large worksheet with a lot of columns and rows. ...

Unhide All Rows Not Working in Excel (5 Issues & Solutions)

In many cases, you have to unhide unnecessary rows to make particular rows more presentable. Unfortunately, you may get troubled if unhiding all rows ...

How to Print Page Number in Excel (5 Easy Ways)

When you print an Excel sheet, you may want to print the sheet with page numbers. In this article, I’ll introduce you to 5 easy ways to print the ...

How to Combine Multiple Workbooks to One Workbook in Excel (6 Ways)

Combining multiple workbooks into one master workbook can be quite intimidating. Depending on the contents and the number of worksheets in each of ...

How to Freeze Selected Panes in Excel (4 Suitable Examples)

Freezing panes is an excellent feature Excel offers that keeps certain rows or columns visible while scrolling through the spreadsheet. When a ...

How to Insert a Date Picker in Excel (With Step-by-Step Procedure)

In Microsoft Excel, many essential tools create a great user experience. One of them is the Date Picker. With this tool, you can insert any date and ...

How to Print Sheet on One Page in Excel (9 Easy Ways)

Sometimes you may want to see the whole dataset on one page but just for one or two extra columns or rows, you have to deal with multiple pages. If ...

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo