Tags : Excel

Tutorials

How to Calculate an Average in Microsoft Excel

In addition to spreadsheets, the primary purpose of Microsoft Excel is to perform calculations in everyday work. Excel can perform all kinds of calculations, from complicated tasks to simple ones, such as calculating averages. We use formulas for calculations in Excel, and the formula for calculating the average is one of the simpler ones. Watch […]Read More

Tutorials

How to Rotate Text Inside a Cell in Microsoft Excel

Microsoft Excel has an interesting option that will allow you to rotate text within a cell. This can be useful because the rotated text is a convenient way to highlight a particular cell, and it can also help with table formatting. Watch our video tutorial where we show you how to rotate text inside a […]Read More

Tutorials

How to Delete All Blank Rows in Microsoft Excel

When you copy a Microsoft Excel spreadsheet from one document to another, or when you load an Excel file that was not created in the same version of Excel as the version you’re using to run the file, the formatting of the spreadsheet can get messed up. The text in the table may be in […]Read More

Tutorials

How to Save an Excel Spreadsheet in PDF Format

The PDF format is convenient because the content will always be displayed exactly the same, regardless of the version of the program with which the document was created. For this reason, when you need to share a certain document with colleagues or friends, it is a good idea to save the document in PDF format […]Read More

Tutorials

How to Find the Smallest and Largest Number in Microsoft Excel

When you have a spreadsheet full of data, finding the number you need can be extremely difficult and tedious. However, whether you’re looking for the lowest product sales or the highest test score, Microsoft Excel‘s SMALL and LARGE functions will help. Watch our video tutorial where we show you how to find the smallest or […]Read More

Tutorials

How to Turn on Dark Mode in Microsoft Excel

If you spend a lot of time staring at Excel spreadsheets, especially at night, it is recommended to turn on dark mode. In this way, you will reduce the strain on your eyes, which will help you sleep better, and your head and eyes won’t hurt. Microsoft Excel includes an option to turn on the […]Read More

Tutorials

How to Insert an Excel Table Into Word Document

If you have a table in Excel that you want to add to Word, you don’t need to manually copy column by column. Word allows you to load an Excel file directly into a Word document. When you add a table like this, the layout of the Excel table will be copied, but you’ll probably […]Read More

Tutorials

How to Group Rows and Columns in Microsoft Excel

Microsoft Excel has an option that allows you to group rows and columns. When you group rows or columns, you will be able to collapse them so that the grouped elements are not visible, thus making the table clearer and easier to navigate. Watch our video tutorial where we show you how to group rows […]Read More

Tutorials

How to Change Units of Measurement in Microsoft Excel

By default, Microsoft Excel uses the units of measure used by the operating system. This means that if Windows is set to use centimeters, Excel will also use centimeters. This can of course be changed and you are free to choose to use any units of measurement that you want. Watch our video tutorial where […]Read More