Share this page!

Enter Twitter Thread URL to Unroll

Needs to be the full URL like: https://twitter.com/threadreaderapp/status/1644127596119195649

How to get URL link on Twitter App

  1. On the Twitter thread, click on or icon on the bottom
  2. Click again on or Share Via icon
  3. Click on Copy Link to Tweet
  4. Paste it above and click "Unroll Thread"!
  5. More info at Twitter Help
Anders Liu-Lindberg Profile picture
@LiuLindberg
Jul 19 β€’ 10 tweets β€’ 6 min read Twitter logo Read on Twitter
Learn Excel 101 for free.

Save 1,000s of dollars.

Let's dig into the curriculum.

6 Modules and 22 Lessons 🧡. Free Excel 101 Course
EXCEL BASICS

1. The Microsoft Excel Manual –

2. Processing data in Excel - https://t.co/Cyx50Q51qI

3. Excel formula bible - https://t.co/e9moRWydeVbit.ly/40Xn9WW
bit.ly/3m4imUw
bit.ly/3U7U5tl
DATA ANALYSIS

4. Data analysis in Excel -

5. 20 Tips and tricks for data analysis - https://t.co/6rmc30Hng0

6. Introduction to PivotTables - https://t.co/1aIFWQyOJg

7. Advanced Excel - https://t.co/i2OVLmIRqRbit.ly/3ZGg7oe
bit.ly/40yZa0r
bit.ly/3U2U9ui
bit.ly/3nI4DU4
VISUALIZATION

8. Creating charts -

9. Excel dashboards - https://t.co/3l6cyv8JZQ

10. Adding pictures to charts - https://t.co/Ah91tjKVrWbit.ly/3K9i4DU
bit.ly/3U2GKCw
bit.ly/3KpnD14
FINANCIAL MODELING

11. Financial Modeling with Excel -

12. Ten formulas for modeling - https://t.co/oe1qKdne5U

13. Five functions for modeling - https://t.co/BzXzGRe0Ma

14. Learn VBA - https://t.co/tgzcNiOlXo

15. VBA notes - https://t.co/Cgu1XMGLdVbit.ly/3mqtfR1
bit.ly/3K3NxY8
bit.ly/3GbQF35
bit.ly/432YstE
bit.ly/3Gbruh4
(1/2) CHEAT SHEETS FOR THE EXAM

16. Excel cheat sheet -

17. The formulas cheat sheet - https://t.co/ODBWJyXRMY

18. Excel Smart Guide - https://t.co/5JRlAwgxdnbit.ly/3zsAL0A
bit.ly/3m9CC7f
bit.ly/3Mc61Ix
(2/2) CHEAT SHEETS FOR THE EXAM

19. The Ultimate Excel Guide -

20. The 100 most useful Excel tips - https://t.co/QC0V0RsnLw

21. VBA cheat sheet - https://t.co/DwlQyUEV7lbit.ly/3GdLxeV
bit.ly/42XZHdM
bit.ly/3ma3bJs
CONTINUOUS LEARNING

22. How to boost your Excel skills -

How did you learn Excel?

What more would you like to know?bit.ly/40EyFGM
That's a wrap!

If you enjoyed this thread:

1. Follow me @LiuLindberg for more of these
2. RT this tweet to help others learn Excel 101.
Check out how we help finance teams elevate the influence they have in their company at .bpidk.org

β€’ β€’ β€’

Missing some Tweet in this thread? You can try to force a refresh
γ€€

Keep Current with Anders Liu-Lindberg

Anders Liu-Lindberg Profile picture

Stay in touch and get notified when new unrolls are available from this author!

Read all threads

This Thread may be Removed Anytime!

PDF

Twitter may remove this content at anytime! Save it as PDF for later use!

Try unrolling a thread yourself!

how to unroll video
  1. Follow @ThreadReaderApp to mention us!

  2. From a Twitter thread mention us with a keyword "unroll"
@threadreaderapp unroll

Practice here first or read more on our help page!

More from @LiuLindberg

Anders Liu-Lindberg Profile picture
Jul 19
Financial planning & analysis is one of the 10 most important areas of responsibility for CFOs.

Forecast accuracy is one of the ten most important KPIs for FP&A teams.

Here are 6 ways for CFOs to improve forecast accuracy 🧡. 6 ways to improve forecast accuracy
First an overview of the six ways to improve forecast accuracy:

1. Data quality
2. Rolling forecasts
3. Advanced analytics
4. Scenario planning
5. Collaboration
6. Monitoring
1/6 Data quality

Establish robust data management processes to collect, cleanse, and validate financial and operational data.

Implement systems and tools that enable efficient data integration and analysis.

Regularly review and improve data collection methods.
Read 10 tweets
Anders Liu-Lindberg Profile picture
Jul 16
π—œπ—»π˜π—Ώπ—Όπ—±π˜‚π—°π—Άπ—»π—΄ π—§π—›π—˜ π—¨π—Ÿπ—§π—œπ— π—”π—§π—˜ 𝗖𝗙𝗒 π—šπ—¨π—œπ——π—˜ 𝗧𝗒 π—§π—›π—˜ π—™π—œπ—‘π—”π—‘π—–π—˜ π—™π—¨π—‘π—–π—§π—œπ—’π—‘!

Never has this much guidance on how CFOs can successfully run the finance function been shared on a page.

Let's dig into the 29 resources 🧡. The Ultimate CFO Guide
1. The CFOs Guide to Managing the Finance Function -

2. The CFOs Guide to Measuring the Finance Function - https://t.co/G8fHbZLDPp

3. The ten responsibilities of a CFO - https://t.co/Skx3e0A2nRbit.ly/3CVuuw4
bit.ly/3piSCp5
bit.ly/3NxtMtN
4. The CFOs Guide to Financial Planning & Analysis -

5. The ten KPIs of a successful FP&A team - https://t.co/h91NywvCT0

6. The CFOs Guide to Financial Reporting - https://t.co/7b26kLfb0xbit.ly/43W8n4y
bit.ly/3NmXMsc
bit.ly/3CWgpOO
Read 13 tweets
Anders Liu-Lindberg Profile picture
Jul 15
CFOs are used to looking at lagging indicators but here's the challenge.

We cannot change the past and that's what lagging indicators are by definition.

Instead, CFOs should look at leading indicators to drive performance.

Let's check out the differences 🧡. Leading vs. Lagging indicators
Explaining leading indicators...

Leading indicators provide insights into future performance trends and potential outcomes.

They are predictive in nature and help identify early signals of potential success or challenges.

Leading indicators are proactive and forward-looking.
Explaining lagging indicators...

Lagging indicators provide information about past events and outcomes.

They are historical in nature and reflect decisions already taken.

Lagging indicators are useful for assessing the effectiveness of past strategies and actions
Read 7 tweets
Anders Liu-Lindberg Profile picture
Jul 12
Introducing "The CFOs Guide to Driving the Business"!

Retweet this tweet and I'll send you a link to download the high-res PDF version.

100 KPIs to keep the company on track and be a sparring partner to the CEO.

The KPIs are split across the following departments 🧡.
βœ… Strategy
βœ… Sales
βœ… Marketing
βœ… Operations
βœ… Procurement
βœ… Customer Service
βœ… Finance
βœ… HR
βœ… IT
βœ… Legal
1/10 Strategy

1. Revenue growth rate
2. Customer churn
3. Brand equity
4. Gross profit margin
5. Return on investment
6. Market share
7. Innovation rate
8. Free cash flow
9. EBITDA
10. EVA
Read 15 tweets
Anders Liu-Lindberg Profile picture
Jul 12
Learn Financial Analysis 101 for free.

Save 1,000s of dollars.

Let's dig into the curriculum.

6 Modules and 28 Lessons 🧡.
(1/2) FINANCIAL STATEMENT ANALYSIS

1. The Financial Statements -

2. All about KPIs - https://t.co/EF0fDuwdhb

3. Value driver analysis - https://t.co/xjMQarZCWZbit.ly/3m0PGvO
bit.ly/3oZpgLY
bit.ly/3Vr45OU
(2/2) FINANCIAL STATEMENT ANALYSIS

4. Vertical and horizontal analysis -

5. Budget vs. actuals - https://t.co/CQPvxmpR0u

6. Four types of data analysis - https://t.co/XZLKZN1uhebit.ly/3LN8mcq
bit.ly/40VJ8wT
bit.ly/41X8jQV
Read 12 tweets
Anders Liu-Lindberg Profile picture
Jul 12
Here are 6 ways for CFOs to improve the timeliness of their financial reporting.

Retweet this tweet and I'll send you four more ideas 🀝.

Check out these six ideas 🧡.
First an overview of the six ways...

1. Clear Deadlines
2. Templates & Tools
3. Data Integration
4. Reporting Milestones
5. Real-time Monitoring
6. Post-reporting Reviews
1/6 Clear deadlines

Set clear and realistic reporting deadlines for each stage of the reporting process.

This ensures that all stakeholders understand their roles and responsibilities.

It will also keep them aware of the expected timelines.
Read 10 tweets

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/month or $30/year) and get exclusive features!

Become Premium

Don't want to be a Premium member but still want to support us?

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

Donate via Paypal

Or Donate anonymously using crypto!

Ethereum

0xfe58350B80634f60Fa6Dc149a72b4DFbc17D341E copy

Bitcoin

3ATGMxNzCUFzxpMCHL5sWSt4DVtS8UqXpi copy

Thank you for your support!

Follow Us on Twitter!

Send Email!

:(