Excel

Excel Pivot Tables

Pivot tables: using Excel to its fullest

Excel pivot tables can considerably ease the evaluation of data. Data analysis can be especially time-consuming and tedious with complex numerical series, but with Excel pivot, this doesn’t have to be the case. Simply place your data in the right context and filter the essential information in just a few clicks. The pivot table allows you to create expressive diagrams in no time. Find out all you...

Creating an Excel table

How to create a table in Excel

Excel is a powerful tool for formatting, analyzing and presenting your data. Excel lets you create tables that perfectly organize groups of data and provide useful features like sorting and filtering functions, for example. In this tutorial, you’ll learn how to create Excel tables and tailor them to your individual needs.

Inserting Excel into Word

Inserting Excel into Word

Want to learn how to insert an Excel table into Word and aren’t sure how to proceed? We’ll explain how to insert an Excel file into Word. The easiest way is to use the copy and paste commands. But if you want to edit the data later, it’s better to link the Excel spreadsheet in Word. You can do this quickly and easily with our simple step-by-step guide.

Merge data in Excel

Merging data in Excel: A step-by-step guide

If you want to compare data and run analyses, it is often necessary to merge data in Excel. This can quickly get messy though, depending on what kind of contents are in the table. Keep reading our article to find out how to use the Consolidate function as well as the Power Query Editor to successfully merge data in Excel.

XLSB

XLSB: just what is an XLSB file in Excel?

The spreadsheet program Microsoft Excel handles a lot of different file formats. Excel spreadsheets can be saved not only as the usual XLSX format but also as XLSB files. But what actually are XLSB files and what are they used for? This article will give you all the information you need about the XLSB file extension and how to use it.

Inserting pictures in Excel cells

Inserting pictures in Excel cells

Pictures in Excel can help to make tables clearer. However, if a picture is not aligned and pinned to its cell, it can shift when changes are made to the table. This can cause chaos in your documents. In this guide, you will find out how to insert a picture in an Excel cell and other ways to deal with pictures in Excel.

XMATCH in Excel

XMATCH in Excel explained through examples

If you want to search through a range or a specific array of cells for data in Excel, the XMATCH function can come in handy. The Excel XMATCH function lets you find specific data responses from ranges of cells and gives you the result’s relative position. We will use examples to show you how XMATCH works and how it differs from MATCH.

XLOOKUP in Excel

XLOOKUP: Here’s what Excel’s XLOOKUP can do

Excel is well-known for its helpful functions and features when it comes to managing and organizing large amounts of data. One of them is the relatively new XLOOKUP function, which makes it easier to search for specific values within a dataset. Learn how to use the XLOOKUP function in Excel and why it replaces functions like the VLOOKUP or HLOOKUP here.

Excel: median function

Excel: median function: explained with practical examples

The median indicates the middle number in a group of existing numbers. It is also known as the central value. If you do not want to measure the average, but instead are looking for the central value in a series of numbers ordered by size, just use the Excel median function. The median function can be applied to groups of numbers of any size, even or odd.


Wait! We’ve got something for you!
Have a look at our great prices for different domain extensions.


Enter the web address of your choice in the search bar to check its availability.
.org
$1/1st year
then $20/year
.com
$1/1st year
then $15/year
.info
$1/1st year
then $20/year
.me
$1/1st year
then $20/year