Plus a BONUS tip on how to create date series!
In this tutorial, you'll learn how to create custom number series in Excel using Autofill, the SEQUENCE function, and the Series tool. First, we will cover how to quickly create a numbered list down columns and across rows using the mouse. Then we will dive into creating a customized number series that start at and increment by various values using the SEQUENCE function and Series tool! Plus, don't miss the BONUS tip at the end on creating date series!
📖RESOURCES
- Download the workbook and follow along: excel-dictionary.com/pages/yo...
🤓SHOP EXCEL DICTIONARY
- COURSES: excel-dictionary.com/collecti...
-GUIDES: excel-dictionary.com/collecti...
-MERCH: excel-dictionary.com/collecti...
-TEMPLATES: excel-dictionary.com/collecti...
📩NEWSLETTER
-Unlock the full potential of Excel and PowerPoint with expert tips delivered to your inbox each week: www.excel-dictionary.com/subs...
📺SUBSCRIBE
-Subscribe to never miss a video: / exceldictionary
🕰️TIMESTAMPS
‘0:00 Intro
‘0:23 Create a numbered list using Autofill - Column
‘0:51 Create a numbered list using Autofill - Row
‘1:09 Create a custom series using Autofill
‘2:01 Create a numbered list using SEQUENCE - Column
‘2:27 SEQUENCE Function Overview
‘2:59 Create a numbered list using SQUENCE - Row
‘3:14 Create a custom series using SEQUENCE
‘3:59 Create a numbered list using Series Tool - Column
‘4:51 Create a custom series using Series Tool
‘5:16 BONUS: Create date series
‘6:06 Wrap Up
#excel #exceltips #tutorial
Негізгі бет How to Create Custom Number Series in Excel (3 Methods)
Пікірлер: 5