Ultime notizie Excel ⋆ FullPress

Excel, come inserire automaticamente la data - Foto FPAI

How to automatically insert the date in Excel: useful methods and tricks

30 September 2025 Raffaele Lopardo 0

When working with spreadsheets, it can be useful to have the date update automatically, without having to type it in every time. Excel offers several methods for inserting the current date or updating it automatically: from keyboard shortcuts to functions like TODAY() and NOW(), to combined formulas. In this guide, we will look at all the practical methods.

Excel Tips and Tricks: Optimize Your Spreadsheet Work

7 May 2025 Anna Bruno 0

Excel is a fundamental tool for storing, organizing, and analyzing data. This guide will reveal valuable tips and tricks to maximize Excel’s potential, increasing your productivity and enabling you to make more informed business decisions.

How to Select Only Visible Cells in Excel: 5 Effective Methods

4 May 2025 Anna Bruno 0

When working with complex spreadsheets in Excel, selecting only the visible cells becomes crucial for proper data manipulation. This article guides you through five effective methods to exclusively select visible cells, avoiding common mistakes and improving your workflow.

5 ways to insert emoji in Excel (even on Windows)

25 April 2025 Anna Bruno 0

Adding emoji to an Excel sheet is easier than you think. Whether you’re using the desktop version on Windows or the online version, there are several methods to insert symbols and emojis that help make data clearer and more visually appealing. Here are 5 practical ways to do it right away.

Fuzzy Grouping in Excel: How to Merge Similar but Not Identical Data

18 April 2025 Paolo Bergamaschi 0

Have you ever had to manually group similar but not identical data in Excel? Discover how Power Query offers an effective solution through fuzzy grouping, a powerful but little-known feature that automates this tedious process.

3 effective ways to insert images into Excel cells

11 April 2025 Raffaele Lopardo 0

Transform your spreadsheets with eye-catching visuals using these three innovative methods for inserting images directly into Microsoft Excel cells, making your data more communicative and effective.

3 modi per generare un codice QR in Microsoft Excel - Foto FPAI

3 ways to generate a QR code in Microsoft Excel

8 April 2025 Paolo Bergamaschi 0

Want to insert a QR code directly into your Excel spreadsheets? In this guide, we explain three practical methods to generate QR codes in Microsoft Excel: using the IMAGE() function and Google API, through free add-ins like QR4Office, and using integrable external tools. Perfect for forms, dynamic data, and automations in your files.

Excel Macro: Extract Historical Data for Multiple Stocks with One Click

25 February 2025 Raffaele Lopardo 0

Looking to automate the extraction of stock market historical data in Excel? With a VBA macro, you can retrieve quotes for multiple stocks simultaneously, saving time and enhancing financial analysis. Discover the code and detailed instructions in this guide.

9 methods to square a number in Microsoft Excel

21 February 2025 Anna Bruno 0

Learn how to square a number in Microsoft Excel through 9 different methods, from basic formulas to advanced functions, to improve your calculation efficiency.

What #SPILL! Means in Microsoft Excel: Causes and Solutions to Fix the Error

18 February 2025 Raffaele Lopardo 0

The #SPILL! error in Microsoft Excel can appear when a formula cannot expand correctly. Discover the most common causes and quick solutions to fix it without hassle.

How to Highlight “Yes” in Green and “No” in Red in Excel

14 February 2025 Paolo Bergamaschi 0

Customize your Excel reports by highlighting “Yes” in green and “No” in red with simple conditional formatting techniques.

How to Use Headers and Footers in Excel

23 December 2024 Raffaele Lopardo 0

Learn how to manage headers and footers in Excel to optimize your documentation. Discover how to customize information, add page numbers, and insert images to make your worksheets more professional and informative.

Excel

6 Ways to Add Yes or No in Excel

13 December 2024 Raffaele Lopardo 0

Learn how to manage your data in Excel by quickly adding “Yes” or “No” values through six effective methods, from using drop-down lists to advanced functions like IF and VBA.

9 ways to square a number in Excel

11 December 2024 Paolo Bergamaschi 0

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

8 Ways to Count Unique Values in Excel

4 December 2024 Raffaele Lopardo 0

Discover 8 effective ways to count unique values in Microsoft Excel. From built-in functions to Power Query, learn to manage your data with ease.

4 Ways to Add PowerPivot to Excel

12 November 2024 Anna Bruno 0

This article provides a comprehensive overview of how to add PowerPivot to Microsoft Excel, with practical details and useful tips for optimizing the use of this powerful tool.

7 ways to get the number of days in a month in Excel

2 November 2024 Paolo Bergamaschi 0

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

5 Ways to Lock and Unlock Formulas in Excel

15 October 2024 Paolo Bergamaschi 0

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

7 Simple Methods to Insert Hyperlinks in Excel

17 September 2024 Paolo Bergamaschi 0

Discover the 7 simple and intuitive methods to insert hyperlinks in your Excel spreadsheet. Improve navigability and user experience with this comprehensive guide.

Excel To Do Template

10 September 2024 Anna Bruno 0

Discover how Excel’s To Do Template can help you effectively manage your tasks and increase your productivity. Explore its key features and best practices to make the most of it.

7 Ways to Add Chart Axis Labels in Excel

3 September 2024 Paolo Bergamaschi 0

Tired of your charts lacking clear and informative axis titles? Worry not, as I’ll guide you on how to add axis labels in Excel for your charts.

7 Ways to Change Page Orientation in Excel

27 August 2024 Paolo Bergamaschi 0

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

5 effective ways to add months to a date in Excel

20 August 2024 Paolo Bergamaschi 0

This article will guide you through each approach, offering you the tools needed to manage dates in your spreadsheets with ease.

9 Ways to Separate First and Last Names in Microsoft Excel

13 August 2024 Paolo Bergamaschi 0

In this article, we’ll explore 9 different methods for extracting first and last names into separate columns in Excel. Each of these approaches has its own advantages and disadvantages, so you’ll choose the one that best suits your specific needs.

Excel

9 Ways to Combine First and Last Names in Excel

23 July 2024 Anna Bruno 0

Discover 9 methods to combine first and last names in Excel, including using Ampersand, CONCAT, TEXTJOIN, Power Query, and Power Pivot. Streamline your data for efficient reporting and analysis.

4 effective ways to filter by color in Excel

16 July 2024 Raffaele Lopardo 0

Discover 4 methods to filter data by cell color in Excel. Organize and analyze information with ease using tools, VBA

Excel

3 Methods to Insert Images into Excel Cells

9 July 2024 Paolo Bergamaschi 0

In this article, we will explore in detail 3 effective methods for inserting images into Microsoft Excel cells.

5 ways to sort by color in Microsoft Excel

2 July 2024 Paolo Bergamaschi 0

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

Excel

How to Use Excel for Project Management

15 March 2024 Anna Bruno 0

Here’s how to use Microsoft Excel to organize your software development team. Create backlogs, plan tasks, track progress, and more! Free templates and useful tips.

Excel

How to count consecutive positive/negative numbers in Excel

6 March 2024 Paolo Bergamaschi 0

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

4 Ways to Group and Separate Excel Sheets

1 March 2024 Raffaele Lopardo 0

There are several situations where it can be advantageous to have worksheets grouped or separated, such as when working on complex projects, analyzing sales data, or preparing detailed reports.

3 ways to generate a barcode in Microsoft Excel

1 December 2023 Paolo Bergamaschi 0

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.

3 Ways to Generate QR Codes in Microsoft Excel

14 November 2023 Paolo Bergamaschi 0

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

How to convert an Excel document to a Google Sheet

11 November 2023 Paolo Bergamaschi 0

Keep reading to find out how to convert an Excel document into a Google Sheet and vice versa.

13 Excel formulas for SEO data management

6 October 2023 Paolo Bergamaschi 0

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

How to sort data in Excel

29 August 2023 Paolo Bergamaschi 0

Excel allows you to sort by one column at a time or by multiple columns. In this tutorial, we’ll show you how to do it.

How to Integrate ChatGPT into Excel

23 August 2023 Paolo Bergamaschi 0

In this post, we’ll discuss how to integrate ChatGPT into MS Excel. ChatGPT’s popularity is growing day by day. It has a variety of use cases ranging from healthcare to banking.

How to use CHAT GPT in Excel: plugin

18 August 2023 Anna Bruno 0

In this article, we will discuss how to use the Excel add-in for ChatGPT.

How to enable macros in Excel

7 August 2023 Paolo Bergamaschi 0

Learning how to enable macros is relatively easy, and in this article, we’ll show you how to enable macros in Excel, as they are disabled by default.

Excel

5 Ways to Add a Sort Button in Microsoft Excel

18 July 2023 Anna Bruno 0

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

How to perform calculations with Excel

29 December 2022 Paolo Bergamaschi 0

After reading these tips, you will be able to perform basic addition, subtraction, multiplication, and division operations with ease.

How to create a price list with Excel

13 March 2020 Anna Bruno 0

Excel allows formatting and layout options that enable the creation of an illustrated price list spread over multiple pages, with prices that update automatically as the price lists of various suppliers change.

How to create a crossword puzzle with Excel

18 August 2019 Anna Bruno 0

All the secrets to creating a crossword puzzle with Excel, defining the overall grid formatting and an advanced system for verifying the entered text.

How to manage a current account with Excel

14 April 2019 Anna Bruno 0

A spreadsheet to manage your current account, enter expense items, and record credits. Thanks to a clear graphical distinction, it is possible to know whether expenses or savings prevail.

Let’s monitor the diet with Excel

25 February 2019 Anna Bruno 0

If we have taken the big step of going on a diet, we need to keep everything under control: we want to proudly see every gram lost, chart in hand!

How to manage bills with Excel

25 February 2019 Anna Bruno 0

Have I already paid the phone bill? When does the electricity bill expire? Questions that we have all asked ourselves at least once. We can keep everything organized thanks to Excel.

Lotto game with Excel

5 January 2019 Anna Bruno 0

The tutorial “Lotto game with Excel” organizes spreadsheets useful for keeping track of lotto draws, overdue numbers, and cases related to the lotto game. All with simplicity, thanks to Excel.

How to prepare training for the football match with Excel

16 August 2018 Anna Bruno 0

Here is how to create a series of cards containing the data of the players on your football team in order to verify their characteristics and attendance at training sessions to be able to compile a truly “scientific” lineup.

Discover the most convenient phone rate

12 August 2018 Anna Bruno 0

The competition among telephone companies is becoming increasingly fierce and the rates are turning into a maze: connection fees, discounts, VAT… navigating it is getting more and more difficult, let alone finding the one that suits us best. Let’s try to get oriented with the help of Excel.

How to organize a wedding and gift registry with Excel

11 August 2018 Anna Bruno 0

A memo created with Excel to keep track of the wedding gift list progress, appointments, costs, and details associated with preparing one of the most important events in life: the wedding.