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
(1103)
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:
Microsoft Office Home and Student 2019 Download 1 Person Compatible on Windows 10 and Apple MacOS
(1978)
![Microsoft Excel 2016 – Full Tutorial for Beginners [COMPLETE in 13 MINUTES!]*](https://img.youtube.com/vi/HacWD9HSww0/0.jpg "Microsoft Excel 2016 – Full Tutorial for Beginners [COMPLETE in 13 MINUTES!]*")
![Microsoft Excel 2019 – Full Tutorial for Beginners [COMPLETE in 17 MINS!]](https://img.youtube.com/vi/XAw79w4Rr-o/0.jpg "Microsoft Excel 2019 – Full Tutorial for Beginners [COMPLETE in 17 MINS!]")
![Microsoft PowerPoint 2016 – Full Tutorial for Beginners [ 14 MINUTES! ]*](https://img.youtube.com/vi/tQicwstinOA/0.jpg "Microsoft PowerPoint 2016 – Full Tutorial for Beginners [ 14 MINUTES! ]*")
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.