Pro User
Timespan
explore our new search
50 things you didn't know Excel can DO
Excel
Aug 16, 2023 7:30 AM

50 things you didn't know Excel can DO

by HubSite 365 about Chandoo

Pro UserExcelLearning Selection

Get ready to be surprised and amazed.

Learn 50 advanced Excel functions through a free Excel + Power BI tips newsletter hosted on chandoo.org. This includes:

  • Quick file duplication
  • Adding buttons to Quick Access Toolbar (QAT)
  • Moving QAT and making custom list
  • Using Excel's GPS capabilities and Clipboard Tool
  • Pinning files for quick access
  • Changing Excel's color, default settings, and shortcuts
  • Using Excel's Top 10 filter and sorting by more than one column
  • Adding screenshots, hiding data, rotating text, selecting numbers, and adding new lines in cells
  • Finding and highlighting matching values
  • Using Navigator for bird's eye view, Data from picture, and TAKE function (Excel 365)
  • Editing formula ranges, moving help text, and using Unique function (Excel 365)
  • Adding images in cell (Excel 365), using Formulatext function, debugging formulas, using Formula result tooltip (Excel 365) and reverse formulas

Additional Excel Features

Aside from the tools mentioned, Excel provides additional capabilities:

  • Creation of new files
  • Recommendation of pivot tables and moving pivot fields
  • Hiding buttons in pivot tables, creating multiple pivots, and slicing pivots
  • Sorting pivot table field list, providing distinct count in pivots, and providing Median in Pivots (with DAX)
  • Setting your own Pivot Table defaults, hiding items in a chart, filtering charts, creating dynamic chart titles, and adding emojis or Images in charts
  • Creating tiny charts with sparklines, using negative values in a different color chart, creating combo charts, and adjusting charts range with a mouse

Learn about 50 things you didn't know Excel can DO 💡

Microsoft Excel is a powerful and versatile program that can be used for a wide range of tasks. It can be used to organize and analyze data, create charts and graphs, create formulas and equations, and much more. In this article, we will explore 50 things you didn't know Excel can do, including how to duplicate files quickly, adding buttons to the Quick Access Toolbar, creating your own lists in Excel, using GPS in Excel, accessing the clipboard tool, pinning files to quickly access them, changing the default number of sheets, rotating text in cells, selecting just numbers, using the new line function in a cell, using the Navigator to get a birds eye view of the workbook, using the TAKE function in Excel 365, using the Unique function, adding images to cells, using the Formulatext function to debug formulas, using the Goal Seek feature to reverse formulas, using Excel.New to create new files, using Recommended Pivots, sorting the pivot table field list, using the Distinct Count in pivots, using the Median function with DAX, setting pivot table defaults, hiding items in charts, using dynamic chart titles, using emojis, creating tiny charts with sparklines, using images in charts, using different colors for negative values in charts, creating combo charts, adjusting chart ranges with the mouse, and using the Recommended Charts feature. With these 50 tips and tricks, you can make the most of your Excel experience.

More links on about 50 things you didn't know Excel can DO 💡

Chandoo
50 things you didn't know Excel can DO 💡 · 5 POWER Tips to Analyze Data in Excel - End to End Project with Real Life Data.

Keywords

Microsoft Excel tips, Microsoft Excel tricks, Microsoft Excel features, Microsoft Excel functions, Microsoft Excel shortcuts