Microsoft Excel 2016 Tutorial for Beginners – How to Use Excel Part 6
658 views · Published 28 August 2018 · 1:19:50 · Indexed 4 November 2026
Channel: Kirt Kershaw · 2018 · Education
This is a Microsoft Excel 2016 Basic Tutorial for beginners. In this basic course Excel video tutorial, you’ll learn how to link data from a cell into another on the same or different worksheet, or workbook, UPPER, LOWER and PROPER functions to manipulate the case of a word, CONCATENATE to bring together data from separate cells into one, LEFT, FIND and SEARCH functions to extract data from the left most part of a cell and up to a certain point, RIGHT, FIND and LEN to also extract data from the left most part of a cell and up to a certain point, MID function to extract data from in between other data within the same cell, AND, OR to add additional arguments that has to meet all defined conditions, or any one of them, IF function to have set a logical test that if true will calculate or return data, and if false something else, how to combine and nest functions, how to use the IFERROR function to display specified text if a function returns and error, PMT is the payment function used to calculate like a monthly payment based upon principle, interest and number of payments, how to display and print formulas, SUMIFs, COUNTIFs, AVERAGEIFs where if it meets two or more conditions the end result will sum, count or average a range of data, CONVERT to convert one unit of measure into another, MATCH and INDEX to find matching data in a table or database, the LOOKUP, VLOOKUP and HLOOKUP to look up a value in a table. 1. Link Data 2. UPPER, LOWER and PROPER 3. CONCATENATE 4. LEFT, SEARCH and FIND 5. RIGHT, FIND and LEN 6. MID 7. AND & OR 8. IF 9. Combined Nested Function 10. IFERROR 11. PMT 12. Display Print Formulas 13. SUMFIFs, COUNTIFs and AVERAGEIFs 14. CONVERT 15. MATCH and INDEX 16. LOOKUP 17. VLOOKUP 18. HLOOKUP All 160 of my Excel 2016 training videos contain everything you need to help pass both the Microsoft Office Excel 2016 Core (77-727), and Expert (77-728) exams and become certified! DVD & DOWNLOAD AVAILABLE: https://www.DreamForce.us SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts! http://www.youtube.com/subscription_center?add_user=videotrainingpro LET'S CONNECT! -- http://www.linkedin.com/in/kirt-kershaw-33874410
More from this channel
-
5:42
Windows 7: Basic Overview
-
6:27
Excel 2010 Print Rows Top Each Page - Repeat Column Headers Training Video
-
4:14
Excel 2010 Evaluate and Watch Formulas Training Video
-
5:04
Word 2010 Document Views Training Video
-
0:30
PowerPoint 2010 Introduction Training Video
-
2:56
Project 2013 Reschedule Task Training Video
-
9:51
Excel 2013 Essential and Basic Training Video
-
4:33
Excel 2013 Evaluate and Watch Formulas Training Video