⬇ Download Workfile from here: https://drive.google.com/open?id=1iD8B_4C7d8LuJ0EPXM1bQe2P6ErZkI0i
In This Tutorial, we will Why Do You Need to Know About Data Entry Forms?
Data Entry Form in Excel
Adding Data Entry Form Option To Quick Access Toolbar
Parts of the Data Entry Form
Creating a New Entry
Navigating Through Existing Records
Deleting a Record
Restricting Data Entry Based on Rules
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.
excel tutorial
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-Power-BI-Sinhalen-100552174658252/?modal=admin_todo_tour
LinkedIn : https://www.linkedin.com/in/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 #exceldataentry #exceldashboard
