Excel Helpdesk LIVE #1 - Help With Excel Beginner To Advanced

Welcome to the Excel Helpdesk - the best place to get answers to your Excel questions on the internet (in our opinion!)

💻Link to Excel download file(s)

00:00:00 Intro
00:03:20 Range vs. Cells Referencing Techniques In Excel VBA
00:19:25 Tom Joins The Stream
00:24:20 Can I Use VBA With Excel 365?
00:39:00 How To Use AND and OR functions in Excel
00:58:35 How To Use The COUNTIF Formula
01:00:15 What Should You Use For Different Jobs In Excel? Formulae? VBA? Power Query?
01:06:30 Is VBA Being Replaced By Python?
01:16:30 How To Insert Buttons Into A Spreadsheet To Trigger A Macro
01:20:40 How To Declare, Initialise and Assign Value To A Variable In Excel VBA
01:34:30 How To Build A Formula Across Sheets In Excel
01:39:10 How To Run Multiple Macros As Part Of A 'Process'
01:43:20 Tips For Working With Numbers Stored As Text In Excel

If watching before the stream, leave a comment below with a question - we will try to answer it in the live session.

After the stream, timestamps will be uploaded here to the different questions answered on the stream.

🎁A special discount for the Excel Basics Course will be offered during the stream.

Want to chat directly to Chris during the stream? We will share the link for you to join the action in you'd like to.

See you @ 1500 UK this Friday!

[henrikijonkoping]

A very successful live stream today Chris! Thanks to Bart too!

[maritzasmith]

How can you send data from an excel sheet and send an email? Can you add a button in the userform?