- Видео 17
- Просмотров 75 155
EZ Excel
Канада
Добавлен 29 май 2020
The main purpose of the channel is to share some tricks and hidden capabilities of Excel that might not be so obvious, popular, or known by the majority of people using the program. These videos will be especially helpful to students and newly hired. All videos are made with real-world examples and are easy to follow and understand.
How to Hide Repeating Labels in Excel Data Set - Quick Tip
Quick and easy trick to hide repeating values in Excel data set and still being able to further manipulate the data by sorting and filtering. This formatting will also remain when printing the data on paper.
Time Stamps
00:00 Introduction and setting expectations
02:01 Selecting the cells in the table with repeating labels
02:18 Applying conditional formatting
03:46 Important to know
04:27 Testing filtering of the data after the repeating labels have been hidden
Time Stamps
00:00 Introduction and setting expectations
02:01 Selecting the cells in the table with repeating labels
02:18 Applying conditional formatting
03:46 Important to know
04:27 Testing filtering of the data after the repeating labels have been hidden
Просмотров: 859
Видео
Restoring Missing Repeating Labels in Excel - Quick TIP
Просмотров 3414 года назад
Quick and easy trick to clean data in Excel and convert table data from Outline layout to Tabular by restoring missing data labels, which will help for further data manipulation in the form of sorting and filtering. Time Stamps 00:00 Introduction and setting expectations 02:03 Selecting the blank cells in the table 03:00 Formula to populate the blank cells with labels
How to Apply Complex Criteria with Advanced Filter in Excel
Просмотров 2,1 тыс.4 года назад
Learn how to apply complex criteria with OR conditions, using advanced filter options on a large data set. Additionally, learn how to save the filtered data on a new spreadsheet, without copying and pasting and how to get the result in a table formatted with only the desired headers/columns and not with all the original headers. Time Stamps 00:00 Introduction and setting expectations 01:15 Sett...
Get Dynamically Updated Data From Web in Excel in Real Time
Просмотров 3,9 тыс.4 года назад
Learn how to import real time Data in Excel from frequently updated website & refresh after a certain time frame or with push of a button. Use the data for further calculations, reports, pivot tables, visualization & make informed future decisions. Time Stamps 00:00 Introduction and setting expectations 00:21 Case Study 02:28 Query data from Web source 03:49 Data transformation in Query Editor ...
Dynamic Currency Calculator in Excel with Data from Web - Mini Project
Просмотров 5784 года назад
Learn how to build dynamically updated exchange rate calculator in Excel, getting data from Web & easy to refresh currency rates to the most recent daily rates. With this mini project we will practice Power Data Query (Get & Transform Group), Data Validation, VLOOKUP function & recording and using Macros. Time Stamps 00:00 Introduction and setting expectations 02:26 Getting data from Website ta...
Add Sparklines to Your Data in Excel for Visual Representation
Просмотров 1114 года назад
Quick and easy way to add visual effect to your data in Excel with Sparklines - tiny chart inserted in single cell, showing the data trends & highlighting maximum and minimum values.
Dependent Drop-Down List with Data Validation in Excel
Просмотров 2384 года назад
Learn how to build a template with drop-down lists, using Data Validation to cell range, named range and INDIRECT reference to a value in a cell (Dependent Drop-down List).
Master (Dynamic) Named Ranges in Excel
Просмотров 8004 года назад
Learn the benefits of using Named Ranges; how to create, update and delete Named Range; how to create multiple Named Ranges at the same time; how to refer to Named Ranges in formulas and 3 ways to create Dynamic Ranges.
Manage Data in Excel Effectively by Using Tables
Просмотров 6164 года назад
Learn how to create tables, name the tables & use tables as reference in formulas, effectively keep data & get dynamically updated results. Time Stamps 00:00 Introduction and benefits of using tables in Excel 00:56 Three ways to create a table 05:11 Naming the table 06:10 Referring to Tables in formulas 10:28 Inserting a Slicer 12:23 Converting Tables back to Ranges
World Geographic Heat Map With Covid-19 Data in Excel
Просмотров 2,7 тыс.4 года назад
Step-by-step tutorial on how to build World Geographic Heat Maps in Excel, using Covid-19 data from World Health Organization.
How to Create a Heat Map with Excel
Просмотров 55 тыс.4 года назад
Learn two easy ways to create a Heat Map in Excel with Conditional Formatting - visually representing the variation of tracked data in variety of colours with different intensity and colour hues.
10+ Examples of Conditional Formatting in Excel
Просмотров 3614 года назад
Learn how to use Excel's Conditional Formatting options and apply different background colours as well as other features, like Data Bars, Icon Sets and Colour Scales to emphasize data, make it eye-catching, help to spot trends and patterns.
How to use Auto Fill, Custom Lists & Flash Fill in Excel (with 10+ examples)
Просмотров 6244 года назад
10 examples of how to use Auto Fill, Custom Lists and Flash Fill to safe time, speed up your work and make your daily Excel tasks less tedious and boring. Shortcut for Flash Fill: CTRL E
Fun Mini Excel Project: How to Create Your Own Dynamic Excel Unit Converter
Просмотров 6 тыс.4 года назад
Step by step instructions on how to build a dynamic Measurement Converter in Excel, practicing dependent drop-down lists with data validation, defining lists names, functions like VLOOKUP, INDIRECT & CONVERT, as well as recording and using a macro. Time Stamps 00:00 Setting the expectations on the final Project result 00:52 Demonstration of how the Measurement Converter will work 03:10 Creating...
Master Find and Replace in Excel
Просмотров 2424 года назад
Learn how to use Excel's Find and Replace feature to quickly search for specific text, number or special character and replace them with others. Learn how to use Excel's Go To Special feature to select all cells with formulas, comments, conditional formatting, constants, data validation, etc.
Excel Introduction to Workbooks and Worksheets
Просмотров 2114 года назад
Excel Introduction to Workbooks and Worksheets
Excel Introduction to Ribbon Settings
Просмотров 2324 года назад
Excel Introduction to Ribbon Settings
How did u make that legend?
Great video!🎉 very helpful 😊😊
Thank you so much, god bless you😀
Helpful tutorial. Thanks.
too good!!
can you do a video for Mapping a country color
Hii, how do I place this heat map in a dashboard
good job
actually tears were already falling down my face SO THANK U
i love u so much thank u for ur help i was actually about to cry
How to convert from km to miles and miles to km using same two cells only?
Thank you! amazing tutorial
May I please inquire as to whether you can provide the step-by-step directions and instructions as to how to create this same live heatmap in Excel...and more specifically with the use of Microsoft Excel RTD/Real-Time Edition...and whereas I am seeking to establish a realtime stock market DDE/dynamic link and whereby an array of stock market exchange tick-by-tick trades are constantly and instantly updated autonomically/automatically @ ultra high-frequency....Thank you
how you add legend scale to define the values ??
Great video. How export it as image?
Very well explained .. tq
Nice and clear description of Heatmap
I really liked the tutorial its the best unit converter I have seen so far, however I need one able to convert 6'1" into International System inappropriately called "metric" how do you build one like that? should I just make a table of conversions? because if I place 40 cm = 1'4" it will give me 1. some decimals, I dont want it in decimals, I want it to express inches
Thank you
great video. thank you
Well thought out and presented video, thanks!
nice one keep uploading, you will grow.
it worked as you demonstrated 100% Ecstatic
very useful best wishes please do more
Impressive! thanks so much!
This, this right here, is what I like to see in my recommended
this what i need ,but can how if i want to make custom unit like pack that consists of 8 portion ?
Hi @dunia_bayi_luci, this Unit converter is using a built-in Excel function that is working with a limited list of metric and US measurements. If you want to build your own custom converter, you can use the method used in my other Excel project for Exchange rate calculator: ruclips.net/video/DGRTa2bIqR4/видео.html&ab_channel=EZExcel. First, you should create table with the custom conversions similar to the table with exchange rates (for example: in column A: portion, column B: 8 (meaning 1 pack = 8 portions), column C: 1/8 (meaning 1 portion = 1/8 packs). Hope this helps.
Your Video was just what i was looking for and very helpful. Thank you so much!!
I also found this video really helpful
Keep up the good videos
I really enjoy your excel videos
Love this video! It was very helpful
This is a great tool for Univariate Tables ("consists of observations on only a single characteristic or attribute"). For Multivariate tables, I used simple Powerpoint VBA to generate a Geographic Heat Map. With minor changes, the code will work for Excel too. ruclips.net/video/1cIKfUt4pL4/видео.html
If you find this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos.