Posts

Explanation The ExcelNETWORKDAYS functioncalculates the number of working days between two dates. Note that NETWORKDAYSincludesboth the start and end dates in the calculation if they are workdays. NETWORKDAYS can also exclude a custom list of holidays. This formula returns 3, since two of the 5 days are holidays. Custom weekends If you need take into account custom weekends (i.e. weekends are Saturday only, Sunday and Monday, etc.) Need a date? If you need a date n workdays in the past or future, see theWORKDAYfunction....

In the example, the formula is: B4 contains a date value for January 5, 2016. The YEAR function returns the number 2016 representing the year of the date.

The first argument,data_field, names a value field to query. The second argument, pivot_table, is a reference to any cell in an existing pivot table. The second argument is a reference to a cell that is part of the pivot table.

This works because the Go To dialog records the hyperlink location when a hyperlink is clicked. When the enter key is pressed, Excel will navigate to the recorded location.

About This Shortcut Move to next / previous workbook window. This shortcut “cycles” through open workbooks each time it is used. To reverse direction, add the shift key. Related videos The videos below demonstrate this shortcut.

On a Mac, you might also use Option + right arrow. Related videos The videos below demonstrate this shortcut. Shortcuts to navigate workbooks How to navigate a workbook

About This Shortcut Move to next / previous workbook window. On a Mac, check System Preferences > Keyboard > Shortcuts > Keyboard to confirm the shortcut is enabled. Related videos The videos below demonstrate this shortcut. Shortcuts to navigate workbooks How to navigate a workbook

Related videos The videos below demonstrate this shortcut. Shortcuts to navigate workbooks How to navigate a workbook

you might also use FALSE instead of zero if you like. VLOOKUP simply looks up the value and returns the group name from the 2nd column in the table. As always, if VLOOKUP can’t find a match, it will return #N/A.

LOOKUP’s default behavior makes it useful for solving certain problems in Excel.

Explanation In this example, the goal is to group ages into buckets. Then use a lookup function to find the right bucket or group for each age. Also note that we are using anamed rangefor convenience only, since named ranges do not change when copied. We don’t want this reference to change as the formula is copied down. Because VLOOKUP is set to perform an approximate match, it has a particular behavior....

About This Shortcut This shortcut will group selected pivot table items.

About This Shortcut This shortcut will group selected rows or selected columns. Select whole rows or columns first before using. Related videos The videos below demonstrate this shortcut. Shortcuts to group, ungroup, and outline