Learn how to use the IF function in Excel to "program" your spreadsheets to show you certain data. You can create If ________ then _______ statements that can produce powerful results in Excel. #excel #exceltutorial ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
Learn how to split names in Excel. Sometimes in Excel you end up with too much information in one column, for example first and last names in the same column.
Learn how to create pivot tables in Excel and how to use them to draw out the information you want to see. Pivot tables are intimidating to many Excel users, b
Learn how to use Excel's IF Function in your reports. We cover a few examples in this tutorial including: 1. Simple IF function (also with greater than or less
Learn what I consider to be the most useful Excel keyboard shortcuts. See below links to the CDs and bands mentioned in the video: The Killers - Wonderful Wond
Check out my Blog: http://exceltraining101.blogspot.com If you are familiar with the VLOOKUP function it's a great tool to lookup values in a range or table.
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm 1. IF Function: Put 1 of 2 things into a cell based on a logical test 2. AND Function: When
In this video i will show you how to create data entry form in Microsoft Excel 2016.
Practice file for DOWNLOAD: http://www.exceljunction.com/12-excel-functions-made-easy/ The most used functions in Excel are the ones that sum and count. You ca
When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of Excel
Learn some of the key intermediate level Excel for Mac skills, tips, and tricks. You'll learn some formatting tools, including conditional formatting, the Auto
In this advanced Excel tutorial you'll learn how to get started using the VLOOKUP function in Excel. VLOOKUP can help you pull specific information from a spre
The Top 25 tips and tricks for Excel 2016. Use these tips and tricks to improve your efficiency using Excel. I am sure you will discover some that you have not
Learn how to protect sheets in Excel so that only part of the sheet can be altered. Protecting a sheet is especially useful if you share spreadsheets with othe
After Microsoft enhanced Excel to the 2013 version, it offered more surprises than ever. In order to deal with tons of big data, you can’t ignore the important
Learn how to use two simple functions that can help you generate important information in Excel: Count and CountA. You'll also learn about the Excel Status Ba
Learn how to use Data Validation tools in Excel to improve the accuracy of the data in your spreadsheets. One of the Data Validation features you'll learn in th
Using a combination of IF, AND, and OR functions to determine employee pay and bonuses.
WATCH PART 2: https://www.youtube.com/watch?v=g530cnFfk8Y Download file used in the video: http://www.excelcampus.com/pivot-table-checklist-yt In this video se
https://www.udemy.com/excel-2010-superhero-course/?couponCode=Excel2010YouTube Compare two lists using the VLOOKUP formula in Excel. Use the VLOOKUP function t