Cool Things To Do With Excel?

20 Excel Tricks That Can Make Anyone An Excel Expert

  • 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.

Contents

What is the craziest thing you can do with Excel?

Top Crazy Things You Can Do in 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 are 7 things you can use Excel for?

More Than a Spreadsheet: 7 Things You Can Do with Microsoft Excel

  • 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.

How do I make Excel fun?

Excel can be Exciting – 15 fun things you can do with your spreadsheet in less than 5 seconds

  1. Change the shape / color of cell comments.
  2. Filter unique items from a list.
  3. Sort from Left to Right.
  4. Hide the grid lines from your sheets.
  5. Add rounded border to your charts, make them look smooth.

How do you do Tetris on Excel?

Tetris on Excel

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

How do I make an Excel spreadsheet look pretty?

Excel for Architects – 9 Steps to Beautiful Spreadsheets

  1. Choose a good font.
  2. Align your data.
  3. Give your data some space.
  4. Define your headers.
  5. Choose your colors carefully.
  6. Shade alternate rows for readability.
  7. Use Grids Sparingly.
  8. Create cell styles for consistency.

What are the 3 common uses for Excel?

The three most common general uses for spreadsheet software are to create budgets, produce graphs and charts, and for storing and sorting data. Within business spreadsheet software is used to forecast future performance, calculate tax, completing basic payroll, producing charts and calculating revenues.

What are the 10 uses of Microsoft Excel?

Top 10 Uses of Microsoft Excel in Business

  • 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 can excel be used in everyday life?

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.

Is there a game 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!

Is there a game hidden in Excel?

Microsoft Excel contained a hidden Doom-like mini-game called “The Hall of Tortured Souls”, a series of rooms featuring the names and faces of the developers.

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?

It is just as easy to color the tabs of each worksheet. To do so, simply right-click on a tab and then select “Tab Color” from the list of options. A palette of color options then appears from which to choose the desired color for the tab.

How many styles Does Excel 2010 have?

In Excel 2010, Microsoft promotes styles in Excel, adding a drop-down right on the Home tab offering 42 built-in styles as shown in Figure 1 (below). You can choose which styles you think are appropriate and which are not. In Figure 2, cell A1 has a Title style.

What are the 5 functions in Excel?

5 Functions of Excel/Sheets That Every Professional Should Know

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

What are the 5 uses of spreadsheet?

What Is the Purpose of Using a Spreadsheet?

  • Business Data Storage. A spreadsheet is an easy way to store all different kinds of data.
  • Accounting and Calculation Uses.
  • Budgeting and Spending Help.
  • Assisting with Data Exports.
  • Data Sifting and Cleanup.
  • Generating Reports and Charts.
  • Business Administrative Tasks.

How can Excel help you as a student?

Excel reduces the difficulty of plotting data and allows students a means for interpreting the data. You can also reverse the traditional process of analyzing data by giving students a completed chart and see if they can reconstruct the underlying worksheet.

How can excel help me in the future career?

Benefits of Excel for Employees

  1. Sharpening Your Skill Set.
  2. Improving Your Efficiency and Productivity.
  3. Making Yourself a More Valuable Member of the Company.
  4. Making You Better at Organizing Data.
  5. It Can Make Your Job Easier.
  6. It Creates Greater Efficiency and Heightens Productivity.

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 basic things in Excel?

The 10 most useful things you can do in Excel

  1. Conditional Formatting. Utility: 100. Difficulty: 3.
  2. PivotTables. Utility: 95. Difficulty: 3.
  3. Paste Special. Utility: 88.
  4. Add Multiple Rows. Utility: 87.
  5. Absolute References. Utility: 85.
  6. Print Optimisation. Utility: 84.
  7. Extend formula across/down. Utility: 84.
  8. Flash Fill. Utility: 84.