In this Excel tutorial, we’ll show you how to create a custom list in Excel and save it so you don;t have to manually add one to your worksheets every time the need arises. By default, Excel offers some common custom lists like days of the week and months of the year. If you … [Read more...] about How to Create a Custom List in Excel
excel how to
Learn Excel: How to Use the Excel Count Function
When you work with large sets of data in Excel, one of the most common analysis you do involves counting cells in the worksheet. The Excel Count function makes it easy for you to count cells based on various criteria. In our Learn Excel Series, we'll be taking a look at the … [Read more...] about Learn Excel: How to Use the Excel Count Function
Learn Excel : How to Use the IF Logical Function
Decisions! Decisions! Life is filled with situations where you have to make decisions. Thankfully Excel is a pretty good tool to use to help you make better decisions, at least in some matters. In this Excel tutorial, I’ll show you how to use the IF logical function in Excel to … [Read more...] about Learn Excel : How to Use the IF Logical Function
How to Sum Up Specific Values in a Range in Excel
Excel offers a number of handy tools to sum up the totals of all the numbers in a range of cells in your worksheet. But what about those times when you only want to sum up specific values in a range? In such situations, you can make use of the SUMIF and SUMIFS functions. In this … [Read more...] about How to Sum Up Specific Values in a Range in Excel
How to Enter the Ampersand Sign in Excel Headers and Footers
Have you tried entering the ampersand sign in your custom header or footer only to find that it disappears on your printed worksheet? Well, here’s a simple trick on how to enter the ampersand sign in Excel headers and footers that show up on your printed page. If you are new … [Read more...] about How to Enter the Ampersand Sign in Excel Headers and Footers
How to Use Text to Speech to Check Errors in Excel
Excel offers some handy tools to help you identify and weed out errors in your worksheet. A simple Find and Replace is one way to correct errors, while the Spell Check feature can put paid to typos. However, if you have mistyped some data or overwritten something from the … [Read more...] about How to Use Text to Speech to Check Errors in Excel
How to Combine the Contents of Multiple Cells in Excel [Method 3 is Super Easy]
![How to Combine the Contents of Multiple Cells in Excel [Method 3 is Super Easy]](https://theapptimes.com/wp-content/uploads/2018/02/How-to-Combine-the-Contents-of-Multiple-Cells-in-Excel-Method-3-is-Super-Easy.png)
There may be times when you need to combine the contents of multiple cells in your Excel worksheet to arrive at a single name. For instance you may have a salutation, a first name and a second name, which appear in three different columns in your worksheet and you may want to … [Read more...] about How to Combine the Contents of Multiple Cells in Excel [Method 3 is Super Easy]
How to Save Excel Workbook Settings Using Custom Views
There may be times when you need to work on an Excel sheet for a prolonged period of time with some unique settings applied, such as a zoom option that is not default, a specific column width or height, or a specific print area. You’ll lose plenty of time if you have to keep … [Read more...] about How to Save Excel Workbook Settings Using Custom Views