Here are some of the most creative uses of Excel to create fun, weird projects.
- Awesome AutoShape Art.
- A Sudoku Solver and Generator.
- A Traditional Slide Puzzle.
- A Working Flight Simulator.
- A Planetary Model.
- A Tetris Clone.
Contents
How do you make a spreadsheet fun?
The other keys are shown on the right hand side.
- 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 can you do with spreadsheets?
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 some cool things you can do with Excel?
The 10 most useful things you can do in Excel
- Conditional Formatting. Utility: 100. Difficulty: 3.
- PivotTables. Utility: 95. Difficulty: 3.
- Paste Special. Utility: 88.
- Add Multiple Rows. Utility: 87.
- Absolute References. Utility: 85.
- Print Optimisation. Utility: 84.
- Extend formula across/down. Utility: 84.
- Flash Fill. Utility: 84.
What are 5 things you can use a spreadsheet for?
Once this data is entered into the spreadsheet, you can use it to help organize and grow your business.
- Business Data Storage.
- Accounting and Calculation Uses.
- Budgeting and Spending Help.
- Assisting with Data Exports.
- Data Sifting and Cleanup.
- Generating Reports and Charts.
- Business Administrative Tasks.
How do you do Tetris on Excel?
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.
What is Vlookup in Excel?
VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.
How do you hide a worksheet?
Right-click the sheet tab you want to hide, or any visible sheet if you want to unhide sheets.
Hide or unhide a worksheet
- Select the worksheets that you want to hide.
- On the Home tab, in the Cells group, click Format > Visibility > Hide & Unhide > Hide Sheet.
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.
Why is excel the most popular spreadsheet?
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.
How do I impress in Excel?
Useful Excel Tricks that Will Impress Your Boss
- Eliminate Blank Cells.
- Modify the Size of the Rows and Columns.
- Add and Remove Columns, Rows, or Cells.
- Use Conditional Formatting.
- Create a Diagonal Like to Any Cell.
- Conceal Your Formulas.
- Convert Your Rows into Columns and Vice Versa.
- Save Charts as Templates.
How do I make an Excel spreadsheet look pretty?
Excel for Architects – 9 Steps to Beautiful Spreadsheets
- Choose a good font.
- Align your data.
- Give your data some space.
- Define your headers.
- Choose your colors carefully.
- Shade alternate rows for readability.
- Use Grids Sparingly.
- Create cell styles for consistency.
How can you use a spreadsheet in your daily 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.
How can I play Flash games in Excel?
How to Embed Flash Game in Excel Spreadsheet
- Download free flash game online or use one you already have.
- Open Excel and go to the top left option button.
- Click show developer tab in the ribbon.
- Go to the developers tab and click insert.
- Create an area on the spreadsheet as large as the window you are working on.
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 is not possible with VLOOKUP?
Problem: The lookup value is not in the first column in the table_array argument. One constraint of VLOOKUP is that it can only look for values on the left-most column in the table array. If your lookup value is not in the first column of the array, you will see the #N/A error.
Is 0 false in Excel?
You can use True , False , 1 , or 0 in the formula for this value. All values are valid. True is the same as 1 , False is the same as 0 .
What is macro in Excel?
An Excel macro is an action or a set of actions that you can record, give a name, save and run as many times as you want and whenever you want. Macros help you to save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently.
What are the letters at the top of a spreadsheet called?
By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65,536). These letters and numbers are called row and column headings.
How do I protect an Excel spreadsheet with a password?
In your sheet of interest, go to Home ribbon -> Format -> Hide & Unhide -> Hide Sheet and hide your sheet. Go to Review ribbon -> Protect Workbook, make sure Structure is selected, and enter your password of choice.
How do I stop someone from Unhiding my Excel spreadsheet?
Hide Sheet in Excel that user can’t unhide
- Go to Review Tab.
- Click on Protect Workbook (Structure option should be ticked)
- The password is optional.