Services4People

  IF function The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False. For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2). Simple IF examples =IF(C2=”Yes”,1,2) In the above example, cell D2 says:  IF(C2 = Yes, then return a 1, otherwise return a 2) =IF(C2=1,”Yes”,”No”) In this example, the formula in cell D2 says:  IF(C2 = 1, then return Yes, otherwise return No) As you see, the IF function can be used to evaluate both text and values. It can also be used to  evaluate errors . You are not limited to only checking if one thing is equal to another and returning a single result, you can also use mathematical operators and perform additional calculations depending on your criteria. You can also nest multiple IF functions together in order

  Convert numbers stored as text to numbers Use Paste Special and Multiply  If the steps above didn't work, you can use this method, which can be used if you're trying to convert more than one column of text. Select a blank cell that doesn't have this problem, type the number 1 into it, and then press  Enter . Press  Ctrl + C  to copy the cell. Select the cells that have numbers stored as text. On the Home tab, select  Paste  >  Paste Special . Select  Multiply , and then click  OK . Excel multiplies each cell by 1, and in doing so, converts the text to numbers. Second Method: 1- Select range  2- Type short key=  Alt+D+E+F

  Conditional Formatting in Outlook:  Automatically change incoming message colors and fonts based on sender, subject, or recipients Conditional formatting is a way to make messages that meet defined conditions stand out in the message list by using color, fonts, and styles. You specify conditions that an incoming message should meet, such as a sender’s name or email address, and then conditional formatting is applied only to those messages. For example, a conditional rule can specify that all messages sent from your manager appear in red text in the message list. To make further changes to the body of your email messages,  change the default font or text color for email messages  . Note:   In Microsoft Outlook 2007, the  Organize  feature enabled you to create conditional text formatting rules for email messages. In Microsoft Outlook 2010 and later, conditional text formatting is now accessed in the  Advanced View Settings  dialog box. Create a conditional formatting rule On the  View

  First, please save your Excel as a .csv file. Outlook can import comma separated value (.csv) files, but not workbooks with multiple sheets. ln your workbook, click the worksheet with the calendar information you want to import. Click  File  >  Save As . Choose where to save your file. In the  Save as type  box, choose  CSV (Comma delimited) (*.csv) , and click  Save . Excel tells you “The selected file type does not contain workbooks that contain multiple sheets.” This refers to a limitation of the CSV file; nothing will happen to your original workbook (the .xlsx file). Click  OK . Excel tells you “Some features in your workbook might be lost if you save it as CSV (Comma delimited).” This refers only to limitations of the CSV file and can be ignored.  Click  Yes  to have Excel save the current worksheet as a CSV file. The original workbook (the .xlsx file) closes.  Close the CSV file. You're done with Excel. Now, you can start the import process in Outlook. Next, please impo

  How does the XLOOKUP function work in Microsoft Excel? To explain the XLOOKUP function properly, we’ll use an example scenario. An example Excel spreadsheet contains the staff list of a small company, containing IDs, names, email addresses, and responsibilities. A dataset, such as this one, can be used as a searchable directory in Excel using an XLOOKUP formula. A search value for this formula could contain any of the values above, from an ID number to an email address. XLOOKUP can find a value (matching in full or the closest approximation) from a range of cells (or search array) and return it. To do this, a formula using XLOOKUP has a number of arguments that need to be used to create the query. Sample -2 

  The Show Report Filter Pages Feature The Show Report Filter Pages feature: Creates a copy of an existing pivot table for each unique item in a field. The new pivot tables are created on individual worksheets. Each sheet is renamed to match the item name. A filter is applied to the field in the Filters Area of each pivot table for the item. All this is done with a click of a button.  Your field can have 5 or 500 unique items.   Show Report Filter Pages will create a sheet for each item and replicate the pivot table report . Here are the steps to use Show Report Filter Pages: Step 1 – Add the field to the Filters Area The first step is to create a pivot table.  Then add the field that contains the list of items to the Filters Area of the pivot table. In this example we want to create one pivot table for each salesperson in the organization.  So, we are going to add the Salesperson field to the Filters Area of the pivot table. Step 2 – Run the Show Report Filter Pages Once we have the p

    How to create a conditional formatting rule based on formula On the  Home  tab, in the  Styles  group, click  Conditional formatting > New Rule… In the  New Formatting Rule  window, select  Use a formula to determine which cells to format . Enter the formula in the corresponding box. Click the  Format…  button to choose your custom format. Switch between the  Font ,  Border  and  Fill  tabs and play with different options such as font style, pattern color and fill effects to set up the format that works best for you. If the standard palette does not suffice, click  More colors…  and choose any RGB or HSL color to your liking. When done, click the  OK  button. Make sure the  Preview  section displays the format you want and if it does, click the  OK  button to save the rule. If you are not quite happy with the format preview, click the  Format…  button again and make the edits. Tip.  Whenever you need to edit a conditional formatting formula, press  F2  and then move to the neede