Скачать или смотреть Excel Top 30 Shortcut Keys : Sinhala ▶ Excel Basics - Episode 06 (Sinhalen)

Microsoft Excel is a very powerful application for spreadsheet processing and a pretty old one, its first version emerged as early as in 1984. Each new version of Excel came with more and more new shortcuts and seeing the full list (over 200!) you may feel a bit intimidated. Don't panic! 20 or 30 keyboard shortcuts will absolutely suffice for everyday work; while others are purposed for highly specific tasks such as writing VBA macros, outlining data, managing PivotTables, recalculating big workbooks, etc.I've put together a list of the most frequent shortcuts below and you can download it as a printable image (shortcuts-page1, shortcuts-page2) or a PDF-file for your convenience.If you want to re-arrange the shortcuts to your liking or extend the list, then download the original workbook. Must-have Excel shortcuts no workbook can do without know, I know, these are basic shortcuts and most of you are comfortable with them. Still, let me write them down again for beginners. Note for newbies: The plus sign "+" means the keys should be pressed simultaneously. The Ctrl and Alt keys are located on the bottom left and bottom right sides of most keyboards.Ctrl + N Create a new workbook. Ctrl + O Open an existing workbook.Ctrl + S Save the active workbook.F12 Save the active workbook under a new name, displays the Save as dialog box.Ctrl + W Close the active workbook.Ctrl + C Copy the contents of the selected cells to Clipboard.Ctrl + X Cut the contents of the selected cells to Clipboard.Ctrl + V Insert the contents of the Clipboard into the selected cell(s).Ctrl + Z Undo your last action.

Learn Microsoft Excel and Microsoft Power BI in Sinhala with this group. We will be teaching Excel from Basic to Advance in a very simple form.

Other Important Videos
Excel VLOOKUP Exact Match: Sinhala ▶ Excel Advanced Formulas and Functions - Episode 01(Sinhalen)
   • Excel VLOOKUP Exact Match: Sinhala ▶ Excel...  

Amazing and Simple Data Entry Form Excel: Sinhala ▶ Excel Tips and Tricks - Episode 01 (Sinhalen)
   • Amazing and Simple Data Entry Form Excel: ...  

Excel Top 30 Shortcut Keys : Sinhala ▶ Excel Basics - Episode 06 (Sinhalen)
   • Excel Top 30 Shortcut Keys : Sinhala ▶ Exc...  

Excel Data Validation Controls : Sinhala ▶ Excel Basics - Episode 04(Sinhalen)
   • Excel Data Validation Controls : Sinhala ▶...  

Excel Drop-down list: Sinhala ▶ Excel Basics - Episode 03(Sinhalen)
   • Excel Drop-down list: Sinhala ▶ Excel Basi...  

Excel Progress Circle Chart: Sinhala ▶ Charts and and Data Viz. in Excel - Episode 01(Sinhalen)
   • Excel Progress Circle Chart: Sinhala ▶  Ch...  

shorcut keys in excel,popular excel shortcuts,excel shortcuts,ms excel shortcut keys in telugu,excel shortcut sum formula,excel shortcut select to bottom of column,excel shortcut insert chart,excel shortcut filter,excel insert current date and time,excel tutorials,excel paste special shortcut,ms excel basics,leila gharani,excel 2016,excel 2013,excel 2010,xelplusvis,advanced excel tricks,excel online course,excel tips and tricks,excel for analysts

excel tutorial
excel basic
excel advanced tutorials
excel tutorial sinhala
excel sinhala
excel vlookup
excel dashboard
excel formulas and functions
excel shortcut keys
excel basic for beginners
excel tricks
power BI tutorials for beginners
power bi tutorial
power bi dashboard
power bi tutorial advance
power bi dax
power query

Also you can connect with me on Below Channels.

FaceBook : https://www.facebook.com/Excel-and-Po...
LinkedIn :   / kasun-manchanayake-fmva™-cba-mos-4756a532  
Web : www.dubaipowerbi.com

We will be covering these areas from our excel and Power BI tutorials series.

My Online Courses

1. The Beginner's Guide to Excel - Excel Basics Tutorial
2. Advanced Excel Formulas and Functions (8 Hours)
3. Analyzing Data with Excel Power Query, Power Pivot and DAX (20 Hours)
4. Excel Data Visualization in Depth (5 Hours)
5. Excel PivotTables in Depth (5 Hours)
6. Analyzing and Visualizing Data with Microsoft Power BI (20 Hours)
7. Excel Master Class
8. Excel Dashbaords Course
8. Financial Reporting with Power BI
9. HR Analytics with Power BI

Text Functions
Logical Functions
Information Functions
Date and Time Functions
Lookup and Reference Functions
Math and Trig Functions
Statistical Functions
Database Functions
Financial Functions
Engineering Functions
Cube Functions
Web Functions
Excel Dashboards

INDEX + MATCH CONDITIONAL FORMATTING CONCATENATE VLOOKUP SUMIF, COUNTIF, AVERAGEIF IF STATEMENTS HLOOKUP XLOOKUP SUM, COUNT, AVERAGE PIVOT CHARTS DATA VALIDATION CONDITIONAL FORMATTING VBA MACRO DASHBOARDS DROPDOWNLIST

#exceltutorialsinhalen #excelshortscuts #shortcuts