What cool things can excel do

One Click to Select All. … Open Excel Files in Bulk. … Shift Between Different Excel Files. … Create a New Shortcut Menu. … Add a Diagonal Line to a Cell. … Add More Than One New Row or Column. … Speedily Move and Copy Data in Cells. … Speedily Delete Blank Cells.

What is the craziest thing you can do with Excel?

Monopoly.
Sudoku. If you are a fan of Sudoku and are bored to find new Sudoku games to play, this is for you! …
Make Art, Not War. …
Arena. …
Flight Simulator Model.

What fun things can you do with Excel?

Awesome AutoShape Art. …
A Sudoku Solver and Generator. …
A Traditional Slide Puzzle. …
A Working Flight Simulator. …
A Planetary Model. …
A Tetris Clone.

What are 7 things you can use Excel for?

Accounting. Excel has long been a trusted accounting tool. …
Data Entry, Storage, and Verification. At its core, Excel is data-entry software. …
Data Visualisation. …
Data Forecasting. …
Inventory Tracking. …
Project Management. …
Creating Forms.

What can you use Excel for at home?

Whether it is family-based planning for a weekly, monthly or yearly calendar or a personal appointment daily planner or a schedule for managing bill payments, homework, favorite sports team’s games, and many more, excel can make it easy to compile, filter, search, organize and simplify large amounts of data.

What are the 10 uses of Microsoft Excel?

Business Analysis. The number 1 use of MS Excel in the workplace is to do business analysis. …
People Management. …
Managing Operations. …
Performance Reporting. …
Office Administration. …
Strategic Analysis. …
Project Management. …
Managing Programs.

How do you make a spreadsheet fun?

Solve your Sudokus in Excel. Play or solve Sudokus in Excel. …
Create your picture in Excel cells. Your picture in Excel: Each cell has one color. …
More fun? Play a slide puzzle. …
One more game: CellSweeper. Game in Excel: CellSweeper. …
(New) Follow up the most famous chess games.

What are the benefits of Excel?

Best way to store data.
You can perform calculations.
All the tools for data analysis.
Easy to data visualizations with charts.
You can print reports easily.
So many free templates to use.
You can code to automate.
Transform and clean data.

How does excel help students?

Excel reduces the difficulty of plotting data and allows students a means for interpreting the data. … This goes a long way toward helping them understand the relationship between the data and the chart. Excel can easily convert any chart or data set into a web page, making it very easy to share information among groups.

How do you do Tetris on Excel?

Step 1: Enable Macros. Open the excel file then enable the macros following steps: …
Step 2: Controls. The controls are based on keyboards and already set-up. …
Step 3: Scoring. Scores are based on lines completed.
Step 4: All Done! Whenever game is over, a message box will prompt.

Article first time published on

How do I make cute in Excel?

Don’t use column A or row 1. …
Use charts, but avoid 3D charts. …
Images are important. …
Resize rows and columns. …
Don’t use many colors. …
Turn off gridlines and headers, and chart borders. …
Avoid using more than 2 fonts. …
Table of contents.

Are there games in Excel?

Excel Games Roundup Almost all games use a combination of VBA and handcrafted macros to deliver the fun, but Excel can also play host to many flash games. Be warned: the flash games are much harder to hide from other people!

What is VBA in Excel?

VBA stands for Visual Basic for Applications. Excel VBA is Microsoft’s programming language for Excel. … and all the other Microsoft Office programs, like Word and PowerPoint. The Office suite programs all share a common programming language.

What are the 5 functions in Excel?

VLookup Formula.
Concatenate Formula.
Text to Columns.
Remove Duplicates.
Pivot Tables.

What are basic Excel skills?

Saving and Opening a Workbook. Saving and opening an Excel workbook is just like as you do in any other application. …
Managing Worksheets. …
Formatting Cells. …
Printing. …
Excel Functions (Basic) …
Charts. …
Sorting Data. …
Find and Replace Option.

What is Pivot in Excel?

A pivot table in Excel is an extraction or resumé of your original table with source data. A pivot table can provide quick answers to questions about your table that can otherwise only be answered by complicated formulas.

Why is Excel so popular?

Even after three decades, MS Excel is still the most preferred and used spreadsheet software around the world. Microsoft Excel is commonly used for financially-related activities. The reason for its popularity is that the user can define custom formulas for calculating quarterly, half yearly and annual reports.

What are the benefits of spreadsheet?

Formulae can be used to instantly recalculate totals. …
You can carry out “what if?” investigations. …
The information can be presented in different ways. …
It is easy to make these changes, save your work and print it out again.

What are the benefits of Excel essay?

Microsoft Access As A Database Program. …
Assessment Of Spreadsheet And Database Alternatives. …
Proposal for Data Migration, Increasing Efficiency and Collaboration in an Organization. …
Efficiency and Collaboration Proposal for New Information System.

What are the benefits of spreadsheet to you as a student?

Spreadsheet skills allow students to organize, calculate, graph, and analyze data. These skills provide a critical foundation in preparation for future studies and the workplace.

How do you make a game in Excel?

Fun and Games with Microsoft Excel Download Microsoft excel games. These games get download in few seconds. Extract the and open excel file and to play games in Excel, you need to enable Macro. Don’t worry its very easy, when you open the game file, a dialog box automatically appear and ask you to enable macros.

What are dashboards in Excel?

A dashboard is a visual representation of key metrics that allow you to quickly view and analyze your data in one place. Dashboards not only provide consolidated data views, but a self-service business intelligence opportunity, where users are able to filter the data to display just what’s important to them.

How do you make an Excel spreadsheet colorful?

Click Page Layout > Colors, and pick the set of colors you want. …
To create your own set of colors, click Customize Colors.
For each theme color you want to change, click the button next to that color, and pick a color under Theme Colors.

What is the best font for Excel?

Here is a quick tip, fonts of the sans-serif group are the best for your Excel spreadsheet if readability is your goal. Calibri, Helvetica, Arial or Playfair are few examples. If used with the right alignment, spacing, and color, they can bring out the best in your Excel presentation.

Is there still a flight simulator in Excel?

Microsoft Excel contained a hidden flight simulator. Microsoft Word contained a hidden pinball game. Microsoft Access contained a hidden simulation of the Magic 8 Ball toy.

How do I get to the Hall of Tortured Souls in Excel 2010?

Tap and hold CTRL + ALT + SHIFT, then click the tech support button. Then the game will appear. A window with a name “Hall of Tortured Souls” will appear. On the second level, you will see this stuff.

Can you play Doom in Excel?

A DOOM-like 3D engine has been created only using Microsoft excel formulas. What was once thought to be impossible has been done, a developer known C Bel has created a 3D DOOM-like engine only using Microsoft excel formula.

How does a Vlookup work?

The VLOOKUP function performs a vertical lookup by searching for a value in the first column of a table and returning the value in the same row in the index_number position. The VLOOKUP function is a built-in function in Excel that is categorized as a Lookup/Reference Function.

How do I create a unique ID in Excel?

1. type 1 into the cell which is adjacent to the first data you want to add ID number. 2. Then in the cell below it, type this formula =IF(B1=B2,A1,A1+1), press Enter key to get the first result, drag fill handle down until last data showing up.