Datarails

Catch our latest whitepaper: The CFO's Office 2.0 https://lnkd.in/dyPBauV5 Some of the findings: 1. 𝐀𝐈 𝐦𝐞𝐧𝐭𝐢𝐨𝐧𝐬 in 𝐂𝐅𝐎 𝐣𝐨𝐛 𝐥𝐢𝐬𝐭𝐢𝐧𝐠𝐬 𝐫𝐢𝐬𝐞𝐬 15% 𝐢𝐧 2024 🤖 CFOs saw the highest increase in mentions of AI skills (15%) with nearly one quarter (23%) of US CFO jobs requiring AI expertise or knowledge by April 2024. 2. 𝐒𝐨𝐟𝐭 𝐒𝐤𝐢𝐥𝐥𝐬 𝐑𝐢𝐬𝐢𝐧𝐠 𝐛𝐲 5% 𝐢𝐧 𝐅𝐢𝐧𝐚𝐧𝐜𝐞 𝐭𝐞𝐚𝐦𝐬 🥎 “Soft skills”–traits less able to be replicated by AI–saw a 5% increase in mentions across job posts in the CFO’s Office in 2024. Of these soft skills, “attention to detail” rose fastest for chief financial officer roles (18.7%). 3. 𝐑𝐞𝐦𝐨𝐭𝐞 𝐰𝐨𝐫𝐤 𝐨𝐧𝐥𝐲 𝐨𝐟𝐟𝐞𝐫𝐞𝐝 𝐢𝐧 14% 𝐨𝐟 𝐣𝐨𝐛𝐬 𝐢𝐧 𝐂𝐅𝐎’𝐬 𝐎𝐟𝐟𝐢𝐜𝐞 🏠 Remote work dropped from 19% of all finance positions in January to only 14% by April. The accountant position saw remote work opportunities rise by 6% (to 23% of vacancies) followed by controllers (22% of positions were work from home). FP&A roles saw a drop of 5% in remote work opportunities (to 19% of vacancies). Prominent organizations offering remote work for their finance team included Hennepin Healthcare, Volvo, Allstate. AECOM, and Harvard University. 4. 64% 𝐨𝐟 𝐂𝐅𝐎 𝐫𝐨𝐥𝐞𝐬 𝐫𝐞𝐪𝐮𝐢𝐫𝐞 𝐚 𝐌𝐚𝐬𝐭𝐞𝐫'𝐬 𝐃𝐞𝐠𝐫𝐞𝐞 𝐨𝐫 𝐌𝐁𝐀 🎒 For CFOs 64% of open vacancies require a master's degree or an MBA. This is followed by the FP&A position (42% requiring) followed by controllers (41%) and accountants (19%). Across the finance team 38% of vacancies list the need for a CPA. 5. 𝐄𝐱𝐜𝐞𝐥 𝐬𝐭𝐢𝐥𝐥 🔥𝐟𝐨𝐫 𝐂𝐅𝐎’𝐬 𝐎𝐟𝐟𝐢𝐜𝐞 Despite assertions that Excel may be replaced–as automation and AI continues apace– Excel skills are explicitly mentioned in 30% of all CFO’s Office roles by April 2023. Excel requirements are most common in FP&A vacancies (rising to 66% of all FP&A roles by April 2024). For accountants 36% of roles cited Excel skills, and for Controllers 24% did. By contrast, only 17% of CFO job listings state the need for Excel skills.

Eye of the Tiger

TOMORROW!! 🔗 We are partnering with our friends at CFO Connect. And we are giving you a tailored demo of Datarails (you lucky things!) Get a deep-dive into how Datarails can transform your FP&A with Trevor E., Account Executive at Datarails Sign up here: 👉 https://lnkd.in/d58SrYMG

1. The Best role in the CFO's Office for Remote Work? 2. Upcoming AMA 3. 🎧 FP&A as Business Intelligence – Len McFall 4. Meme of the Week

71 VITAL Excel Shortcuts ⌨️ Memorize these and watch your productivity FLY 💨 Follow Josh Aharonoff, CPA for more great content like this! I get asked all the time “do excel keyboard shortcuts really matter?” The short answer? YES The long answer? Each movement from your keyboard to your mouse is a disruption in your workflow that shaves off seconds of productivity… and these seconds really start to add up when you perform hundreds of tasks in Excel. These shortcuts may seem overwhelming, but they are actually REALLY easy once you start to see the patterns, and once you practice them. By the 3rd or 4th time practicing a shortcut, it starts to seep into your muscle memory… and before you know it, your fingers are conducting a symphony on your excel sheet. While there are hundreds of shortcuts available, these are the 71 shortcuts that I use almost everyday… ➡️ THE EASY ONES These shortcuts are ones you can find in almost any application 1. Ctrl c - copy 2. Ctrl x - cut 3. Ctrl v - paste 4. Ctrl a - select all 5. Ctrl s - save workbook 6. Ctrl n - new workbook 7. Ctrl o - open workbook 8. Ctrl p - print workbook 9. Ctrl f - find 10. Ctrl z - undo 11. Ctrl y - redo 12. Ctrl b - bold 13. Ctrl u - underline 14. Ctrl i - italic ➡️ THE ESSENTIALS These are the ones that will yield massive efficiencies 1. Ctrl arrow - jump to next / last active cell 2. Shift arrow - highlight cells 3. Select row - shift + space 4. Select column - ctrl + space 5. Insert row / column - ctrl + + on numerical keypad 6. Delete row / column - ctrl + - 7. Remove gridlines - alt + w + vg 8. Insert Cut cells - alt + h + i + e 9. Add data validation - alt + a + v + v 10. Freeze panes - alt + w + f + f 11. Autofit cells - alt + h + o + i 12. Create table - ctrl + t 13. Create filter - Alt + H + S + F 14. Change windows - Alt + W + W 15. Group cells - Alt + A + G 16. Ungroup Cells - Alt + A + U 17. Remove Duplicates - Alt + A + M 18. Define name - Alt + M + M 19. Autosum - Alt + = 20. Access dropdown - Alt + ↓ 21. Ctrl + 1 - open cell dialogue box 22. F2 - edit cells 23. F4 - fix references 24. F5 - go to ➡️ BORDERS Simply hit ALT + H + B and then any of these letters… 1. All - alt + h + b +a 2. None - alt + h + b + n 3. Left - alt + h + b + l 4. Right - alt + h + b + r 5. Top - alt + h + b + p 6. Down - alt + h + b + o 7. Outer edge - alt + h + b +s 8. Change color - alt + h + b + i ➡️ PASTE SPECIAL Pasting is as big part in excel - but there’s so much more than just pasting with CTRL V. To access these, simply hit ALT + H + V and any of these letters 1. Format - alt + h + v + r 2. Values - alt + h + v + v 3. Transpose - alt + h + v + t 4. Picture - alt - h + v + u 5. Formula - alt + h + v + f === I couldn’t list all 71 shortcuts due to the character limit… but you can watch this free video to learn them all: 🔗 https://lnkd.in/eybiANKN Which one is your favorite shortcut?

Really, it's fine

Ambitious CFOs all agree. They want to be in the media. McKinsey surveyed CFOs looking to advance. “If there was one area our interviewees most emphasized developing, it’s external stakeholder management. “Press and external relations.” Learning from CFOs doing it well 👇 1️⃣The Soundbite Lander” Starbucks CFO Rachel Ruggeri ☕ Examples of her direct and unambiguous language to media “We have be worth paying for” “The U.S. customer remains loyal though, through and through.”  2️⃣ Using FP&A insights to stimulate conversations 🍦 Graeme Pitkethly, former CFO of Unilever. Pitkethly explained how forecasting planning models for sales of items like Magnum and Cornetto. CNN and other media lapped it up like a Hot Fudge Sundae. 3️⃣ CFOs who let us peer into the Batcave 🎬 BatGirl, a $90million too-bad-to-release movie was sacrificed as a tax write-off. Warner Bros. Discovery’s CFO Gunnar Wiedenfels didn’t simply say no comment “My team has helped them by providing financial data points where possible, and a framework to assess the potential from a financial perspective.” (The Hollywood Reporter) 4️⃣ Connect the Finance Dots 🌭 Keep it simple (and real) like Outgoing Costco CFO Richard Galanti He speaks about iconic things such as Costco’s most famous offering The $1.50 hotdog and soda combo Which other CFOs are great at presenting the numbers to media? Let us know your favorites ⬇

1. New Datarails report: analysis of 2,000 job vacancies for U.S. CFOs, senior accountants, controllers, and FP&A roles 2.  The biggest FP&A event of the year is today and tomorrow 3. 🎧 FP&A Today: My Adventures in Finance Real Estate: From Whistleblowing Fraud to Big Wins for Residents Seth Zimmerman 4. Meme of the Week Catch our must-read weekly summary

If you're planning to become a data analyst or business intelligence analyst but feel unsure about where to start, this post is for you. You don't need to spend money on expensive courses to succeed in this field. Many LinkedIn posts promoting paid courses are often shared by individuals trying to sell their own products or being compensated to endorse these courses. 1. SQL: The Foundation SQL is one of the most in-demand skills for data roles. You can learn SQL from free resources like: - freeCodeCamp on YouTube - Thoufiq Mohammed on YouTube Most data interviews start with SQL rounds. Practice questions on: - LeetCode - StrataScratch - DataLemur 🐒 (Ace the SQL & Data Interview) 2. Excel: The Underrated Powerhouse Excel is highly useful but often underrated. Learn Excel from: - Chandoo.org on YouTube - Lokesh Lalwani on YouTube 3. Data Visualization: An Extra Edge Learn a data visualization tool like Tableau or Power BI. Recommended resources: - Pavan Lalwani 🇮🇳 on YouTube - Kevin Stratvert on YouTube - Leila Gharani on YouTube 4. Showcase Your Skills: Projects and Portfolios Creating projects and portfolios will help you stand out. Find datasets on Kaggle For guidance on creating your data portfolio, watch videos by: - Alex Freberg on YouTube - Luke Barousse on YouTube - Mo Chen on YouTube 5. Quality Over Quantity Don’t overwhelm yourself with too many resources. Focus on the ones mentioned above. Best Telegram channels for Data Analytics with Free Resources 👇👇 ❯ Python ➟ https://t.me/dsabooks ❯ SQL ➟ https://t.me/sqlanalyst ❯ Data Analysts ➟ https://t.me/sqlspecialist ❯ Excel ➟ https://t.me/excel_analyst ❯ PowerBI ➟ https://lnkd.in/ddDbrkVi ❯ Data Science Portfolio➟ https://t.me/DataPortfolio ❯ Projects ➟ https://lnkd.in/dbYpFh-d ❯ Data Science & Machine Learning ➟ https://lnkd.in/dWphueEQ Credit Data Analytics - make sure to follow on LinkedIn. Join Data Analytics' data community of 50,000+ subscribers on Telegram to get free books and useful resources. Free Courses with Certificates 👇👇 https://lnkd.in/dfvpeggF #dataanalytics #dataanalyst #sql #excel

9 Best Power BI Videos on YouTube 📊📽️ Curated by Financial Modeling World Cup Learn Power BI from these amazing YouTube videos! 🤩 1️⃣ Data Modeling for Power BI by Pragmatic Works: https://lnkd.in/dBSz6cMU 2️⃣ Power BI Full Course in 8 Hours by Pavan Lalwani 🇮🇳: https://lnkd.in/dMvNTX7e 3️⃣ Power BI Tutorial for Beginners by Kevin Stratvert: https://lnkd.in/dfM69Fit 4️⃣ How to Build Power BI Reports from Start to Finish by Mynda Treacy (MyOnlineTrainingHub): https://lnkd.in/dNk4peeu 5️⃣ Upgrade Your REPORT DESIGN in Power BI by Bas Dohmen (How to Power BI): https://lnkd.in/dyi9SkNm 6️⃣ Should You Learn Power BI? by Leila Gharani: https://lnkd.in/d6hyPzWb 7️⃣ Master Power BI Essentials in Just 15 Minutes by Kenji Farré (Kenji Explains): https://lnkd.in/dimBxNnT 8️⃣ Full Power BI Guided Project by Alex Freberg (Alex The Analyst): https://lnkd.in/dqxs9HeH 9️⃣ Learn Power Pivot & DAX for Power BI with 20 Beginner to Pro Examples by Purna Duggirala (Chandoo): https://lnkd.in/dNVNhhsx Check out 9 Best Advanced Excel Videos: https://lnkd.in/dg9gGKip