Videos uploaded by user “Excel to Excel”
Vlookup simply explained
Simple explanation of vlookup function and made it easy for everyone to learn.
Views: 834767 Excel to Excel
Accounts receivable excel - Quick Aging Report using Excel
Use Excel to determine which customers are paying on time, which are not, and how far they are behind the payment date. This analysis assists in estimating bad debts and in establishing credit guidelines. the aging report categorizing receivables as "current," "30 days," "60 days," "90 days," and "120 days and over." The purpose of this report is to show the business owner what receivables need to be dealt with more urgently because they have been overdue longer.
Views: 63098 Excel to Excel
How to compare two Excel Spreadsheets for differences
The tutorial shows how to compare two Excel files /sheets for differences : - Excel's compare feature - Via formulas and conditional formatting
Views: 37143 Excel to Excel
Power query excel 2013 tutorial
Introduction to Power Query for Excel, how to design a power query and import data from various sources. This session should give you and understanding of how you can create queries and utilize this functionality to enhance your data analysis capabilities.
Views: 189692 Excel to Excel
How to add Google Maps to powerpoint 2016
A quick tutorial to add Google maps to your powerpoint presentation.
Views: 46486 Excel to Excel
Trick to change field names in pivot tables
Quick tip to change field names in pivot tables using keyboard.
Views: 10596 Excel to Excel
5 Excel tips and tricks you must know
This is a tutorial describing various tips and tricks to boos your productivity in Excel when working with your spreadsheets.
Views: 68031 Excel to Excel
Google maps secrets MS Excel uploads
Use Microsoft Excel to build and setup your google maps. with one click you can upload thousands of links and connect them.
Views: 32650 Excel to Excel
Mail merge excel to outlook automatic emails
Mail Merge is a very useful tool that allows you to produce multiple emails, letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. When performing a Mail Merge, you will need a Word document (you can start with an existing one or create a new one) and a recipient list, which is typically an Excel workbook.
Views: 14933 Excel to Excel
How to create a simple Pivot Macro in Excel?
A very simple tutorial to automate and develop a simple Pivot Macro in Excel which can be helpful in avoiding repetitive pivot creation tasks for you. Link to the tutorial on how to enable developer. https://www.youtube.com/watch?v=d6hZ1rdF6uQ
Views: 16264 Excel to Excel
Excel add ins : How to Make your own Excel Add-ins
Create you own Excel functions and add-ins in few steps.
Views: 13926 Excel to Excel
Excel Charts : Automatically Highlight negative values
How to make Excel charts format automatically your negative values to colors of your choice.
Views: 10842 Excel to Excel
How to enable Excel Add-ins
Tutorial to explain how your excel add-ins can be enabled.
Views: 15735 Excel to Excel
Forecasting in Excel and Trends Functions
You can use this function to predict future sales, cash and inventory, or consumer trends. Calculates, or predicts, a future value by using existing values. Formula syntax and usage of the FORECAST and TREND functions in Microsoft Excel.
Views: 17163 Excel to Excel
How do I use drag fill in Excel for android?
A short tutorial on how to drag fill in Excel for Android (top create rising numbers, days of the week, months of the year...)
Views: 21952 Excel to Excel
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 role Excel plays in daily work. However, both for beginners and advanced users, there are still many useful tips and tricks that are inevitably overlooked. Here are 20 useful Excel spreadsheet secrets you may not know. Please note that all these functions are based on Microsoft Excel 2013.
Views: 1126134 Excel to Excel
How to create animated videos and Gifs using Powerpoint?
Easy and quick way to to create animated videos and Gifs using Powerpoint.
Views: 34995 Excel to Excel
12 useful Pivot Tables Tips & Tricks everyone should know
Helpful Pivot table tips and tricks that everyone should know. Handle pivots in simple and creative way.
Views: 122316 Excel to Excel
Date picker : Popup Calendar for Excel
One of the biggest problems in maintaining "good" data is the entry of dates. People seem to get confused about entering dates. Should they enter dd/mm/yy or mm/dd/yy? Do they enter slashes or dashes or dots? And what was the date of the third Thursday in September last year anyway? What you really need is a calendar! Use an Excel Calendar control or Date Picker to fill in dates.
Views: 183861 Excel to Excel
Mouse tricks Excel - Time-saving Mouse tricks in Excel spreadsheets
Little tricks can help you become a more powerful Excel user as they simplify and speed up your work. And there’s a delicious range of mouse tricks I’d like you to discover today. You might say to yourself “Surely I know how to use the mouse in Excel, everyone knows. Why do I need any more tips and tricks?” I understand the feeling – but actually there are so many ways to really use the mouse effectively in Excel.
Views: 13759 Excel to Excel
Excel HR dashboard - Chart for HR Professionals
Add a variety to your reporting with innovative graph for your presentations, and precise data representation using Excel add-ins creatively.
Views: 21377 Excel to Excel
Excel slicer - How to build Dashboards that Persuade, engage and inform
How to automate dashboards through Excel slicer. What’s new for the Slicer Filter object making them great for dashboarding scenarios. Slicers can be contextual meaning that they can underline the information that need your attention avoiding to spend time on items with no data for example by shadowing them.
Views: 12290 Excel to Excel
How to copy File directory to Excel Spreadsheet
A simple demonstration of how you can copy list of files in Excel and then export it to any office application.
Views: 2906 Excel to Excel
Setting up default format for your Pivot tables in Excel
How to save time by setting up default formatting for your pivot tables?
Views: 2929 Excel to Excel
Top 10 skills that employers want?
Based on a number of surveys on the skills required by graduates undertaken by Microsoft, Target Jobs, the BBC, Prospects and other organisations, here is our summary of the skills which were most often deemed important.
Views: 20300 Excel to Excel
Import data from web to excel - Sports | Statistics | Weather forecast
Import data into dynamic tables in Excel and stay up to date with latest information without browsing, Run time data or statistics analysis, maybe it be Sports information, weather forecast or statistics,connect link once and enjoy forever, illustrated with multiple examples.
Views: 21487 Excel to Excel
How to build Excel trafficlight Dashboards using Icon sets
Icon sets give you an opportunity to create visual effects in your data to see how the value of a cell compares with other cells. Learn how to implement and manipulate icon sets through the user interface and pro-grammatically and build your own Excel traffic-light Dashboards
Views: 31664 Excel to Excel
How to add background images to excel spreadsheets
Short tutorial explaining how to add images to your Excel Spreadsheet.
Views: 5433 Excel to Excel
How to sum ONLY negative or  positive numbers in Excel?
A tutorial to guide practically how to sum ONLY negative or positive numbers in Excel.
Views: 860 Excel to Excel
How to fix Last digits in cells of Excel
Solution when last digits are changed to zeroes when you type long numbers in cells of Excel. When you type a number that contains more than 15 digits in a cell, Microsoft Excel changes any digits past the fifteenth place to zeroes.
Views: 16281 Excel to Excel
How to use MAXIFS function in Excel 365?
The MAXIFS function returns the maximum value among cells specified by a given set of conditions or criteria. This function is available if you are an Office 365 subscriber and have the latest version of Office installed. It's also available with Excel Online, Excel Mobile, Excel for iOS, and Excel for Android phones and tablets.
Views: 1490 Excel to Excel
How to make Effective Collection Calls
Secrets to get paid faster, How to make your collection calls Right and Make them more effective and What to Say during a Collection Call
Views: 79127 Excel to Excel
Dynamic Excel Heat Maps for complex data dashboards
Excel heat map add-in is a graphical representation of data where the individual values contained in a matrix are represented as colors, helping you to create dynamic and spot-on visual analysis for your presentations.
Views: 26755 Excel to Excel
Subtotals in Excel - Tips & Tricks for Calculations
Easy and Fun way of learning automated Excel subtotals and its calculations. How to quickly insert subtotals in Excel and its different uses.
Views: 10409 Excel to Excel
How to make Doughnut Charts
Using Microsoft Office Excel, you can quickly turn your data into a doughnut chart, and then use the new formatting features to make that doughnut chart
Views: 5933 Excel to Excel
Excel tutorial : Table of Content Automation
How to make Table of Content Automatically and very quickly for your Excel spreadsheets. Link to Macro file https://www.dropbox.com/s/2du4eyfcxc7hys5/ExcelTOC_LIST.xlsm?dl=0
Views: 2202 Excel to Excel
One Click and remove all comments from Excel
How to remove all sorts of comments from your Excel spreadsheet with only 1 click.
Views: 645 Excel to Excel
Power BI: How to Drill Down Charts, Customize Axis Scales
How to Drill Down in Power BI charts and bars , Customize Axis Scales.
Views: 2384 Excel to Excel
How to clean data in excel ?
How to clean up raw data for processing in Excel. if you have multiple spaces in between numbers you can easily clean it through demonstrated formulas which are stated below. Formula 1: =TRIM(CLEAN(SUBSTITUTE(A1,CHAR(160),""))) Formula 2: =SUBSTITUTE(A2," ","") Please see details in tutorial to apply these properly.
Views: 2165 Excel to Excel
How can I lookup a value from Multiple Columns in Excel?
Simple tutorial to demonstrate how you can fetch information from multiple columns based on a certain criteria through a very simple example.
Views: 777 Excel to Excel
Tips and Tricks — Charts in Excel for Professionals
Chart Formatting Techniques and Tricks 1- Handy Keyboard short cut 2-Chart formats 3-Extending charts 4-Automate your charts 5-Transfer formats to other charts 6-Managing sizes of charts 7-Formatting and display (Millions)
Views: 1848 Excel to Excel
Quick Tip View workbook side by side in Excel
View two worksheets of different workbooks side by side in Excel, without sharing your screen share your excel spreadsheet.
Views: 792 Excel to Excel
How to lookup partially matched values? Crazy lookup in Excel
Real workplace problem, when you need to lookup one value in Excel but you have part of the information and you need to figure out corresponding values. Simple solution to find values by only small part of the cell.
Views: 880 Excel to Excel
Hlookup for Beginners - Microsoft Excel
This tutorial explains describes the formula syntax and usage of the HLOOKUP function in Microsoft Excel. Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find. The H in HLOOKUP stands for "Horizontal." Applies To: Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013
Views: 590 Excel to Excel
How to add Shapes and Icons to charts
Tutorial demonstrating how to add Shapes and Icons to charts
Views: 726 Excel to Excel
Create dynamic animated KPI charts in 2 minutes using Excel
An easy way to create a dynamic and great looking Key performance indicator (KPI) or performance measurement in just 2 minutes using Office 2013. step by step approach to quickly create a chart and impress your manager/ audience.
Views: 7559 Excel to Excel
How to fix and boost Excel's calculation speed
We often can't understand errors in excel files with large data, slow calculation speed and sometimes endless calculations making it very difficult to work, let me share some tips & tricks to handle such excel files by understanding excel’s Calculation Mechanics and Background Process to fix such errors.
Views: 17519 Excel to Excel
Tips for using Excel Clipboard
How to use MS Excel Clipboard and apply multiple options in that
Views: 732 Excel to Excel
Make Excel Speak - Text to Speech Magic
Handy feature Text-to-speech in Excel enabling you to make excel speak upon each enter. Instant productivity command.
Views: 6833 Excel to Excel
How to use Excel Macros Efficiently
Guidance on how to store and refer to macros in your workbooks more efficiently and smoothly.
Views: 752 Excel to Excel