Miscellaneous

What are some cool things you can do with Excel?

What are some cool things you can do with 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.

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?

READ:   Can you get your ex back after months of begging?

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.

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.

What are the main things to learn in Excel?

10 essential things you should learn about Microsoft Excel

  • How to create a Pivot Table in Excel.
  • How to enter basic formulas and calculations in Excel.
  • Use the SUM function to add up a column or row of cells in Excel.
  • Absolute and relative references in Excel.
  • Rounding numbers in Excel.

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.
READ:   Why do angel fish eat other fish?

What are the five benefits of using Microsoft Excel?

Top 5 Benefits of Microsoft Excel

  • Build great charts. Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells.
  • Use conditional formatting.
  • Help identify trends.
  • Bring data together.
  • Online access.

What is Excel and its uses?

Microsoft Excel is a spreadsheet program. That means it’s used to create grids of text, numbers and formulas specifying calculations. That’s extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart data and succinctly present fiscal results.

What can you do with Microsoft Excel?

Admit it, when you hear Microsoft Excel, you immediately think of calculations, formulas, graphs and tables – things usually used for organizing and analysis of data making charts, and other related whatnots. Did you know that Excel can actually be used for other interesting stuff like art and gaming?

READ:   How do I choose a good fund manager?

What games can you recreate with Excel?

Recreation of Iconic Games. Excel knows that when you work hard, you should also be able to play hard. Using Microsoft Excel, many people have managed to recreate iconic games like Pacman, Monopoly, Tetris, and more. More recent games like 2048 and Candy Crush Saga also now has their version in Excel format.

Is Excel 2010 still useful for beginners?

After Microsoft developed Excel to the 2010 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked.

How do you do a vague search in Excel?

You may know how to activate the speedy search by using the shortcut Ctrl + F, but there are two main wild cards—Question Mark and Asterisk—used in Excel spreadsheets to activate a vague search. This is used when you are not sure about the target result.