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
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
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
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
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
Create you own Excel functions and add-ins in few steps.
Views: 13926 Excel to Excel
How to make Excel charts format automatically your negative values to colors of your choice.
Views: 10842 Excel to Excel
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
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
Easy and quick way to to create animated videos and Gifs using Powerpoint.
Views: 34995 Excel to Excel
Helpful Pivot table tips and tricks that everyone should know. Handle pivots in simple and creative way.
Views: 122316 Excel to 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
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
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 save time by setting up default formatting for your pivot tables?
Views: 2929 Excel to Excel
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
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
Short tutorial explaining how to add images to your Excel Spreadsheet.
Views: 5433 Excel to Excel
A tutorial to guide practically how to sum ONLY negative or positive numbers in Excel.
Views: 860 Excel to 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
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
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
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 Drill Down in Power BI charts and bars , Customize Axis Scales.
Views: 2384 Excel to 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
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
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
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
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
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
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