Excel 2021/365 Beginners & Intermediate Training: 10-Hour Excel Tutorial Class

✅ Download to follow along and complete the exercises ➡️www.simonsezit.com/excel-2021-beginner-and-intermediate-course-files/
In this Excel 2021 Beginner to Intermediate training course, go from zero to hero as we cover the basics and expand to intermediate Excel skills. We'll go over Excel logical IF functions, Excel lookup functions such as VLOOKUP and XLOOKUP, importing data into Excel, formatting, and so much more!
We've even included downloadable exercise files from our paid-for course, which means you can complete the exercises in this Microsoft Excel 2021 Tutorial and put what you are learning into practice. This will help you master the various Excel tips and tricks taught.
✅www.simonsezit.com/excel-2021-beginner-and-intermediate-course-files/
📝Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Introduction
00:00:22 - Course Intro
00:02:42 - Excel 2021 vs Excel 365
00:08:21 - Launching Excel
00:12:00 - The Start Screen
00:22:12 - Exploring the Interface
00:33:51 - Ribbons, Tabs and Menus
00:42:20 - Backstage Area
00:47:00 - Quick Access Toolbar
00:56:45 - Useful Keyboard Shortcuts
01:06:27 - Getting Help
01:13:04 - Exercise 01
01:15:27 - Working with Templates
01:24:30 - Workbooks and Worksheets
01:32:04 - Saving Workbooks
01:40:50 - Entering and Editing Data
01:50:43 - Navigating and Selecting Cells, Rows and Columns
01:58:02 - Exercise 02
02:03:22 - Formulas and Functions Explained
02:15:06 - SUM Function
02:22:44 - COUNT Function
02:30:10 - AVERAGE Function
02:34:27 - MIN and MAX Function
02:36:52 - Handling Errors in Calculations
02:45:34 - Absolute vs Relative Referencing
02:52:29 - Autosum and Autofill Options
03:02:12 - Flash Fill
03:07:15 - Exercise 03
03:12:26 - What are Named Ranges
03:21:33 - Managing Named Ranges
03:25:22 - Using Named Ranges
03:30:42 - Exercise 04
03:35:00 - Applying Number Formats
03:45:03 - Applying Date and Time Formats
03:50:41 - Formatting Cells, Rows and Columns
03:59:20 - Format Painter
04:04:00 - Exercise 05
04:08:11 - Working with Rows and Columns
04:16:36 - Deleting and Clearing Cells
04:23:02 - Aligning Text and Numbers
04:34:15 - Applying Themes and Styles
04:42:13 - Course Introduction
04:48:31 - Improve Readability with Cell Styles
04:53:30 - Controlling Data Input
05:01:49 - Adding Navigation Buttons
05:10:36 - Logical Functions
05:23:56 - The IF Function
05:29:25 - Nested IFs
05:37:24 - The IFs Function
05:43:27 - Conditional IFs
05:50:13 - Multiple Criteria
05:57:25 - Error Handling
06:03:27 - Exercise 01
06:10:56 - VLookup (Exact Match)
06:21:36 - VLookup (Approximate Match)
06:26:02 - HLookup
06:31:40 - INDEX and MATCH
06:42:09 - XLookup and XMatch
06:52:18 - OFFSET Function
07:03:10 - INDIRECT Function
07:12:17 - Exercise 02
07:17:19 - Sorting on Multiple Columns
07:24:25 - Soring Using a Custom List
07:28:00 - SORT and SORTBY Functions
07:37:49 - Advanced Filter
07:44:52 - UNIQUE Function
07:50:10 - FILTER Function
07:49:40 - Exercise 03
08:05:20 - How Date and Times are Stored
08:09:32 - Custom Data and Time Formats
08:16:42 - Time and Date Functions
08:25:26 - WORKDAY and WORKDAY.INTL Functions
08:29:16 - NETWORKDAYS and NETWORKDAYS.INTL Functions
08:32:13 - DATEDIF
08:38:28 - EDATE and EOMONTH
08:45:52 - Exercise 04
08:50:45 - Importing Data into Excel
09:00:40 - Removing Blank Rows, Cells and Duplicate Entries
09:06:02 - Changing Case and Removing Spaces
09:15:07 - Splitting Up Data Using Text to Columns
09:22:08 - Splitting Up Data Using Text Functions
09:30:13 - Flash Fill
09:35:13 - CONCAT
09:42:44 - Formatting Data as Table
🌍 Get unlimited training with Simon Sez IT’s 150+ courses ⏩ www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 8,500+ videos ⏩ www.simonsezit.com/ssit-first-month-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
✅ Check out our free video playlist for Excel beginners 👉kzbin.info/aero/PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
✅ Excel 2021 Tutorials for Intermediate Users here 👉kzbin.info/aero/PLzj7TwUeMQ3jhT7yg37LKe8aSTA7OuWn3
✅ Microsoft Excel Tips and Tricks 👉kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉kzbin.info/aero/PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: www.SimonSezIT.com/
LinkedIn: www.linkedin.com/company/simon-sez-it/
FaceBook: SimonSezIT
🔔 Subscribe to our channel:
kzbin.info
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[@ifemanimmazuubs]

You are the best teacher in the world Deborah! If I had teachers like you growing up, I would have done better in academics. God bless you.

[@SimonSezIT]

Thank you! 😃

[@thomassamuelrobinson9155]

This is an awesome class. It is very long, but that is because the teacher tells you every single step, she makes it very easy. I looked on youtube the last few months and I could never find an Excel training that was not very small and not taught in a professional manner as much as this one.

[@SimonSezIT]

Thanks Thomas! The video will be available later tonight on your KZbin channel, so you can always pause and watch it later :-)

[@HappyCampingMom]

I recently completed a college computing course where excel was 1/4 of the semester. I have learned more of what I really NEED to learn in the first 4 hours of this course. Very well presented for business use!

[@SimonSezIT]

Thanks for the nice comments and the visit 😊

[@UskaVII]

Thank you so much for making this. And for having it free! You're amazing. Great class

[@SimonSezIT]

Thanks for watching, Uska 🙂

[@bernardotabil774]

I sat through the whole 10hrs video and i must confess this is one of the best tutorial videos i have watched on KZbin thus far...thank you Deb for gems and nuggets you released in this video.

[@SimonSezIT]

Wow, that's impressive! A great way to start off 2023, we hope it helps :-)

[@arwahsdiary6535]

Thanks. It is really detailed teaching covering all the aspects.

[@philippelambrechts6494]

Bonjour, Un grand merci pour ce cours. Vous avez une élocution parfaite ce qui me permets de suivre ce cours.

[@tanweerabbasabbas649]

Best teacher!!

[@user-gr4uo2jx5y]

Excellent training

[@summerliu123]

Your way of teaching is most effective. Your voice is most beautiful. The class you presented here is just awesome. YOU ARE THE BEST TEACHER!!!

[@SimonSezIT]

Thank you! 😃

[@CLARAIVETTE1]

Thank you so much for this Valuable Tutorial along with an excellent trainer who covers every single detail and question one might have, Thank you Deborah & Simon Sez IT... Thank you, Thank you, Thank you! After this 10 hr training, one is trained to master excel like a pro.

[@SimonSezIT]

Thanks so much for the nice and kind comments, Clara. Greatly appreciated! If you need advanced Excel training, check out the 3.5 hour Excel 2021 course on KZbin -> kzbin.info/www/bejne/hp2zmIyFe6-Fhas All the best with your Excel training :-)

[@HollowPointBlank]

Best of the wishes for the lovely teacher

[@SimonSezIT]

All the best!

[@juanrosario]

Excellent class

[@sarahanwar6241]

This woman is a genius.

[@lovewillwinnn]

This woman is an A. I. bot

[@kalamay]

Okay, I finally got to download the files and I'm half-way through this. So far, AWESOME

[@mayasam1326]

how did u download files for exercise

[@nasirmehmood8990]

Excellent Work! Service to humanity

[@SimonSezIT]

Thank you kindly

[@tejasness]

Thank you so much. It means a lot!

[@SimonSezIT]

You are so welcome! Thanks for the kind comments 🙂

[@indikamadugalle7510]

Thank you !!

[@johnfogarty91]

Outstanding instruction Deborah!

[@SimonSezIT]

Thanks a bunch for the shoutout! I'm thrilled that you found my instruction outstanding. Keep watching for more helpful content 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@Sofiii85]

Absolutely fantastic. Thank you. I love discovering all the hidden options that make my work easier and more effective.

[@SimonSezIT]

I'm so glad you found the video helpful! It's always great to discover those hidden options that can make our work easier and more effective. 😊 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@johndrizis9391]

Deborah Ashby is the best tutor ever!!!!

[@SimonSezIT]

That is very kind of you :-)

[@FlouradenceEnterprise]

Awesome. Learnt So Much. Thanks So Much Ma. Love Your Voice Too.

[@SimonSezIT]

Thank you so much 🙂

[@shibainsouthcarolina2696]

Her voice is very pleasant and relaxing! it's almost like I am studying to hear her voice...lol I appreciate not only her amazing teaching skills, but also her voice and how she talks! Makes my study a lot bearable ;) Thanks for turning my study into something fun!!!

[@SimonSezIT]

Thank you for the kind comments 🙂 There’s additional MS Word training here if you need it ➡️ kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@yordankapavlova8354]

I absolutely love this lady! And I think the same for her voice but beside that she is a brilliant teacher! I am very grateful for this lessons! Very well done!!!

[@domniconyango8781]

Thanks, you make it look easier

[@SimonSezIT]

You bet!

[@vishnusuraj9914]

Great teaching video I learned a lot thank you will recommend this channel to my friends ❤❤❤❤❤👍👍👍👍⭐⭐⭐⭐⭐

[@SimonSezIT]

Awesome, thank you! :-)

[@SimonSezIT]

✅ Download to follow along and complete the free exercises ➡www.simonsezit.com/excel-2021-beginner-and-intermediate-course-files/ 🔥Check out our FREE 300+ hour training course playlist here ➡️ kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Boost your Excel skills with these free Excel playlists 👉🏼 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉🏼 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉🏼kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u

[@rustydizon4596]

waiting for this refresher course 😁

[@SimonSezIT]

Hope you like it!

[@vencislavvankov4897]

Hello! Thanks for the wonderful tutorial! How do I remove tabs at the beginning of cells? How do I enter a tab character in REPLACE?

[@pabloaarongarciamedrano7329]

Thanks for a Great reference

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂

[@khalidifkirene8271]

Thank you so much

[@SimonSezIT]

You're most welcome

[@VAL_ON_WHEELS]

You have invested in time and patience to summarise everything systematically...awesome, i can now take 3 days off from work and focus on the fundamentals to gain more experience...pretty much sums up thank you.

[@SimonSezIT]

Thank you for the kind words 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@mbusomabena9751]

2 hours in 😤😤 let's go.

[@asikomezahiri5443]

The best Teacher

[@SimonSezIT]

Thanks for the kind comment 😊

[@PaulEllisBIGDATA]

Thanks 😊

[@SimonSezIT]

Welcome 😊

[@SteelerY360Nation]

I used to love Excel 15 years ago when I last had it, so I'm relearning it from this video. I bought MS 365 last April

[@SimonSezIT]

Thank you! We also have a free 9-hour course for Office 2021/365 👉 kzbin.info/www/bejne/bKLNoHqZYrB3j9U

[@ryanmcamis7419]

Subscribed to the channel to learn Quickbooks for a part time job. Listened to the entire 10 hour course and then reviewed the sections individually. This channel has good content.

[@SimonSezIT]

Thanks for subscribing, Ryan! If you are in need of some advanced Excel training, check out the 3.5 hour advanced Excel 2021/365 course here ➡️ kzbin.info/www/bejne/hp2zmIyFe6-Fhas and additional training here ➡️ kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@alisongrey6216]

Deb, You are a great teacher. Love this video. Quick question though. On the 'naming ranges' exercise on the Customer Data. I named them in the same way you did but when I did the CountA for customers it picked up the title 'Customer Name' and added it so my number of customers changed from 50 to 51. I had to go into the defined names tab and delete it and then rename it using the click and drag method so as not to include it in my range. How come that didn't happen when you did it.?Thanks for this great tutorial.

[@mugyenyiyoram456]

Thanks alot

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@abdulazizharke6585]

دەستان خوش..

[@aviwemaqanda2203]

Thanks woooow you are suphab on what you do ❤👌🔥

[@SimonSezIT]

Glad you are enjoying the training. 😀

[@satyamkewat]

Absolutely awesome classes. We don't get such useful videos even after paying money. Each and every thing has been explained beautifully. And I must say, Deb's voice is beautiful. Is there any paid course of SEZIT?

[@SimonSezIT]

So nice of you! Our complete set courses are available at SimonSezIT.com. We also offer a free 30-day trial with unlimited access to over 140+ courses, details here ➡️ simonsezit.lpages.co/month-free/

[@andrewmayorakuot3346]

I wish I could have this vedioes for this tutorial 🤔.

[@ub_ers8472]

Hi, It's great. IK just have an issue with Home Icon in Module 02-04 Adding Navigation buttons. When I copy and paste them across the tabs only one icon is actually working. The rest are selected when I am setting up the Hyper Link, but they still do not work. Any ideas? Thanks.

[@chenkeith7272]

I don't see freeze panes, freeze top row and columns here. Where is it? Thanks

[@lovewillwinnn]

6:10:56 VLOOKUP section

[@dwarccanation2781]

6:31:27 So I'm not sure how to fix this but for the movie "13th" which is rated "TV-MA" it gives me an N/A error. I know how to fix it with iferror or ifna but, there are more issues like this. The movie "Victoria" which is rated "NOT RATED", gives the value of "R" instead of "NOT RATED". Is there a way to put two values for an iferror/ifna?

[@shibainsouthcarolina2696]

just so you know, Intermediate Training, Exercise 01, spread sheet has typo. Because of this, calculation cannot be done correctly. I think B24 is supposed to be "Canada", but it's "Canadata" in the file.

[@SimonSezIT]

Thank you for letting us know!

[@sedrickbosh6132]

At 7:22:00, some of the sorts for city & town do not seem to be working right. How can that be?

[@md.mustakimrahmanbappy5749]

Hello 👋, I need the exercise file . Can you please mail me the exercise file ☺️?

[@demensclay6419]

Great to have a 2021/365 beginners course Excel, but will there be a 2019 Excel beginners course as well?

[@SimonSezIT]

Yes, here's a 3-hour course for Excel 2019 -> kzbin.info/www/bejne/kH-qoph5mLmoZrM

[@omerveysel]

Why do I get an error when I try to multiply two numbers using the =SUM() function in Excel?

[@ItzikMarko]

Hi. Which tool are you using to present on screen which keyboards you are using? Thank you

[@SimonSezIT]

Camtasia Studio.

[@muhammadika]

Are these complete courses like the ones you offer upon paid subscription?

[@SimonSezIT]

They are not complete courses like the ones we offer, only a part of the full courses. Thanks for watching!

[@styleee449]

Wow

[@kennyhabeeb4708]

Well explanatory tutorial ❤.. How can I get the excel files used in this video?

[@SimonSezIT]

Thank you so much for your feedback! I really appreciate it. As for the Excel files, you can find the link from the video description. We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@Aravind-2906]

00:33:51 - Ribbons, Tabs and Menus

[@RA-rh5lb]

Valuable class. The instructor is truly amazing. I couldn't get the practice file that I requested to send to my email id.

[@SimonSezIT]

It seems like the problem might be related to the browser or its cache. I suggest trying a different web browser or clearing the cache of your current browser.

[@nasirmehmood8990]

Could you please share the link of PowerPoint course well?

[@SimonSezIT]

Here you go, Nasir - Microsoft PowerPoint for Beginners: 4-Hour Training Course in PowerPoint 2021/365 ➡️kzbin.info/www/bejne/gnbIaYKBnct9jdk If you need additional Excel training - 3.5 hour advanced Excel 2021/365 course: ➡️ kzbin.info/www/bejne/hp2zmIyFe6-Fhas

[@nasirmehmood8990]

@@SimonSezIT Thank you so much

[@satyamkewat]

"The golden rules of spreadsheet" is missing.

[@richarddasen9872]

This looks like a great course but it doesn't cover the new Offrice 365 that Microsoft just foisted on me. Sure would like to see unupdated one.

[@SimonSezIT]

Check out our new Excel 365 course just published on KZbin :-) kzbin.info/www/bejne/rpKroWWJopWtnNU

[@thetry_fecterbyms_scilla_f]

This course appeared promising, but requiring my email for access raises concerns. Offering free access to course material aligns with the course being free. Currently, the emphasis on collecting emails might attract individuals solely seeking material, potentially diluting genuine interest and creating impurities in the leads collected. this is what I think as this has deterred my interest in completing the course.

[@onthewall4yah730]

Will I be able tu use Excel from Microsoft 365?

[@SimonSezIT]

If you have a Microsoft 365 active subscription, then yes!

[@khaledezzat007]

Thanks a lot you rock :)😍

[@PsE8]

👏🏻👏🏻👏🏻

[@audiovalet]

01:13:04 - Exercise 01 of the introduction section

[@audiovalet]

02:56:52 - a little secret menu have been presented

[@burhankalu2682]

the dataset link is not working on my end.

[@SimonSezIT]

is the link not accessible at all or did you not receive an email? Please check your spam folder and make sure you entered the correct email address. You can also try clearing your cache or using a different browser.

[@zahorullahhayat4904]

I can’t download your files for exercise. Your links are not opening

[@SimonSezIT]

Please try clearing your browser cache or another web browser.

[@cyrixone2771]

The fact is that the files offered for free download never arrived even though I made three attempts with my email

[@SimonSezIT]

Sorry to learn about this. Please check your spam or junk folder, If nothing is there,, try another web browser and clear the browser cache.

[@zdk1099]

I requested the sample files but never received the email link to download them! Very disappointing!

[@SimonSezIT]

Sorry to learn about that. Please ensure you click on the confirmation button in the email you receive.

[@zdk1099]

@@SimonSezIT Finally was able to download the files,

[@kengraves4992]

Is it me, or did something amiss happen at the 6:09:05 mark? During the exercise, we're supposed to be finding Canadian females, and the data in cell b24 was miraculously changed after the formula was entered?! Still a great video

[@kengraves4992]

Canadata to Canada

[@SimonSezIT]

Hi Ken, there was indeed a typo in cell B24. The change from Canadata to Canada was not due to the formula but it was corrected mid-recording. I hope it didn't cause much trouble for that part of the lesson.

[@kengraves4992]

@@SimonSezIT No worries! The video is definitely detailed and what it shows is truly amazing! Thank you for posting it!

[@aboibrahim4069]

we cannot download exercise files Could you please resolve this problem Whenever we click on Get My Files it does not do anything We tried to download the exercise files using three different web browsers Google Chrome, Firefox and Microsoft Edge but none of them worked so it is definitely a problem in your web site

[@zahorullahhayat4904]

If you solved your problem then show me

[@amysmith8103]

I cannot open exercises, says protected.

[@SimonSezIT]

Hi! You can click on "Enable Editing" if the file opens in Protected View.

[@tutsecret499]

If everything fails in your life, you still can sell your voice recording ebooks to make money. Everybody should always have plan A, B, C: different skills, if fails. Voice really matters. In Brazil, there was a lady that worked at the airport for many years to announce the flights. The whole world passengers were crazy about her voice, some passengers wanted to meet, see the lady behind the voice. One day, the Airline decided to show the lady behind the voice. There is a video talking about her ,from her age she was born until she retired from the Airline. I know a lady who is very successful, she is a CFO, Finances, Budget, high core level, but she has other skills, she is a hair dresser, manicure.

[@qamaruddinkhichi904]

Why not all 3 together Beginner, Intermediate, and Advanced Excel 2021/365??

[@SimonSezIT]

Hello Qamaruddin Khichi! The combined Beginner, Intermediate, and Advanced Excel 2021/365 video is planned for release later this year (12 hours!) :-)

[@qamaruddinkhichi904]

@@SimonSezIT Eagerly waiting.. Thanks!

[@waynelast1685]

For some reason, I like a woman's voice more than a man's.

[@mahmoudali6205]

at @ 03:09:21 why use sum function ? you can multiply direct without sum!!!!!!!

[@SimonSezIT]

There is more than one way to do this and a direct multiplication is one of them. Deb chose to show it using the SUM function in this specific exercise.

[@mahmoudali6205]

@@SimonSezIT thanks for caring

[@BuzzandBumble]

the files aren't downloading.

[@SimonSezIT]

Sorry that they are not downloading. Please try another web browser and/or clear your browser cache. If the issue continues, get in touch with our support team :-)

[@tanweerabbasabbas649]

Cannot download files! No emails!!!

[@martinauckland]

I received the email. but my pc blocked as the site was on a "Black List ", what ever that means

[@brightdaniel1830]

Why are guys not teaching Microsoft SQL

[@SimonSezIT]

We'd like to, but we haven't found a great teacher for that topic. Hopefully in 2023 :-)

[@brightdaniel1830]

@@SimonSezIT tell Deborah ashby, she is the first British I will like. She really helped me.

[@alxmampilly]

Jesus 10 Hours

[@SimonSezIT]

Our 12-hour Excel class is coming later in the year 🙂

[@derekcanmexit]

@@SimonSezIT looking forward to it 😀 … thank you for providing excellent content 👍🏻

[@propeace7211]

[@LaceyWinter-jp3ur]

Deb, You are a great teacher. Love this video. Quick question though. On the 'naming ranges' exercise on the Customer Data. I named them in the same way you did but when I did the CountA for customers it picked up the title 'Customer Name' and added it so my number of customers changed from 50 to 51. I had to go into the defined names tab and delete it and then rename it using the click and drag method so as not to include it in my range. How come that didn't happen when you did it.?Thanks for this great tutorial.