Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation - - vimore.org

Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation

Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation

YouTube

Excel Power Tips: Learn these useful Techniques for creating Lists, setting up Drop Down Menus and doing Data Validation in Excel. Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda Treach: Go to this link - http://www.launchexcel.com/moth-excel-expert Download sample workbook to follow along at: http://www.launchexcel.com/excel-dropdown-list-data-validation In this 20 minute episode we'll look at lists, drop downs and data validation. These are very important areas of Excel that you should master if you want to take your Excel skills to the next level. Read the accompanying article and download the sample workbook at www.launchexcel.com: http://www.launchexcel.com/excel-dropdown-list-data-validation Video Highlights: --- Excel Built-in Lists --- 0:10 Excel's Built-in Lists (Days of week, Months of year) --- Excel Custom Lists --- 1:06 Three use cases for Custom Lists 3:57 How to create a Custom List (instructions for Excel 2010) --- Dependent Drop-down Lists (Country, City) --- 5:08 Drop Downs for Data Entry 6:47 How to create Dependent Drop Downs with Data Validation and Named Ranges 9:38 TIP: How to define multiple Named Ranges 10:02 The "Slow" Way using the Name Manager 11:24 The "Fast" Way using CTRL + SHIFT + F3 14:09 Why do we need "Helper" columns? --- Data Validation (E-mail, Date of Birth) --- 15:40 Data Validation of Email addresses 18:20 Data Validation of Date of Birth (you must be at least 15 years old) 19:48 Warning: Data validation can be easily overwritten by Copy ➜ Paste and what to do about this



Excel Power Tips: 20 Tricks to help you become a Mouse Power User

Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda

YouTube

Create a searchable drop down list in Excel

This video will show you step by step how to create a searchable dropdown list in Excel. This technique uses data validation and some formulas. SEARCH, VLOOKU

YouTube

Excel Macro Tutorial - Learn how macros can really speed up your work in Excel

Get FREE 28-page e-book "Record Your First Macro" here → https://www.launchexcel.com/get-excel-macros-ebook ----- // Episode Notes Read more at http://www.la

YouTube

Create a Scrolling Table

Check out my Blog: http://exceltraining101.blogspot.com It's fairly easy to create a table in Excel, but when it gets large you have to use the the arrows to

YouTube

Realistic Case: Dependent Drop-Down Lists in Excel with Multiple Words & Spaces in 1st List

Download the Workbook here: http://www.xelplus.com/excel-dependent-drop-down-lists-multiple-words-spaces/ This video builds on the methods shown in a previous

YouTube

Top 25 Excel 2016 Tips and Tricks

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

YouTube

Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 1 of 2

Excel formula tutorial - How to use the VLOOKUP formula in Excel | Part 1 of 2 Download the interactive workbook at http://www.launchexcel.com/vlookup-formula-

YouTube

Excel Shortcuts You Probably Don't Know

Excel Shortcuts You Probably Don't Know | Upgrade Your Life Becky Worley shows time-saving shortcuts to make your spreadsheet workflow faster and easier. Micr

YouTube

10 Things you can do Easily in Excel under 10 Minutes

10 things you can do in Excel under one minute each. You can learn how to, 1. Auto sum a bunch of values 2. Save Excel file as PDF 3. Insert Org chart 4. Insert

YouTube

Excel Magic Trick 550: Data Validation List Drop-Down Based On 2nd Data Validation List Dependent DV

Downlod file: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT539-550.xls Dependent Data Validation List. See how to create a Drop Down List that is ba

YouTube

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will retu

YouTube

Excel Advanced Filter - part (1 of 2)

Part 2: http://www.youtube.com/watch?v=wMddq7yn9BI This tutorial video is part 1 of a two part lesson on using Advanced Filters in excel. Advanced filtering is

YouTube

Create dependent drop down lists in Excel

Learn Excel online https://www.udemy.com/excel-2010-superhero-course/?couponCode=Excel2010YouTube Create dependent drop down lists in Excel to select items bas

YouTube

Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

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

YouTube

How to create a Dynamic Search Suggestion Drop Down List in Excel

In this video tutorial, learn how to create a dynamic Google-type search suggestion drop down list in Excel. This technique uses a mix of Excel Formulas and VBA

YouTube

Excel Tutorial | 20 Tricks & Shortcuts That Can Make Anyone An Excel Expert

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

YouTube

Excel Tutorial - How To Make Dynamic Drop-Down Lists

http://5minuteguide.net This Microsoft Excel tutorial will teach you how to make a drop-down/pop-up menu that changes based on the contents of another menu. Vi

YouTube

Data Validation 6 - Run Macros from Drop Down Menus in Excel

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials. Excel video tutorial that teaches you how to run macros from

YouTube

Excel Power Tips: 10 Ways to make Data Entry Faster and More Accurate

Do you want to become an Excel expert? Learn how to use Excel more powerfully than ever before. Then you should take a look at the Excel Expert course by Mynda

YouTube

Excel Logic Functions - IF, AND, and OR

Using a combination of IF, AND, and OR functions to determine employee pay and bonuses.

YouTube