How to Calculate YTD (Year to Date) Values in Excel using the SCAN function

Leila Gharani November 13, 2021
Video Thumbnail
Leila Gharani Logo

Leila Gharani

View Channel

About

Excel. Power Query. Copilot. ChatGPT. Power BI. PowerPoint. You use them every day to automate Excel and your work - so why not actually master them? I’ll show you how to: ✔️Automate the stuff that drives you nuts ✔️ Spend less time on grunt work, more time on wow work ✔️ Build reports that look good AND actually make sense What You’ll Learn Here: ✔️ Excel, Power BI, PowerPoint, VBA, Google Sheets & more ✔️ AI-powered Excel & the future of work ✔️ Data & finance skills that give you an edge I don’t just teach this stuff - I use it daily. My goal? To help you think differently about the tools you already have, so you can work faster, and with confidence. 🎓 My background: MA in economics / Economist / Business Consultant / Accounting Systems Expert / Oracle & SAP implementations (for Finance) / Teacher & Microsoft MVP 💡 400,000+ professionals have taken my courses at XelPlus - because working smarter just makes sense. Join here 👉 https://www.xelplus.com/courses/

You May Also Like

Can't-Miss iPhone Accessories

AI-recommended products based on this video

Loading...
DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

FNTCASE for iPhone 12 Case: iPhone 12 Pro Case Clear Slim Shockproof Cell Phone Protective Cover | Anti Yellowing Scratch Proof Drop Proof Tough 5G Mobile Phone Protection Bumper 6.1 inch Global Recycled Standard

(2,171)
$7.19
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

(2,806)
$12.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Yarxiawin Phone Case for Samsung S25 Case with Ring Stand Magnetic Compatible with Magsafe Wireless Charger, Pink Bumper Cover Samsung Galaxy S25 Case Clear Shockproof (Blue)

Yarxiawin Phone Case for Samsung S25 Case with Ring Stand Magnetic Compatible with Magsafe Wireless Charger, Pink Bumper Cover Samsung Galaxy S25 Case Clear Shockproof (Blue)

(0)
$20.23
FREE delivery Sat, Jun 14 on your first order
Loading...
AsperX for Magsafe Power Bank, 10000mAh Wireless Magnetic Power Bank, 22.5W Wire Fast Charging Portable Charger with USB C Cable, LCD Display for Magsafe Battery Pack for iPhone 16/15/14/13/12

AsperX for Magsafe Power Bank, 10000mAh Wireless Magnetic Power Bank, 22.5W Wire Fast Charging Portable Charger with USB C Cable, LCD Display for Magsafe Battery Pack for iPhone 16/15/14/13/12

(895)
$37.98
FREE delivery Sat, Sep 20
400+ bought in past month
Loading...
Wireless Charging Case for AirPods Pro 1st / 2nd Gen with Type-C Charging Port, Compatible with AirPod Pro 2nd Generation Replacement Case, with Blue-Tooth Sync Button, No Earbuds

Wireless Charging Case for AirPods Pro 1st / 2nd Gen with Type-C Charging Port, Compatible with AirPod Pro 2nd Generation Replacement Case, with Blue-Tooth Sync Button, No Earbuds

(15)
$42.98
PrimeFREE delivery Sat, Jun 14
Loading...
Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White
Best Seller

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

(9,766)
$9.89
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

(26,678)
$259.99$194.99
FREE delivery Wed, Aug 20
5K+ bought in past month
Loading...
Wireless Charger, 3 in 1 Charging Station, Fast Charging Station Foldable Charging Stand, Wireless Charging Station for Multiple Devices, Compatible with lPhone 17/16/15/14/13 Pro Max Airpods Watch

Wireless Charger, 3 in 1 Charging Station, Fast Charging Station Foldable Charging Stand, Wireless Charging Station for Multiple Devices, Compatible with lPhone 17/16/15/14/13 Pro Max Airpods Watch

(156)
$25.64
FREE delivery Wed, Dec 24 on your first order
3K+ bought in past month
Loading...
Kaiess 62" Tripod for iPhone, Selfie Stick Tripod & Phone Tripod Stand with Remote, Cell Phone Tripod for iPhone, Extendable Travel Tripod Compatible with iPhone 14/13/12 Pro Max/Android
Best Seller

Kaiess 62" Tripod for iPhone, Selfie Stick Tripod & Phone Tripod Stand with Remote, Cell Phone Tripod for iPhone, Extendable Travel Tripod Compatible with iPhone 14/13/12 Pro Max/Android

(5,298)
$28.98
FREE delivery Sat, Jun 14 on your first order
1K+ bought in past month
Loading...
EUCOS 62" Phone Tripod, Tripod for iPhone & Selfie Stick Tripod with Remote, Extendable Phone Tripod Stand & Travel Tripod, Solidest Cell Phone Tripod Compatible with iPhone/Android

EUCOS 62" Phone Tripod, Tripod for iPhone & Selfie Stick Tripod with Remote, Extendable Phone Tripod Stand & Travel Tripod, Solidest Cell Phone Tripod Compatible with iPhone/Android

(13,783)
$28.99
Prime
5K+ bought in past month
Loading...
NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

NEEWER Advanced 18 inch LED Ring Light for Phone, LCD Touch Screen, 2.4G Remote Lights Control, 3200-5600K, Tripod Light for iPhone Action Camera, for Studio Makeup TikTok YouTube Video Salon (Black)

(2,807)
$181.49
FREE delivery Sun, Aug 10
Loading...
Phone Mount for Tripod, Adjustable Phone Tripod Mount with Cold Shoe & Arca Swiss Quick Release Plate,Universal Adjustable Clamp Suitable for iPhone 14 pro/13 Pro/12/11/Samsung

Phone Mount for Tripod, Adjustable Phone Tripod Mount with Cold Shoe & Arca Swiss Quick Release Plate,Universal Adjustable Clamp Suitable for iPhone 14 pro/13 Pro/12/11/Samsung

(394)
$48.12$43.08
FREE delivery Jun 18 - 20
Loading...
ESR Camera Lens Protector for iPhone 16/16 Plus, Tough HD Individual Protectors, Scratch Resistant, Ultra-thin Tempered Glass, Armorite Series, 1 Pack, Clear

ESR Camera Lens Protector for iPhone 16/16 Plus, Tough HD Individual Protectors, Scratch Resistant, Ultra-thin Tempered Glass, Armorite Series, 1 Pack, Clear

(3,839)
$7.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
Ailun 3 Pack Screen Protector for iPhone 14[6.1 inch] + 3 Pack Camera Lens Protector,Case Friendly Tempered Glass Film,[9H Hardness] - HD

Ailun 3 Pack Screen Protector for iPhone 14[6.1 inch] + 3 Pack Camera Lens Protector,Case Friendly Tempered Glass Film,[9H Hardness] - HD

(213,275)
$10.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Ailun 3 Pack Screen Protector for iPhone 17 [6.3 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

Ailun 3 Pack Screen Protector for iPhone 17 [6.3 inch] + 3 Pack Camera Lens Protector with Installation Frame,Sensor Protection,Dynamic Island Compatible,Case Friendly Tempered Glass Film

(216,515)
$9.67
Prime
2K+ bought in past month
Loading...
[2+2] LK 2 Pack Compatible for iPhone 16 Screen Protector + 2 Pack Camera Lens Protector, Tempered Glass Film, Ultra HD, 9H Hardness, Bubble Free, Easy Installation, Case Friendly

[2+2] LK 2 Pack Compatible for iPhone 16 Screen Protector + 2 Pack Camera Lens Protector, Tempered Glass Film, Ultra HD, 9H Hardness, Bubble Free, Easy Installation, Case Friendly

(66,622)
$13.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

2 Pack Magnetic Wireless Charger 15W Fast Mag-Safe Charger Stand Compatible with iPhone 16/15/14/13/12 Series Wireless Charging Pad for AirPods 3/2/Pro 2/Pro White Portable Mag Safe Kickstand

(31)
$24.69
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

Magnetic Wireless Charger for iPhone: Fodable 3 in 1 Charging Station for Multiple Apple Devices - Travel Charging Pad Dock for Apple Watch iPhone 16 15 14 13 12 Pro Max Plus & Airpod Global Recycled Standard

(656)
$49.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White

Wireless Earbuds, 2025 Bluetooth 5.4 Bass Stereo Headphones with 4 ENC Mic, 48H Playback Ear Buds with Charging Case LED Display,Sport Earphones IPX7 Waterproof for Phone, Android, Pad, White

(38)
$27.99
Prime
Loading...
AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 16 Pro Max with Vent Clip Hand Free Cell Phone Car Mount for iPhone 16 Plus Samsung S25 Ultra Car Accesorries

AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 16 Pro Max with Vent Clip Hand Free Cell Phone Car Mount for iPhone 16 Plus Samsung S25 Ultra Car Accesorries

(29,179)
$19.99$18.17
FREE delivery Tue, Jun 17 on your first order
2K+ bought in past month
Loading...
Miracase Phone Holders for Your Car, Multifunctional Car Phone Holder with Suction Cup Base, Hands Free Universal Cell Phone Car Mount, Automobile Phone Mount Car for iPhone Android Smartphones(Base)
Best Seller

Miracase Phone Holders for Your Car, Multifunctional Car Phone Holder with Suction Cup Base, Hands Free Universal Cell Phone Car Mount, Automobile Phone Mount Car for iPhone Android Smartphones(Base)

(11,031)
$21.99
FREE delivery Tue, Jun 17 on your first order
2K+ bought in past month
Loading...
Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

(128)
$21.99
FREE delivery Tue, Jun 17 on your first order
Loading...
Miracase Car Phone Mount, [2025 Upgraded Strong Military Grade Suction Cup] Long Arm Phone Holder for Car Dashboard Windshield Vent, Hands Free Cell Phone Holder Compatible with All Mobile Phones Global Recycled Standard

Miracase Car Phone Mount, [2025 Upgraded Strong Military Grade Suction Cup] Long Arm Phone Holder for Car Dashboard Windshield Vent, Hands Free Cell Phone Holder Compatible with All Mobile Phones Global Recycled Standard

(39,711)
$22.49
FREE delivery Sat, Sep 20 on your first order
4K+ bought in past month
Loading...
FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

FNTCASE for iPhone 12 Clear Case: for iPhone 12 Pro Case Magnetic Military Grade Drop Protection Anti Yellowing Cell Phone Cover - Rugged Durable Shockproof Protective Bumper (Clear) Global Recycled Standard

(2,806)
$12.99
FREE delivery Sat, Sep 20 on your first order
500+ bought in past month
Loading...
Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

Phone Case for iPhone 12 Pro Max Case Compatible with MagSafe, YUANDMI Case for iPhone 12 Pro Max Magnetic Slim Thin Translucent Matte Back Shockproof Anti-Yellow Protective Cover Case Black

(130)
$12.99
FREE delivery Sat, Jun 14 on your first order
Loading...
FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

FNTCASE for iPhone 12 Pro Case: iPhone Magnetic Military Grade Drop Protection Clear Cell Phone Case - Rugged Durable Shockproof Anti Yellowing Slim Cases for iPhone 12 Pro (Clear)

(81)
$9.99
FREE delivery Sat, Jun 14 on your first order
50+ bought in past month
Loading...
DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

DUEDUE for iPhone 12 Case iPhone 12 Pro Case Liquid Silicone Slim Cover with Microfiber Lining Shockproof Protective Case for iPhone 12/12 Pro 6.1 inch Light Purple

(1,577)
$12.99
FREE delivery Sat, Jun 14 on your first order
100+ bought in past month
Loading...
LISEN Retractable Car Charger, 69W USB C Car Accessories Adapter Fast Charging, Gifts Christmas for Women Men, Travel Essentials for Truck Ford Bronco Honda Dodge, for iPhone 17 Air 16 Pro Max

LISEN Retractable Car Charger, 69W USB C Car Accessories Adapter Fast Charging, Gifts Christmas for Women Men, Travel Essentials for Truck Ford Bronco Honda Dodge, for iPhone 17 Air 16 Pro Max

(10,786)
$26.99
Prime
1K+ bought in past month
Loading...
USB C Fast Wall Charger for iPhone/iPad, 20W Type C Power Adapter Fast Charging Block for iPhone 16/16e/16 Plus/16 Pro/16 Pro Max/15/14/13/12/11/XS/XR/X/8 Plus, iPad Pro/Air/Mini, Pixel 9, Galaxy S25

USB C Fast Wall Charger for iPhone/iPad, 20W Type C Power Adapter Fast Charging Block for iPhone 16/16e/16 Plus/16 Pro/16 Pro Max/15/14/13/12/11/XS/XR/X/8 Plus, iPad Pro/Air/Mini, Pixel 9, Galaxy S25

(503)
$9.78
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
USB C Charger Block, 40W Dual USB C Wall Charger PD+QC USB Wall Plug Multiport Type C Power Adapter Fast Charging Block for iPhone 15 14 13 12 iPad Galaxy S23 S22 Pixel LG Tablet Android

USB C Charger Block, 40W Dual USB C Wall Charger PD+QC USB Wall Plug Multiport Type C Power Adapter Fast Charging Block for iPhone 15 14 13 12 iPad Galaxy S23 S22 Pixel LG Tablet Android

(9,415)
$15.99
FREE delivery Sat, Sep 20 on your first order
5K+ bought in past month
Loading...
65W 45W USB C Laptop Charger Compatible with Dell Latitude 5420 5430 5520 5530 7340 7430 Inspiron 14 16 XPS 13 Chromebook 3100 Dell Computer Type C Fast Charging AC Adapter Power Cord

65W 45W USB C Laptop Charger Compatible with Dell Latitude 5420 5430 5520 5530 7340 7430 Inspiron 14 16 XPS 13 Chromebook 3100 Dell Computer Type C Fast Charging AC Adapter Power Cord

(7)
$19.99
FREE delivery Sun, Aug 24 on your first order
Loading...
Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

Hand Warmers 2 Pack, 14000mAh Rechargeable Hand Warmers, Electric Hand Warmer Reusable, Portable Power Bank USB Hand Warmers 4 Levels 8 Heating, Gifts for Raynauds Ski Golf Camping

(683)
$74.08$59.47
FREE delivery Jun 13 - 18
Loading...
Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

Hand Warmers Rechargeable, 10000mAh Electric Heated Gloves Power Bank Portable Graphene Handwarmers Pouch with 3 Levels & Double-Sided Heating for Hunting Camping Golf Xmas Gifts for Women Men Kids

(651)
$44.99
PrimeFREE delivery Sun, Jun 15
Loading...
2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping
Amazon's Choice

2Pack Rechargeable Hand Warmer, 8000mAh Electric Hand Warmer Power Bank, Portable USB-C Hand Warmer for Pocket, Reusable Hand Warmer Up to 8 hrs Each, Warm Gift for Men Women, for Hunting, Camping

(1,128)
$15.99
FREE delivery Sat, Jun 14 on your first order
Loading...
GTOCE Portable Charger,40000mAh Power Bank with 22.5W Fast Charging LED Digital Display Battery Pack with 6 Outputs 2 Inputs, Type C Powerbank Portable Charger for iPhone 16 pro Samsung AirPods,Black

GTOCE Portable Charger,40000mAh Power Bank with 22.5W Fast Charging LED Digital Display Battery Pack with 6 Outputs 2 Inputs, Type C Powerbank Portable Charger for iPhone 16 pro Samsung AirPods,Black

(334)
$42.99
FREE delivery Thu, Oct 16
1K+ bought in past month