The need to merge first and last names seems to come up often. Here are 3 ways to combine first and last names in Microsoft Excel.Continue readingHow to Merge First and Last Names in Excel (3 Ways)
Category: Excel
Articles, shortcuts, tips and tricks designed to help Microsoft Excel users get more out of the business world’s leading spreadsheet application.
Comma style incorporates a thousands separator and two decimal places to present numbers in a consistent, very legible way.Continue reading3 Ways to Apply Comma Style in Excel to Format Numbers
Excel filter not working? Here are 10 things to check if you’re having trouble filtering data in Excel – along with the recommended solutions.Continue readingExcel Filter Not Working? 10 Common Problems and Solutions
The ability to pare down a large data list to a focused record set is an extremely useful skill. Read on for everything you need to know!Continue readingHow to Add a Filter in Excel to Display Relevant Data
When your spreadsheet has a financial focus, key figures should be displayed using the accounting number format. Read on to find out how!Continue readingHow to Apply the Accounting Number Format in Excel (3 Ways)
The NPER function will calculate the number of payment periods required to repay a loan or reach a savings goal. Read on to learn more!Continue readingHow to Use the NPER Function in Excel Like a Boss!