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

Watch on YouTube

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