#excelhacks

Описание: #FillSeries​ #ExcelTitips #fillseries #jobtraining #excelhacks
Hello Friends,

In this video, you will learn how to use Fill Series in Microsoft Excel. Fill Series is used to fill the series of numbers or dates quickly. Using the Series feature you can fill a continuous date series, weekday date series, Month Series or Year Series.

Download the practice file from the below link:
https://www.pk-anexcel...​

Download the Free Project Management Dashboard
https://www.pk-anexcel...​
See our Power BI Dashboard videos:
    • Power BI Tutorial  ​
Learn and download our interactive Excel dashboards free of cost-
    • Excel Dashboards  ​
Download the Calendar Control in VBA from below link
https://www.pk-anexcel...​


Download our free Excel utility Tool and improve your productivity:
https://www.pk-anexcel...​

See our Excel Products:
https://www.pk-anexcel...​

Visit to learn more:
Chart and Visualizations: https://www.pk-anexcel...​
VBA Course: https://www.pk-anexcel...​
Download useful Templates: https://www.pk-anexcel...
Dashboards: https://www.pk-anexcel...​

Watch the best info-graphics and dynamic charts from below link:
    • Dynamic Graphs  ​

Learn and free download best excel Dashboard template:
    • Excel Dashboards  ​

Learn Step by Step VBA:
    • VBA Tutorial  ​


YouTube -
   / @tech_sultanpur  

Facebook -
  / 1jdvh7okb2  

Instagram -
https://www.instagram.com/computer_tr...

https://www.instagram.com/tech_sultan...

https://www.instagram.com/ahsan_aziz_...

Telegram -
t.me/excel_specialist_007


Most people don't know How to use the fill series properly in Excel

In this video you will learn how to use Autofill option to get productive in your office place. So watch video till the end & share with your friends.

Get Free Notification for Upcoming Videos = https://forms.gle/kXmk...

Join 30-Days Excel Crash Course : https://courses.skillc...
Join Excel Course : https://skillcourse.in...

Download practice file from Skillcourse app : https://bit.ly/3BWfQVa

Attend Satish sir's Online Webinar Free: https://courses.skillc...

#autofill
#exceltricks
#exceltips
------------------------------------------------------------------------------------------------------------------------------
Learn Professional courses with Certificate
Download Course App : https://bit.ly/3BWfQVa
Course Website :https://bit.ly/skill_c...
Course Features :
✅ सभी Videos सरल हिंदी भाषा में
⬇️ Download Video in APP
✅ Basic to Advance Courses
✅ Practice Files (Yes)
✅ PDF Shortcuts
✅ Course Completion Certificate
✅ Instant Access
✅ Watch on Desktop : https://skillcourse.in/

Use Of Fill Series | Fill Series Of Dates In Excel ‪@BrainUpp‬
Use the Fill Handle
Type the initial date in the first cell.
Select the cell with the initial date and drag the fill handle (a small green square at the bottom-right corner) down or to the right.
Excel will immediately generate a series of dates in the same format as the first date that you typed manually.
Fill a column with weekdays, months or years
To create a series of workdays, months or years, do one of the following:
Fill a column with sequential dates as described above. After that, click the AutoFill Optionsbutton and pick the desired option, say Fill Months:


Fill a series of dates incrementing by N days
To auto generate a series of days, weekdays, months or years with a specific step, this is what you need to do:

How to Autofill Dates in Microsoft Excel
How to Autofill Sequential Dates
► Example: 04/04/19, 04/05/19, 04/06/19, ...

Autofilling sequential dates is easy. There are several methods, and we provide step-by-step directions for the easiest method. Then we discuss two alternative methods using different Excel functions that some might prefer to use.

Key in the beginning date in the first cell and format the cell to look as you wish.
Fill Handle
Hover the mouse over the bottom right corner of the cell until you see the Fill Handle.
With the LEFT mouse button pressed, drag along the row or column to select the cells to autofill.
Release the mouse button.

How to Autofill Dates with Any Step Value
► Example: 04/04/19, 04/07/19, 04/10/19, ...

There are three ways to autofill every "nth" date. We've listed them below from fast to slow.


Autofill Weekday Dates with Any Step Value
These instructions show how to autofill every "nth" weekday date. Excel skips all weekend dates, of course.

Key in the first date and press Enter. Then select that cell and the cells to be filled.
The next step depends on your version of Excel
In the Series Dialog box, select Weekday as the Date unit, and the step value.