Sign in to confirm you’re not a bot
This helps protect our community. Learn more
Simon Sez IT Membership
$15.00
Subscribe to Simon Sez IT | 50% Off - $15 per Month Boost Your Skills with Training that Makes Learning Software Simple. From Excel and data analysis to cyber security, Adobe Photoshop and Artificial Intelligence. Get training from the experts at Simon Sez IT and give your career a boost.Subscribe for just $15/month
Unisex garment-dyed heavyweight t-shirt XL
$25.00
If you’re looking for a thick, structured tee that’s also super soft and breathable—look no further! The unisex garment-dyed heavyweight t-shirt ticks all the boxes and is made of 100% ring-spun cotton. The regular t-shirt style will complement most looks and fit you to a tee. • 100% ring-spun cotton • Fabric weight: 6.1 oz/yd² (206.8 g/m²) • Garment-dyed • Relaxed fit • 7/8′′ double-needle topstitched collar • Twill-taped neck and shoulders for extra durability • Double-needle armhole, sleeve, and bottom hems • Blank product sourced from Honduras This product is made especially for you as soon as you place an order, which is why it takes us a bit longer to deliver it to you. Making products on demand instead of in bulk helps reduce overproduction, so thank you for making thoughtful purchasing decisions!Size guide WIDTH (inches) LENGTH (inches) SLEEVE CENTER BACK (inches) S 18¼ 26 ⅝ 16¼ M 20¼ 28 17¾ L 22 29⅜ 19 XL 24 30¾ 20½ 2XL 26 31 ⅝ 21¾ 3XL 27¾ 32½ 23¼ 4XL 29¾ 33½ 24 ⅝ WIDTH (cm) LENGTH (cm) SLEEVE CENTER BACK (cm) S 46.4 67.6 41.3 M 51.4 71.1 45 L 55.9 74.6 48.3 XL 61 78.1 52 2XL 66 80.3 55.3 3XL 70.5 82.6 59 4XL 75.6 85 62.6
Unisex Hoodie L
$40.00
Who knew that the softest hoodie you'll ever own comes with such a cool design. You won't regret buying this classic streetwear piece of apparel with a convenient pouch pocket and warm hood for chilly evenings. • 100% cotton face • 65% ring-spun cotton, 35% polyester • Front pouch pocket • Self-fabric patch on the back • Matching flat drawstrings • 3-panel hood • Blank product sourced from Pakistan Disclaimer: This hoodie runs small. For the perfect fit, we recommend ordering one size larger than your usual size. This product is made especially for you as soon as you place an order, which is why it takes us a bit longer to deliver it to you. Making products on demand instead of in bulk helps reduce overproduction, so thank you for making thoughtful purchasing decisions!Size guide CHEST WIDTH (inches) LENGTH (inches) S 20 27 M 21 28 L 23 29 XL 25 30 2XL 26½ 31 3XL 28 32 CHEST WIDTH (cm) LENGTH (cm) S 50.8 68.6 M 53.3 71.1 L 58.4 73.7 XL 63.5 76.2 2XL 67.3 78.7 3XL 71.1 81.3
Hardcover bound notebook Black
$15.00
Whether crafting a masterpiece or brainstorming the next big idea, this notebook will inspire your inner wordsmith. The product features 80 lined, cream-colored pages, a built-in elastic closure, and a matching ribbon page marker. Plus, the expandable inner pocket is perfect for storing loose notes and business cards, so you’ll never lose track of important information. • Cover material: UltraHyde hardcover paper • Size: 5.5" × 8.5" (13.97 cm × 21.59 cm) • Weight: 10.9 oz (309 g) • 80 pages of lined, cream-colored paper • Matching elastic closure and ribbon marker • Expandable inner pocket
White glossy mug
$8.00
Whether you're drinking your morning coffee, evening tea, or something in between—this mug's for you! It's sturdy and glossy with a vivid print that'll withstand the microwave and dishwasher. • Ceramic • 11 oz mug dimensions: 3.8′′ (9.6 cm) in height, 3.2′′ (8.2 cm) in diameter • 15 oz mug dimensions: 4.7′′ (11.9 cm) in height, 3.3′′ (8.5 cm) in diameter • 20 oz mug dimensions: 4.3′′ (10.9 cm) in height, 3.7′′ (9.3 cm) in diameter • Lead and BPA-free material • Dishwasher and microwave safe

Prerequisites of the Course and Version of Excel

0:00

Course Structure

8:47

Functions - Part 1 (Start here to skip the introduction)

13:50

Autosum

29:35

Functions - Part 2

35:52

How Date and Time Works

46:36

Basic Date and Time Functions

57:57

Complex Date and Time Functions

1:09:53

Using Text Functions - Part 1

1:24:39

Using Text Functions - Part 2

1:39:16

Using Logical Functions

1:54:24

Exercise 01

2:05:38

HLOOKUP Function

2:07:58

VLOOKUP Function

2:23:16

Exercise 02

2:32:12

Financial Functions and Terminology (PMT Function)

2:38:19

Personal Financial Functions (FV Function, DATE Function, DATEDIF Function, RRI Function, PDURATION Function)

2:49:40

Professional Financial Functions (PPMT Function, IPMT Function)

3:00:21

Depreciation (SLN Function)

3:08:10

Exercise 03

3:13:24

Statistical Functions for Description - Part 1 (MIN Function, MAX Function, AVERAGE Function, MODE.MULT Function, AVERAGEIF Function)

3:15:10

Statistical Functions for Description - Part 2 (QUARTILE.INC Function, QUARTILE.EXC Function, STDEV.P Function)

3:29:24

Statistical Functions for Forecasting - Part 1 (SLOPE Function, FORECAST.LINEAR Function, TREND Function)

3:44:00

Statistical Functions for Forecasting - Part 2 (LINEST Function)

3:56:18

Exercise 04

4:08:45

One Click Forecasting

4:10:30

Statistical Functions for Inference

4:19:46
Advanced Excel Tutorial: Advanced Functions Course (VLOOKUP, IF, Forecasting, Statistical)
4KLikes
239,555Views
2020Mar 9
During this epic 4 hour, 32 minute, advanced Excel training we look at some of the advanced Excel formulas and advanced Excel functions, including the IF statement and VLOOKUP in Excel. This Excel course assumes you already know how to use Microsoft Excel to a good standard and it teaches you how to take your spreadsheeting skills to the next level. This course has a full introduction. If you don't wish to watch the introduction, then skip to 0:13:50 which is where the content starts. 🔥This tutorial is an extract from our full Advanced Excel 2019 course, available here 👉https://bit.ly/3iVdBHg 📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead! 0:00:00 - Prerequisites of the Course and Version of Excel 0:08:47 - Course Structure 0:13:50 - Functions - Part 1 (Start here to skip the introduction) 0:29:35 - Autosum 0:35:52 - Functions - Part 2 0:46:36 - How Date and Time Works 0:57:57 - Basic Date and Time Functions 1:09:53 - Complex Date and Time Functions 1:24:39 - Using Text Functions - Part 1 1:39:16 - Using Text Functions - Part 2 1:54:24 - Using Logical Functions 2:05:38 - Exercise 01 2:07:58 - HLOOKUP Function 2:23:16 - VLOOKUP Function 2:32:12 - Exercise 02 2:38:19 - Financial Functions and Terminology (PMT Function) 2:49:40 - Personal Financial Functions (FV Function, DATE Function, DATEDIF Function, RRI Function, PDURATION Function) 3:00:21 - Professional Financial Functions (PPMT Function, IPMT Function) 3:08:10 - Depreciation (SLN Function) 3:13:24 - Exercise 03 3:15:10 - Statistical Functions for Description - Part 1 (MIN Function, MAX Function, AVERAGE Function, MODE.MULT Function, AVERAGEIF Function) 3:29:24 - Statistical Functions for Description - Part 2 (QUARTILE.INC Function, QUARTILE.EXC Function, STDEV.P Function) 3:44:00 - Statistical Functions for Forecasting - Part 1 (SLOPE Function, FORECAST.LINEAR Function, TREND Function) 3:56:18 - Statistical Functions for Forecasting - Part 2 (LINEST Function) 4:08:45 - Exercise 04 4:10:30 - One Click Forecasting 4:19:46 - Statistical Functions for Inference Note, this video was recording using Excel 2016, but much of what is shown is still relevant in Excel 2013, 2019, and Office 365 versions of the Excel software. 🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ https://www.simonsezit.com/courses/ 🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ https://www.simonsezit.com/ssit-first... 💻 Watch more free popular training tutorials from Simon Sez IT: 🔥Check out our FREE 300+ hour training course playlist here ➡️    • Simon Sez IT Long Training Courses   ✅ Check out our free video playlist for Excel beginners 👉   • Microsoft Excel Beginner's Training Tutorials   ✅ Excel 2021 Tutorials for Intermediate Users here 👉   • Excel 2021 Tutorials for Intermediate Users   ✅ Microsoft Excel Tips and Tricks 👉   • Microsoft Excel Tips and Tricks   ✅ Microsoft Office 2021 and Office 365 Training here 👉   • Microsoft Office 2021 and Office 365 Train...   💬Stay in touch! SimonSezIT.com: https://www.SimonSezIT.com/ LinkedIn:   / simon-sez-it   FaceBook:   / simonsezit   🔔 Subscribe to our channel: https://www.youtube.com/simonsezittra... If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
5 lessons
Excel Formulas and Functions Course: Beginners to Advanced
Simon Sez IT

Course progress

0 of 5 lessons complete

Simon Sez IT

676K subscribers