Sage-Tips

What is the most complicated thing you have done in Excel?

VBA, Macros & Automation No wonder VBA is the trickiest of Excel features. It took me more than 3 years to become proficient in VBA (and I had a head start as I learned VB programming in college). VBA is vast, technical and complicated (for those without programming or technical background).

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 is the coolest thing you can do in Excel?

All his work is online and has also been featured in museums.

• #2 CREATE A FULL LENGTH ROLE PLAYING GAME.
• #3 CONVERT ANY PHOTO INTO AN EXCEL SPREADSHEET.
• #5 CREATE A SUDOKU IN EXCEL.
• #6 PLAY A VIDEO GAME IN EXCEL.
• #7 CREATE 3D DANCING PENDULUMS.

What are some cool Microsoft Excel tricks?

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.

What are the Advanced Excel skills?

Advanced Excel Skills

• Now a days, many jobs require advanced Excel skills.
• Data, Power Query, Tables & Formatting.
• Conditional Formatting.
• Advanced Charting.
• Pivot Tables & Pivot Reporting.
• VBA & Macros.
• Using Excel Productively.
• Data Tables, Simulations & Solver.

What are some intermediate Excel skills?

Intermediate Excel Skills

• Go to Special. The GO TO SPECIAL option helps you navigate to a specific cell or a range of cells within the worksheet.
• Pivot Table. Pivot tables are one of the best ways to analyze data.
• Named Range.
• Drop Down Lists.
• Conditional Formatting.
• Excel Table.
• Idea Button.
• Using Sparklines.

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.

What are the things in MS Excel?

The main uses of Excel include:

• Data entry.
• Data management.
• Accounting.
• Financial analysis.
• Charting and graphing.
• Programming.
• Time management.
• Task management.

What is advanced knowledge of Excel?

Advanced knowledge of Excel means possessing the ability to use spreadsheets, graphing, tables, calculations, and automation efficiently to process large quantities of data relevant to business tasks. The way Excel is used depends on the needs and duties of specific departments or job roles.