Get the free MS Excel 2016 course exercise and instructor data files here ►

Get the complete 23-hour Excel 2016 Beginner to Expert course here ►

Introduction to the Excel Course and Exercise Files – 0:07

Basics of Using the Ribbon – 2:47

Quick Access Toolbar – 18:07

Mini Toolbars and Contextual Menus – 24:06

Status Bar – 27:41

Basics of Entering and Editing Data in a Workbook – 32:43

Exercise 01 – 46:13

Formatting Dates – 48:03

Formatting Numbers – 1:00:40

Exercise 02 – 1:14:28

Working with Fill and Series – 1:16:11

Flash Fill – 1:25:20

Workbook Views, Zoom, and Freeze – 1:29:25

Printing – 1:38:06

Exercise 03 – 1:53:05

Methods of Cutting, Copying, and Pasting – 1:56:01

Delete and Clear – 2:09:33

Insert, Hide, Column Width and Row Height, and Merge – 2:23:18

Alignment – 2:36:06

Themes and Styles – 2:48:10

Exercise 04 – 2:59:29

Basics of Formulas and Functions – 3:01:14

Complex Examples of Formulas – 3:12:29

Exercise 05 – 3:26:35

Managing Worksheets – 3:30:02

Working with Multiple Workbooks -3:38:42

Saving in Different File Types – 3:54:31

The Spell Checker – 4:07:34

Inserting Comments – 4:20:42

Exercise 06 – 4:26:06

The VLOOKUP Function – 4:29:07

Text Functions – 4:43:14

Date and Time Functions – 4:51:31

Logical Functions – 4:58:19

Creating Graphs and Charts – 5:14:10

Customizing a Cluster Column Chart – 5:26:20

Customizing a Pie Chart – 5:42:02

New Chart Types in Excel 2016 – 5:55:38

Exercise 7 – 5:58:08

In this mega, 6-hour long Excel course you’ll finally learn how to use Microsoft Excel including Excel formulas and functions to get you started on your Excel journey.

We’ve taken some of our best course content and combined it into this super Excel tutorial. If you’re new to Excel, looking to learn Excel or just haven’t found the right Excel tutorial, Simon Sez IT has you covered with this Excel crash course.

Click below to download the follow-along exercise files so you can make the most of this amazing free Excel course.

Download the Excel 2016 tutorial exercise files here:

Stay in touch:

SimonSezIT.com:

StreamSkill.com:

YouTube Channel:

Twitter:

If you enjoyed the video, please give a “thumbs up” and subscribe

to the channel 😉

Nguồn: https://marishka-moi.com/

Xem thêm bài viết: https://marishka-moi.com/category/cong-nghe

Very informative course, I learned a lot. Thank you so much!

thanks for the great video!!!

Thank you very much for this video.

Enjoying working my way through this training video……..Very well explained and at a steady pace. Bravo !

What a great video! I am having issues with "Flash Fill". Is there anything special I should be paying attention to?

Thank you for uploading this video, really appreciate your effort.

Thank you!! You're a blessing!

great stuff there really relevant i appreciate you so much

Thanks for sharing a good and fast way.

Thanks a lot

About halfway through and great content. Definitely purchasing the course.

Just what I have been looking for, awesome

that was a pretty much useful video, I appreciate it.

where do i find exercise one? not the file, but the instructions on how to do it?

Thank you, Mr. Simon, for this great video…really appreciate your great effort!!!

I can not find other videos from this one. Have you uploaded video of full course in exel. 😟😟😟😟

Thank you very much Mr.Simon,excellent course.

good job guys

Good day! Great tutorial and thank you. Blessings!

I'm loving it so far. I'm learning new things

Really informative course.. thanx!!

Way too zoomed out most of the time, shame because it seems informative.

thanks

You Are Amazing I just finished this Video and am looking forward on going to Advanced. Where can i Purchase the Advanced Course?

Thumbs up. But the instructor files are missing from the link above

Can this be watched to learn Excel 360? 2019

Simon, how are you going to make any money if you start giving this away for free.

This is great. Any chance of some chapter bookmarks?

Thank you very much. Please keep it up.