Скачать или смотреть Excel Range Names: Sinhala ▶ Excel Basics - Episode 02(Sinhalen)

⬇ Download Workfile from here: https://drive.google.com/open?id=1Zu0...

The tutorial explains what an Excel name is and shows how to define a name for a cell, range, constant or formula. You will also learn how to edit, filter and delete defined names in Excel.
Names in Excel are a paradoxical thing: being one of the most useful features, they are often considered pointless or nerdy. The reason is that very few users understand the essence of Excel names. This tutorial will not only teach you how to create a named range in Excel, but will also show how to leverage this feature to make your formulas much easier to write, read, and re-use.
Excel name - the basics
How to name a range in Excel
Type name in the Name box
Define a name using the Define Name option
Create a named range using Name Manager
How to create a named constant
How to make a named formula
How to name columns and rows (create names from selection)
How to create a dynamic named range in Excel
Excel name rules
Scope of Excel names
Excel Name Manager
Editing a named range
Filtering Excel names
Delete defined names in Excel
Top 5 benefits of using names in Excel
Excel named range - tips and tricks

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...  



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 #excelvlookup #exceldashboard
#excel #sinhalenexcel #basicexcel