In this Learn Excel series, we show you how to remove the first word from a cell containing data. You can use the formulas directly by copying and pasting or you can learn how these formulas work so you can apply it by yourself the next time you’re faced with a similar problem. … [Read more...] about Learn Excel : How to Remove the First Word from a Cell
learn excel
Learn Excel: How to Use Data Validation
In our Learn Excel series, we continue you teach you how to use the various tools and functions in Excel to enter and analyze your data. In today’s lesson, we’ll talk about what data validation is and how to use data validation in Excel to control what data you enter in your … [Read more...] about Learn Excel: How to Use Data Validation
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 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
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