thedatalabs.org Open in urlscan Pro
198.54.114.240  Public Scan

Form analysis
4 forms found in the DOM

GET https://thedatalabs.org/

<form method="get" class="td-search-form" action="https://thedatalabs.org/">
  <!-- close button -->
  <div class="td-search-close">
    <a href="#"><i class="td-icon-close-mobile"></i></a>
  </div>
  <div role="search" class="td-search-input">
    <span>Search</span>
    <input id="td-header-search-mob" type="text" value="" name="s" autocomplete="off">
  </div>
</form>

GET https://thedatalabs.org/

<form method="get" class="td-search-form" action="https://thedatalabs.org/">
  <div role="search" class="td-head-form-search-wrap">
    <input id="td-header-search" type="text" value="" name="s" autocomplete="off"><input class="wpb_button wpb_btn-inverse btn" type="submit" id="td-header-search-top" value="Search">
  </div>
</form>

GET https://thedatalabs.org/

<form method="get" class="tdb-search-form" action="https://thedatalabs.org/">
  <div role="search" class="tdb-search-form-inner"><input class="tdb-search-form-input" type="text" value="" name="s" id="s">
    <div class="tdb-search-form-border"></div><button class="wpb_button wpb_btn-inverse tdb-search-form-btn" type="submit" id="searchsubmit"><span>Search</span></button>
  </div>
</form>

POST

<form id="mc4wp-form-1" class="mc4wp-form mc4wp-form-1339" method="post" data-id="1339" data-name="TheDataLabs Update">
  <div class="mc4wp-form-fields">
    <p>
      <label>First Name</label>
      <input type="text" name="FNAME" placeholder="First Name" required="">
    </p>
    <p>
      <label>Email address</label>
      <input type="email" name="EMAIL" placeholder="Email address" required="">
    </p>
    <p>
      <label>
        <input name="AGREE_TO_TERMS" type="checkbox" value="1" required=""> <a href="https://thedatalabs.org/privacy-policy/" target="_blank">I have read and agree to the privacy policy.</a>
      </label>
    </p>
    <p>
      <input type="submit" value="Sign up">
    </p>
  </div><label style="display: none !important;">Leave this field empty if you're human: <input type="text" name="_mc4wp_honeypot" value="" tabindex="-1" autocomplete="off"></label><input type="hidden" name="_mc4wp_timestamp"
    value="1673168273"><input type="hidden" name="_mc4wp_form_id" value="1339"><input type="hidden" name="_mc4wp_form_element_id" value="mc4wp-form-1">
  <div class="mc4wp-response"></div>
</form>

Text Content

 * MS Excel
   * Spreadsheet History
   * Spreadsheet Structure
   * Introduction to Excel
   * The Ribbon
   * Backstage view
   * Keyboard Shortcuts
 * Charts|Graphs
   * 3D Infographics
   * 3D Glass Fill Infographics
   * Progressive Doughnut Chart
   * Highlight Max and Min in Chart
 * Utility Tools
   * Annual Leave Tracker
     * Using Annual Leave Tracker
     * Download Leave Tracker
   * Employee Activities Tracker
   * Data Entry Form
   * Advance Data Entry Form
   * Animated Countdown Timer in Excel
   * Fully Automated Data Entry Userform
   * Employee Activities Tracker version 2.0
   * Displaying Chart in a UserForm
   * Dynamic Gantt Chart
 * DAX
   * Introducing DAX 
   * DAX operators
   * DAX Syntax
   * Parameter-Naming Conventions
   * Filter Context
   * DAX Functions
 * Blog Posts
   * Charts & Visualization
   * Tips & Tricks
   * Tools and Trackers
 * About Us
 * Contact Us

Sign in

Welcome!Log into your account

your username
your password
Forgot your password?

Password recovery
Recover your password

your email

Search

10.1 C
Delhi
Sunday, January 8, 2023

Sign in
Welcome! Log into your account

your username
your password
Forgot your password? Get help
Password recovery
Recover your password

your email
A password will be e-mailed to you.


THEDATALABS

 * MS Excel
   * Spreadsheet History
   * Spreadsheet Structure
   * Introduction to Excel
   * The Ribbon
   * Backstage view
   * Keyboard Shortcuts
 * Charts|Graphs
   * 3D Infographics
   * 3D Glass Fill Infographics
   * Progressive Doughnut Chart
   * Highlight Max and Min in Chart
 * Utility Tools
   * Annual Leave Tracker
     * Using Annual Leave Tracker
     * Download Leave Tracker
   * Employee Activities Tracker
   * Data Entry Form
   * Advance Data Entry Form
   * Animated Countdown Timer in Excel
   * Fully Automated Data Entry Userform
   * Employee Activities Tracker version 2.0
   * Displaying Chart in a UserForm
   * Dynamic Gantt Chart
 * DAX
   * Introducing DAX 
   * DAX operators
   * DAX Syntax
   * Parameter-Naming Conventions
   * Filter Context
   * DAX Functions
 * Blog Posts
   * AllCharts & VisualizationTips & TricksTools and Trackers
     
     
     DEVELOP SURVEY OR FEEDBACK FORM IN EXCEL AND VBA
     
     
     VBA TO SEND EMAIL FROM EXCEL WITH ATTACHMENT AND IMAGE IN…
     
     
     HOW TO GET THE SAME PERIOD LAST YEAR TO DATE IN…
     
     
     SHAREPOINT LIST
     
     
     
 * About Us
 * Contact Us


Trending Now


DEVELOP SURVEY OR FEEDBACK FORM IN EXCEL AND VBA


VBA TO SEND EMAIL FROM EXCEL WITH ATTACHMENT AND IMAGE IN MAIL BODY


HOW TO GET THE SAME PERIOD LAST YEAR TO DATE IN POWER BI


SHAREPOINT LIST


DEFINITIVE GUIDE TO ADO IN EXCEL AND VBA




DEVELOP SURVEY OR FEEDBACK FORM IN EXCEL AND VBA

TheDataLabs - Modified date: December 28, 2022


VBA TO SEND EMAIL FROM EXCEL WITH ATTACHMENT AND IMAGE IN MAIL BODY

TheDataLabs - Modified date: September 18, 2022


HOW TO GET THE SAME PERIOD LAST YEAR TO DATE IN POWER BI

TheDataLabs - Modified date: September 5, 2022


SHAREPOINT LIST


DEFINITIVE GUIDE TO ADO IN EXCEL AND VBA


MICROSOFT SHAREPOINT


UNDERSTANDING FILTER FUNCTION IN EXCEL



TRENDING ARTICLES

 * All
 * Blog Posts
 * Charts & Visualization
 * Tips & Tricks
 * Tools and Trackers

More


FULLY AUTOMATED DATA ENTRY USERFORM

TheDataLabs - December 1, 2019 32
In this tutorial, we will learn how to create data entry form based on User Form
in Excel. We will utilize the Excel sheet as database and User Form to enter the
data and transfer it to Database sheet.


AUTOMATED DATA ENTRY FORM – GOOGLE SHEET

TheDataLabs - March 14, 2021 1
Google provides a default data entry form that is a Google Form. It can be
utilized for a basic data entry job. When it comes to complex and large scale of
data entry works, it is always preferable to develop an Automated Data Entry
Form to make the task user friendly and improve accuracy & speed.


ADVANCE DATA ENTRY FORM

December 1, 2019


DATA ENTRY FORM

April 23, 2019


AUTOMATED STUDENT’S REGISTRATION FORM IN EXCEL AND VBA

February 18, 2020


AUTOMATED NSE OPTION CHAIN DATA EXTRACTOR

May 24, 2020


Search

FOLLOW US


151FansLike


42FollowersFollow

31,300SubscribersSubscribe

SUBSCRIBE TO OUR NEWSLETTER

First Name

Email address

I have read and agree to the privacy policy.



Leave this field empty if you're human:



LATEST ARTICLES

 * All
 * Blog Posts
 * Charts & Visualization
 * Tips & Tricks
 * Tools and Trackers

More


DEVELOP SURVEY OR FEEDBACK FORM IN EXCEL AND VBA

TheDataLabs - Modified date: December 28, 2022
0

https://youtu.be/Xkn1ywJTA7Y How to develop customer survey/feedback form in
Microsoft Excel and VBA? Survey or Feedback form helps business to know what
their customer think about their business and services. With the help of
feedback...
Read more



VBA TO SEND EMAIL FROM EXCEL WITH ATTACHMENT AND IMAGE IN MAIL BODY

TheDataLabs - Modified date: September 18, 2022
0

VBA to Send Email from Excel with Attachment and Image in Mail Body Create Excel
file and design the ‘Home’ page and user email list table Open VBA window and
insert blank module Write VBA code to send automated emails Attach an Excel file
to the email Show image in mail body without losing the reference (using content
id) HTML to create the mail body
Read more



HOW TO GET THE SAME PERIOD LAST YEAR TO DATE IN POWER BI

TheDataLabs - Modified date: September 5, 2022
0

Microsoft Power BI has an inbuilt Time Intelligence function,
SAMEPERIODLASTYEAR, to return a table that contains a column of dates shifted
one year back in time from the dates in the specified dates column, in the
current context. But this function has some limitations and does not return the
exact date range in some scenarios. In this post, we will discuss the limitation
and find the solution so that this Time Intelligence function can return the
date range accurately to calculate the performance metrics.

Read more


SHAREPOINT LIST

TheDataLabs - Modified date: August 28, 2022
0

A SharePoint list is simply a collection of information and data like Excel
spreadsheet or MS Access table. It has rows and columns to organize the data. We
can filter and sort the data same as Excel table. For example, you can create a
SharePoint list to store the employee information like the first name, last
name, email address, etc., SharePoint list can also be used to add attachments
to a particular record.
Read more

Watch Our YouTube Tutorials
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
35:41
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
35:41

How to Create a Data Entry Form in Excel (Step-by-step Guide)
01:25:36

Creating Dynamic Calendar in Worksheet (No Macro) - Simple and Easy
17:36

How to make Macro enabled Form in Excel Sheet?
17:49


ARCHIEVES


KEYBOARD SHORTCUTS

TheDataLabs - April 2, 2019 0
Using Excel Keyboard shortcut keys is the best best way to increase your
productivity. You can save valuable time while performing tasks on MS Excel.
Using the mouse to do all the tasks reduces your productivity. Hence, we will
recommend you to use Excel Shortcuts rather than mouse. In this page, we are
providing the list of Excel Keyboard Shortcuts so that you can refer it and
start using them in your day-to-day activities while working on Microsoft Excel.


CALCULATING CHANGE %

TheDataLabs - April 3, 2019 1
Calculating Change % By saying change %tage – we essentially mean that the
percentage of increase or decrease of a number from its original value to a new
value. To calculate the increase percentage: First: get the difference
(increase) between the two numbers you are comparing. Then: divide
the increase by the original number and multiply the answer by 100. If your
answer is a negative number, then this is a percentage decrease. Calculating
Change % in MS Excel Let’s understand how to calculate this in MS Excel. Suppose
we have a number ‘X’ which has changed to a new value called ‘Y’, then the
change % would be calculated as under:


COMMON CHARTS AND USAGE

TheDataLabs - April 8, 2019 0
What Are Common Chart Types and Where to Use Them? Charts provide a
visual representation of your data, making it easier to analyze.  In this below
post, we will learn about some basic common charts and where to use them. LINE
GRAPH A line chart or line graph is a type of chart which displays information
as a series of data points called 'markers' connected by straight line segments.
It is a basic type of chart common in many fields. It is similar to a scatter
plot except that the measurement points are ordered (typically by their x-axis
value) and joined with straight line segments. A line chart is often used to
visualize a trend in data over intervals of time – a time series – thus the line
is often drawn chronologically. In these cases they are known as run charts.
Line graphs are used to track changes over short and long periods of time. When
smaller changes exist, line graphs are better to use than bar graphs. Line
graphs can also be used to compare changes over the same period of time for more
than one group.


ABOUT DASHBOARD

TheDataLabs - April 15, 2019 0
About Dashboard The term dashboard originates from the automobile dashboard
where drivers monitor the major functions at a glance via the instrument
cluster. It provides all the critical information needed to operate the vehicle
at a glance. In the same way, if we talk about BI Dashboard then we refer a
single-screen display where all the required visuals and performance graphs are
available so that management can get the key information related to the business
performance and take the decisions.


WHAT IS DASHBOARD

TheDataLabs - April 15, 2019 0
The term dashboard originates from the automobile dashboard where drivers
monitor the major functions at a glance via the instrument cluster. It provides
all the critical information needed to operate the vehicle at a glance. In the
same way, if we talk about BI Dashboard then we refer a single-screen display
where all the required visuals and performance graphs are available so that
management can get the key information about the business performance and take
the decisions. Let’s go through the proper definition and usage of Dashboard.


FILTER CONTEXT

TheDataLabs - April 17, 2019 0
Understanding Evaluation Context in DAX In simple language, we can say that the
context is the “environment” under which the formula is evaluated. You can think
of the evaluation context of a formula as the surrounding area of the cell where
DAX evaluates the formula. Context plays an important role in DAX and it enables
you to perform dynamic analysis, in which the results of a formula can change to
reflect the current row or cell selection and also any related data.
Understanding context and using context effectively are very important for
building high-performing formulas, dynamic analysis, and for troubleshooting
problems in formulas.


ANNUAL LEAVE TRACKER

TheDataLabs - April 19, 2019 0
Business & Annual Leave Tracker Business & Annual Leave Tracker is Excel based
an automated tool to track and generate leave reports for a team or a function.
This tracker is fully customizable and you can make the changes according to
your business required. It supports 15 employees and 4 types of leaves. It's
totally dynamic in nature and you can change the Holidays list, Weekend details,
Employee names and Leave types as per your requirement. It's generate automatic
report which shows all the dates against Leave type, Employee name and month.


USING ANNUAL LEAVE TRACKER

TheDataLabs - April 19, 2019 0
How to use Business & Annual Leave Tracker? How to use Business & Annual Leave
Tracker? In previous article, we discussed about Business & Annual Leave Tracker
and how to customize the same as per your business requirement. In this post, we
will focus on how to use this tool, apply leave and generate reports. The usage
of this tool has been divided into three different functionalities: 1. Plan 2.
Summary 3. Database On 'Home' sheet, you will find the below mentioned User
Interface where there are three different buttons (Plan, Summary and Database).


DOWNLOAD LEAVE TRACKER

TheDataLabs - April 19, 2019 0
Business & Annual Leave Tracker version 1.0 Please click on below button to
download the Business & Annual Leave Tracker version 1.o. Don't forget to
provide your feedback and subscribe our YouTube Channel. Thanks!


3D INFOGRAPHICS

TheDataLabs - April 20, 2019 0
3D Infographics  Column Chart  3D infographics are the most popular creative
trends to remain in the mainstream this year. Among all other charts and
visualization design trends in 2019, this particular design concept is
increasingly becoming the benchmark today and companies are using these
visualization to represents the numbers in Dashboard and Reports. Dashboard
designers are continuously exploring modern ideas to meet the needs of their
target audience. As Infographics has both the visual and textual elements, it
convey the strong message to audience and leave the good impact due to beautiful
design of charts.


5 COMMON EXCEL ISSUES & FIXES

TheDataLabs - April 21, 2019 0
Top 5 Common Excel Issues & Fixes #1. Enabling Fill Handle & Cell Drag-And-Drop
Excel’s Fill Handle is an extremely useful and flexible tool. It can fill or
extend a series of numbers, dates or text to the desired number of cells
instantly.


PROGRESSIVE DOUGHNUT CHART

TheDataLabs - April 21, 2019 0
Progressive Doughnut Chart in Excel This is Animated Progressive Doughnut Chart
made in Excel. This has conditional formatting where it's changing the color of
Doughnut and Labels basis the Sales% entered by user. The condition is if Sales%
is >=80% then Green, if sales%>=70% and <80% then color will be Amber and if
Sales% will be <70% then color will be Red.


3D GLASS FILL INFOGRAPHICS

TheDataLabs - April 23, 2019 0
Dynamic 3D Glass Fill Infographics In this post, we will learn how to create
Dynamic 3D Glass Fill Infographics in Excel. This is very beautiful chart and
you can use it in dashboard and reports to present the performance% against the
target. This is one of the best substitute of 100% Stacked Column and Target vs.
Actual chart in Excel.


DATA ENTRY FORM

TheDataLabs - April 23, 2019 2
How to Make Macro Enabled Form in Excel Sheet In this post, we will discuss
about an automated data entry form developed in Excel and VBA. This is simple
form to demonstrate how can you transfer the data from a form to a worksheet.
Using the same type of code and techniques, you can develop a complex form to
transfer and collate the data in a Excel Sheet.


UNDERSTANDING SHRINKAGE AND CALCULATION

TheDataLabs - April 24, 2019 0
What is Shrinkage and how to calculate it in a BPO industry? Shrinkage can be
defined as the time for which people are paid but not available to handle calls
or perform their task.  In a broader way, we can say that shrinkage is every
activity that keeps an agent off the phone for a certain time or day(s). This
would include his/her leaves & holidays entitlement, offline activities
(training, meeting, coaching etc.), breaks, outbound calling (if any). There are
two types of shrinkage in BPO – Planned Shrinkage Unplanned Shrinkage



RECENT POSTS

 * Develop Survey or Feedback Form in Excel and VBA
 * VBA to Send Email from Excel with Attachment and Image in Mail Body
 * How to get the Same Period Last Year to Date in Power BI
 * SharePoint List
 * Definitive Guide To ADO in Excel and VBA

ARCHIVES

 * December 2022 (1)
 * September 2022 (2)
 * August 2022 (4)
 * June 2022 (1)
 * May 2022 (2)
 * December 2021 (1)
 * October 2021 (2)
 * September 2021 (2)
 * August 2021 (1)
 * June 2021 (3)
 * March 2021 (1)
 * February 2021 (1)
 * January 2021 (6)
 * November 2020 (21)
 * October 2020 (1)
 * August 2020 (3)
 * July 2020 (2)
 * June 2020 (1)
 * May 2020 (6)
 * April 2020 (2)
 * February 2020 (2)
 * January 2020 (3)
 * December 2019 (13)
 * November 2019 (1)
 * April 2019 (18)

 * Blog Posts71
 * Tools and Trackers36
 * Charts & Visualization8
 * Tips & Tricks6

ABOUT US
We are a small team of experts in MS Excel, VBA, Power BI, Data Visualization
and Automation.
Contact us: info@thedatalabs.org
FOLLOW US
© 2016-2023 TheDataLabs - Privacy Policy | Terms and Conditions



ADBLOCK DETECTED!

×

PLEASE DISABLE ADBLOCK FOR THIS SITE.








Sumo