admin

How To Generate Random Passwords

Home Contact Privacy Policy By David M. How To Generate Random Passwords https://www.youtube.com/watch?v=RWeN7VRDaN4&t=34s We cover how to create a random password generator in Excel. We will start by entering our password inputs, in other words the characters we want our password to include, we will then perform intermediary calculations to retrieve the random characters adjusted …

How To Generate Random Passwords Read More »

How To Calculate CAGR

Home Contact Privacy Policy By David M. How to calculate cagr https://www.youtube.com/watch?v=YRjV86PCqiE&t=2s The Compound Annual Growth Rate (CAGR) calculates the rate of return over a period of time and it is often used to measure past performance of investments or analyse business measures like sales or market value. In our example, we will calculate the …

How To Calculate CAGR Read More »

Randomly Assign Names To Groups

Home Contact Privacy Policy By David M. Randomly Assign Names to groups https://www.youtube.com/watch?v=hfFD6dGBk0w We cover how to randomly assign names to groups in excel. In other words, we will assign each of the 30 people in this table here to a group, based on the group size that we select. To start, we’ll use the …

Randomly Assign Names To Groups Read More »

Excel VBA

Home Contact Privacy Policy Excel VBA https://www.youtube.com/watch?v=fnWS-6jrMXY&list=PLK5FjPWoDFmKqia88KXX3uIKQINJmiQND&index=1 Store All Of Your Passwords in Excel – Using VBA And Data Validation https://www.youtube.com/watch?v=Sq6SXSebstI&list=PLK5FjPWoDFmKqia88KXX3uIKQINJmiQND&index=2 Display Welcome Message When Excel Workbook Is Opened Using Workbook Open Method – VBA Tutorial https://www.youtube.com/watch?v=x0xGFwn1tus&list=PLK5FjPWoDFmKqia88KXX3uIKQINJmiQND&index=3 Run VBA Macro Automatically When Sheet Is Selected Using Worksheet Activate Method https://www.youtube.com/watch?v=CaN_GjXPAkU&list=PLK5FjPWoDFmKJvbEuDRb81EukCgE1NLz3&index=4 10 Excel Keyboard Shortcuts Everyone …

Excel VBA Read More »

Excel Functions

Home Contact Privacy Policy Functions https://www.youtube.com/watch?v=KvS-1o1C–g&list=PLK5FjPWoDFmJu_s82Z0S5H7W3WMeq2MhV&index=1 VLOOKUP Function Excel Tutorial – Find Things In A Table https://www.youtube.com/watch?v=3ijt-P58yQc&list=PLK5FjPWoDFmJu_s82Z0S5H7W3WMeq2MhV&index=2 COUNTIF Excel Tutorial – Count Cells That Meet A Condition In A Range https://www.youtube.com/watch?v=sKbwbvt5y7w&list=PLK5FjPWoDFmJu_s82Z0S5H7W3WMeq2MhV&index=3 IF Function Excel Tutorial – Test Whether A Condition Holds Using Simple and Nested IF https://www.youtube.com/watch?v=6Fk5vzuwpaE&list=PLK5FjPWoDFmJu_s82Z0S5H7W3WMeq2MhV&index=4 MATCH Function Excel Tutorial – Find Position Of …

Excel Functions Read More »

Shortcuts

Home Contact Privacy Policy Shortcuts https://www.youtube.com/watch?v=sAIsVd6OIH0&list=PLK5FjPWoDFmKJvbEuDRb81EukCgE1NLz3&index=3 Why Are Excel Shortcuts Important And What Are The Main Types – Excel Shortcuts Series Part 1 https://www.youtube.com/watch?v=LDSrBvK9yEo&list=PLK5FjPWoDFmKJvbEuDRb81EukCgE1NLz3&index=2 Move Around Excel Efficiently Using These Navigation Shortcuts – Excel Shortcuts Series Part 2 https://www.youtube.com/watch?v=sAIsVd6OIH0&list=PLK5FjPWoDFmKJvbEuDRb81EukCgE1NLz3&index=3 Why Are Excel Shortcuts Important And What Are The Main Types – Excel Shortcuts Series Part …

Shortcuts Read More »

Accounting&Finance

Home Contact Privacy Policy Accounting & Finance https://www.youtube.com/watch?v=v6n4wWXy5Us&list=PLK5FjPWoDFmIz-WQjXgTK3BYEM_SIi5DO&index=1 Create A Monthly Amortisation Table – Mortgage Repayment Calculator In Excel (Part 1 of 3) https://www.youtube.com/watch?v=fUZU5VWNMDk&list=PLK5FjPWoDFmIz-WQjXgTK3BYEM_SIi5DO&index=2 Make Amortisation Table Dynamic With VBA – Mortgage Repayment Calculator In Excel (Part 2 of 3) https://www.youtube.com/watch?v=cQdoyomsrIw&list=PLK5FjPWoDFmIz-WQjXgTK3BYEM_SIi5DO&index=3  Insert Charts And Compare Mortgage Options – Mortgage Repayment Calculator In Excel (Part 3 …

Accounting&Finance Read More »

Reducing Balance Depreciation

Home Contact Privacy Policy By David M. Reducing Balance Depreciation In this video I’ll show you to calculate depreciation using the reducing balance method. The reducing balance method assumes that most of the asset’s value drops in the first few years of its useful life. Proponents of this method argue that this is more realistic …

Reducing Balance Depreciation Read More »