Videos like this “Connect Excel to Coinmarketcap for live and historic data”
MS Excel - Import Live Data From Web
MS Excel - Import Live Data From Web Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
What is Blockchain
Blockchain explained. Shai Rubin, CTO of Citi Innovation Lab, explains in an easy and simple way the basics of blockchain.
Views: 1686017 zlotolow
Tutorial: Auto Updating Cryptocurrency Portfolio on Excel Spreadsheet
Update: Video is outdated For cryptocurrency brokerage services, go to calebandbrown.com How to make a spreadsheet with automatically updated prices from coinmarketcap API. API data link here: https://api.coinmarketcap.com/v1/ticker/ Example File: https://drive.google.com/file/d/0B__HlHJ29Ar6R2tFUk5lWFdpUFU/view?usp=sharing When you open it, there will be a yellow banner at the top where you need to enable external data to allow excel to connect to the internet and retrieve the coinmarketcap data.
Views: 107099 Jackson Zeng
Excel Magic Trick 1107: VLOOKUP To Different Sheet: Sheet Reference, Defined Name, Table Formula?
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to do a VLOOKUP to a different Sheet using: 1. Sheet References 2. Defined Names 3. Table Formula Nomenclature (Structured References)
Views: 641945 ExcelIsFun
How to connect an Excel Spreadsheet to CoinMarketCap (bitcoin)
Use CoinMarketCap to connect your excel file to live Bitcoin and ALT coin prices. Download the Model Excel Template here: https://www.mariuslandman.com/premium-membership.html Use this code: https://api.coinmarketcap.com/v1/ticker/
Views: 2898 Marius Landman
Most Useful Excel Keyboard Shortcuts - Tutorial 2018
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 Wonderful: http://amzn.to/2G7AKlF Brandon Flowers - The Desired Effect: http://amzn.to/2G6gBMG Blaqk Audio -Material: http://amzn.to/2DUOfo1 Covenant - The Blinding Dark: http://amzn.to/2n1J0uH Depeche Mode - Spirit: http://amzn.to/2E0BUio Erasure - World Be Gone: http://amzn.to/2G46U1t Future Islands - The Far Field: http://amzn.to/2DC7yVx Hurts - Desire: http://amzn.to/2DX6Dww OMD - The Punishment of Luxury: http://amzn.to/2DpzVmA The Frozen Autumn - The Fellow Traveller: http://amzn.to/2DXfA9f The Jellyrox - Bang and Whimper: http://amzn.to/2Drnvue Ulver - The Assassination of Julius Caesar: http://amzn.to/2DoFLEB ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
How to Code Google Sheets to Track Cryptocurrencies' Prices
Learn to code your Google Sheets to automatically track different exchanges' latest prices of crytocurrencies - bitcoin (BTC), ethereum (ETH) etc etc. Make sure to view it in minimum 720 HD. 👉🏽 Check out: I consider this as one of the key basics before we can move on to other stuff. As a start we'll be using Gemini: https://gemini.com/ Similar API protocols as Gemini: - Bitfinex: https://www.bitfinex.com/ - Coinbase: https://www.coinbase.com/ - There can be more but I didn't research I'll be creating a series of videos. Comment to request! - It could be learning how to use different exchanges - How to track your portfolio balance with your API keys - etc etc. For some people who are curious about my coding background, I learned to code at NEXT Academy - https://www.nextacademy.com/?utm_source=audrey-youtube&utm_medium=video&utm_campaign=learn-coding-gs-gemini. I am not a professional coder, I learned coding out of curiosity and I am doing this as a hobby on the side. If you like this, feel free to... ✅ Subscribe to my channel! ✅ Follow me on Steemit: https://steemit.com/@audreyling ✅ Like my vid ✅ Share!!
Views: 7680 Audrey Ling
Power BI and Microsoft Flow - Monitoring your data
In this video, Patrick shows how you can use Microsoft Flow, combined with Power BI, to monitor data and alert you when something is available. This takes advantage of a streaming dataset and using the schedule recurrence in Microsoft Flow to trigger an action as Patrick wasn't using anything else to trigger it. You have a ton of options though. LET'S CONNECT! Guy in a Cube -- https://guyinacube.com -- http://twitter.com/guyinacube -- http://www.facebook.com/guyinacube -- Snapchat - guyinacube -- https://www.instagram.com/guyinacube/ ***Gear*** Check out my Tools page - https://guyinacube.com/tools/
Views: 34522 Guy in a Cube
Bitcoin: How Cryptocurrencies Work
Whether or not it's worth investing in, the math behind Bitcoin is an elegant solution to some complex problems. Hosted by: Michael Aranda Special Thanks: Dalton Hubble Learn more about Cryptography: https://www.youtube.com/watch?v=-yFZGF8FHSg ---------- Support SciShow by becoming a patron on Patreon: https://www.patreon.com/scishow ---------- Dooblydoo thanks go to the following Patreon supporters—we couldn't make SciShow without them! Shout out to Bella Nash, Kevin Bealer, Mark Terrio-Cameron, Patrick Merrithew, Charles Southerland, Fatima Iqbal, Benny, Kyle Anderson, Tim Curwick, Will and Sonja Marple, Philippe von Bergen, Bryce Daifuku, Chris Peters, Patrick D. Ashmore, Charles George, Bader AlGhamdi ---------- Like SciShow? Want to help support us, and also get things to put on your walls, cover your torso and hold your liquids? Check out our awesome products over at DFTBA Records: http://dftba.com/scishow ---------- Looking for SciShow elsewhere on the internet? Facebook: http://www.facebook.com/scishow Twitter: http://www.twitter.com/scishow Tumblr: http://scishow.tumblr.com Instagram: http://instagram.com/thescishow ---------- Sources: https://bitinfocharts.com/ https://chrispacia.wordpress.com/2013/09/02/bitcoin-mining-explained-like-youre-five-part-2-mechanics/ https://www.youtube.com/watch?v=Lx9zgZCMqXE https://www.youtube.com/watch?v=nQZUi24TrdI https://bitcoin.org/en/how-it-works http://www.forbes.com/sites/investopedia/2013/08/01/how-bitcoin-works/#36bd8b2d25ee http://www.makeuseof.com/tag/how-does-bitcoin-work/ https://blockchain.info/charts/total-bitcoins https://en.bitcoin.it/wiki/Controlled_supply https://www.bitcoinmining.com/ http://bitamplify.com/mobile/?a=news Image Sources: https://commons.wikimedia.org/wiki/File:Cryptocurrency_Mining_Farm.jpg
Views: 2604087 SciShow
Trading Journal - My Excel Spreadsheet Trading Journal (+ Free Trading Journal Spreadsheet!)
Learn what information should be recorded in a trading journal + get a free copy of my trading journal. This can be used as a Forex trading journal. In this video - 'How I Use My Excel Spreadsheet Trading Journal' I briefly talk about the different options available when it comes to choosing what to actually create your trading journal in - mainly Microsoft Excel or Evernote. I then move on to what information you should record in your journal spreadsheet. I show you my personal trading journal spreadsheet and explain the reasons why I record what I record. Lastly, I explain how you can get a copy of my Excel Spreadsheet trading journal if you want one. To download the spreadsheet go to: https://www.disciplinedtrader.co.uk and sign up to the Academy. You can then go to the Trading Journal section and download the spreadsheet for free. My Previous Video - https://youtu.be/--V9bEEO4Dw Subscribe to the YouTube Channel for more videos: https://www.youtube.com/c/DisciplinedTraderUK Check out the Disciplined Trader blog: http://www.disciplinedtrader.co.uk Follow me on Twitter: https://twitter.com/disciplinedtrad Follow me on Instagram: https://www.instagram.com/disciplined_trader/ Follow me on Facebook: https://www.facebook.com/disciplinedtrader/
Views: 35934 Disciplined Trader
10.5: Working with APIs in Javascript - p5.js Tutorial
This video demonstrates how to work with an API. The example uses open weather map. How do you form an API query? How do you get an API key? How do you use the JSON data the API sends you back? Oh, and what is an API? All examples: https://github.com/shiffman/Video-Lesson-Materials Contact: https://twitter.com/shiffman Next video: https://youtu.be/4UoUqnjUC2c JavaScript basics: https://www.youtube.com/playlist?list=PLRqwX-V7Uu6Zy51Q-x9tMWIv9cueOFTFA HTML/CSS basics: https://www.youtube.com/playlist?list=PLRqwX-V7Uu6bI1SlcCRfLH79HZrFAtBvX Full Data playlist: https://www.youtube.com/playlist?list=PLRqwX-V7Uu6a-SQiI4RtIwuOrLJGnel0r Help us caption & translate this video! http://amara.org/v/QbuE/
Views: 179809 The Coding Train
How to build Interactive Excel Dashboards
Download file used in the video with step by step instructions and links to more tutorials: https://www.myonlinetraininghub.com/workbook-downloads In this video you will learn how to create an interactive dashboard from scratch using the built in Excel tools. No add-ins or VBA/Macros. Just plain Excel. Applies to Excel 2007 onward for Windows & Excel 2016 onward for Mac. Subscribe to my free newsletter and get my 100 Tips & Tricks eBook here: https://www.myonlinetraininghub.com/sign-up-for-100-excel-tips-and-tricks
Views: 1566632 MyOnlineTrainingHub
Advanced Excel - Using the IF Function in Excel to Program Your Spreadsheets
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
Tutorial: How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup
In this video, I show you how to insert a drop-down box in an order form in Excel and use VLookup to auto-fill the contact info fields. This is a great way to select a customer number and have all of the address fields auto-fill. It's pretty simple once you get the hang of it! Don't forget to subscribe to my channel for more tutorials! Check out my website at http://www.sallyu.com Video recorded using Screencast-O-Matic (http://www.screencast-o-matic.com) Thanks for tuning in!
Create Dynamic Excel Filter - Extract data as you type
In this video tutorial, learn how to create a dynamic Excel filter. This dynamic Excel filter allows you to type the filter text in a text box and instantly extracts the records as you type in the search bar. This Dynamic Excel filter can be created in 3 steps: -- Getting a unique list of items (countries in this case). This would be used in creating the drop down list. -- Creating the search box. Here I have used a Combo Box (ActiveX Control). -- Setting the Data. Here I would use three helper columns with formulas to extract the matching data. You can use this dynamic Excel filter when you have a huge dataset and you want to quickly filter it by entering the text. Since this is dynamic, you can remove the existing filter by simply deleting the text in the text box and type something else to filter based on it. Step-by-step written tutorial and download file: https://trumpexcel.com/dynamic-excel-filter/ You May Also Like the following Tutorials: -- Creating a drop down list in Excel: https://www.youtube.com/watch?v=uREmXWvSuo4 -- Advanced Filter in Excel: https://www.youtube.com/watch?v=ZUFEqjDLM2I -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 308434 Trump Excel
Add Realtime Currency Data into Excel
The simple video tutorial will show you how to import live currency data from the web into your excel spread sheet. I will also show you how to get this data to update automatically so that you can set it up once and forget about it. The link I used in demo: http://www.x-rates.com/table/?from=EUR&amount=1
Views: 65601 TheTechscore
How to use Excel Index Match (the right way)
Quickly learn all you need to know about INDEX & MATCH to get a quick start. Complete Excel Dashboard course: https://courses.xelplus.com/p/professional-excel-dashboards Check out my other courses below. Download workbook here: http://www.xelplus.com/excel-index-and-match How to do Index Match in Excel: The basics. Watch this video tutorial to find out how you can use Index & Match for more complex lookup problems. This video shows you how Index Match works with simple and to the point explanation. It first shows you how Index works on it's own and then how Match works and then puts the two Excel functions together. Why index match is better than vlookup & why use index match instead of vlookup? Here are 3 reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH. 1. Unlike VLOOKUP, which searches only to the right, INDEX and MATCH can look in both directions – left and right. 2. INDEX & MATCH can perform two-way lookups by both looking along the rows and along the columns to find the intersection within a matrix. 3. INDEX & MATCH is less prone to errors. Assume you have a VLOOKUP where the final value you want returned is in column N. Your lookup value is in column A. You need to highlight the entire A to N range and then provide your index number to be 14. If you happen to delete any of the in-between columns, you would have to update that index number. You don’t need to worry about this when you use INDEX & MATCH. All in all, INDEX and MATCH is more flexible than VLOOKUP. Here are some of the reasons why Excel experts generally substitute VLOOKUP with INDEX and MATCH. Note: Index match is not case sensitive Index explained: The first argument of INDEX is to give it an array. This array (range) should include your answer. You then need to specify how many rows to go down and how many columns to move to find the correct value. You cannot move outside the INDEX range. The syntax of INDEX is: • The range where the return value resides. • Number of rows to move down (the row index) • Number of columns to move to the right (the column Index). This argument is optional. If you only have one column, you can leave the column argument empty, otherwise, you need to specify the number of columns to move over, in the range. The MATCH function’s syntax is as follows: • Like VLOOKUP, Match needs a lookup (target) value. The user can reference a cell or directly type the value into the formula. • Lookup_array: The “list” (range) where the return values are located. • Match_type: 0 for an “exact” match. Index MATCH used together: When INDEX and MATCH are used together, the MATCH function finds the look up value’s row / column index and then hands this value off to the INDEX function to get the lookup value. ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 402110 Leila Gharani
How to Get Bitcoin and Cryptocurrency Data into Spreadsheets
Learn how to get live data of any cryptocurrency into a Google Sheet spreadsheet. Signup for coinbase with this link and get $10 free bitcoin: https://www.coinbase.com/join/598a586883e93500c298d03e Plugin Author: Julien Buty @jbuty If you like his plugin, please consider sending him some BTC: 17mzQHeg77BszCgK2EPfNsEUKGinMEGFst More information, functions, and explanations are available here: https://jbuty.com/how-to-get-crypto-currencies-rates-and-more-in-google-sheet-1a57e571bc14
Views: 6188 HowToCryptos.com
How To Access A JSON API With Power Query
You can find all links and a written tutorial here. http://www.howtoexcel.org/power-query/how-to-access-a-json-api-with-power-query/ In this video, we will learn how to use Excel's From Web power query to access and pull data from a free and open government API.
Views: 3745 How To Excel
Advanced PivotTables: Combining Data from Multiple Sheets
See companion tutorial and sample files on Tuts+: https://computers.tutsplus.com/tutorials/advanced-pivottables-combining-data-from-multiple-sheets--cms-21190. By Bob Flisser.
Views: 734314 Tuts+ Computer Skills
Advanced Excel - Protecting a Sheet - Excel Tutorial 2017
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 other people and don't want them to be able to accidentally change or input incorrect data. Please also watch my other Excel video tutorials. Also mentioned in the video is AMAZING music such as the following: Classic Synthpop and New Wave: Depeche Mode - Violator: http://amzn.to/2utJMqp Alphaville - Forever Young: http://amzn.to/2tl4gle OMD - Messages: The Best of OMD: http://amzn.to/2uyz1Ct New Music by Classic Synthpop Bands: A-ha - Foot of the Mountain: http://amzn.to/2tbfrsv Alphaville - Catching Rays on Giant: http://amzn.to/2tbD445 Underground Modern Synthpop: Code 64 - Departure: http://amzn.to/2tbEtbd Echo Image - Compuphonic: http://amzn.to/2uEvzr4 I WILL POST MORE SOON
Web Query Excel 2016: Importing data from a website to your spreadsheet
Recorded with http://screencast-o-matic.com
Views: 67997 Lucy Provost
Coding With Python :: Learn API Basics to Grab Data with Python
Coding With Python :: Learn API Basics to Grab Data with Python This is a basic introduction to using APIs. APIs are the "glue" that keep a lot of web applications running and thriving. Without APIs much of the internet services you love might not even exist! APIs are easy way to connect with other websites & web services to use their data to make your site or application even better. This simple tutorial gives you the basics of how you can access this data and use it. If you want to know if a website has an api, just search "Facebook API" or "Twitter API" or "Foursquare API" on google. Some APIs are easy to use (like Locu's API which we use in this video) some are more complicated (Facebook's API is more complicated than Locu's). More about APIs: http://en.wikipedia.org/wiki/Api Code from the video: http://pastebin.com/tFeFvbXp If you want to learn more about using APIs with Django, learn at http://CodingForEntrepreneurs.com for just $25/month. We apply what we learn here into a Django web application in the GeoLocator project. The Try Django Tutorial Series is designed to help you get used to using Django in building a basic landing page (also known as splash page or MVP landing page) so you can collect data from potential users. Collecting this data will prove as verification (or validation) that your project is worth building. Furthermore, we also show you how to implement a Paypal Button so you can also accept payments. Django is awesome and very simple to get started. Step-by-step tutorials are to help you understand the workflow, get you started doing something real, then it is our goal to have you asking questions... "Why did I do X?" or "How would I do Y?" These are questions you wouldn't know to ask otherwise. Questions, after all, lead to answers. View all my videos: http://bit.ly/1a4Ienh Get Free Stuff with our Newsletter: http://eepurl.com/NmMcr The Coding For Entrepreneurs newsletter and get free deals on premium Django tutorial classes, coding for entrepreneurs courses, web hosting, marketing, and more. Oh yeah, it's free: A few ways to learn: Coding For Entrepreneurs: https://codingforentrepreneurs.com (includes free projects and free setup guides. All premium content is just $25/mo). Includes implementing Twitter Bootstrap 3, Stripe.com, django south, pip, django registration, virtual environments, deployment, basic jquery, ajax, and much more. On Udemy: Bestselling Udemy Coding for Entrepreneurs Course: https://www.udemy.com/coding-for-entrepreneurs/?couponCode=youtubecfe49 (reg $99, this link $49) MatchMaker and Geolocator Course: https://www.udemy.com/coding-for-entrepreneurs-matchmaker-geolocator/?couponCode=youtubecfe39 (advanced course, reg $75, this link: $39) Marketplace & Dail Deals Course: https://www.udemy.com/coding-for-entrepreneurs-marketplace-daily-deals/?couponCode=youtubecfe39 (advanced course, reg $75, this link: $39) Free Udemy Course (40k+ students): https://www.udemy.com/coding-for-entrepreneurs-basic/ Fun Fact! This Course was Funded on Kickstarter: http://www.kickstarter.com/projects/jmitchel3/coding-for-entrepreneurs
Views: 406834 CodingEntrepreneurs
Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation
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
Views: 220411 Launch Excel
Create This AMAZING Excel Application that Tracks Purchases, Sales AND Inventory [Part 1]
Learn The Excel Dashboard That Launched My Career Here: http://bit.ly/BestExcelDashboard Download Your FREE Workbooks From either of the following links: Using Your Email Here: http://bit.ly/InvMgrPt1_Wb With Facebook Messenger Here: http://bit.ly/InvMgrPt1_FbDl See Part 2 Here: https://youtu.be/GodLw1LfTj4 Controlling Purchases, Sales & Inventory can often be a headache, even in Excel. But today all of that changes! In this week's UNIQUE TRAINING Training I will create a POWERFUL Inventory Manager right before your eyes.  In Part 1 of this FREE Training, you will learn: ☑️ Create a single unique single click switch ☑️ Program both Sales AND Purchases in the SAME SCREEN ☑️ Master Conditional Formatting  ☑️ Automated Inventory Count ☑️ Automatically display Product Pictures Got Excel Question? Let us help you with that, Join thousands of the worlds best Excel Experts in Facebook's fastest growing @Excel For Freelancers Group right here: http://bit.ly/groupexcel Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing on YouTube here: http://bit.ly/ExcelForFreelancers_FreeTraining I hope you love these videos, for More Free videos, personalized training and amazing tricks for freelancers, please find and follow us here: Twitter: https://twitter.com/RandyNAustin Website: https://www.ExcelForFreelancers.com LinkedIn: https://www.linkedin.com/in/excelforfreelancers/ Facebook: https://www.facebook.com/ExcelForFreelancers/
Views: 203468 Excel For Freelancers
Learn to connect: PowerApps Excel Spreadsheet hosted in OneDrive
Do you want to learn to use PowerApps Excel Spreadsheets? Then this video is for you. We take an Excel workbook hosted in OneDrive for Business and use it as a data source for PowerApps. This video is the foundation that will let us explore more complicated scenarios in the future. PowerApps for SharePoint https://www.youtube.com/watch?v=BnYe_7fpZRM PowerApps Playlist https://www.youtube.com/playlist?list=PLCGGtLsUjhm2bonhBZuEhZU72QkFjOpc6
Views: 53345 Shane Young
Import JSON Data Into Excel 2016 Using a Get & Transform Query
Connecting Excel 2016 with JSON data is easy. Using Get & Transform (formerly PowerQuery) allows you to write a query to create a table from your JSON data.
Views: 129216 SyntaxByte
How to Install Power Query in Excel 2010 or 2013 for Windows
Learn how to install Power Query with this step-by-step tutorial for Excel 2010 or 2013. If you have Excel 2016 then Power Query is already built-in and located on the Data tab of the ribbon. The first step is to determine what bit version of Excel you have, 32-bit or 64-bit. This can be found on the File menu under Help (2010) or Account (2013). Once you know the bit version you can install Power Query from the following link. http://www.microsoft.com/en-us/download/details.aspx?id=39379 Next, completely close Excel. You might need to close other Office apps like Outlook or Power Point. Run the Power Query installer. Once it finishes, open up Excel. You should see the Power Query tab in the Ribbon. Here is a link to an article with step-by-step instructions. http://www.excelcampus.com/install-power-query/ Checkout my article on an overview of Power Query to learn more. https://www.excelcampus.com/powerquery/power-query-overview/
Views: 80934 Excel Campus - Jon
IMPORTJSON Function - Google Sheets Tutorial - How to Import JSON feed to Spreadsheets
Learn how to import JSON data from API to Google Sheets using user defined IMPORTJSON function. Get the function script here https://www.chicagocomputerclasses.com/google-sheets-import-json-importjson-function/ Google Sheets https://www.google.com/sheets/about/ Company Page http://www.chicagocomputerclasses.com/
Excel VLOOKUP: Basics of VLOOKUP and HLOOKUP explained with examples
Find out how to do a VLOOKUP in Excel and for what situations you can use Excel's Vlookup and Hlookup formulas for. Download the free Excel Vlookup workbook here: http://www.xelplus.com/basics-vlookup-hlookup/ Get the full course: https://courses.xelplus.com/ The Excel VLOOKUP formula can search for a specific category or value in an Excel data table and return the “opposing” value from adjacent columns. HLOOKUP function works exactly in the same way except that it looks horizontally rather than vertically. “V” in VLOOKUP refers to vertical and “H” in HLOOKUP refers to horizontal. If the data in your table has column headers, use the VLOOKUP function. If the data table has row headers and you need to search horizontally across the rows for a “match” then use HLOOKUP formula. Vlookup formulas do not need to have sorted lists. If your Excel table is unsorted make sure you look for an exact match by selecting "false" in the last argument of Vlookup. One major limitation of VLOOKUP is that it cannot look to the left. The values to lookup must always be on the left-most column of the range and the values to return must be on the right hand side. For two-way lookups - If you need to look up values across rows and also columns or multiple rows and columns the best function to use is the Index and Match function. Watch this video to learn more: https://youtu.be/F264FpBDX28 ★ My Online Excel Courses ► https://courses.xelplus.com/ ✉ Subscribe & get my TOP 10 Excel formulas e-book for free https://www.xelplus.com/free-ebook/ EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/ Get Office 365: https://microsoft.msafflnk.net/15OEg Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593 GEAR Camera: https://amzn.to/2FLiFho Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161 Microphone: https://amzn.to/2DVKstA Lights: http://amzn.to/2eJKg1U Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #MsExcel
Views: 443323 Leila Gharani
Retrieving External Data for Excel on Mac
This is a video showing how to get data from the internet, and put it into your excel sheet. -~-~~-~~~-~~-~- Please watch: "PlayBoy Bunny Makeup!!" https://www.youtube.com/watch?v=rUP2zJVIOrU -~-~~-~~~-~~-~-
Views: 14972 makeup17jam
Q&A: Using AutoFilter, Advanced Filter, and Macros in Excel
In this video, Neil Malek demonstrates how to create an Advanced Filter controlled by a macro. Get your questions answered - neil@knacktraining.com http://knacktraining.com/dl/FilterMacros.txt - Download today's macros. "Slow Burn" Kevin MacLeod (incompetech.com) Licensed under Creative Commons: By Attribution 3.0 http://creativecommons.org/licenses/by/3.0/
Views: 3613 Neil Malek
Drop Down List in Excel
http://www.contextures.com/xlDataVal01.html Make data entry easier -- select valid entries from a drop down list on the Excel worksheet. Instructor: Debra Dalgleish, Contextures Inc. Get Debra's weekly Excel tips: http://www.contextures.com/signup01 More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html Data Entry Pop Up Kit: http://www.contextures.com/datavalidationmultiselectpremium.html '---------------------------------- Transcript for Drop Down List in Excel You've created an order form, and instead of having people type the name of the item they'd like to order, you're going to make a drop down list so that people can just select from that list. That way, you'll prevent typing mistakes and people ordering things that aren't available. To start, we're going to create a list of items and we've done that on the sheet called Lists. We've typed the items in column B and now i'm going to select all those cells and we're going to give that a group of cells a name. To do that we'll click in the name box and type -- this is going to be FruitList -- the name has to be all one word We'll type, and then press the Enter key, and now with those cells selected, you can see the name Now we'll go back to be order sheet which is called data entry, and we'll select the cells where we want the list To create the list we'll use data validation, so go to the data menu, and click validation On the settings tab we'll select List -- that's what we're going to allow For the source, we start with an equal sign, and then type the name of our list Or on your keyboard you can press F3, and that will bring up a list of all the names that you've created So there's FruitList. Click ok and now it's entered for us We'll click OK, aand now you can click on any of those cells and select from the drop-down list
Views: 1361549 Contextures Inc.
How to Pull in Data from a Website into an Excel Spreadsheet
This tutorial explains how to index tables on specific websites and extract real time data into an Excel spreadsheet.
Views: 110945 edutechional
Using Excel and VBA to get API data
Tutorial on the use of Excel VBA to get 12 month LIBOR (USD) from Fed Reserved Economic Data site.
Views: 101119 Bane Data Solutions Ltd
Linking Excel data with Word to create up-to-date reports from the Excel file
The video covers the steps on how to link an Excel file with a Word document. The procedure is for Excel/Word 2010. It should work the same way for other versions too. For more information and other tutorials visit us at http://kaceli.com. If you want to take get a deeper understanding of Microsoft Access, take a look at http://learn.kaceli.com Copyright notice: These videos may not be downloaded or distributed in any way without permission from Sali Kaceli. Contact me if you have such a need.
Views: 84143 Sali Kaceli
How to Import CSV File Into Excel
How to Convert CSV to XLS Importing CSV Files into Excel How to convert a csv file to Excel 2010 Convert a CSV File to Excel XLS Importing Text Files in an Excel Sheet CSV to XLS Converting a Text File (.txt, .prn, .csv) to an Excel 2003/2007/2010 How do you Convert CSV files to Excel How to Import Contacts from Excel or a CSV File How To Import a CSV File Containing a Column With a Leading How do I make a CSV file for import from Excel? How to export Excel data to CSV files in Excel? I have trouble opening CSV files with Microsoft Excel.
Views: 433941 ProgrammingKnowledge2
How to Connect Excel to the Internet?
The following video is based off of an older version called, "The Automated Spreadsheet "Hello, this is an alert from your spreadsheet. Call your office ASAP."" It was written by Anna M. Rose and Jacob M. Rose. Basically, by following these steps two things are able to happen on Excel: 1. it will automatically update the price of stocks you have chosen, 2. it will email you anytime your stock is below a specific price you designated for your stock. This is a great tool to use when setting up your personal stock portfolio and helps you design it with your own personal budget.
Excel Magic Trick 528: Check Two Lists For Discrepancies MATCH and VLOOKUP functions
See how to check two data sets (lists tables) to see if there are Discrepancies using MATCH and VLOOKUP functions function. See Conditional Formatting TRUE FALSE formulas using ISERROR and comparative operators to highlight records not in list and records that have discrepancies. Match Two Lists. Match 2 Lists.
Views: 178849 ExcelIsFun
Import Data from the Web into Excel
http://alanmurray.blogspot.co.uk/2013/06/import-data-from-web-into-excel.html Import data from the web into Excel. Importing data from the web creates a connection. This connection can be refreshed to ensure your spreadsheet is up to date.
Views: 198227 Computergaga
Extract Data based on a drop down list selection in Excel
In this video tutorial, learn how to extract or filter data in Excel based on a drop down selection. This Excel trick is extremely useful in situations where you have a huge dataset and you want to extract part of it by making a selection. For example, suppose you have the sales transaction records or various products. You can use this technique to select the product item from the drop down list and all the records for that item would get extracted and listed separately. Since this is dynamic, you can change the selection from the drop down, and the results would update. There are three steps in extracting data based on a drop down selection: -- Create a Unique list of items. -- Add a drop down to display these unique items. -- Use helper columns to extract the records for the selected item. It also uses Excel formulas (INDEX, MATCH, ROWS, SMALL) to extract the data based on the drop down selection. It can work for extracting the data on the same or different worksheet in Excel Step-by-step written tutorial and download file: https://trumpexcel.com/extract-data-from-drop-down-list/ -~-~~-~~~-~~-~- Find Amazing Online Excel Tips and Tricks: https://trumpexcel.com/ -~-~~-~~~-~~-~- Let's Connect: Google+ ► https://plus.google.com/+Trumpexcel Facebook ► https://www.facebook.com/Trumpexcel Twitter ► https://twitter.com/TrumpExcel Pinterest ► https://in.pinterest.com/trumpexcel/ TrumpExcel Channel: https://www.youtube.com/c/trumpexcel
Views: 315994 Trump Excel
Advanced Excel - Data Validation and Drop-Down Lists
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 this video is how to create Excel drop-down lists so that the person entering data can simply click a button and choose from a list of possible entries. Movies Mentioned in this Video: Dirty Rotten Scoundrels: http://amzn.to/2xTpck1 The Princess Bride: http://amzn.to/2yk3tDc Ladyhawke: http://amzn.to/2xOhLsA Stardust: http://amzn.to/2yjJvs9 Young Sherlock Holmes: http://amzn.to/2xaJJNv Mystery Men: http://amzn.to/2yRmQ3r Music Mentioned in this Video: Classic Synthpop and New Wave: Depeche Mode - Violator: http://amzn.to/2utJMqp Alphaville - Forever Young: http://amzn.to/2tl4gle OMD - Messages: The Best of OMD: http://amzn.to/2uyz1Ct New Music by Classic Synthpop Bands: A-ha - Foot of the Mountain: http://amzn.to/2tbfrsv Alphaville - Catching Rays on Giant: http://amzn.to/2tbD445 Underground Modern Synthpop: Code 64 - Departure: http://amzn.to/2tbEtbd Echo Image - Compuphonic: http://amzn.to/2uEvzr4 ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents
Finance with Excel for Mac: Getting External Data
This video is to teach the user how to get data from the internet, such as data from a table posted on a web page, into Microsoft Excel for Mac.
Views: 28889 Peter Dixon
Adding a Simple VBA Button to Excel
Demonstrates how to add a simple button to an Excel sheet to run a VBA program (macro).
Views: 319852 Peter Casey
HP UFT/QTP - Import Data in Excel and use in Scripts
HP UFT/QTP - Import Data in Excel and use in Scripts Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Pavan Lalwani Tutorials Point India Private Limited
How to Backtest A Trading Strategy in Excel
This video shows how anybody can test their own trading strategies using Excel. I demonstrate how to use historic price data and to calculate technical indicators. Then I show how to input the trading logic and look at the results. Read the accompanying article for more information: http://bit.ly/1ZGzKMj Full subtitles are available on this video. Click on Subtitles to view. How to Develop a Trading Strategy is the subject of my eBook, available in the Amazon Kindle Store: http://amzn.to/1OccZJE Follow me on twitter: http://bit.ly/19etSBO Facebook: http://on.fb.me/1715mCE Or Google+ http://bit.ly/1zRkAWi www.tradinformed.com
Views: 22035 Mark Ursell
Trade using excel with real time data
Learn about our new offering in API trading. Use excel to monitor feeds, order, and positions in real time. Also, build your own strategies in excel using real-time data. Open Upstox account: https://upstox.com/open-demat-account/ Get your API key and secret: https://developer.upstox.com Forum: https://upstox.com/forum Traders Interest: Upstox Products & Tools: https://upstox.com/products/ Brokerage charges: https://upstox.com/pricing/ Open Demat Account: https://upstox.com/open-demat-account/ Learning Center: https://upstox.com/learning-center/ Help Center: https://upstox.com/help-center/ Become a Sub-Broker: https://upstox.com/sub-broker/ Upstox Social Profiles: Facebook: https://www.facebook.com/upstox/ Twitter: https://twitter.com/upstox
Views: 16997 Upstox
Real Time API Data pulled into Excel using Microsoft BI tools Power Pivot, Power Query, & Power View
This video gives an overview of the process by which to pull Seattle Real Time Fire 911 Calls data into Excel using an API. The API is called using Microsoft Power Query, the data is then modeled in Power Pivot, and an interactive data visualization is shown using Microsoft Power View. The API data can be refreshed throughout the day to obtain updated data from the source database.
Views: 22118 Insights & Outliers
Excel Magic Trick 923: Recorded Macro Basics: Click Button To Move Data To Table On Another Sheet
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Enter Data On One Sheet and then click Button To Send Data To Table on Second Sheet 2. Recorded Macro: Move Record From Data Entry Sheet To Table On Second Sheet 3. Learn how to Show Developer Ribbon (Excel 2010 = Right-click Ribbon, Customize Ribbon, Checkbox for Developer Ribbon) 4. Keyboard: Alt + F8 = List of Macros 5. Keyboard: Alt + F11 = VBA Editor 6. Learn how to use Absolute and Relative References in Recorded Macro 7. Add Form Button To Sheet that can be clicked to execute recorded Macro. 8. Absolute References = Selecting Cells with Macro Recorder on means Absolute Movement 9. Relative References = Selecting Cells with Macro Recorder on means Relative Movement 10. View Code: Range function for Absolute References, OFFSET Function for Relative References
Views: 348290 ExcelIsFun