Microsoft Excel

Descriptive statistics summarizes the given data and provides a summary of key statistics for the data such as mean, mode, median, Variance, standard deviation, Skewness, Count, maximum and minimum, etc. When working with a large dataset, knowing key statistical information about your dataset and trends in your data could be useful.

Microsoft Excel has various built-in functions that can calculate many statistical values individually such as mean, variance, count, etc. Excel also has an add-in tool called Analysis Toolpak that helps you generate all descriptive statistics in one go. In this article, we will explain how to calculate descriptive statistics

By default, when you type a formula in a cell and hit enter, Excel shows the result of the formula and hides the formula underneath it. However, when working with huge amounts of data and lots of formulas, sometimes you may need to show the formulas in the cells instead of the outputs for several reasons.

Those reasons include displaying formulas for printing, editing the formula, understanding the dependencies, correcting errors and mistakes, etc. Displaying cell formulas can help you keep track of data (or the cells containing the data) used in each formula and verify the entered formulas

The arrow keys are some of the most commonly used keys when working in an Excel spreadsheet, especially for navigating between cells. However, if the arrow keys are not working properly, it can be very annoying and time-consuming.

If your arrows keys are stopped working or not responding in Excel, it can be caused by several reasons such as scroll lock enabled, sticky keys glitches, corrupted or conflicting add-ins, frozen panes, protected worksheets, etc. In this post, we’ll show you how to fix when arrow keys are not working properly in Excel.

Disable Scroll Lock

When the

There are times when you want to rotate the text inside a cell for appearance purposes or to best fit the column, especially for column and row headers. If you have a column heading that is longer than the cell size, it will flow into the next cell or part of the text will be hidden if the next cell has data.

Normally you would resize the column size to its largest content to fit the text. However, it will take too much screen space and give your dataset an awkward look especially if the column heading is too big

When managing an accounting ledger or a large product list, you may need to highlight or shade alternate rows in your worksheet to make it easier to read and sort data. Highlighting alternate rows help distinguish the different rows from monotonous data and makes it user-friendly.

If you were to manually select every other row one by one and add colors to them, it would be time-consuming and tiresome. Instead, you can have Excel color alternate rows automatically.

Shading a different color for every other row or highlighting alternate rows can be done using several different automatic methods, including

Let’s assume you had been working on an important Excel document for several painstaking hours and Excel crashes, the power went out, system crashes or you accidentally closed the file without saving it. And it would be really annoying to see all your hard work and time are wasted. But don’t worry, you can still recover those files if you act quickly.

There are also other cases when you have accidentally overwritten some important data or when you make a mistake that you can’t undo, you may need to restore previous versions of your workbook.