How to run spell check in Excel
![Built-in Spell Check in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-25.png)
Learn how to run spell check and how to turn on/off AutoCorrect quickly with Ted Jordan.
How to combine sales and forecast data in Excel chart
![Sales Forecast Graph in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/02/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-23-1.png)
Showcase actual vs targets in an Excel chart by following these quick and easy steps! Combine data to highlight your success.
Scroll to top button in Excel: how to add one?
![Navigation Button in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-22-1.png)
Add a scroll to top button in Excel to impress your customers and use shortcuts to go back to the first cell of your worksheet. Learn Excel tips and trick with Ted Jordan!
How to define names in Excel (tables)
![Transpose Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-20.png)
Discover shortcuts to create Excel tables and rename them; learn how to define selections and name them. Use structured references in Excel formulas to save time!
Excel TRANSPOSE formula: how to rotate columns to rows
![Transpose Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-20.png)
![Transpose Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-20.png)
![Transpose Function in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-20.png)
What’s the TRANSPOSE formula in Excel? How to flip rows and columns and keep the formatting when transposing? Learn how now!
How to format graphs in Excel
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-18-1.png)
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-18-1.png)
Learn how to format graphs in Excel for a more professional look: remove gridlines, style your graph title and rename axis labels.
Simple gauge chart in Excel: how to create one
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/02/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-17-1.png)
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/02/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-17-1.png)
Create a simple yet original gauge chart in Excel to highlight important metrics such as the number of clients you helped with your expertise.
Insert drop-down in Excel like a pro
![Insert Drop-down List in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-16.png)
![Insert Drop-down List in Excel](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/03/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-16.png)
Drop-down in Excel: learn how to insert Data Validation, modify drop-down lists and remove them with ease. And discover why Data Validation is greyed out.
Excel AutoSum shortcut: how to sum a column
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-15.png)
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-15.png)
The AutoSum shortcut or how to save time to calculate sum of columns or rows in Excel. Learn how to use AutoSum in MS Excel with our various examples (with short videos and with images).
How to use COUNTIF: greater than
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-14.png)
![](https://blogtedjordan.b-cdn.net/wp-content/uploads/sites/9/2024/01/Copy-of-Green-Spreadsheet-Data-Analysis-Instagram-Post-14.png)
COUNTIF: greater than, less than, not blank; this Excel function is so handy! Learn how to use it in your spreadsheets with Ted Jordan.