Excel 2016 Tutorial for beginners

This is a Microsoft Excel 2016 Full Tutorial for beginners & intermediate users.In this crash course Excel video tutorial you will learn how to use Excel 2016 formulas and functions, Excel 2016 new features, Excel 2016 Charts along with many other necessary features that you must know how to use when using Excel 2016.

1:38 The Excel Ribbon

2:10 Ribbon Groups and Commands in Excel 2016

2:30 Data Entry in Microsoft Excel

3:08 How to enter data in to a cell in Excel

3:22 How to enter data into the formula bar in Excel

3:50 How to Navigate through Microsoft Excel

4:24 How to navigate and select cells in Excel with keyboard

8:01 Autofill in Excel 2016

9:15 Autocomplete in Excel 2016

10:32 How to zoom in and zoom out Excel 2016

10:50 Formulas & Functions Tutorial in Microsoft Excel 2016

11:25 Addition in Excel

13:04 Autosum Function in Excel

14:03 The Sum Function in Excel 2016

15:45 Subtraction in Microsoft Excel

16:12 Multiplication in Excel 2016

17:15 The Product Funtion/Formula in Microsoft Excel

17:44 How to Find/Search for a function in Excel using the insert function command in the Function Lirbrary

19:29 Division in Microsoft Excel

19:46 the Quotient Function in Excel

21:25 Exponential formulas in Excel

22:20 Concatenation in Excel

23:06 Logical Comparison in Excel

23:08 Equal to logical comparison in Excel

24:17 Logical Comparison Greater Than in Excel

24:36 Less Than Logical Comparison

24:58 Greater than or equal to

25:42 Not Equal to Excel 2016

26:14 Combining Formulas and Functions in Microsoft Excel 2016

29:18 Cell Reference Tutorial in Microsoft Excel

29:57 Types of cell reference in Excel

30:07 Relative Cell Reference in Excel 2016

32:04 Using Autofill for formulas and cell reference

32:25 Show formula in Excel 2016

33:15 Absolute cell reference in Excel 2016

33:10 How to lock cell reference

34:40 Mixed Cell Reference locking only the row or column

39:27 How to refer to cells in another worksheet in Excel

40:06 How to refer to another workbook in Excel

40:35 How to clear/remove/delet content in a cell

40:52 Autofill dates in Excel

41:15 How to delete a row or column in Excel

46:36 How to style and Excel worksheet

46:50 How to format numbers in Excel

47:50 increase of decrease decimals in Excel

48:54 How to format dates in Excel (short date, long date)

40:32 How to resize cells columns and rows in Excel

50:35 the Today function in Excel Today()

51:54 Formattin and styling cells in Excel

52:05 How to add color fill in Excel

52:55 How to add borders in Excel

53:44 How to copy and paste a range of cells in Excel

54:23 Cell Styles in Excel 2016

55:27 Text direction and how to angle diagnal text content and numbers in Excel

57:00 How to Merge cells in Excel

57:53 Merge across in Excel

58:18 Change height or width of cell in Excel

58:49 Font Style in Excel

1:01:37 content alignment in Excel

1:02:20 Conditional Formatting in Excel 2016

http://www.roofstampa.com

hjttp://roofstampa.com

http:/www.subjectmoney.com

http://www.excelfornoobs.com

**Price: $799.00**

#### Microsoft Surface Pro 7 – 12.3" Touch-Screen - 10th Gen Intel Core i5 - 8GB Memory - 128GB SSD (Latest Model) – Platinum with Black Type Cover

Next-gen, best-in-class laptop with the versatility of a studio and tablet, so you can type, touch, draw, write, work, and play more naturally Faster than surface pro 6, with a 10th gen intel core processor – redefining what’s possible in a thin and ... (as of October 24, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)**Price: $25.00**

#### $25 Xbox Gift Card [Digital Code]

Get an Xbox gift card for games and entertainment on Xbox and Windows Buy the latest games, map packs, movies, TV, music, apps and more* On Xbox One, buy and download blockbuster games the day they're released Great as a gift, allowance, or credit ca... (as of October 24, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)**Price:**

#### Microsoft 365 Personal | 12-Month Subscription, 1 person | Premium Office apps | 1TB OneDrive cloud storage | PC/Mac Download

For 1 person Premium Office apps, including Word, Excel, PowerPoint, and Outlook 1 TB OneDrive cloud storage per person to back up files and photos Works on Windows, macOS, iOS, and Android (iOS and Android require separate app installation) Advance ... (as of October 24, 2020 - More infoProduct prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on [relevant Amazon Site(s), as applicable] at the time of purchase will apply to the purchase of this product.)**Price:**

Do you have one for Excel users whom use Mac? This is great!

what are these diff version of excel ..which one should i learn or all are similar

Thanks for this great tutorial. Great pace.

I found this very helpful!

Thank you for this tutorial!!

Thank you, I needed this for my Educational Research class! This is great! 🙂

Thanks…for sharing wonderful video…for beginners learning…:) keep sharing more videos…I have watched both of you videos i.e. part 1 $ 2 completely…if there are more videos…please share the link…Thanks 🙂

Nice organization of topics / timing splits in the desc

Thank you so helpful

OK so this is “Beginning” Excel? Really? You have boxes made without teaching how to make them. I kind of think that is where you should have started.

Watch’d all of them. Very informative video. Thank you!

Good info, thank you so much!!!

Hello, can i please get your email address? Thank you.

Thank You!!!

where to get all of the tables you provided on the video?

thank you!!

I got lost at cell forumla’s

I have to take some assessment tests, and I really appreciate how you’ve explained it all; I find Excel intimidating as all hell, so this is a great tool, thank you.

this video helped me a lot as beginner in excel. Loking forward to part 2. good work

Thank you. Your presentation was outstanding and easy to follow. Very clear and useful information.

MOST PEOPLE WHO MAKE THESE VIDEOS HAVE HEAVY ACCENTS. THANKS AGAIN. YOU WERE VERY HELPFUL.

Can I send SMS to send customize text.

thanks… 🙂

this is helpful…

🙂

keep it up… 🙂

This was a very good tutorial. What would make it even better is if the author could provide practice sheets for the viewer to follow along with 🙂

thank you 🙂

This was easy and clear to follow. His voice was nice and exciting; thanks for this tutorial.

I find this way too fast and chaotic. Too much info too fast, it doesn’t help a beginner at all

Thank you!

slow but helpful

Even better than the real thing.

2:51 It’s written *Types of Date* as a heading of table. Mustn’t it be “Types of Data”?

THANK YOU!!!

Very helpful although when I first started the video your voice reminded me of a character on Silicon Valley. So after I went and watched the newest episode of that, I came back and found your video really informative. Thanks for the post.

How can I download this template?

NICE

https://freeonlinesurveys.com/s/8k3Dl0Wo

This is a great tutorial for anyone new to Excel. I appreciate the patience with which he is teaching.

Very difficult to understand. About 25 minutes in it went WAY beyond beginner.

I can’t get off the first page! What did you do to auto fill that you did not include in the instructions? It doesn’t work!

I think I need an excel tutorial for “dummy’s”! LOL! Thanks for the upload though

The f4 button is not applicable on my PC to lock in the absolute reference. Any other and quicker option than doing it manually? I’d appreciate your reply. Thanks.