Get the free MS Excel 2016 course exercise and instructor data files here: ️ https://simonsezit.lpages.co/excel-2016-course-exercise-files/

During this Microsoft Excel 2016 training tutorial video, we will show you the basics of entering and editing data in a workbook. We will also demonstrate how to use autofit column width to make data fit within a cell, as well as how to format numbers into currency.

If you want to follow along as you learn Excel, you will find the first exercise of this course accompanying this video. Applying the things you have learned in the earlier chapters, you'll create a workbook and enter data showing the monthly averages for rainfall, minimum temperature, and maximum temperature where you live.

We will show you how to format dates in Excel. You will learn how to change the date and time settings according to your region, how to format dates in their short or long forms, how to work with dates that appear invalid in a cell, as well as how Excel interprets numbers entered in a cell as dates.

Discover how to modify numbers entered in a cell into various formats such as fractions, scientific, accounting, special, and time formats. We will also demonstrate how to format numbers as text, as well as how to edit contents and delete characters in a cell.

The second exercise of this course relates to formatting date and time. You will be tasked to modify the content of a workbook by changing the time format from 12-hour to 24-hour clock and by editing certain date and time.

If you want to become competent with Excel or planning on using Excel for finance and will be using MS Excel 2016, this MS Excel 2016 tutorial is packed full of Excel tips for you.

Get the complete 23-hour Excel 2016 Beginner to Expert course here:️ https://www.simonsezit.com/course-category/excel/

Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!

Basics of Entering and Editing Data in a Workbook: 0:07
Exercise 01: 14:05
Formatting Dates: 15:55
Formatting Numbers: 28:32
Exercise 02: 42:21

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-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 Advanced Excel 2019 Training Tutorials https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9

Excel 2021/365 Training Tutorials for Beginners playlist https://www.youtube.com/playlist?list=PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb

Advanced Excel 2019 Training Tutorials here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3gL_KnxdZzkDExVeX5vngx9

Microsoft Office 2021 and Office 365 Training here https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j

Check out our FREE 300+ hour training course playlist here ️
https://www.youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

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 ;-)