Link for Date Picker : http://samradapps.com/datepicker
The tutorial shows how to insert a drop-down calendar in Excel (date picker) and link it to a specific cell. You will also learn a quick way to create a printable calendar based on an Excel calendar template.
When working with large or shared worksheets, maintaining data integrity is the biggest problem, especially when it comes to entering dates. Should they be entered as mm/dd/yy or dd/mm/yy or mm-dd-yyyy? And can I simply type a date like “05 Sep 2016”? Oh, and what was the date of the first Monday in September this year?
All of the above problems can easily be solved by inserting a drop down calendar that will let your users fill in dates in a mouse click! This tutorial will teach you an easy way to make such a calendar in Excel, and show how to quickly create a calendar based on a template.
How to insert calendar in Excel (Date Picker control) – step-by-step instructions to create a drop-down calendar.
Third-party calendar tools for Excel – a selection of free third-party tools to insert a calendar (date picker) in the desktop and online versions of Excel.
How to make calendar in Excel – a quick way to create a printable calendar based on a template (weekly, monthly or yearly).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)
Amazing and Simple Data Entry Form Excel: Sinhala ▶ Excel Tips and Tricks – Episode 01 (Sinhalen)
Excel Top 30 Shortcut Keys : Sinhala ▶ Excel Basics – Episode 06 (Sinhalen)
Excel Data Validation Controls : Sinhala ▶ Excel Basics – Episode 04(Sinhalen)
Excel Drop-down list: Sinhala ▶ Excel Basics – Episode 03(Sinhalen)
Excel Progress Circle Chart: Sinhala ▶ Charts and and Data Viz. in Excel – Episode 01(Sinhalen)
excel advanced tutorials
excel tutorial sinhala
excel formulas and functions
excel shortcut keys
excel basic for beginners
power BI tutorials for beginners
power bi tutorial
power bi dashboard
power bi tutorial advance
power bi dax
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
Date and Time Functions
Lookup and Reference Functions
Math and Trig Functions
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 #exceldatepicker #calender