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]
excel how to
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
How to Insert a Tick Mark in Microsoft Word and Excel
We often have the need to insert a tick mark or a check mark in our Excel and Word documents. But look around the Ribbon interface and you won;t find one simple button or command that can let you insert a tick mark in a click. However, there are a number of workaround solutions … [Read more...] about How to Insert a Tick Mark in Microsoft Word and Excel
How to Use Excel Functions in Formulas
In the previous few posts, we discussed how to write Excel formulas, starting with simple ones and moving on to more complex formulas. We also saw how to use absolute and relative referencing in formulas. Today’s topic is all about how to use Excel functions in formulas. … [Read more...] about How to Use Excel Functions in Formulas
How to Change the Regional Date and Time Format for Excel
Excel is not designed to automatically recognize date formats where the number of the day precedes the number of the month and year. For example, if you are in the U.S and are working with European Date formats, when you enter 5/04/2016 in Excel, you want it to represent April 5, … [Read more...] about How to Change the Regional Date and Time Format for Excel
How to Convert Fractional Times to Hours and Minutes in Excel
If you have data with fractional times, say 8.8 hours and you need to convert them to hours and minutes, say 8 hours and 48 minutes, you can do the math manually to get the result. You’d multiply .8 hours by 60 minutes to convert the hours to minutes. However, if you’ve got a … [Read more...] about How to Convert Fractional Times to Hours and Minutes in Excel
Understanding Relative and Absolute Cell References in Excel
As we learned in our post on Excel for Beginners, Excel formulas can be constructed using cell references. You can reference cells or a range of cells in a worksheet, other worksheets, or even other workbooks. There are 2 main types of cell references in Excel; Relative and … [Read more...] about Understanding Relative and Absolute Cell References in Excel
How to Write Complex Excel Formulas
In a previous article, we learned how to create and input simple formulas in Excel. If you are already familiar with that, let’s move on to working with complex Excel formulas. By complex formulas, I mean one that has more than one mathematical operator, such as 2+3*56. The thing … [Read more...] about How to Write Complex Excel Formulas