EDNA Vlog

Ever wanted to swap text in your spreadsheet like changing characters in a story? The SUBSTITUTE formula in Excel has got you covered! 📝 Here's how it works: To replace "apple" with "banana" in the sentence "I love apple", just use this formula: =SUBSTITUTE("I love apple", "apple", "banana"). Voila! The formula turns it into "I love banana". 🔁 It’s that easy! #Excel #SUBSTITUTEFormula #DataReplace #ExcelMagic #ChangeText #SpreadsheetHacks #ExcelTips #ExcelTricks #DataManipulation

Publicly-traded companies may grant employees a variety of stock-based compensation. The most common forms of shared-based compensation are restricted stock awards, restricted stock units, stock options, share appreciation rights, and employee share purchase plans. A restricted stock award grants stock to an employee; while ownership of the shares is transferred into the employee's name on the grant date, the employee isn't free to sell or transfer the shares until the shares have vested (vesting usually takes place after a certain period of employment has been completed, although there are sometimes additional performance or market conditions). A restricted stock unit grants an employee the right to receive stock (and sometimes cash in lieu of stock) once the restricted stock unit vests. A restricted stock unit differs from a restricted stock award in that a restricted stock unit doesn't transfer legal ownership of the share to the employee until the restricted stock unit has vested. A stock option grants the employee the right, but not the obligation, to purchase stock at a set price (the strike price, aka exercise price) for a certain time period. A share appreciation right grants the employee a certain benefit (usually cash) if the company's stock price increases. An employee stock purchase plan allows employees to purchase stock directly from the company on favorable terms. — Edspira is the creation of Michael McLaughlin, an award-winning professor who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education freely available to the world. — SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS, PLUS: • A 23-PAGE GUIDE TO MANAGERIAL ACCOUNTING • A 44-PAGE GUIDE TO U.S. TAXATION • A 75-PAGE GUIDE TO FINANCIAL STATEMENT ANALYSIS • MANY MORE FREE PDF GUIDES AND SPREADSHEETS * http://eepurl.com/dIaa5z — SUPPORT EDSPIRA ON PATREON *https://www.patreon.com/prof_mclaughlin — GET CERTIFIED IN FINANCIAL STATEMENT ANALYSIS, IFRS 16, AND ASSET-LIABILITY MANAGEMENT * https://edspira.thinkific.com — LISTEN TO THE SCHEME PODCAST * Apple Podcasts: https://podcasts.apple.com/us/podcast/scheme/id1522352725 * Spotify: https://open.spotify.com/show/4WaNTqVFxISHlgcSWNT1kc * Website: https://www.edspira.com/podcast-2/ — GET TAX TIPS ON TIKTOK * https://www.tiktok.com/@prof_mclaughlin — ACCESS INDEX OF VIDEOS * https://www.edspira.com/index — CONNECT WITH EDSPIRA * Facebook: https://www.facebook.com/Edspira * Instagram: https://www.instagram.com/edspiradotcom * LinkedIn: https://www.linkedin.com/company/edspira — CONNECT WITH MICHAEL * Twitter: https://www.twitter.com/Prof_McLaughlin * LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin — ABOUT EDSPIRA AND ITS CREATOR * https://www.edspira.com/about/ * https://michaelmclaughlin.com