d

Excel Shortcut Keys: Using Ctrl + P (Print file)

Ctrl + P

Display the Print tab in Microsoft Office Backstage view. or Print the sheet/file

 

 

Excel Shortcut Keys: Using Ctrl + O (Open a file)

Ctrl + O

Display the Open dialog box to open or find a file

 

 

Excel PowerPivot: CLOSINGBALANCEMONTH Function (DAX)


CLOSINGBALANCEMONTH Function (DAX)

Syntax:

CLOSINGBALANCEMONTH(<expression>,<dates>,[<filter>])

Parameters:

expression: An expression that returns a scalar value.

dates: A column that contains dates.

filter: (optional) An expresion that specifies a filter to apply to the current context

Action:

Evaluates the expression at the lat date of the month in the current context.

 

Excel Shortcut Keys: Ctrl + N (Create a new workbook)


Ctrl + N

Creates a new, blank workbook

 

 

Excel Shortcut Keys: Ctrl + L (Create a Table)


Ctrl + L

Displays the Create Table dialog box. To Make a Table

or Make your data into uniform to change your range into Table

 

 

Excel Shortcut Keys: Ctrl + K (Insert Hyperlink)

Ctrl + K

Displays the Insert Hyperlink dialog box

For new hyperlinks or the Edit Hyperlink dialog box for selected existing hyperlinks.

 


Excel Shortcut Keys: Ctrl + I (Italic)

Excel Shortcut Keys

Ctrl + I

Applies or remove italic formatting

 

Explore Excel 2016


In this video, you will explore the Excel overview,  using the tell me box and add or delete a worksheet.





Click here to view the original source

Recommended for You

LinkWithin

Related Posts Plugin for WordPress, Blogger...