Categories
Excel

How to Merge First and Last Names in Excel (3 Ways)

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)

Categories
Excel

3 Ways to Apply Comma Style in Excel to Format Numbers

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

Categories
Excel

Excel Filter Not Working? 10 Common Problems and Solutions

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

Categories
Excel

How to Add a Filter in Excel to Display Relevant Data

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

Categories
Excel

How to Apply the Accounting Number Format in Excel (3 Ways)

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)

Categories
Excel

How to Use the NPER Function in Excel Like a Boss!

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!