Excel Shortcut Keys: Using Ctrl + W (Closes the selected workbook window)

Excel Shortcut Keys

Ctrl + W
Closes the selected workbook window.

Excel Shortcut Keys: Using Ctrl + V (Inserts the contents of the Clipboard)

Excel Shortcut Keys

Ctrl + V
Inserts the contents of the Clipboard at the insertion point and replaces any selection.
Available only after you have cut or copied an object, text, or cell contents.

Excel Shortcut Keys: Using Ctrl + U (Underlining the text)

Excel Shortcut Keys

Ctrl + U
Applies or removes underlining.

Excel Shortcut Keys: Using Ctrl + T (Create a Table)

Excel Shortcut Keys

Ctrl + T
Display the Create Table dialog box. Or Create a range into Table.

Excel Shortcut Keys: Using Ctrl + S (Saves the active file)

Excel Shortcut Keys

Ctrl + S
Save the active file with its current file name, location, and file format.

Excel Shortcut Keys: Using Ctrl + R (Fill Right command to copy)

Excel Shortcut Keys

Ctrl + R

Uses the Fill Right command to copy the contents and format of the leftmost cell of a selected range into the cells to the right.

Excel Shortcut Keys: Using Ctrl + Q (Quick Analysis option)

Excel Shortcut Keys

Ctrl + Q

Display the Quick Analysis option for your data when you have cells that contain data selected

Weeding Planner - Excel Template

Do you need help planning your wedding on a budget? Download the wedding budget spreadsheet to plan and keep track of your expenses. The file contains two worksheets ... one to create your detailed budget, and one to come up with an initial estimate or plan.

Spanish:

¿Necesitas ayuda para planificar tu boda con un presupuesto? Descargue la hoja de cálculo del presupuesto de la boda para planificar y realizar un seguimiento de sus gastos. El archivo contiene dos hojas de trabajo ... una para crear su presupuesto detallado, y una para llegar a una estimación inicial o un plan.

Arabic:

هل تحتاج إلى مساعدة تخطيط حفل الزفاف الخاص بك على الميزانية؟ تحميل جدول ميزانية الزفاف لتخطيط وتتبع النفقات الخاصة بك. يحتوي الملف على ورقتي عمل ... واحدة لإنشاء ميزانيتك التفصيلية، وواحد من أجل التوصل إلى تقدير أولي أو خطة.

Urdu:

کیا آپ کو اپنی شادی کی بجائے بجٹ میں مدد کی ضرورت ہے؟ شادی کے بجٹ سپریڈ شیٹ کو ڈاؤن لوڈ کریں اور آپ کے اخراجات کا سراغ لگانا رکھیں. اس فائل میں دو ورکشاپ بھی شامل ہیں ... ایک آپ کے تفصیلی بجٹ کو پیدا کرنے کے لئے، 

اور ایک ابتدائی اندازہ یا منصوبہ کے ساتھ آنے کے لئے.

क्या आपको बजट पर अपने शादी की योजना बनाने में मदद की ज़रूरत है? शादी के बजट स्प्रैडशीट को डाउनलोड करें और अपने खर्चों का ट्रैक रखें। फ़ाइल में दो कार्यपत्रक हैं ... एक आपका विस्तृत बजट बनाने के लिए, और प्रारंभिक अनुमान या योजना के साथ आने के लिए एक है

你需要帮助规划你的婚礼预算吗？ 下载婚礼预算电子表格，以计划和跟踪您的费用。 该文件包含两个工作表...一个用于创建您的详细预算，一个用于初步估算或计划。

Collaborate on Excel workbooks - Excel 2-16 New feature

Collaborate on Excel workbooks at the same time with co-authoring

If you need a co-author

Step-1 Upload your workbook
Step-2 Share It
Step-3 Other People can open it
Step-4 Co-author with others

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

Excel Shortcut Keys

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)

Excel Shortcut Keys

Ctrl + O

Display the Open dialog box to open or find a file

 

 

Did you Know about Excel Rows and Columns

Know about Microsoft Excel

Worksheet Size

there are 1,048,576 rows and 16,384 columns in one worksheet

 

 

Using VLOOKUP function (step by step tutorial)

Excel Tutorial

Using VLOOKUP() function (step by step tutorial)

How to use VLOOKUP() function in Excel

using VLOOKUP function

Close All file on a single click in Excel 2013 and 2016

Excel Tutorial

Close All file on a single click in Excel 2016

In Excel 2013 & 2016 All the excel files open in separate window so it's not possible to close all the opened file at once. This is by default, there is no option to close all excel workbook/files at once in version 2013 & 2016.
Previous version of Excel workbook/file opened in one window and we can easily have closed all the files just using the Alt+F4. Excel 2013 each excel file open on separate window and continue in 2016 version.
For example, if we have 10 files open we must close all the files separately or hit the Alt+F4 command 10 times.

Video Tutorial: Analyze and Visualize Data with Excel

Video Tutorial: Analyze and Visualize Data with Excel







Get the full course at Microsoft Virtual Academy: https://www.microsoftvirtualacademy.c...

Excel PowerPovit: DATE Function (DAX)

Excel PowerPivot DAX Function & Features

DATE Function (DAX)

Syntax:

DATE(<year>, <month>, <day>)

Parameters:

year: A number representing the year.

month :month is a number from 1 to 12, then it represents a month of the year. 1 represents January, 2 represents February, and so on until 12 that represents December.

day: day is a number from 1 to the last day of the given month then it represents a day of the month.

Action:

Returns the specified date in datetime format.

 

Excel PowerPivot: CALENDAR Function (DAX)

Excel PowerPivot DAX Function & Features

CALENDAR Function (DAX)

Syntax:

CALENDAR(<start_date>, <end_date>)CALENDAR(<start_date>, <end_date>)

Parameters:

start_date: Any DAX expression that returns a datetime value.

end_date :Any DAX expression that returns a datetime value.

Action:

Returns a table with a single column named “Date” that contains a contiguous set of dates. The range of dates is from the specified start date to the specified end date, inclusive of those two dates.

 

Take Screen shoot / Screen clipping in Excel

Take Screen shoot / Screen clipping in Excel

Take Screen shoot / Screen clipping in Excel

 

How to Take Screen shoot / Screen clipping in Excel

Lets start .

Excel Healthcare KPI Dashboard

Health KPI dashboard template is our first attempt to develop computer graphics style dashboard using Excel infogaphics male and female elements.

Daily task list Excel 2013 Online Template

Description:

Stay organized with this template list of daily tasks. Important events, special occasions, holidays and have your own list, and every day tasks to do to stay on track. Enter a date in the yellow box to highlight the tasks for that day.