Office Productivity Hacks

EBITDA explained to Kids Brilliant Share By: Nicolas Boucher Original Post Below 👇 👇 👇 "EBITDA explained to Kids Explanations for kids... and adults! 💰 What is EBITDA? EBITDA stands for: Earnings Before Interest Taxes Depreciation Amortization It's a financial metric that shows how much money a company makes before taking into account certain expenses. ❗️ Why is EBITDA important for Businesses? EBITDA is important because it gives businesses an idea of how much money they're generating from their operations. This is useful for investors and lenders who want to know how profitable a company is. It’s like a scorecard to know how much money a company is making. 💸 How is EBITDA calculated? To calculate EBITDA, you need to start with a company's revenue and subtract its cost of goods sold. Then, you subtract its operating expenses (like salaries and rent). This gives you the company's EBITDA. 👧🏼 Example: Let's say you and your friends sell lemonade from a stand. You make $20 selling lemonade, but you spent $5 on lemons, sugar, and cups. You also spent $5 on flyers to advertise your lemonade stand. To calculate your EBITDA, you would start with the $20 you made selling lemonade, and subtract the $5 you spent on lemons, sugar, and cups. This leaves you with $15. Then, you would subtract the $5 you spent on advertising. This leaves you with an EBITDA of $10. 🔼 EBITDA vs Net Income Imagine that on top of your expenses of your lemonade stand you have to pay taxes (for example to be allowed to sell on the street). Imagine as well that you need to put money aside to invest in a new machine or a new stand because your machine is getting old. This is called depreciation. In EBITDA, you don’t take consideration these expenses. But the net income is what remains as profit after all these expenses are taken in account. 👉 Do you have other examples? Share this example around with kids… and adults! (By liking or commenting you will help give visibility to this post, if you found it valuable, consider giving a like 😉)" ____________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

RIP Microsoft Excel? Brilliant Share By: Paul Storm Original Post Below 👇 👇 👇 "RIP Microsoft Excel? No more wasted time on manual calculations and tutorials. Use these 14 AI tools that will do your excel work in minutes. [ Save now ] 1.Equals Tap in to the power of AI from your spreadsheet.  From blank sheet to insight, all you have to do is ask. https: equals. com 2.Rows. com is a next-generation spreadsheet. It’s the easiest way to import data from your SaaS tools, DBs and APIs, such as Notion, Google Analytics, BigQuery, HubSpot and more. https: rows. com 3.Julius AI • Experience the power of AI to analyze your spreadsheets like a pro. • Uncover trends by chatting with your data and Visualize and forecast with ease • Also, Analyze Excel, CSV, and Google Sheets effortlessly 🔗 https://lnkd.in/dEcXgNHS 4.Tomat AI Open and analyze CSV or Excel without code.  Easy step-by-step interface. https: www.tomat. ai 5.ChatCSV The way you normally talk, but with your spreadsheets. Your new personal data analyst. https: www.chatcsv. co 6.Sheetplus AI • Write Google Sheets and Excel formulas 10x faster with its built-in AI Tool. • Save time and become a spreadsheet master with this amazing AI Tool. 🔗 http: sheetplus. ai 7.Formulagod Chat about your data with AI in Google Sheets Generate tables, graphs, formulas, and insights, and directly amend your Sheets without ever changing tabs. https: www.formulagod. ai 8. Simple ML for Sheets Simple ML for Sheets is an add-on for Google Sheets from the TensorFlow Decision Forests team that helps make machine learning accessible to all. https://lnkd.in/g8Av2r6e 9.Smartsheet: It combines project management and spreadsheets. • Multiple views: grid, calendar, Gantt • Interactive dashboard for real-time progress; • Set alerts and reminders for deadlines; • Automated workflows to reduce repetitive tasks 🔗 https: smartsheet. com 10.Chartify Chartify is a completely new way to interact with your data.  No more using frustrating chart editors on Google Sheets and Excel or manually coding up charts in Plotly. https: www.chartify. it/ 11.SheetAI SheetAI put’s AI with Brain in your Google Sheets. describe what you want in plain English, and watch the magic happen in your spreadsheet! https: www.sheetai. app/ 12. ChatGPT for Excel: Your Productivity Powerhouse! • Streamlines workflows • Automates tasks • Gains insights from data effortlessly • Saves time on every project" ____________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

Free Accounting Cheat Sheet Brilliant Cheat Sheet By: Josh Aharonoff, CPA Original Post Below 👇 👇 👇 "Free Accounting Cheat Sheet This infographic contains close to everything I learned while getting my degree in Accounting 📣 Help me spread financial literacy by liking, sharing, and commenting! 📣 Looking to get a copy of this Cheat sheet? Like & comment below Here’s what’s included: ➡️ The Accounting Equation → Assets = Liabilities + Owners Equity This shows you how your balance sheet must always tie. Items of economic value (assets) were funded by capped amounts owed to creditors (liabilities) and uncapped amounts owed to owners ➡️ Debits & Credits → Debits & Credit showcase which accounts on your General Ledger are increasing or Decreasing. They must always equal each other ➡️ Cash vs Accrual The Cash basis → treats money in as income, and money out as expenses The Accrual basis → treats money earned as income, benefits incurred as expenses ➡️ GAAP vs IFRS GAAP → stands for Generally Accepted Accounting principles, primarily used in the US. IFRS → stands for International Financial Reporting Standards, and is used for reporting internationally ➡️ Bank Reconciliations → Bank reconciliations allow you to confirm the bank balance shown on our general ledger to your bank account. This is the most important part of a month end close ➡️ Chart of Accounts → These are the accounts that show up on your income statement and balance sheet (or general ledger) ➡️ The 3 Financial Statements Profit and Loss → what you are earning vs consuming) Balance Sheet → A snapshot in time showing items of economic value, capped amounts owed to creditors, and uncapped amounts owed to owners Cash Flows → movements in your cash flows, prepared by either the direct or indirect method ➡️ 10 Accounting interview Questions → these questions are common to be asked in an interview, and can help reveal just how strong your foundation in accounting is ➡️ 10 Common Adjusting Journal Entries → these journal entries are often times booked as part of a month end close ➡️ Balance Sheet Ratios → these ratios involve the balance sheet, allowing you to get key insights ➡️ Cash Flow Ratios → these ratios allow you to understand different metrics around your cash, which is your most important asset ➡️ Profitability Ratios → these ratios help you understand the different levels of profitability in your business 📣 Get a copy of this cheat sheet by liking and commenting below 📣" ________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

I said we should run meetings like this cartoon — and then, OMG, SOMEONE ACTUALLY DID IT! Great Share By: Jason Feifer Original Post Below 👇 👇 👇 "I said we should run meetings like this cartoon — and then, OMG, SOMEONE ACTUALLY DID IT! The background: I posted this New Yorker cartoon on LinkedIn last week, and said we should take it seriously. Why? Because when we put 30 or 60 minutes on the calendar, we blindly fill the time — even if we don’t need it. But constraints force focus. Obviously planks is a joke, but we’d do better with intentional forcing functions — like weirdly timed meetings (7 minutes!) or walk-and-talks. I hoped it would get people thinking — but I did NOT expect this response! O2E Brands founder Brian Scudamore sent me this photo from his office. “3 out of 3 agree — it actually works!!” he wrote. What great leadership... because no matter what happened, I bet they had fun. They tried something new. They used their time wisely. And how many meetings can you say THAT about?" ____________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

KPIs CHEAT SHEET Brilliant Cheat Sheet By: Nicolas Boucher Original Post Below 👇 👇 👇 "KPIs CHEAT SHEET 50 KPIs for Finance Includes explanations and formulas! 👉 Here is the High Resolution PDF https://lnkd.in/dTskw9eK You see a lot of KPIs lists but they miss something: 1) These lists do not explain the goal of the KPI 2) These lists do not give you the KPI formula In this Cheat Sheet you get both! Because a KPI is not helpful without explanation and without formula... Take it as a catalog from which you can pick 3 to 4 key KPIs. I like to take 4 KPIs to make a 4 quadrant dashboard. The standard quadrant I would recommend? This one: 1. Revenue Growth 2. Net Profit Margin 3. Operating Cash Flow 4. Employee engagement What would be yours? You can pick in the 50 following KPIs: 🧾 Accounting KPIs: 1. Debt-to-Equity Ratio 2. Invoice Processing Time 3. Working Capital Ratio 4. Net Profit Margin 5. Return on Equity 6. Gross Profit Margin 7. Accounts Receivable Turnover 8. Fixed Asset Turnover 9. Accounts Payable Turnover 10. Inventory Turnover 💰 Cash KPIs: 11. Operating Cash Flow 12. Days Payables Outstanding 13. Average Days Delinquent 14. Days Sales Outstanding 15. Days of Inventory Outstanding 16. Cash Burn Rate 17. Free Cash Flow 18. Cash Conversion Cycle 19. Cash Reserves in Days 20. Overdues Ratio 👨💼 CEO KPIs: 21. Revenue Growth 22. Market Share 23. Employee Productivity 24. Innovation Index 25. Brand Equity 26. Market Expansion 27. Sustainability Metrics 28. Employee Engagement 29. Employee Turnover 30. Cash Flow 🖥 SaaS KPIs: 31. Lifetime Value 32. SaaS Quick Ratio 33. New Buyer Growth Rate 34. ARR Per FTE 35. Customer Churn Rate 36. Runway 37. Customer Acquisition Costs 38. Monthly Recurring Revenue 39. Average Revenue Per User 40. Total Addressable Market 💼 Investors KPIs: 41. Earnings per Share 42. Quick Ratio 43. Dividend Payout Ratio 44. Current Ratio 45. Return on Investment 46. Share Buyback Ratio 47. Price-to-Earnings Ratio 48. Gross Margin Ratio 49. Dividend Yield 50. Net Promoter Score Note: Average Revenue Per User Formula and definition contain a mistake and should be Total Revenue / Total Users Note 2: People engagement explanation is also wrong. All the corrections were done in the PDF that you can download (see link at the beginning)." ________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

EVERYTHING about Dates & Time in Excel. Brilliant Share By: Mynda Treacy Original Post Below 👇 👇 👇 "EVERYTHING about Dates & Time in Excel.    >>> See the comments for download link to hi-res cheat sheets, plus PDF and Excel file.   🎁 SHARE, comment and like this post and spread the Excel love.   These guides go under the hood to expose how Excel treats dates and times, as well as formulas for common calculations, functions, shortcuts and more.   Excel Date & Time 101 - Get up to speed fast! - How Excel Handles Date and Time - Entering Dates and Time - Simple Date and Time Math - Shortcuts for entering Dates and Time   Functions - Every date and time function in Excel, explained!   Formatting - Custom Date Formats - Custom Time Formats - How to tell if Dates are entered as Text - Fixing Dates Entered as Text - Converting Dates to Text - Extract Month Number from Text Month Name - Extract Date/Time Elements from Date-Time Serial Number   Common Calculations - Calculate Age or Years of Service - Difference between Dates - Difference between Times (same day) - Difference between Times (different days) - Finding Dates - Rounding Time and Time Intervals  - Convert Time to Decimals - Convert Minutes to Hours, Hours to Days etc.   Template - Timesheet Template 🔖Follow me for more tips like this to help you stand out from the crowd. 💬 Did I miss any tips? Let me know what your favourite tip is in the COMMENTS. I read them all! Or if you’re short of time, please click the 👍 #Excel #MicrosoftAmbassador" ________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

Reportedly] Elon Musk sent an email to the staff at Tesla with his 6 rules for productivity. Unsurprisingly, it leaked. Brilliant share By: Paul Storm Original Post Below 👇 👇 👇 "Reportedly] Elon Musk sent an email to the staff at Tesla with his 6 rules for productivity. Unsurprisingly, it leaked. Here they are: 1) Avoid large meetings Large meetings waste valuable time and energy. - They discourage debate - People are more guarded than open - There’s not enough time for everyone to contribute Don’t schedule large meetings unless you’re certain they provide value to everyone. 2) Leave a meeting if you’re not contributing If a meeting doesn’t require your: - Input - Value - Decisions Your presence is useless. It’s not rude to leave a meeting. But it’s rude to waste people’s time. 3) Forget the chain of command Communicate with colleagues directly. Not through supervisors or managers. Fast communicators make fast decisions. Fast decisions = competitive advantage. 4) Be clear, not clever Avoid nonsense words and technical jargon. It slows down communication. Choose words that are: - Concise - To the point - Easy to understand Don’t sound smart. Be efficient. 5) Ditch frequent meetings There’s no better way to waste everyone’s time. Use meetings to: - Collaborate - Attack issues head-on - Solve urgent problems But once you resolve the issue, frequent meetings are no longer necessary. You can resolve most issues without a meeting. Instead of meetings: - Send a text - Send an email - Communicate on a discord or slack channel Don’t interrupt your team’s workflow if it’s unnecessary. 6) Use common sense If a company rule doesn’t: - Make sense - Contribute to progress - Apply to your specific situation Avoid following the rule with your eyes closed. Don’t follow rules. Follow principles." ________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

Excel CTRL Shortcuts Cheat sheet 👇 Brilliant Cheat Sheet By: Josh Aharonoff, CPA Original Post Below 👇 👇 👇 "Excel CTRL Shortcuts Cheat sheet 👇 ⬇️ Download this cheat sheet in high resolution and hang it up!  (check bottom of cheat sheet for free download link). If you aren’t using keyboard shortcuts in excel… you are MISSING out… and most likely adding tons EXTRA TIME with your mouse 🐌 Lucky for you, I have aggregated this cheat sheet for you to bookmark and refer to whenever you need 🤓 Let’s do a walk through each of them: ➡️ THE EASY ONES TO REMEMBER CTRL + S → save workbook CTRL + O → open workbook CTRL + N → new workbook CTRL + C → copy CTRL + X → cut CTRL + V → paste CTRL + B → bold CTRL + U → underline CTRL + I → italicize CTRL + F → find CTRL + A → select all CTRL + T → insert table CTRL + P → print CTRL + Z → undo CTRL + Y → redo ➡️ THE REALLY USEFUL ONES CTRL + ARROW KEYS → Jump to first / last cell in region CTRL + SPACE → select column CTRL + 1 → format cells CTRL + PgUp / PgDn → toggle up or down tabs CTRL + [ → select direct precedents CTRL + ] → select direct dependents CTRL + - → delete column / row CTRL + + → insert column / row ➡️THE ONES YOU MAY NOT HAVE KNOWN CTRL + Q → analysis CTRL + W → close CTRL + E → flash fill CTRL + G → go to CTRL + H → replace CTRL + K → hyperlink CTRL + : → insert time CTRL + ; → insert date ➡️ THE ONES USING 3 KEYS CTRL + ALT +V → opens paste special dialogue box CTRL + SHIFT + ` → convert format to plain text CTRL + SHIFT + O → select comment cells CTRL + SHIFT + U → toggle formula bar CTRL + SHIFT + L → toggle filters CTRL + SHIFT + F3 → Create named range from selection CTRL + SHIFT + F6 → Previous workbook window and many more!" ________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

100 Finance Answers Brilliant Cheat Sheet By: Nicolas Boucher Original Post Below 👇 👇 👇 "100 Finance Answers Learn Accounting / Excel / KPIs / Cash Bookmark this, you'll save 1,000 of hours! 👉 Follow, Like and Comment to get the High Resolution PDF Then download it here: https://lnkd.in/gPCnFHYm What do we cover? A list of answers that all Finance Professionals need. If you want more explanations, feel free to ask in the comment section. Here is a preview: 💹 Accounting 1. How is the accrual principle applied? → Records revenues & expenses when earned/incurred 2. How does the consistency principle work? → Use same methods every accounting period 3. How is the matching principle used? → Match expenses with revenues of same period 4. How does the cost principle function? → Record assets at cost paid, not current value 5. How is the monetary unit assumption applied? → Record only quantifiable transactions (get the answers 6-25 in the Cheat Sheet below) 📊 Excel 26. How to calculate NPV in Excel? → Use =NPV(rate, value1, [value2], ...) 27. How to compute IRR in Excel? → Use =IRR(values, [guess]) 28. How to find present value in Excel? → Use =PV(rate, nper, pmt, [fv], [type]) 29. How to calculate a bond's yield in Excel? → Use =YIELD(settlement, maturity, rate, pr, redemption, frequency) 30. How to use PMT function in Excel? → Use =PMT(rate, nper, pv, [fv], [type]) for loan payments (get the answers 31-50 in the Cheat Sheet below) 🔑 KPIs 51. How to measure profitability? → Use net profit margin: Net Profit / Revenue 52. How to gauge liquidity? → Calculate current ratio: Current Assets / Current Liabilities 53. How to assess debt burden? → Compute debt-to-equity ratio: Total Debt / Total Equity 54. How to track asset efficiency? → Calculate asset turnover: Sales / Total Assets 55. How to evaluate investment returns? → Use return on investment (ROI) Formulas 51-54 corrected (and updated correctly in PDF) (get the answers 56-75 in the Cheat Sheet below) 💵 Cash 76. How to forecast cash flow? → Use historical data and project future receipts/payments 77. How to improve cash position? → Speed up receivables, slow down payables 78. How to calculate cash conversion cycle? → DSO + DIO - DPO 79. How to manage short-term cash surplus? → Invest in short-term liquid securities 80. How to measure liquidity? → Use quick ratio: Liquid Assets / Current Liabilities (corrected and is updated in PDF) (get the answers 81-100 in the Cheat Sheet below) 👉 What else would you add? 👉 Let me know if you want more explanations." ________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.

Finance Charts Cheat Sheet Cheat Sheet By: Soufyan Hamid Original Post Below 👇 👇 👇 "Finance Charts Cheat Sheet Of the 100 charts available, here are 7 you can use 🙏 Help me spread this free Cheat Sheet: like, share and comment! You want to get the free PDF of this Cheat Sheet? 👉 Like and comment and then click here: https://lnkd.in/gNJgQR9Q And I do not only name them Find out which charts to use and undersrtand  - their goals - the type of data you need to use - the pros and cons of their usage - the key considerations - when to use (and when not) - the best practices - the main use cases So before jumping on your Excel file to build them, here's some that you want to know 1. Bar/Column Charts: Although many purists would disapprove, for a limited time (like 12 months), they can represent time value. Combined with a line, they're super powerful to explain to show Actuals vs Budget 2. Line Charts: when you show a flow (over a year for example), they're particularly good to show trends. Other good point: you can put multiple lines on the same chart and still be readable. 3. Pie Charts: the little ugly duck of the charts. No one likes them (except me) despite their ease of use and global understanding. They're not good for everything, but they are, they are. 4. Scatter Plot: Not to use in a final presentation but rather as a backup or in a working session. From it, deduce the conclusions and tell them (otherwise, you'll lose everyone) 5. Speedometer Chart (or any indication actually): When you want to show a performance vs a comparative (budget, last year,...), they do the job. Today, cards are more often used. 6. Bullet Charts: if you have a target to reach (especially if the targets are different for each bar), bullet charts can be very efficient. 7. Waterfall: will I have to convince you again how much I love them. The only chart who could possibly tell a story on its own. Of course, make sure the categories are self speaking enough and run away from the simple accounting categories. Convinced this is helpful? But can't read in this resolution? Go and get your high resolution PDF in the link" ________ Discover the best Office Productivity Hacks right here. Follow for the tips and tricks you need.