Categories
Resources for Accountants

RANDBETWEEN FORMULA – WALLSTREETMOJO EXCEL MINI SERIES [Video]

RANDBETWEEN FORMULA – WALLSTREETMOJO EXCEL MINI SERIES

Hey Excel friends! 🌟

Ever wish you could bring a little randomness into your spreadsheets? Well, the RANDBETWEEN formula is here to help! It’s like rolling dice right in Excel! 🎲

Want to get a random number between 1 and 10? Just type in: =RANDBETWEEN(1, 10). You might get a 7, or any other number between 1 and 10. How cool is that? 🎲

#Excel #RANDBETWEENFormula #DataRandom #ExcelFun #RandomNumbers #SpreadsheetMagic #shorts

Watch/Read More
Categories
Resources for Accountants

FREE Excel Course (Step by Step) [Video]

In this Free Excel course, an industry expert provides a practical understanding of the fundamental aspects related to Excel. First, the video discusses basic Excel functions. Then, it moves on to explain cell referencing and named ranges, name manager, and array formula. Lastly, the course covers how to work with charts in Excel. The detailed coverage of the basic concepts makes it an ideal course for beginners who wish to develop knowledge of Excel. Timestamps: 0:00:01-0:00:49 Introduction 0:00:49-0:12:13 Basic Excel Functions 0:12:13-0:27:29 Cell Referencing and Named Ranges 0:27:09-0:36:05 Name Manager 0:36:05-0:51:36 Array Formula 0:51:36-1:15:21 Working with Charts Get all important Excel functions here: https://www.wallstreetmojo.com/excel-functions/?utm_source=YouTube&utm_medium=Social&utm_campaign=Description

Categories
Resources for Accountants

From Lawyer in Bolivia to Successful US Accountant: 3 Steps to Make It Happen [Video]

Ever wondered if you can switch careers and build a successful accounting career in the USA as an immigrant? 🌎 Meet Monica, a former lawyer from Bolivia who followed 3 key steps to transition into accounting in the U.S.! In this interview, we cover: ✅ The biggest challenges of switching careers as an immigrant ✅ The exact 3 steps that helped Monica become a successful accountant ✅ How YOU can start your journey—even with no U.S. experience! Join the EXACT course Monica enrolled in: https://controller-academy.com/courses/controller-academy Time Stamps: 00:00 Intro 00:47 Monica's Background 01:47 Monica's Job Responsibilities 02:56 Monica's Goal in 5 Years 04:47 Monica's Learned This From My Course 06:08 Monica's fav TV Show & Music 08:42 Monica's Journey To the US ----------------------------------- Hang Out with me on social media: 📸 https://www.instagram.com/the_financial_controller/ 📱https://www.tiktok.com/@thefinancialcontroller https://www.linkedin.com/in/bill-hanna-cpa-7653a851/ 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

Categories
Resources for Accountants

IFRS 16 Lessor Accounting Example 2 | Finance Lease [Video]

When a lessor accounts for a finance lease under IFRS 16, the lessor must derecognize the asset from its statement of financial position and record a lease receivable upon commencement of the lease. If the lessor is a manufacturer or dealer, then the lessor must also record sales revenue and cost of goods sold upon commencement of the lease. Both the sales revenue and cost of goods sold must be reduced by the present value of the unguaranteed residual value.The lessor will then recognize interest revenue throughout the lease term. At the end of the lease, the lessor will restore the asset to its statement of financial position. If the actual residual value turns out to be less than the unguaranteed residual value, the lessor records a loss for the difference.— 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

Categories
Resources for Accountants

Accounting Jobs At Amazon | Job Duties, Qualifications & Salaries [Video]

Amazon offers a variety of Accounting and Finance positions for qualified candidates. In this video I review 3 different Accounting jobs with their duties, qualifications, and compensation. Videos mentioned in this episode:My video on making the move from Accounting to Finance:https://youtu.be/UXz2nw2kDbUMy video on US GAAP:https://youtu.be/Yy2y_tfqKdcMy video on benefits of working at a Big 4:https://youtu.be/afL2OmCUiA0My video on VAT vs. Sales Tax:https://youtu.be/TVhhQH7PXZkMy 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 METRICShttps://thefincontroller.com/p/learn-financial-metrics-kpis/?product_id=2659754&coupon_code=SAVE25&preview=logged_outUse Coupon Code: Save25-------------------------------------------------------------------My 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.