Excel

Learn to manage headers and footer in Excel to optimize your documentation. Find out how to customize the information, add page numbers, and enter images to make your work sheets more professional and information.

Learn to manage your data in Excel by rapidly adding "yes" or "no" values ​​through six effective methods, from the use of drop -down lists to advanced functions such as IF and VBA.

Learn how to raise a number in Excel to the square with 9 different methods. Whether you prefer simple formulas or advanced tools, you will find the right solution for your needs.

Discover 8 effective ways to count the unique values ​​in Microsoft Excel. From the functions integrated with Power Query, learn to manage your data easily.

This article provides a complete overview of how to add Powerpivot to Microsoft Excel, with practical details and useful suggestions to optimize the use of this powerful tool.

Learn to calculate the number of days in one month in Excel with 7 different techniques, including formulas, VBA and Power Query. Optimize your work with Excel and increase your productivity.

Discover 5 effective methods to protect and change the formulas in Excel. From the review tab to the VBA code, learn to safeguard your important calculations.

Discover the 7 simple and intuitive methods to insert hypertext connections in your Excel calculation sheet. It improves navigability and user experience with this complete guide.

Find out how Excel's to do model can help you effectively manage your activities and increase your productivity. Explore its key features and best practices to use it to the maximum.

Tired of your graphic graphs without the titles of the clear and information axes? Don't worry, because I will explain how to add labels to the axes in Excel for your graphs.

In this article, we will explore in detail seven effective methods to change the orientation of the page in Excel, offering a complete overview of the available features and tools.

This article will guide you through each approach, offering you the necessary tools to easily manage the dates in your spreadsheets.

In this article, we will explore 9 different methods to extract the name and surname in separate columns in Excel. Each of these approaches has its advantages and disadvantages, so you will choose the one that best suits your specific needs.

Discover 9 methods to combine name and surname in Excel, including the use of Ampersand, Concat, Textjoin, Power Query and Power Pivot. Simplifies your data for efficient reports and analyzes.

In this article, we will explore in detail 3 effective methods to insert images in the Microsoft Excel cells.

In this article, we will explore five different methods to order by color in Microsoft Excel, each with its own advantages and specific considerations.

Here's how to use Microsoft Excel to organize your software development team. Create Backlog, plan activities, trace progress and more! Free models and useful advice.

Count the consecutive negative numbers in an Excel spreadsheet can be a challenge, but with this guide you will learn an effective solution to do it. Follow the practical example to count consecutive negative numbers and optimize the management of your data.

There are several situations in which it may be advantageous to have grouped or separated sheets of work, such as when working on complex projects, sales data are analyzed or detailed reports are prepared.

Do you want to create a barcode in Excel? A barcode is a representation of data using parallel lines that vary in width and spacing. Let's see how to do it.

QR codes are two -dimensional bar codes readable by scanners and smartphones. QR codes are a popular way to connect physical objects to digital information. When a QR code is scanned, the user will connect to a website, a text, audio or video file.

If you use Excel but you need a hand to understand it, here it is: 13 Excel formulas for SEO data management.

Excel allows you to order for a column at a time or multiple. In this tutorial we see how to do it.

Learning how to enable macro is relatively easy and in this article we will show you how to enable macro in Excel, since they are disabled by default.

Excel offers many ways to order data, but not in a simple solution with a single click. But with a little ingenuity, you can create your buttons to order the data. This article will show you how to create buttons to order your data.

Excel allows formatting and pagination options that allow the creation of a price list illustrated on several pages whose prices are automatically updated when the lists of the various suppliers vary.

All the secrets to build a crosswords with Excel, defining the general formatting of the grid and an advanced system for verifying the text entered.

A spreadsheet to manage your current account, insert items of spending and record credits. Thanks to a clear graphic distinction it is possible to know if expenses or savings prevail.

Did I already pay the phone bill? When does that of electricity expire? Questions that at least once we all asked ourselves. We can keep everything in order thanks to Excel.

If we took the great step of getting on a diet we need to keep everything under control: we want to proudly see every lost gram, graphic in hand!

The "Lotto game with Excel" tutorial organizes useful calculation sheets to keep track draws of the lot, late numbers and cases linked to the game of lot. All with simplicity, thanks to Excel.

Here's how to create a series of cards containing the data of the players of their football team in order to verify its characteristics, the frequency of training to be able to draw up a real "scientific" training.

The competition of the telephone companies is becoming increasingly fierce and the rates are becoming a junior: shots for the answer, discounts, VAT ... to extricate itself is increasingly difficult, let alone find the one most suitable for us. Let's try to orient ourselves thanks to Excel.

A memorandum created with Excel not to forget the trend of the wedding list, appointments, costs and details associated with the preparation of one of the most important events of life: marriage.

If we have decided to buy a house we must know that that, unfortunately, is not the only cost we will have to face. Let's see how much "turnkey" can cost us, with the help of Excel.

Here is a tutorial to follow the trend of the actions: a very simple method perfect for those who play on the stock exchange and always want to have the picture of the situation available, thanks to Excel.