Showing posts with label Excel Shortcuts. Show all posts
Showing posts with label Excel Shortcuts. Show all posts

How to create list of business days in Excel 2013

The easiest way to generate a list of business days is using following functions:
1. WORKDAY
2. WORKDAY.INTL
Generating list of business days using WORKDAY:
The WORKDAY function returns the serial number of the date before or after a specified number of workdays.
Syntax:               =WORKDAY(start_date, days, holidays)
  • Start_date: Needs the input of the start date. This could be directly entered or can be given as cell reference.
  • Days: This is the number of non-weekend and non-holiday days before or after the start-date
    • Positive value is used to get date after the start-date
    • Negative value is used to get number before the start-date
  • Holidays: This is an optional argument wherein you can feed the list of additional holidays.

Notes:
  • Excel stores the dates as sequential serial numbers for the ease of calculations (by default 1 January 1900 is stored as 1.
  • In order to view the number as date, select the cell and follow as below:
    • Right click >> Format cells >> "Number" tab >> Select "Date" in Category
  • If any of the input date is not a valid date, the function will return #VALUE! error.
  • If the output returned is an invalid date, the function returns #NUM! error.

Generate list of business days using WORKDAY.INTL function:
This function is only available in Excel 2010 and 2013 versions.
Syntax:               =WORKDAY.INTL(start_date, days, [weekend], [Holidays])
As you would have noticed from above syntax, the only addition is [weekend] as compared to WEEKDAY function syntax.
The two functions are pretty much the same except the WORKDAY.INTL function allows you to specify when your weekend dates are.
Note:
The default weekend is Saturday and Sunday. Hence, if the desired weekend is same, then you can keep this argument blank.

Text alignment keyboard shortcuts for Excel 2013

Text alignment options are located at below location in Excel 2013:
"HOME" tab>>>"Alignment" area

Keyboard shortcuts in Excel
Both vertical and horizontal alignment options are available in the area:
Vertical Alignment: Top, Middle, Bottom
Horizontal Alignment: Left, Center, Right
On pressing "Alt" key, the shortcut key for tabs on the ribbon gets activated
"Alt+H" will activate the "Home" tab in the ribbon and shortcut letters of this tab will get activated.
Text Alignment shortcuts in Excel

Thus, the letters mentioned below along with "Alt+H" will be shortcut keys for respective text alignment:
Text Alignment keyboard shortcuts in ExcelVertical Alignment shortcuts:
AT-Align Top
AM-Align Middle
AB-Align Bottom
Text Alignment keyboard shortcuts in Excel-2007-2010-2013
Also read: How to Trace Precedents and Dependents in Excel
Horizontal Alignment shortcuts:
AL-Align Left
AC-Align Center
AR-Align Right

Once the alignment options are applied, the active alignment of the active cell can be seen in the alignment area as below:
Text Alignment shortcuts
More interesting articles on this website: