Professor Excel
select all pictures, excel, images, select, delete

Select all Pictures in Excel: 5 Easy Methods

When you copy something from a webpage and paste it into Excel, not only the text and numbers are pasted, but also pictures. As often as not, you don’t want to have these images, for example website logos, as they make your Excel file large and hide your data.

sort, horizontally, horizon, left to right, left, right, sorting, excel

Sort Horizontally: How to Sort Data Left to Right in Excel

Today, we got a quick tip for you: Sort data left to right. Most Excel users don’t know that it is possible to sort horizontally. Admittedly, the option is a little bit hidden in Excel. But once you know it, it’s not a big deal.

[…]

file, size, reduce, workbook, excel, smaller, too big

How to Reduce the File Size of an Excel Workbook

Excel workbooks usually have an acceptable file size. But sometimes, they are unreasonably large. There are several reasons for a big file size coming with different ways of how to reduce it. Depending on the contents of your Excel workbook some methods will work better than others. So, let’s try them one by one.

[…]

print, excel, sheets, worksheets, printout, page, layout, guide

Print Excel Sheets: No More Trouble When Printing

It’s a nightmare: Printing Excel sheets. You permanently feel like Excel hates you when you want to print an Excel sheet. That said, let’s take a look at the basics (like defining the print range) as well as advanced topics (like changing headers and footers on several sheets simultaneously). 

[…]

convert, pdf, acrobat, excel, xls, xlsx, table, copy

PDF to Excel: How to Convert a PDF File

Using the PDF format has an important advantage: People can’t change the content (easily). This is also the major disadvantage: Have you ever received a PDF file and wanted to change things? When it comes to Excel, you often want to change, prove or simply understand the numbers. Therefore, you have to convert the PDF file back to Excel.

[…]

6 Great but Hardly known functions in Excel

6 Great Excel Functions Most Users Don’t Know

Most Excel users only use a small number of the functions in Excel. There are a lot of extremely useful features, but even many advanced users don’t know all of them. In this article, we introduce you to six great Excel functions, which are hardly known.

 

[…]

pivot, pivotable, excel

Pivotable: How to Prepare Data for Creating Pivot Tables in Excel

Pivot Tables are one of the most helpful features in Excel. With Pivot Tables, you can easily evaluate data. Per drag-and-drop you arrange analysis layouts. Within seconds, you’ll see your results – without using any formulas. Usually the first obstacle comes up, when you try to create a Pivot Table. There are some rules to regard in order to create Pivot Tables and your data needs a certain structure. In this article we explore how to make your data ‘pivotable’.

[…]

calculation, options, calculate, manual, automatic, excel, thumbnail

Calculation Options in Excel: Decide When and What to Calculate

Does this sound familiar to you: Excel takes too much time calculating. Instead of instantly showing the results, you have to wait for several seconds or even minutes for Excel to finish up the calculation. The problem: The larger your Excel model gets, the more you get frustrated by the lack of performance.

[…]

hide, zeros, zeroes, excel

Hide Zero Values in Excel: 3 Simple Methods

There are many reasons why you might want to hide zero values in Excel. For example when working with cell links, Excel shows a 0 even if the source cell is blank. Or because it might look more professional. Whatever reason you have, there are different methods for hiding zero values. Depending on the scope (for example one worksheet or just selected cells), different methods are most suitable. In this article we explore 3 methods of hiding zero values in Excel and compare them.

[…]

speed, up, excel, performance, calculation, speeding

Speed up Excel in 17 Easy Steps and Calculate Faster (+Download)

Excel is a great tool for performing complex calculations. Unfortunately, the larger an Excel spreadsheet gets, the slower the calculations will be. Depending on the formulas, size of the workbook and the computer, the calculations may take up to 30 minutes. In this article, we take a look at 17 methods to save time and speed up Excel. […]