The UEFA Euro 2024 tournament is beginning in June 2024. And whether you want to track the games, make predictions, or just print out a schedule that highlights the games you want to track, this template has you covered. Below, I'll go over how the ...
A line chart in Excel can be a great way to display a time series in Excel. But did you know that you can show a series' actual values along with the year-over-year growth rate, or change? By using a second axis and adjusting the scales, I'll show y ...
One way to enhance your spreadsheets is by adding checkboxes. Using checkboxes, you can make data entry easier for your users. And you can create formulas based on whether a checkbox is checked off or not. In the latest version of Excel, using Micro ...
Whether you're managing projects or working towards a goal, visualizing progress is important to ensure you're on track for meeting your target. And by using charts in Excel, you can easily track your progress, making it easy for you to view and sha ...
Amortization schedules are essential tools for anyone managing a loan or mortgage, providing a clear breakdown of how payments are allocated towards interest and principal over the loan's term. Typically, these schedules detail each payment's date, ...
Moving averages can be useful in data analysis, when looking at trends both in finance and in the stock market. You can look at 30, 60, 90 day trends, and even longer or shorter durations. There's also a difference between whether you are looking at ...
Do you buy stocks? Help track your transactions and your returns with this stock trading template. This is an update over the previous stock trading template, offering more reports and analysis, and the ability to more easily track your portfolio's ...
Do you need to create weekly sales reports that compare the same days of the week? This kind of analysis can be tricky to ensure that you are comparing the same day of the week against the same week in the previous year. Simply comparing dates may n ...
What is the PEG Ratio? The Price/Earnings to Growth (PEG) Ratio is a metric that enhances the traditional price-to-earnings (P/E) ratio by incorporating the company's earnings growth rate into the calculation. This ratio is calculated by dividing ...
Do you have year-to-date values and need to calculate running totals? What about if you have criteria you want to track running totals for? In this post, I'll show you how to accomplish both and how you can create a custom function in Power Query th ...
