Inform Your 2021 By Looking At the Most Popular Finance Content of 2020
With 2020 being such an unusual and unexpected year, we’re looking back on our top content from the past 12 months. The lessons we have all learned from the changes 2020 brought can give you an advantage in 2021. COVID-19 brought a new urgency to financial reporting, with businesses needing to have an accurate view of their cash flow in order to inform future planning. Alongside this, many businesses implemented dashboards to keep track of key financial KPIs on a more regular basis. These enable them to have a visual view of what’s going on, for quicker understanding. And, as always, finance teams always have an interest in polishing up their Excel skills, so they can focus on the results of the calculations, not on how to perform the calculation in the first place.
Focusing on top priorities for the finance team in 2020, including cash flow, dashboards and KPIs, and getting ahead in Excel, we’ve compiled a number of guides and articles to inform your finance team’s decisions, moving into 2021.
2020’s Most Talked About Topic: Cash Flow
Cash flow has always been fundamental to organizations, but it became even more important with the pressures brought on by COVID-19 in 2020. Having a real-time view on your organization’s cash flow allows you to keep on top of your organization’s financial state and, crucially, enables you to make adjustments as soon as an issue arises. Below are some resources on manging your cash flow—a crucial skill moving into 2021:
- Five Tips to Manage Cash Flow Pressures
- How to Build a Free Cash Flow Dashboard, with Downloadable Template
- Our most popular cash flow webinar in 2020 focused on the challenges companies are facing to keep abreast of their cash flow. Watch this 20-minute video to learn how best-in-class businesses are solving cash flow challenges.
The Best of 2020: Dashboards and Key Metrics
Keeping a view on your organization’s KPIs is the main way to know whether or not they are on track. Using dashboards to do this makes it far easier (and quicker) for you to view the state of those KPIs you’re keeping track of. They also provide a quick insight for senior executives, so they don’t need to trawl through lots of data in order to make snappy decisions. To ensure your organization is reaching peak productivity, take a look at these resources:
- 25+ KPIs and Metrics for Finance Departments in 2020
- Best CFO KPIs and Dashboards for the 2021 CFO
- How to Optimize Your Accounts Receivable Dashboard with Examples
- With so many people looking for reporting solutions to improve their productivity, our most popular reporting webinar in 2020 was “Real-Time ERP Reporting in 20 Minutes.” Watch now to see how you too can streamline your reporting process
Hone Your Excel Skills with MrExcel’s Tips and Tricks
Keeping your Excel skills honed allows you to focus on what’s really important—results and planning. Don’t let Excel hold you back; it should be a key tool when working in finance. MrExcel has created 10 Excel Tips and Tricks videos for you to brush up on the following Excel skills
Troubleshooting VLOOKUP
- Six Advantages of XLOOKUP
- Three Pivot Table Tricks
- Superpower Data Model
- Make Pivot Tables Great
- Charting
- Sort Filter and Unique
- Tiny Charts
- Filter Hacks
- Keyboard Shortcuts
Take a look by visiting our Excel Resource Centre.