Whats the coolest thing you can do in Excel?

Here are 15 fun Excel project ideas for you to try:
  • Attendance tracking project. ...
  • Daily expense tracking. ...
  • To-do list. ...
  • Beautiful artwork creation. ...
  • Game development in Excel. ...
  • Creating Sudoku puzzles. ...
  • Making web games. ...
  • Creating a 3D pendulum.


What cool things can Excel do?

Complete List of Things You Can Do With Excel
  • Tools, Calculators and Simulations.
  • Dashboards and Reports with Charts.
  • Automate Jobs with VBA macros.
  • Solver Add-in & Statistical Analysis.
  • Data Entry and Lists.
  • Games in Excel!
  • Educational use with Interactive features.
  • Create Cheatsheets with Excel.


What is the craziest thing you can do with Excel?

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.


What is the most advanced Excel skill?

Advanced Excel Skills for Your Resume
  • Statistical Modeling.
  • Forecasting and Prediction.
  • Pivot Tables.
  • VBA and Macros.
  • Model Historic Stock Trends.


What is the hardest thing to learn in Excel?

Top 10 things we struggle to do in Excel & awesome remedies for...
  • VBA, Macros & Automation. VBA is the most struggling area of Excel. ...
  • Writing Formulas. Excel has hundreds of functions. ...
  • Making Charts. ...
  • Pivot Tables. ...
  • Conditional formatting. ...
  • Array Formulas. ...
  • Dashboards. ...
  • Working with data.


5 ADVANCED Excel Formulas to make you a PRO User



How do I use Excel like a pro?

Excel Tips
  1. Use Pivot tables to recognize and make sense of data.
  2. Add more than one row or column.
  3. Use filters to simplify your data.
  4. Remove duplicate data points or sets.
  5. Transpose rows into columns.
  6. Split up text information between columns.
  7. Use these formulas for simple calculations.


Can you add graphics in Excel?

Click the location in your worksheet where you want to insert a picture. On the Insert ribbon, click Pictures. Select Stock Images… Browse to the picture you want to insert, select it, and then click Open.

Can you make graphics in Excel?

Look for the line graph icon under the Insert tab. With the data selected, go to Insert > Line. Click on the icon, and a dropdown menu will appear to select the type of line chart you want. For this example, we'll choose the fourth 2-D line graph (Line with Markers).


How do I make zebra stripes in Excel?

Steps to create stripes:
  1. Click on the 'New Table Style. '
  2. Then, select 'First Row Stripe' in the New Table Style dialogue box.
  3. Click Format and select the color for shading. The preview window will show your chosen color scheme. ...
  4. Click OK.


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

What is very hidden in Excel?

From the user's perspective, what is the difference between hidden and very hidden sheets? It is simply this: a very hidden sheet cannot be made visible via the Excel user interface, the only way to unhide it is with VBA.


What are unique items in Excel?

Unique values would be a distinct list. To make it more clear, unique values are the values that appear in a column only once. Click on the link below and download the excel file for reference. We will use this workbook to demonstrate methods to find unique values from a column.

What are hot keys in Excel?

Workbook Shortcut Keys
  • To create a new workbook. Ctrl + N.
  • To open an existing workbook. Ctrl + O.
  • To save a workbook/spreadsheet. Ctrl + S.
  • To close the current workbook. Ctrl + W.
  • To close Excel. Ctrl + F4.
  • To move to the next sheet. Ctrl + PageDown.
  • To move to the previous sheet. Ctrl + PageUp.
  • To go to the Data tab. Alt + A.


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 you play Tetris on Excel?

So after downloading the excel file, here are the steps to follow to set-up the game.
  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!


Is there Animation in Excel?

Excel also has some built-in animations that you can use. To access these, go to the Insert tab and click on the Animation drop-down menu. Here you'll find a variety of animations that you can apply to objects in your workbook, such as text boxes, shapes, and charts.

Which art can be created in Excel?

SmartArt graphics can be created in Excel, Outlook, PowerPoint, and Word, and they can be used throughout Office.


Can you script in Excel?

Office Scripts in Excel let you automate your day-to-day tasks. You can create and edit scripts with the Code Editor. Run a series of Excel steps with a single button. Then, share that script with coworkers so everyone can improve their workflow.

How do you make 3d graphics in Excel?

Click the chart, and then click the Format tab on the ribbon. Click Shape Effects, then click 3-D Rotation, and the click 3-D Rotation Options.

Is Excel hard skill?

Microsoft Excel

Now, it is one of the most sought-after hard skills examples in most new-hire prospects, since data now plays a larger role in how organizations operate.


Is Excel soft or hard skill?

Hard skills include things like accounting, Microsoft Excel, typing, copywriting, or computer programming.

What is the most useful tool in Excel?

12 Most Useful Excel Functions for Data Analysis
  • IF. The IF function is extremely useful. ...
  • SUMIFS. SUMIFS is one of the most useful Excel functions. ...
  • COUNTIFS. The COUNTIFS function is another mega function for Excel data analysis. ...
  • TRIM. ...
  • CONCATENATE. ...
  • LEFT/RIGHT. ...
  • VLOOKUP. ...
  • IFERROR.


Can Excel be self taught?

You can teach yourself everything from the most basic Excel functions to complex programming using readily available or free online resources.


Is Excel harder than Python?

All in all, Excel is much easier to get started in and is much more user friendly, despite the handful of free tools out there meant to make Python easy to learn.