Discover and read the best of Twitter Threads about #excelformulas

Most recents (2)

6 Must have line charts for business data analysis 📈👌 💯

🧵
1. Indexed chart for comparing trend
2. #Sparkline for tiny insight
3. Spaghetti line #chart for bringing focus
4. Smoothed line chart for evening out edge
5. Forecast chart to predict future value based on trend & seasonality
6. Line chart combination when just a line won't do
▶ Line charts are similar to #scatterplots except that they connect the data points with lines. Choose a line chart when ordering and joining the #data points by their X-axis values highlights meaningful changes in the vertical Y-axis variable.
Read 4 tweets
Excel DATA VALIDATION is one powerful tool.
Here are TEN [10] tutorials to get up to speed:

#excel #exceltips #exceltricks #exceltutorials #excelformulas
1. Prevent Duplicate Data Entries in Excel with Custom Data Validation
youtube.com/shorts/oOgZLxB…
2. Make Budgets with spending limits in Excel
youtube.com/shorts/6kw8_ba…
Read 12 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!