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
Data collection is an important part of business. It is customer satisfaction survey results, employee performance assessments, market and industry research, lead generation analysis, or anything that depends on collecting, comparing and seeking relevant information. Unfortunately, depending on the setup and your tools, raw data can be confusing and impossible to share unless everyone speaks…
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
While there is no “Excel multiply formula” there are multiple ways to multiply in Excel. For instance, do you use an asterisk (*) to multiply, but hit a brick wall when you apply other arithmetic operators? What about shortcuts for multiplying many numbers in one step? Read on for three powerful ways to perform an…
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
Excel makes it easy to work with data tables, but first you must get that data into tables. Keying data into a spreadsheet and moving the cursor after each entry can be frustrating at best; at worst, it can leave you with mangled data in an unusable format. Fortunately, Excel provides data entry forms to…
Read More
You’ve created the reports for your management meeting, and, just before you print copies for the executives, you discover that the totals are all showing last month’s values. How do you fix it—fast? 1. Check for Automatic Recalculation On the Formulas ribbon, look to the far right and click Calculation Options. On the dropdown list,…
Read More
The CONCATENATE function joins two or more text strings together into one string. For example, if you have the customer’s first name in Column A and the last name in Column B, you could use “=CONCATENATE(A3,“ ”,B3)” to produce a string containing first name and last name.
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.
