David Rivers shows us how to create navigation forms in Microsoft Office 2010 without writing codes or using logic. A navigation form is kind of like a homepage that will give you a list of reports. T ...
1. The following instruction describes how to generate sub totals in Microsoft Excel Sheet. 2. Take Region as a Primary column and Sales Rep as a Secondary Column. 3. First method to sort: Select a ce ...
There is a new function in MS Excel 2010 called 'Sparkline' which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to 'Insert' tab and then select 'Sparklin ...
There are many functions in Microsoft Excel. One function that people rarely use is the Repeat function or REPT. In this video, an example used is a chart of people and their sales of a certain item. ...
In this installment of the Excel Basics Series you'll learn how to use formulas to calculate an annual interest rate, as well as breaking it down to a monthly rate and an effective annual rate. A gene ...
Excel Magic Trick 475 talks about Sumproduct for bank deposit calculation. Here, the total money can be calculated by just a click. Total is taken as Sumproduct and can be obtained by clicking on the ...
Need to compare two datasets and extract the new values? In this the 539th installment of ExcelIsFun's series of Excel magic tricks, you'll see how to use the MATCH function, the Join Symbol (& Ampers ...
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks. See how to ...
Want to retrieve a value in a given Excel column based on criteria from multiple other external columns? You can. And it's not so very hard provided you know what to do (hint: you'll use the LOOKUP fu ...
Want a way to dynamically reference the number of instances of a given word in a Microsoft Office Word document from Excel? Who doesn't, am I right? In this Microsoft Excel tutorial from ExcelIsFun, t ...