Excel Tutorial 2016: Excel Part 1 of 2 - Beginner to Intermediate Tutorial HD

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. Visit us also at http://kaceli.com for more info. 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: Website: http://kaceli.com YouTube Channel: http://youtube.com/skaceli