SUBTOTAL Function: Calculates the total value of a filtered list in Excel
The sum function when filtering data is very important for Microsoft Excel users. This article will summarize for you how to filter and calculate sum in Excel using Subtotal.
Most people only use Excel as a tool to organize data, but its versatility goes far beyond spreadsheets. You can use it to play fun games, create beautiful works of art, and even organize your life using it as a calendar.
Table of Contents
One of the coolest things you can do with Excel is turn it into a gaming platform with a little creativity and some basic formulas. For example, you can create a Tic-Tac-Toe game by customizing cells to form a grid and using formulas to track the player's moves.
If you're feeling adventurous, you can try creating games like Minesweeper, Snake, or Pac-Man, with the help of VBA (Visual Basic for Applications) scripts. You don't have to start from scratch either - many Excel game templates are available online.
In addition to classic games, you can turn an Excel spreadsheet into an interactive Sudoku solver. A notable example comes from Reddit user /u/KrakenOfLakeZurich, who designed an impressive Sudoku solver entirely in Excel using only formulas and conditional formatting. This setup turns a basic spreadsheet into a dynamic puzzle solver, where you enter the given numbers of a Sudoku puzzle and Excel fills in the blanks.
Excel's conditional formatting visually highlights valid moves, while formulas ensure Sudoku rules are followed - no repeating numbers in rows, columns, or grids.
One of the lesser-known but surprisingly powerful features in Excel is the ability to edit images. It goes beyond the basic cropping, rotating, and resizing options – Excel offers other editing tools to enhance your images.
After inserting an image into your Excel spreadsheet, you can go to the Picture Format tab , where you'll find options to apply shadows, reflections, and soft edges to create a more polished, professional look. Like other Office applications, Excel also includes Picture Styles , which allow you to apply various borders and 3D effects to your images.
These options can be really useful if you're in a pinch and need to quickly improve an image - whether it's adjusting the style or even removing the background. Once you're done editing, you can save the image by right-clicking on it and selecting Save as Picture .
This may sound unusual—or even strange—but Excel’s AutoShape feature can help you create stunning works of art. One of the most famous examples of this is Tatsuo Horiuchi, a Japanese artist who turned Excel into his canvas. Using tools like AutoShape, Horiuchi created intricate landscapes that proved that Excel is more than just for calculations.
To create your own artwork, go to Insert > Illustrations > Shapes and use Excel's line tool as a precision tool to sketch out complex shapes or outlines. Then, pair it with Excel's fill tool for shading and coloring, turning your spreadsheet into a canvas.
For a creative approach, you can use Excel's grid structure as your canvas. By resizing cells into small squares, you can turn each cell into a "pixel" and color it differently to create anything from simple designs to complex, mosaic-like images.
You don't have to rely on online password generators to create strong passwords. Excel's built-in functions like RAND and RANDBETWEEN can help you generate complex, random passwords in seconds. For example, to create a random 8-character password that includes letters, numbers, and special characters, you can use the following formula:
=TEXTJOIN("", TRUE, CHAR(RANDBETWEEN(33,126)), CHAR(RANDBETWEEN(33,126)), CHAR(RANDBETWEEN(33,126)), CHAR(RANDBETWEEN(33,126)), CHAR(RANDBETWEEN(33,126)), CHAR(RANDBETWEEN(33,126)), CHAR(RANDBETWEEN(33,126)), CHAR(RANDBETWEEN(33,126)))
Additionally, you can use Excel's RAND, RANDBETWEEN, and RANDARRAY functions to generate random numbers. This is especially useful when you need to select winners from a list of entries, generate random samples for surveys, or assign numbers to sweepstakes entrants.
If you need to send personalized mass emails to a group of recipients, Excel can help. With Mail Merge, you can easily customize and send mass emails directly from Microsoft Word , using data stored in an Excel spreadsheet.
To do this, you'll first need to organize your recipients' details — like names, email addresses, and other personalized information — into columns in Excel. Then, you'll need to create an email draft in Word and link to your Excel file via Mail Merge . This feature lets you insert personalized fields (like names, addresses, or specific offers) into your email template, ensuring each person receives a tailored message.
Once everything is set up, Mail Merge will automatically fill in the details for each recipient, and you can send personalized emails in bulk – all from within Word. While this process takes a bit of time and effort to set up, it can save you hours when sending personalized emails to large groups.
Excel can be a powerful tool for creating interactive, fillable forms, whether they're surveys, questionnaires, or feedback forms. To get started, you'll need to enable the Developer tab , which gives you access to a variety of form controls like text boxes, checkboxes, and drop-down menus.
Once enabled, you can add various controls to your form by selecting them from the Controls group . For example, you can insert check boxes for yes/no questions or drop-down lists for multiple choice choices.
After you design a form, you can ensure data integrity by protecting your worksheet. You can customize protection settings to control user interaction, such as allowing users to fill out a form while preventing other changes.
If you like using Excel, why not turn it into your personal calendar? Excel offers a variety of templates for daily, weekly, monthly, and yearly planning that you can easily customize. Just choose a template you like, then adjust the layout to fit your work or personal schedule.
The main advantage of using Excel as a calendar is the level of customization it offers. You can modify colors, fonts, and even apply conditional formatting to highlight important dates, meetings, or tasks. This allows you to create a calendar that is not only functional, but also visually appealing.
Overall, the potential of Excel goes far beyond managing numbers and data. Take the time to explore its creative applications and who knows, you might unlock a whole new level of productivity and creativity.
The sum function when filtering data is very important for Microsoft Excel users. This article will summarize for you how to filter and calculate sum in Excel using Subtotal.
Airtable lets you create and share relational databases easily. Export your Airtable data to Google Sheets or Excel to enjoy the benefits of advanced charts and data visualization.
Curious about how ChatGPT can enhance your Excel experience? Here are some tips for using ChatGPT in Excel.
If you don't know how to create a family tree from scratch, these Microsoft Word and Excel templates can help you.
For a while, Google Sheets lured people away from Excel. But many people came back after realizing that Google Sheets is far from beating Excel.
You can calculate and visualize trends in Excel using the TREND function. Here's how to use the TREND function in Microsoft Excel.
Regex functions change that. Now you can specify exactly what you need—complex patterns, partial matches, or extracting structured data—without the effort.
How to fix the error of printing blank pages in Microsoft Excel. Why do some Excel documents not display data or contain blank pages when printed? Below are the reasons
How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite
How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file
How to insert a picture into a cell using VBA in Excel, You can easily insert pictures into Excel spreadsheets and edit them with macro code. Here's how to insert images
How to sync Microsoft Forms responses with Excel, Want to sync Microsoft Forms responses with Excel spreadsheets? Here's how to do it easily
To be able to easily change uppercase and lowercase letters in Excel, Microsoft has given us some functions to convert. The following article will provide the functions to support.
The IF function in Microsoft Excel is one of the most commonly used logical functions. In the simplest sense, the IF function will return a result based on one or several input comparison data.
Even the smallest makeup habits can unintentionally age you. This article will reveal the most common makeup mistakes that can age you without you even realizing it.
Below are some fun riddles about human body parts such as hands, feet, eyes, mouth... extremely interesting, please refer to them to quiz children, relatives or friends and have fun relaxing moments.
A series of reward chests, currencies, items and attractive gifts are waiting for you in the latest CMN Tay Du Truyen Ky game code.
In the process of processing and entering Excel data tables, there will be data that you need to convert from numbers to words. To do this quickly, instead of having to type manually, you can use some tools in the article below.
Instagram now lets you create your own Instagram message stickers from photos or videos already in your phone's album.
With iCloud Photos, you can view your entire photo library from any device. But you need to download photos from iCloud if you want to edit or do anything else. There are several ways to download photos from iCloud to devices like iPhone, Mac, and even Windows PC.
iPhone lists the full battery usage of applications, helping you know which applications use a lot of battery on your iPhone.
How to calculate the diagonal of a rhombus? Please find the calculation method and examples below to understand the formula for calculating the diagonal of a rhombus.
Kill Monsters to Save Princess, one of the longest named games in Roblox or shortened to Save Your Princess.
The latest Go Back to the West code will come with attractive items for you to exchange for rewards.
Download Blockman Go on PC to entertain you when your phone capacity is limited and the battery is low while playing.
Your PC ran into a problem and needs to restart and won't start? Here's how to fix it!
Even though the product has only been released for a short time, Nvidia RTX 5080 and RTX 5090 graphics card owners are complaining about a series of problems.
As a long-term support release, Ubuntu 20.04 LTS (Long-Term Support) will be supported with continuous updates for a total of 5 years, meaning it will reach end-of-life around April 2025.
Meow: Sen Oi Dung So gives gamers a series of codes with events for players to participate and receive rewards.