Formulas & functions
How a function works, with worked examples you can paste.
- Percentage Difference in Excel: Formula and ExamplesTo find percentage difference in Excel, divide the absolute difference between two values by their average, then format the result as a…
- Count Unique Values in Excel with a Simple FormulaTo count distinct, nonblank entries in a column in Microsoft 365, enter =IFERROR(ROWS(UNIQUE(FILTER(A2:A100,A2:A100<>""))),0) in an empty cell, replacing A2:A100 with your data…
- How to Find an Average in Excel With AVERAGE FunctionTo find the average in Excel, enter the AVERAGE function in an empty cell and point it to the numbers you want…
- How to Find the Mode in Excel: Formulas and ExamplesTo find the most frequently occurring number in Excel, enter =MODE.SNGL(A2:A11) in an empty cell, replacing A2:A11 with your data range. In…
- Find Month and Year From a Date in Excel with FormulasTo find a month and year from a date in Excel, enter =MONTH(A2) for the month number and =YEAR(A2) for the year,…
- How to Find Repeated Names in Excel with COUNTIF FormulaTo find repeated names in Excel, put names in A2:A100, then enter =COUNTIF($A$2:$A$100,A2) in B2 and fill it down. Each result shows…
- How to Find a Middle Name in Excel: Formula and StepsWith full names in A2 and names written in first-middle-last order, enter =IFERROR(INDEX(TEXTSPLIT(TRIM(A2)," "),1,2),"") in B2 to return the second word; for…
- How to Find the Minimum in Excel Using the MIN FunctionTo find the smallest number in a range, use Excel’s MIN function. If your values are in cells B2 through B10, enter…
- Vending Machine Inventory Spreadsheet: Setup and FormulasA vending machine inventory spreadsheet tracks what is loaded, what remains, what sold, and what needs restocking. Start with one row for…
- How to Share an Outlook Calendar With the Right PermissionsTo share an Outlook calendar, open Calendar, choose Share Calendar, enter the recipient’s email address, set what they are allowed to see…
- Simple Gradebook Spreadsheet: Setup, Formulas, and TipsA simple gradebook spreadsheet can track students, assignment scores, and current averages in Microsoft Excel. With a student name in A2, percentage…
- Long Invoice Template Excel: Layout and FormulasA long invoice template in Excel is a worksheet designed to handle many billable lines while keeping the invoice readable, totals accurate,…
- Left Hanging Indent in Word: Step-by-Step GuideTo make a left hanging indent in Microsoft Word, select the paragraph or paragraphs, open the Paragraph settings, and choose Special: Hanging.…
- If You Block Someone on Outlook, Will They Know?No. When you block a sender in Outlook, Outlook does not send them a notice that you blocked them. Their messages are…
- How to Share a Calendar in Outlook with the Right AccessTo share a calendar in Outlook, open Calendar, choose the calendar you own, select Share or Share Calendar, add the recipient, set…
- Round Numbers in Word Mail Merge: A Step-by-Step GuideTo round numbers in a Word mail merge, add a numeric picture switch to the merge field, such as { MERGEFIELD Amount…
- Outlook Rules: Filter Your Incoming Mail AutomaticallyCreate an Outlook rule by choosing a condition, such as who sent a message or a word in its subject, then assigning…
- How to Create Rules in Outlook to Sort Incoming EmailTo create an Outlook rule, choose the conditions a message must meet and the action Outlook should take, such as moving it…
- How to Create Round Labels in Word: A Step-by-Step GuideTo create round labels in Word, set up a label sheet using the stock’s template or measurements, place a correctly sized oval…
- Outlook Folder Rules: Create Rules to Sort EmailCreate an Outlook rule by choosing a condition, such as a sender or subject phrase, and an action that moves matching messages…
- Different Labels in Word: How to Make Each Label UniqueTo create different labels on one sheet in Microsoft Word, start a label mail merge, connect a recipient list, add the fields…
- How to Create Box File Labels in Word That Fit RightTo create box file labels in Word, measure the label area, set up a page or table to match it, add the…
- Outlook Folders and Rules: Create a Folder and Sort EmailTo sort Outlook email automatically, create a folder, then make a rule that moves messages matching a condition—such as a sender or…
- How to Add Page Numbers in Word Bottom Right CornerTo add page numbers at the bottom right in Word for Microsoft 365 on Windows, select Insert > Page Number > Bottom…
- How to Add Footnotes in a Word Table the Right WayTo add a true footnote to a Word table, click in the table cell where the reference belongs, choose References > Insert…
- How to Create Rules in Outlook to Sort Email AutomaticallyTo create a rule in Outlook, open Settings > Mail > Rules in new Outlook or Outlook on the web, select Add…
- Filter an Inventory Spreadsheet in ExcelTo filter an inventory spreadsheet in Excel, click a cell in the data and choose Data > Filter; use the arrows in…
- Excel Query Function: What to Use InsteadExcel does not have a worksheet function named QUERY like Google Sheets does. In Microsoft 365 for Windows, use functions such as…
- Create a Unique Signature in OutlookTo create a unique signature in Outlook, open the signature editor for your version, write a concise sign-off with useful contact details,…
- PowerPoint Poster Slide Size: Set the Right DimensionsTo change a PowerPoint slide to poster size in Microsoft 365 for Windows, select Design > Slide Size > Custom Slide Size,…