Excel Wizard

Become an Excel Wizard🪄 Follow for Tips & Tricks!📚 Work with me (click the link)🔗

[Excel Wizard @the_excelwizard]

How to Transpose data in Excel📚

[Excel Wizard @the_excelwizard]

Is there a better feeling than working on a VBA macro in Excel and it finally does what you wanted😮‍💨

[Excel Wizard @the_excelwizard]

Sorting by Color in Excel #exceltricks #exceltips

[Excel Wizard @the_excelwizard]

Excel Shortcuts for Grabbing Data Quickly #exceltips #exceltricks #excel

[Excel Dictionary @exceldictionary]

How to highlight the active row within your worksheet. 🤯 #excel

[Excel Wizard @the_excelwizard]

@exceldictionary #ref

[Excel Wizard @the_excelwizard]

@exceldictionary This may be a cool macro to build in VBA with chatgpt!

[Excel Wizard @the_excelwizard]

Conditional Formatting in Excel #exceltricks #exceltips #exceltipsandtricks #excel

[Excel Wizard @the_excelwizard]

@themissexcel Congrats! Those are some big numbers💪

[Excel Wizard @the_excelwizard]

Waterfall Charts in Excel #exceltips #exceltricks #exceltipsandtricks #waterfallcharts #excel #excelcharts

[Excel Wizard @the_excelwizard]

Stocks in Excel $AAPL #exceltips #excel #exceltricks #exceltipsandtricks #stocks

[Excel Wizard @the_excelwizard]

@blakeaburge This one is solid! You can also use the Concatenate function as well to combine cells 💪so it would be =concatenate(A3,” “,B3)

[Excel Wizard @the_excelwizard]

That's a wrap!

If you enjoyed this thread:

1. Follow me @the_excelwizard for more tweets like this.
2. RT the top tweet of the thread to share it with more people.

[Excel Wizard @the_excelwizard]

Want to make a Habit Tracker in Excel from scratch?

Here is a simple 7-step-by-step guide on doing just that:

[Excel Wizard @the_excelwizard]

7/ To track your progress over time, you can create a chart or graph based on the data in your habit tracker. For example, you could create a line chart to show how your completion rate for each habit has changed over the course of a month.

[Excel Wizard @the_excelwizard]

6/ You can also use formulas to calculate your overall completion rate for each habit. For example, you can use the COUNTIF function to count the number of cells with a checkmark in each column, and divide that number by the total number of rows to get your completion rate %.