# Excel Tutorial - Easy Excel 2010

Related:  EXCELTechnology

Excel Formulas- free tutorial Substring in Excel - Easy Excel Tutorial Mid | Left | Right | Substring between parentheses | Substring containing specific text | Flash Fill There's no SUBSTRING function in Excel. Use MID, LEFT, RIGHT, FIND, LEN, SUBSTITUTE, REPT, TRIM and MAX in Excel to extract substrings. Mid To extract a substring, starting in the middle of a string, use the MID function in Excel. Explanation: the MID function starts at position 7 (O) and extracts 6 characters. Left To extract the leftmost characters from a string, use the LEFT function in Excel. To extract a substring (of any length) before the dash, add the FIND function. Explanation: the FIND function finds the position of the dash. Right To extract the rightmost characters from a string, use the RIGHT function in Excel. To extract a substring (of any length) after the dash, add LEN and FIND. Explanation: the LEN function returns the length of the string. Substring between parentheses To extract a substring between parentheses (or braces, brackets, slashes, etc.), use MID and FIND in Excel. 1.

A Satisfying Narrative – Simple stories of complex change Excel SUMIF function – formula examples to conditionally sum cells This tutorial explains the Excel SUMIF function in plain English and provides a numbers of SUMIF formula examples for numbers, text, dates and wildcards. If you are faced with the task that requires conditional sum in Excel, the SUMIF function is what you need. This tutorial will briefly explain the function's syntax and general usage, and then you will extend the new knowledge in practice with a number of SUMIF formula examples. A good thing is that the SUMIF function is identical in all Excel versions, from 2013 to 2003. Another great news is that once you've invested some time in learning SUMIF, it will take you very little effort to get the insight of other "IF" functions such as SUMIFS, COUNTIF, SOUNIFS, AVERAGEIF etc. SUMIF in Excel - syntax and usage The SUMIF function, also known as Excel conditional sum, is used to add cells based on a certain condition, or criteria. SUMIF(range, criteria, [sum_range]) 2. criteria - the condition that must be met. Note. Note. Note. Note. Note. 1.

23 things you should know about Excel pivot tables | Exceljet Many Excel experts believe that pivot tables are the single most powerful tool in Excel. According to Bill Jelen (a.k.a. Mr. Excel) "No other tool in Excel gives you the flexibility and analytical power of a pivot table". I agree completely. 1. Many people have the idea that building a pivot table is complicated and time-consuming, but it's simply not true. Select any cell in the source data On the Insert tab of the ribbon, click the PivotTable button In the Create PivotTable dialog box, check the data and click OK Drag a "label" field into the Row Labels area (e.g. customer) Drag a numeric field into the Values area (e.g. sales) Video: How to quickly create a pivot table Select any cell in the data to start. A very simple pivot table in about 30 seconds 2. To minimize problems down the road, always use good quality source data, organized in a tabular layout. Video: How to quickly fill in missing data Perfect data for a pivot table! 3. 300 first names means we have 300 employees. 4. 5. 6.

The Three Parts of an Effective Apology People make mistakes all the time. Not just bad people, or weak people. All people. Our mistakes are what make us human. And even when we don’t think that we’ve made a mistake, other people will often find errors in our ways. We human beings are walking offenders. Here’s the real question: If we’ve done something that offends someone else—whether or not we feel we are to blame—should we apologize? I believe that it almost always serves our highest good to apologize if we’ve hurt or offended someone else—even if we think the offended person’s anger is unjustified, or if we have a perfectly good excuse for what happened. Often, the impact of our action is not what we intended. We don’t repair a fissure in one of our relationships by ignoring it. But all apologies aren’t created equal, of course. So what makes a good apology? Step 1: Tell them what you feel Usually, we start by saying “I’m sorry” to express remorse. Just share the remorseful feelings, please. Then acknowledge these things.

Excel COUNTIFS and COUNTIF with multiple criteria – examples of usage The tutorial explains how to use COUNTIFS and COUNTIF formulas with multiple criteria in Excel. You will find a number of examples for different data types - numbers, dates, text, wildcard characters, non-blank cells and more. Of all Excel functions, COUNTIFS and COUNTIF are probably most often mixed up because they look very much alike and both are purposed for counting cells based on the specified criteria. The difference is that the COUNTIF function is intended for counting cells based on a single condition in one range, while COUNTIFS allows using several criteria and ranges. In practice, however, you can use Excel COUNTIF with multiple criteria as well. Excel COUNTIFS function - syntax and usage As I've already mentioned, the Excel COUNTIFS function is purposed for counting cells across multiple ranges based on one or several conditions. COUNTIFS syntax The syntax of the COUNTIFS function is as follows: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) Example 1. Tip.