A comprehensive tutorial on Excel 2016 covering most essential features for business professionals, students or anyone that wants to learn how to use Excel. This is part 1 of 2 of the Excel Tutorial. For more info. visit http://learn.kaceli.com. The concepts covered here apply also to previous versions of Excel such as Excel 2013, 2010 and 2007.
If you like the video, please “Like,” “Favorite,” and “Share” it with our friends to show your support on this work. Subscribe to this channel so that you do not miss out on the new videos on this series.
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: http://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
If you want to take get a deeper understanding of Microsoft Access, take a look at http://learn.kaceli.com
Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.