For anyone working in finance or banking, the time value of money is one topic that you should be fluent in. Knowing exactly what it means to discount something or to get the future value of a particular investment vehicle is necessary to do the job. Excel can be an extremely useful tool for these…
Read More
How often have you looked at your watch and typed the current time into your worksheet? Or tried to convert from one time zone to another and produced an error? Or wondered why a time shows up looking like “0.9285”? Fortunately, these questions are easy to answer once you understand how Excel time formulas work….
Read More
In Excel, some functions exist to be used to increase functionality when paired with other functions. MATCH is a good example. MATCH helps you search a range of references to find a “match” to your query. It then returns the position of that match. In short, you can use MATCH to look for your data…
Read More
An essential skill any Excel user should know is how to determine the range of values in Excel. Most businesses don’t have time to waste sorting through rows and rows in Excel in order to find the highest and lowest values of revenue, sales, or other information. The difference between the highest and lowest figures…
Read More
Does your company offer several types of IRA accounts? Are you unsure of your current IRA strategy? How do you know if the choices you make for your future are the best available to you? Say you review your IRA returns and consider changing your mix of investments. Five years ago, you invested $10,000 in…
Read More
Have you ever needed to present a chart that displays component data that roll up to a total? If all of the values are positive, Excel’s stacked column chart works beautifully; but it breaks down when your data includes both positive and negative values. The answer is an Excel waterfall chart! A waterfall chart solves…
Read More
Microsoft eliminated the Excel Chart Wizard in Excel 2007, and it has not returned in the successive versions. In fact, the company rebuilt the entire chart system, and the team decided it would not be worthwhile to update the wizard and all of its options.
Have you ever entered a project due date into a spreadsheet by manually counting the number of days and typing in the number? If so, then you’ve also experienced the tedium of recalculating those dates by hand and retyping them. Fortunately, Excel has all the functions to do the date arithmetic for you.
If you use Excel for reporting on results each month, you have probably needed to adjust your charts automatically to add a new month, state, or sales rep. Typically, that means clicking on each chart and adding a new data series or expanding the range of the current series. Unfortunately, it is easy to miss…
Read More
Preventing duplicate values from being entered in a range of cells may be a requirement in some of your worksheets. Although not obvious, enabling this capability in Excel is very easy. You can prevent duplicate values from being entered in a range of cells through Data Validation.
Since Fred Pryor pioneered the one-day seminar in 1970, Pryor has helped 13+ million learners and 3+ million businesses achieve meaningful and lasting success. Pryor Learning delivers 9,000+ award-winning training options—live and online—to satisfy learning needs anytime, anywhere, in any format. Access live seminars and more than 5,000 online courses within our mobile-friendly learning platform, or purchase eLibrary content to import into an existing LMS. With Pryor, gain access to more than 50 years of curated and professionally accredited content in a cloud-based learning environment that doesn’t obligate special IT requirements, pricey budgets or complicated timelines. You’re fully operational in as little as three days and only three clicks away from unlimited learning options for you and your team.
