Excel 2016 Tutorial – Beginner to Intermediate
Want to learn Excel? Here is part 1 of a 2 part series tutorial on Excel 2016. I have designed it to be concepts-based and simple to follow. Check it out.
A comprehensive tutorial on Excel 2016 covering most essential features for business professionals, students or anyone that wants to learn how to use Excel. The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007.
Link to Excel 2016 Part I Tutorial: https://youtu.be/xUM-GvJwTrw
Full Excel 2016 Tutorial URL: https://youtu.be/8lXerL3DHRw
The Quick Guide for Excel 2016 along with the data files to follow along are available from here: https://kaceli.com/excel-2016-data-file/
The following are covered in detail along with the starting times:
00:07 Getting Started with Excel 2016 – Learn the basics including the Tell Me feature.
11:15 Learn about the basic calculations in Excel 2016 such as SUM, AVERAGE, MAX, MIN, COUNT
21:45 Learn how to format a spreadsheet including conditional formatting in Excel 2016
25:04 Learn about additional core Excel functions and concepts such as SUM, Multiplying, Subtracting, Dividing in Excel 2016
32:41 Learn about the Quick Analysis Tools in Excel 2016
35:51 Learn about Data Sorting and Data Filtering in Excel 206
39:17: Learn about core concepts in Excel such as the types of references: Absolute, Relative Reference in Excel 2016
49:30 Learn how to create and use charts in Excel 2016
55:49 Learn how to use the Flash Fill Data feature in Excel 2016
Keep in touch:
YouTube Channel: http://youtube.com/skaceli