Write For Us

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

E-Commerce Solutions SEO Solutions Marketing Solutions
269 Views
Published
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:
Website: http://kaceli.com
YouTube Channel: http://youtube.com/skaceli
Category
Tech
Sign in or sign up to post comments.
Be the first to comment