tag:blogger.com,1999:blog-18407231533174018172024-03-17T06:42:02.372-07:00Excel Training 101Neat stuff on Microsoft Excel, PowerPoint and maybe some random stuffUnknownnoreply@blogger.comBlogger353125tag:blogger.com,1999:blog-1840723153317401817.post-14757337914712958162024-03-16T12:32:00.000-07:002024-03-16T12:32:32.298-07:00Phone Number Input Tricks - Excel #Shorts<iframe frameborder="0" height="270" src="https://youtube.com/embed/Cfe54p9ElYA?si=tPB6wr5b0PJvDIHg" width="480"></iframe><div><a href="https://youtu.be/Cfe54p9ElYA">https://youtu.be/Cfe54p9ElYA</a></div><div><br /></div><div>Let’s dive into the world of phone number validation in Microsoft Excel. In this tutorial, we’ll explore techniques to ensure your phone number inputs are just the right length—no more, no less. Whether you’re building a contact list, tracking customer info, or simply want to impress your boss with your Excel prowess, this video has got your back. Check out the video to show you how.</div><div><br /></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-41117048082766946542024-03-04T18:40:00.000-08:002024-03-04T18:40:29.217-08:00Create Random Decimal Numbers - Excel #Shorts<iframe frameborder="0" height="270" src="https://youtube.com/embed/fee0wJ0qJqA?si=fCph-NvVc5vhziQh" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/fee0wJ0qJqA">https://youtu.be/fee0wJ0qJqA</a></div><div><br /></div><div><span style="background-color: white; color: #0d0d0d; font-family: Roboto, Noto, sans-serif; font-size: 15px; white-space-collapse: preserve;">Unlock the secrets of generating random decimal numbers effortlessly in today’s tutorial. Whether you're coding, crunching data, or just love numbers, understanding how to create random decimals is a game-changer. We’ll walk you through a step-by-step guide, ensuring you grasp the concept easily. Stay tuned as we dive into the world of random decimals, providing you with the knowledge to master this essential skill. In older Excel versions you had to use a combination of RANDBETWEEN, RAND and then sum to get it. But with M365 Excel or Excel 2021 there's an new function that will do it all in one step.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-49731389110443473142024-02-25T20:47:00.000-08:002024-02-25T20:47:38.513-08:00Stop Manually Adjusting: Excel's Autofit Hack<iframe frameborder="0" height="270" src="https://youtube.com/embed/5IMxiAstF20?si=jpVGH7SC015v1Stj" width="480"></iframe><div><a href="https://youtu.be/5IMxiAstF20">https://youtu.be/5IMxiAstF20</a></div><div><br /></div><div><span style="background-color: white; color: #0d0d0d; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; white-space-collapse: preserve;">Give your spreadsheets an instant makeover with Excel's Autofit! In this tutorial, we'll show you how to use Autofit to achieve perfect formatting, quickly and efficiently. Ideal for all skill levels, this trick will ensure your data looks polished and professional in no time. Join us as we explore how to make your spreadsheets stand out with Autofit!</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-42485161680705393312024-02-20T18:21:00.000-08:002024-02-20T18:21:38.474-08:00Stop Excel from Erasing Leading Zeros | Quick and Easy Solutions - Excel...<iframe frameborder="0" height="270" src="https://youtube.com/embed/HA2mo79cpBI?si=_niHOoFiEvM14At7" width="480"></iframe><div><a href="https://www.youtube.com/watch?v=HA2mo79cpBI">https://www.youtube.com/watch?v=HA2mo79cpBI</a></div><div><br /></div><div><span style="background-color: white; color: #0d0d0d; font-family: Roboto, Noto, sans-serif; font-size: 15px; white-space-collapse: preserve;">Dive into today’s Excel mastery lesson where we're solving a common but perplexing problem: losing leading zeros in your data. Perfect for beginners and seasoned users alike, this video will guide you through the steps to ensure your leading zeros stay put, whether you're working on financial reports, contact lists, or inventory sheets. When you're doing a copy / paste of part numbers or department numbers, sometimes there are leading zeros in front ( to the left). Excel will often turn those "text" numbers into value numbers. You can stop this default before with some settings or tweaks.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-76444847782977770892024-02-13T10:20:00.000-08:002024-02-13T10:20:02.018-08:00Catching Wrong Dates Made Easy - Excel #Shorts<iframe frameborder="0" height="270" src="https://youtube.com/embed/zSSimgB4pFE?si=_x_oK_LwSdC1VUGG" width="480"></iframe><div><a href="https://www.youtube.com/watch?v=zSSimgB4pFE">https://www.youtube.com/watch?v=zSSimgB4pFE</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">In this video, I'm going to show you how to ensure that the input of the correct dates happen in Excel. This is a quick and easy tutorial that will help you avoid common mistakes when people enter dates into your spreadsheet.
If you're having trouble getting people to enter dates correctly, be sure to watch this video! By the end, you'll be able to ensure that the correct dates are in Excel with ease! </span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-17047569191612469632024-02-13T10:18:00.000-08:002024-02-13T10:18:39.655-08:00How Much per Hour is $50000 a Year - Excel #Shorts<iframe frameborder="0" height="270" src="https://youtube.com/embed/rmQDlbSGdMg?si=ZJTMQsxl9iQ2z8NB" width="480"></iframe><div><a href="https://www.youtube.com/watch?v=rmQDlbSGdMg">https://www.youtube.com/watch?v=rmQDlbSGdMg</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">In this short video, we're going to show you how to use Excel to calculate how much per hour is $50000 per year. This is a great video for anyone who wants to know how to reach their financial goals!
If you're looking to calculate how much money they'll need to achieve a certain goal, then this Excel tutorial is for you! By using goal seek and calculate, you can easily find the answer to your question – in just a few minutes! Putting in the work is never so easy! </span></div><div><br /></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-20331347563755196912024-02-03T10:13:00.000-08:002024-02-03T10:13:09.142-08:00Discover Excel's Secret Weapon: Basic Forecasts Made Easy with Exponenti...<iframe frameborder="0" height="270" src="https://youtube.com/embed/P0QBO25-ScA?si=2EDG6aE10_d6Afnj" width="480"></iframe><div><br /></div><div><a href="https://www.youtube.com/watch?v=P0QBO25-ScA">https://www.youtube.com/watch?v=P0QBO25-ScA</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">In this short video, we're going to show you how to use Excel's exponential smoothing feature to make basic forecasts easy.
Using exponential smoothing, you can easily create forecasts for future periods with minimal effort. By understanding exponential smoothing, you'll be able to make accurate predictions for your business and achieve better outcomes! </span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-73961135978707871762024-02-03T10:11:00.000-08:002024-02-03T10:11:55.749-08:00Excel Secrets: Remove Duplicates in Seconds - Excel #Shorts<iframe frameborder="0" height="270" src="https://youtube.com/embed/Y9MkAkFfeCg?si=91CwiaqmJmvHxpzU" width="480"></iframe><div><br /></div><div><a href="https://www.youtube.com/watch?v=Y9MkAkFfeCg">https://www.youtube.com/watch?v=Y9MkAkFfeCg</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">In this video, we're going to show you how to remove duplicate cells in Excel in seconds! This is a useful skill to have if you're ever need to clean up your data or work with large amounts of data.
If you're looking to speed up your work in Excel or clean up your data, then this video is for you! We'll show you how to remove duplicate cells in seconds, so you can get your work done faster.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-11338283373068508902024-01-16T17:36:00.000-08:002024-01-16T17:36:30.971-08:00Round to the Nearest 5 cents<iframe frameborder="0" height="270" src="https://youtube.com/embed/mNpj12YFVh4?si=GY09t3MJVmSILott" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/mNpj12YFVh4">https://youtu.be/mNpj12YFVh4</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">Want some choice or flexibility when you round decimals? Say you don't want to use pennies anymore is currency calculations and need to round up to the nearest nickel. Use the MROUND function to do it. Or round up to the next three cent (though I wonder why that would happen....).</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-48031296519154248152024-01-16T17:35:00.000-08:002024-01-16T17:35:20.710-08:00Effortlessly Get List of Files into Excel in Seconds<iframe frameborder="0" height="270" src="https://youtube.com/embed/LGqJRNl9HW4?si=6hvabIHRFdo8mcQx" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/LGqJRNl9HW4">https://youtu.be/LGqJRNl9HW4</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">Looking for an easy way to get a list of files in a directory into Excel? Look no further! In this short video, I'll show you how to easily export a list of files from a directory into Excel, hassle-free.
Power Query is a great tool if you need to quickly get a list of files into Excel, without having to copy and paste each file. Just add the directory where you want the files to be exported, and it'll take care of the rest! This is a simple, easy way to get the job done quickly and efficiently.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-22313592740100886492023-12-28T20:04:00.000-08:002024-01-16T17:37:03.119-08:00How Much Car Can I Afford?<iframe frameborder="0" height="270" src="https://youtube.com/embed/cMCUtxaIb-k?si=7O-1x_XR9K0lHcYw" width="480"></iframe><div><br /></div><div>https://youtu.be/cMCUtxaIb-k</div><div><br /></div><div><span style="color: #374151; font-family: Söhne, ui-sans-serif, system-ui, -apple-system, "Segoe UI", Roboto, Ubuntu, Cantarell, "Noto Sans", sans-serif, "Helvetica Neue", Arial, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol", "Noto Color Emoji"; font-size: 16px; white-space-collapse: preserve;">Learn to accurately calculate the maximum price of a car that fits within your budget using the Goal Seek feature in spreadsheet software. This instructional video guides you through setting up key parameters: the total price of the car, the loan term in months, and the monthly interest rate (annual rate divided by 12). Start by using the PMT function to estimate your initial monthly payment. Then, delve into the 'what-if' analysis by employing Goal Seek, a powerful tool that helps adjust the car price to ensure your monthly payments remain affordable. This tutorial is perfect for anyone looking to make informed financial decisions when purchasing a vehicle.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-51005676937398193102023-12-28T20:00:00.000-08:002024-01-16T17:36:51.684-08:00Copy Cell Ranges to Other Formulas<iframe frameborder="0" height="270" src="https://youtube.com/embed/jMdGyOb5FGA?si=aZn6A5GnJvVfA4Tj" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/jMdGyOb5FGA?si=aZn6A5GnJvVfA4Tj">https://youtu.be/jMdGyOb5FGA?si=aZn6A5GnJvVfA4Tj</a></div><div><br /></div><div><span style="background-color: white; color: #0d0d0d; font-family: Roboto, Noto, sans-serif; font-size: 15px; white-space-collapse: preserve;">Discover a streamlined approach to applying different formulas to the same set of cells in your spreadsheets. If you're faced with the repetitive task of selecting identical cell ranges for various functions, this tutorial offers a practical solution. Learn an easier, more efficient method to use the same cell ranges across multiple formulas, saving time and enhancing your productivity in spreadsheet management. This video is ideal for anyone looking to optimize their data manipulation techniques in spreadsheet applications. </span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-6854485185147521462023-12-05T16:48:00.000-08:002024-01-16T17:37:12.553-08:00Secret to Sorting by Day of Week<iframe frameborder="0" height="270" src="https://youtube.com/embed/IXMDegfc3VU?si=CymIJ8JP--Q3Eo2t" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/IXMDegfc3VU">https://youtu.be/IXMDegfc3VU</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">If you're looking to sort your data by day of the week, then you need to know about Excel's custom lists! In this short video, we'll show you how to use a custom list in Excel that will help you sort your data by day of the week.
Using a custom list in Excel can be a great way to organise your data by day of the week. Not only that, but a custom list can also be a great way to save time when you're looking to perform simple sorting tasks. So if you're looking for a way to sort your data by day of the week, then you need to check out this video!</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-15263494077281165572023-12-05T16:47:00.000-08:002023-12-05T16:47:38.490-08:00Discover the Hidden Potential of WRAPCOLS and WRAPROWS | Excel Secrets<iframe frameborder="0" height="270" src="https://youtube.com/embed/ZyaQtWaTQ0Q?si=5fIDiwgAdUXq4GPR" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/ZyaQtWaTQ0Q">https://youtu.be/ZyaQtWaTQ0Q</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">Do you want to learn how to use the WRAPCOLS and WRAPROWS functions to make your life easier? Then you’re in the right place! In this video, we’ll show you how to use these functions to transpose address or finance ranges with ease.
With these functions, you can easily manipulate and re-shape arrays, making it easier to analyze your data.
In this video, we’ll walk you through the process of using these functions step by step. We’ll show you how to convert a column or row of values into a two-dimensional array using the WRAPCOL and WRAPROW functions.
By the end of this video, you’ll have a solid understanding of how to use the WRAPCOL and WRAPROW functions to transpose address or finance ranges with ease.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-43637587640800412402023-11-14T15:33:00.000-08:002023-11-14T15:33:46.436-08:00Transpose Table Range - 3 Examples (Copy/Paste, TRANSPOSE, TOROW, TOCOL)<iframe frameborder="0" height="270" src="https://youtube.com/embed/tkB2jIDEkyQ?si=4d_fKABJp-2bIZRd" width="480"></iframe><div><br /></div><div>https://youtu.be/tkB2jIDEkyQ</div><div><br /></div><div><span style="color: #131313; font-family: Roboto, Arial, sans-serif;"><span style="background-color: rgba(0, 0, 0, 0.05); font-size: 14px; white-space-collapse: preserve;">Have you ever wanted to flip your data from horizontal to vertical, or the other way around? Maybe you have a list of names that you want to turn into a column, or a table that you want to rotate 90 degrees. Well, guess what? You can do that in Excel with just a few clicks. And I’m going to show you how in this video. There are three different methods to transpose an address or range in Excel: The Paste Special option, using the TRANSPOSE function or “surprise” another cool dynamic array function. I’ll walk you through each one and show you some examples of how they work. By the end of this video, you will be able to transpose any address or range in Excel like a pro. </span></span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-60632437677848629402023-11-14T15:31:00.000-08:002023-11-14T15:31:18.197-08:00Unlock the power of Excel: Transform your finances with Solver<iframe frameborder="0" height="270" src="https://youtube.com/embed/pb57tO7TRAc?si=3T_IKrNAGPZYVo9w" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/pb57tO7TRAc">https://youtu.be/pb57tO7TRAc</a></div><div><br /></div><div><span style="background-color: white; color: #0d0d0d; font-family: Roboto, Noto, sans-serif; font-size: 15px; white-space-collapse: preserve;">In this video, we'll show you how to use Solver to transform your finances. Solver can help you solve complex financial problems, no matter how tough they might seem. It's an Excel add-in that can optimize financial decisions. Solver can help you with budgeting, investing, loaning, and retiring. </span><span style="background-color: white; color: #0d0d0d; font-family: Roboto, Noto, sans-serif; font-size: 15px; white-space-collapse: preserve;">
</span><span style="background-color: white; color: #0d0d0d; font-family: Roboto, Noto, sans-serif; font-size: 15px; white-space-collapse: preserve;">
</span><span style="background-color: white; color: #0d0d0d; font-family: Roboto, Noto, sans-serif; font-size: 15px; white-space-collapse: preserve;">Solver can find the optimal value for a formula in one cell, called the objective cell, subject to constraints or limits on the values of other formula cells on a worksheet.
If you're looking to transform your finances or take control of your money, then this video is for you! We'll show you how to use Solver to solve complex financial problems and unlock its power to help you reach your goals. So watch and learn!</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-31496874711644248912023-10-29T22:19:00.002-07:002024-01-16T17:37:21.538-08:00Excel Hacks: Generate Alphabet Lists in Seconds!<iframe frameborder="0" height="270" src="https://youtube.com/embed/30_ucv5ogXM?si=t15CP5P2fLwVkqhr" width="480"></iframe><div><a href="https://youtu.be/30_ucv5ogXM">https://youtu.be/30_ucv5ogXM</a></div><div><br /></div><div><div>In this short video, I'm going to show you how to generate an alphabet list in seconds using Excel. This is a great hack to use if you need to generate a list of letters quickly!</div><div><br /></div><div>If you're looking for a quick and easy way to create an alphabet list, then this is the video for you! By following my simple steps, you'll be able to generate your list in seconds! So don't hesitate, watch the video and let us show you how to create an alphabet list in seconds using Excel!</div></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-38049989683461623072023-10-29T22:17:00.005-07:002024-01-16T17:37:30.608-08:00Quickly Combine Tables with VSTACK<iframe frameborder="0" height="270" src="https://youtube.com/embed/cKXQ66vA4lA?si=XhixcoCmT8m3cZH0" width="480"></iframe><div><a href="https://youtu.be/cKXQ66vA4lA">https://youtu.be/cKXQ66vA4lA</a></div><div><br /></div><div>In this quick and handy tutorial, I'm going to show you how to combine tables using the awesome VSTACK function. Picture this: you have two separate tables in Excel, and you want to effortlessly stack them together to create one big, beautiful table. With VSTACK, it's as easy as pie. Just follow along as I guide you through the simple steps. By the end of this video, you'll be a pro at merging tables like a boss. So grab your favorite beverage, sit back, and let's dive into the world of combining tables using the VSTACK function in Excel! </div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-68826397467680781882023-10-16T18:21:00.003-07:002024-01-16T17:37:42.817-08:00Find Cells with Conditional Formatting<iframe frameborder="0" height="270" src="https://youtube.com/embed/5g-84ZlCubM?si=PQoTE9zevOl74cJF" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/5g-84ZlCubM">https://youtu.be/5g-84ZlCubM</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">Are you trying to get a distinct count in your values section of a Pivot Table? You know that by default the values section does a count of the values in the field you put there, but there's a way for you to get a distinct count. But it's an extra step. </span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-33035043734783990712023-10-16T18:20:00.005-07:002023-10-16T18:21:56.894-07:00Get Distinct Count (Ignore Duplicates) in Pivot Table<iframe frameborder="0" height="270" src="https://youtube.com/embed/jEqbwCOBjqk?si=BqmlWjRvjrTQi2MC" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/jEqbwCOBjqk">https://youtu.be/jEqbwCOBjqk</a></div><div><br /></div><div><span face="Roboto, Arial, sans-serif" style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-size: 14px; white-space-collapse: preserve;">Are you trying to get a distinct count in your values section of a Pivot Table? You know that by default the values section does a count of the values in the field you put there, but there's a way for you to get a distinct count. But it's an extra step. Check out the video to learn more.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-90832849524464184182023-10-02T10:48:00.003-07:002023-10-02T10:48:32.818-07:00How to do CAGR<iframe frameborder="0" height="270" src="https://youtube.com/embed/QwxyXKyAcCI?si=Mc3h8NnHsNe9145m" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/QwxyXKyAcCIK">https://youtu.be/QwxyXKyAcCIK</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">Know what a CAGR is? It stands for Compound Annual Growth Rate and it shows the rate of return of an investment over a certain period of time as a percent. You'll see it a lot in business presentations or out the mouth of wall street types. It's a formula but there's a quick and easy function in Excel that will calculate it. </span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-91621355454293695852023-09-25T21:28:00.005-07:002024-01-16T17:37:51.340-08:00How to Add or Multiply Numbers in a Cell [No FORMULAS]<iframe frameborder="0" height="270" src="https://youtube.com/embed/BVu3g91_xg8?si=kw2HcyOMyVr99Otn" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/BVu3g91_xg8">https://youtu.be/BVu3g91_xg8</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #131313; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space-collapse: preserve;">Quickly add multiply or do math on numbers in your table data with this tip. You don't need a helper column with a formula where you cut and paste and then delete the extra column. All you need is the value you want to do the calculation in a temporary location and use Paste Special to do the magic.</span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-54835191779160449692023-09-17T12:05:00.002-07:002023-09-17T12:05:49.444-07:00Data Analysis Made Easy: Compare Population Data in Excel<iframe frameborder="0" height="270" src="https://youtube.com/embed/2PaxqmzaCsI?si=bly10yLgGSxnxEtg" width="480"></iframe><div><br /></div><div><a href="https://youtu.be/2PaxqmzaCsI?si=bly10yLgGSxnxEtg">https://youtu.be/2PaxqmzaCsI?si=bly10yLgGSxnxEtg</a></div><div><br /></div><div>Unlock the power of effortless data analysis with this charting hack! No longer will you be bogged down by complex data comparisons. I’ll walk you through the process of comparing population data like a seasoned pro with this simple trick. With just a few clicks, you'll gain valuable insights, spot trends, and make data-driven decisions. Whether you're a data enthusiast or a business professional, mastering this simple yet effective data analysis technique will save you time and effort, allowing you to focus on what truly matters - leveraging data to drive success. </div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-26069024915969749042023-08-21T06:30:00.001-07:002023-08-21T06:30:00.150-07:00Multiple Pivot Table Views Values Section Total & Percentage<iframe frameborder="0" height="270" src="https://youtube.com/embed/yRHSIfXwLcQ" width="480"></iframe><div><a href="https://youtu.be/yRHSIfXwLcQ">https://youtu.be/yRHSIfXwLcQ</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #0f0f0f; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">Pivot Tables are one of THE best ways to analyze and show your data. But sometimes you want to show different views of the same data like the counts and then percentage from totals. Were you used to having two pivot tables? One with the count and one with percentages? Takes out a lot of space? We put it on one table and still make it look good. You don’t have to have separate pivot tables to show different views of the same data. You can combine them into one pivot table and still have it look presentable. This gives you a way to make your data insightful and look good at the same time. </span></div>Unknownnoreply@blogger.com0tag:blogger.com,1999:blog-1840723153317401817.post-8344395937018026572023-08-14T06:30:00.001-07:002023-08-14T06:30:00.141-07:00Generate Random Numbers that Add Up to Given Amount - Google Sheets<iframe frameborder="0" height="270" src="https://youtube.com/embed/Ahtt5yGm16M" width="480"></iframe><div><a href="https://youtu.be/Ahtt5yGm16M">https://youtu.be/Ahtt5yGm16M</a></div><div><br /></div><div><span style="background-color: rgba(0, 0, 0, 0.05); color: #0f0f0f; font-family: Roboto, Arial, sans-serif; font-size: 14px; white-space: pre-wrap;">In this video, we're going to show you how to use the RAND and RANDBETWEEN in Google Sheets to generate a set of random numbers that add up to a specific value. You'll be able to generate multiple sets of random numbers that add up to any value you want. This can be done with decimal numbers as well as integers. Consider this a hack or workaround to scripting something in Python or JavaScript as a quick solution you can easily put together in Google Sheets.</span></div>Unknownnoreply@blogger.com0