In this video tutorial, we will delve into data analytics, emphasizing Excel's real-time internet data-fetching abilities. We will also cover data entry techniques, shortcuts, and AutoFill usage, showcasing efficient editing, copying, and moving of data. And lastly, we'll explore formatting, emphasizing aligning data and understanding data types.
Timestamps:
00:00:00 - Simon Sez IT Intro
00:00:10 - Viewing, Entering, and Copying Data
00:09:05 - Formatting and Data Types in Excel
00:17:50 - Excel Formula Basics
00:27:35 - Exploring Excel Functions
00:37:13 - Referencing Data
00:46:05 - Exercise 01
Get unlimited training with Simon Sez IT’s 200+ courses ⏩ https://www.simonsezit.com/courses/
Level up your skills with a free 30-day trial to our complete training library of 10,000+ videos ⏩ https://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 ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
Check out our free video playlist for Data Analysis using Microsoft Tools https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jiDSWwQjtVvHqT09XdYFMi
Microsoft Access Training video playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3g7dabQhzlqljY-bnxv1YFA
Microsoft Excel Beginner's Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3iZHn4cv_fZagWSN8tubU9Z
Introduction to Databases Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jJ9OhflqrL5huscvd0Q9Qn
Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn: https://www.linkedin.com/company/simon-sez-it/
FaceBook: https://www.facebook.com/SimonSezIT
Subscribe to our channel:
https://www.youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up ;-)