![Learn Excel -Text to Column Wizard(Fixed Width) in Just 50 Seconds! [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_754_0_0jpg.jpg)
#Shorts In this video, we will learn about how to convert Text to Column(Fixed Width) in Excel What is Text to Columns in Excel?Text to Columns in Excel is a method for separating the text into different columns based on a delimiter or a fixed width. There are two ways to use text to columns in Excel. The first is to use a delimiter, such as a comma space or a hyphen, as an input. The second is to use a fixed defined width to separate text in adjacent columns.In this 50 seconds video, you will learn how to use Fixed Width to convert text to column in excel.For more information, please visit – https://www.wallstreetmojo.com/text-to-columns-in-excel/Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo
![Learn Excel Text to Column Wizard in Just 50 Seconds! [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_742_0_0jpg.jpg)
#Shorts In this video, we will learn about how to convert Text to Column in Excel What is Text to Columns in Excel?Text to Columns in Excel is a method for separating text into different columns based on a delimiter or a fixed width. There are two ways to use text to columns in Excel. The first is to use a delimiter, such as a comma space or a hyphen, as an input. The second is to use a fixed defined width to separate text in adjacent columns.In this 50 seconds video you will learn how to use delimiter to convert text to column in excelFor more information, please visit – https://www.wallstreetmojo.com/text-to-columns-in-excel/Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo
![How the Yield Curve Works [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_739_0_0jpg.jpg)
You will frequently hear about the “yield curve” in the financial press. A yield curve plots the yield-to-maturity for various terms of a financial instrument.A yield curve is thus a graphical representation of yields at different terms.You can create a yield curve for different terms of any debt instrument (the U.S. Treasury yield curve, the LIBOR-swap yield curve, etc.). The common theme is that a yield curve plots the interest rate yield for a certain type of financial instrument over different times to maturity. If you’re wondering, “what is the yield?” it’s the return an investor would earn if they bought the security today and held it until its maturity date. Note that the yield curve usually has an upward shape. This is because yields are usually higher for longer maturities. This is not always the case, however, and the yield curve can take on different shapes. — 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 accessible to all people. — SUBSCRIBE FOR FREE PDF GUIDES TO THE FINANCIAL STATEMENTS, MANAGERIAL ACCOUNTING, TAX, AND MORE* http://eepurl.com/dIaa5z — HIRE MICHAEL MCLAUGHLIN, PHD, CPA* https://michaelmclaughlin.com/hire-me— 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/
![AICPA and CPA Practice Advisor 2020 Most Powerful Women in Accounting [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_732_0_0jpg.jpg)
AICPA and CPA Practice Advisor 2020 Most Powerful Women in Accounting#AICPAwomenlead #AIPCAdiversity #womenleaders
![Asset Liability Management | Risk Factors [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_729_0_0jpg.jpg)
We know that ALM is about properly matching assets and liabilities to manage risk, but what specific risks are faced by a typical bank? The most significant risk is interest rate risk. There are several different types of interest rate risk, as discussed below.Interest rate gap risk occurs when:(a) there is a mismatch between floating-rate and fixed-rate instruments(b) the timing of rate-setting for floating-rate instruments is not alignedInterest rate basis risk occurs when floating-rate assets and floating-rate liabilities are set to different indexes. Option risk occurs when a counterparty exercises an option that changes the expected cash flows of a financial instrument (terminating a contract early, altering the contract, etc.).• This is a type of interest rate risk because option risk is closely linked to the interest ratePrepayment risk occurs when a borrower repays the principal sooner than required, and the bank gets stuck re-lending the money at a less favorable interest rate. • Prepayment risk is a specific type of option risk and is closely linked to the interest rate• Prepayment happens when interest rates decline and borrowers decided to refinance Banks also face risk factors aside from interest rate risks. These include:Exchange rate risk occurs when exchange rates change and the bank translates foreign currency back into its functional currency (the bank will recognize a gain or a loss). Price risk occurs when there are changes to the price of investments in a bank’s trading portfolio.Credit risk occurs when a counterparty defaults (e.g., a borrower fails to pay).Liquidity risk occurs when the bank is unable to satisfy its obligations without suffering extreme losses when one or more sources of funding suddenly become unavailable. • A liquidity crisis could be caused by a run on the repo market, an inability to roll over maturing debt, etc.• Liquidity risk can be severe and cause the bank to become insolvent— Edspira is the creation of Michael McLaughlin, who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education accessible to all people.— SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS* http://eepurl.com/dIaa5z— 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/ — CONNECT WITH EDSPIRA* Website: https://www.edspira.com* Blog: https://www.edspira.com/blog/ * Facebook page: https://www.facebook.com/Edspira* Facebook group: https://www.facebook.com/groups/561316587899818//* Reddit: https://www.reddit.com/r/edspira* LinkedIn: https://www.linkedin.com/company/edspira— CONNECT WITH MICHAEL* Website: http://www.MichaelMcLaughlin.com* LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin * Twitter: https://www.twitter.com/Prof_McLaughlin* Facebook: https://www.facebook.com/prof.michael.mclaughlin* Snapchat: https://www.snapchat.com/add/prof_mclaughlin*Twitch: https://twitch.tv/prof_mclaughlin * Instagram: https://www.instagram.com/prof_mclaughlin*TikTok: https://www.tiktok.com/@prof_mclaughlin
![Data Validation in Excel – Overview, How to Use Data Validation & Create Drop-down Lists? [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_726_0_0jpg.jpg)
Data Validation in Excel – This tutorial will teach you how to use Data Validation in Excel to improve the accuracy of your data by creating a drop-down list and adding data validation checks. With the help of a practical example, we will also look at the types of data formats allowed.How to use Data Validation in Excel?——————————————–Data validation in Excel is used to limit a user’s ability to provide inputs to specific cells or input ranges. It provides pre-defined inputs for a user to choose from in order to avoid multiple formats of the same data.Purpose of Using Data Validation:——————————————–• Prevent users from filling up the worksheet with erroneous or invalid data values• The Data Validation window allows users to quickly gather, sort, and analyze data. The values have a criteria established and can be seen in the Data Validation window• When a worksheet cell is selected, custom messages specifying the valid data format are displayed, thus, acting as a guideline to users while inputting data —————————————————————————————–To know more about the Data Validation in excel, you can go to this link: https://www.wallstreetmojo.com/data-validation-excel/——————————————————————————————Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo
![Asset Liability Management | Metrics [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_720_0_0jpg.jpg)
The purpose of ALM is to match assets and liabilities to avoid adverse changes to the bank’s profit, firm value, and liquidity. But how do we measure the bank’s profit and firm value? This leads to two of the most important metrics in ALM: NII and EVE. NII standards for “net interest income” and is calculated as follows:NII = interest income from assets – interest expense from liabilitiesFor commercial banks that engage heavily in lending, NII is the primary component of net income. EVE stands for “economic value of equity” and is calculated as follows:EVE = economic value of bank’s assets – economic value of bank’s liabilitiesThe job of the bank’s treasury department is to manage loan originations (assets) and funding sources (liabilities) so that EVE and NII don’t fall below acceptable thresholds. This is the heart of ALM. While NII and EVE can both be used to quantify the effects of interest rate risk, they can’t be used to measure liquidity risk. Thus, banks do liquidity stress tests to see how hypothetical scenarios would affect liquidity (and then create contingency plans to deal with such events).— Edspira is the creation of Michael McLaughlin, who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education accessible to all people.— SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS* http://eepurl.com/dIaa5z— 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/ — CONNECT WITH EDSPIRA* Website: https://www.edspira.com* Blog: https://www.edspira.com/blog/ * Facebook page: https://www.facebook.com/Edspira* Facebook group: https://www.facebook.com/groups/561316587899818//* Reddit: https://www.reddit.com/r/edspira* LinkedIn: https://www.linkedin.com/company/edspira— CONNECT WITH MICHAEL* Website: http://www.MichaelMcLaughlin.com* LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin * Twitter: https://www.twitter.com/Prof_McLaughlin* Facebook: https://www.facebook.com/prof.michael.mclaughlin* Snapchat: https://www.snapchat.com/add/prof_mclaughlin*Twitch: https://twitch.tv/prof_mclaughlin * Instagram: https://www.instagram.com/prof_mclaughlin*TikTok: https://www.tiktok.com/@prof_mclaughlin
![How the Gift Tax Works | U.S. Tax [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_711_0_0jpg.jpg)
Here’s how the gift tax works:If you give someone a gift, any amount exceeding $15,000 is considered a taxable gift. However, you also get a lifetime exemption of $11.7 million.Thus, let’s say you give someone a gift of $215,000:• The first $15,000 is excluded • The next $200,000 reduces your lifetime exemption to from $11.7 to $11.5 millionThus, you don’t pay any tax because the amount over $15,000 reduced your lifetime exclusion. However:• When the lifetime exclusion goes down, this decreases the exemption your estate gets when you die. Thus, gifts over $15,000 could end up causing you to get hit with estate tax, depending on the value of your estate• If the lifetime exemption reaches zero, any gifts over $15,000 will incur gift taxNow, if you do make a gift exceeding $15,000 you need to file Form 709 (the gift tax return) on or before April 15th of the year following the gift.And if both you and your spouse make a gift, you each need to file a separate Form 709.You might also be subject to gift tax at the state level depending on where you live.— Edspira is the creation of Michael McLaughlin, who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education accessible to all people.— SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS* http://eepurl.com/dIaa5z— 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/ — CONNECT WITH EDSPIRA* Website: https://www.edspira.com* Blog: https://www.edspira.com/blog/ * Facebook page: https://www.facebook.com/Edspira* Facebook group: https://www.facebook.com/groups/561316587899818//* Reddit: https://www.reddit.com/r/edspira* LinkedIn: https://www.linkedin.com/company/edspira— CONNECT WITH MICHAEL* Website: http://www.MichaelMcLaughlin.com* LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin * Twitter: https://www.twitter.com/Prof_McLaughlin* Facebook: https://www.facebook.com/prof.michael.mclaughlin* Snapchat: https://www.snapchat.com/add/prof_mclaughlin*Twitch: https://twitch.tv/prof_mclaughlin * Instagram: https://www.instagram.com/prof_mclaughlin*TikTok: https://www.tiktok.com/@prof_mclaughlin
![LOOKUP Function in Excel – Overview, Formula, Step by Step Tutorial [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_708_0_0jpg.jpg)
LOOKUP Function in Excel – In this video on the LOOKUP function in Excel, we’ll go over how to use the LOOKUP function in Excel and also understand how it differs from the VLOOKUP function. A practical LOOKUP calculation example will be used to illustrate this.LOOKUP Function in Excel——————————————–The LOOKUP function checks for a value in a range (which can be a single row or single column) and returns a corresponding LOOKUP from the same position of another range (single row or single column). The corresponding LOOKUP is a piece of information related to the value being searched.LOOKUP Excel Formula——————————————–=lookup(lookup_value, lookup_vector, [result_vector])Arguments in LOOKUP Function:——————————————–Lookup value: This is the value that you want to searchLookup vector: This is the row or column in which you wish to search the value. To achieve accurate results, it should be sorted alphabetically or in ascending order.Result vector: This is the row or column region from which you want the output to be returned. The returned output is in the same position as the “lookup value.”——————————————————————————————To know more about the LOOKUP Function, you can go to this link: https://www.wallstreetmojo.com/lookup-excel-function/ ——————————————————————————————Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo
![Controller Dashboard: One KPI Dashboard To Run A Business Part 1 [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_702_0_0jpg.jpg)
One of my previous CEOs used to hate reading financial statements 🤯 which forced me to always give him KPIs.After 68 hours of research and development, I am proud to share with you my free video (and product link below) for the “Controller’s KPI Dashboard”.If you know me, you know I hate doing repetitive tasks. The idea is to automate the process of updating the template with data from the balance sheet and income statement. Get My “Controller KPI Dashboard” Template & Mini-course, with the most important P&L and Balance Sheet KPIs:https://thefincontroller.com/p/controller-kpi-dashboard-one-kpi-dashboard-to-run-a-businessMy Other Best-Selling Products:Get My “Night Before the Accounting Interview Guide” including All Levels Q&A:https://thefincontroller.com/p/the-night-before-your-accounting-interview-guide-for-all-levels📈 Get $25 off MY ONLINE COURSE ON FINANCIAL METRICS (code: Save25)https://thefincontroller.com/p/learn-financial-metrics-kpis/?product_id=2659754&coupon_code=SAVE25&preview=logged_outMy Recommended Products (I will only share what I love ❤ here)⚪️ 🧠 Roger CPA Review Course (get 50% off): https://www.uworld.com/productreferral.aspx?ukey=8lzsxx2bT8qzYRxekeTKyWQ3d3d⚪️ 📚 Learning//SkillShare (get 2 weeks free): https://www.skillshare.com/r/profile/Bill-Hanna/7521537My Recommended Finance & Accounting Books 📚+🧠=💥⚪️ Auditing: https://amzn.to/361wJhZ⚪️ Forensic Accounting: https://amzn.to/2G6t9bo⚪️ Introduction to Finance: https://amzn.to/2ExgUEA⚪️ Introduction to Managerial Accounting: https://amzn.to/33SEyE4———————————————————————Hang Out with me on social media:📱https://www.tiktok.com/@thefinancialcontroller🙋🏼♂️https://www.facebook.com/groups/780732429036886/?source_id=101273467885666📸 https://www.instagram.com/the_financial_controller/DISCLAIMER: Links included in this description might be affiliate links. If you happen to purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to provide you with free content each week!All views expressed on my channel are mine alone. Not intended as financial or professional advice
![The Liquidity Gap | Asset Liability Management [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/08/mp_699_0_0jpg.jpg)
Changes in interest rates can affect the bank’s profit and equity value when assets and liabilities are not properly matched, but this probably won’t cause the bank to become insolvent. Improperly matching the maturities of cash flows (the cash flow gap discussed earlier) could drive the bank to insolvency, but this risk can be managed with planning. A risk that is more difficult to plan for is a liquidity crisis. What if one or more of the bank’s funding sources were to suddenly become unavailable?Before the financial crisis, liquidity risk was treated as part of cash management. But during the financial crisis, banks learned that liquidity problems could be catastrophic. Banks had not experienced problems with liquidity for years, as they could easily raise capital from securitization and through short-term lending in the repo market. But when those sources of funding dried up, some banks were ruined. Now banks have dedicated staff that analyze hypothetical scenarios to assess the bank’s liquidity gap. These staff monitor early warning indicators that could predict a liquidity event, such as credit rating downgrades, increases in default rates, difficulty issuing debt, etc. They also develop a contingency funding plan with steps for obtaining replacement funding should a liquidity event occur.— Edspira is the creation of Michael McLaughlin, who went from teenage homelessness to a PhD. Edspira’s mission is to make a high-quality business education accessible to all people.— SUBSCRIBE FOR A FREE 53-PAGE GUIDE TO THE FINANCIAL STATEMENTS* http://eepurl.com/dIaa5z— 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/ — CONNECT WITH EDSPIRA* Website: https://www.edspira.com* Blog: https://www.edspira.com/blog/ * Facebook page: https://www.facebook.com/Edspira* Facebook group: https://www.facebook.com/groups/561316587899818//* Reddit: https://www.reddit.com/r/edspira* LinkedIn: https://www.linkedin.com/company/edspira— CONNECT WITH MICHAEL* Website: http://www.MichaelMcLaughlin.com* LinkedIn: https://www.linkedin.com/in/prof-michael-mclaughlin * Twitter: https://www.twitter.com/Prof_McLaughlin* Facebook: https://www.facebook.com/prof.michael.mclaughlin* Snapchat: https://www.snapchat.com/add/prof_mclaughlin*Twitch: https://twitch.tv/prof_mclaughlin * Instagram: https://www.instagram.com/prof_mclaughlin*TikTok: https://www.tiktok.com/@prof_mclaughlin
![AVERAGE Function in Excel – Overview, Formula, Step by Step Tutorial [Video]](https://video.ednadigitalmarketing.com/wp-content/uploads/2021/07/mp_696_0_0jpg.jpg)
AVERAGE Function in Excel – In this tutorial, we’ll go over the best way to find the average in an Excel data set using the ‘Average’ formula.How to use AVERAGE Function in Excel?——————————————–In Excel, the AVERAGE function calculates the arithmetic mean of a series of numeric data. This formula belongs to the Statistical Functions category.AVERAGE Excel Formula:——————————————–=AVERAGE(number 1, [number 2]…)Where,number 1 – This is the required number and the number for which the average is calculated.[number 2], [number 3], .. [number n] – These numbers are optional and can be entered as numbers, named ranges, ranges, or numeric values in cell references. —————————————————————————————–To know more about the AVERAGE Function, you can go to this link: https://www.wallstreetmojo.com/average-function-in-excel/——————————————————————————————Connect with us! Youtube https://www.youtube.com/channel/UChlNXSK2tC9SJ2Fhhb2kOUw?sub_confirmation=1LinkedIn https://www.linkedin.com/company/wallstreetmojo/mycompany/ Facebook https://www.facebook.com/wallstreetmojo Instagram https://www.instagram.com/wallstreetmojoofficial/ Twitter https://twitter.com/wallstreetmojo