Видео

In this video, you will learn different ways in which table can be created and few introductory features of the same along with a bonus tip to create alternate colour bands in your data #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

In this video, you will learn how to use forecast sheet feature to predict the future values using the past values as the base in an Excel sheet. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

In this video, you will learn how to use create a drop down menu so as to ease the data entry as well as minimize the errors which inadvertently happen while entering the data in an Excel sheet. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

In one of the previous videos you have seen various methods by which filters can be applied to data. In this video, you will learn how to use the applied filters so as to gain some insights out of the data / understand the data in a better way. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

In this video, you will learn how to select a large amount of data to be used in a very easy and fast way, in an Excel sheet. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

In this video, you will learn three methods to apply filter on a given data present in an Excel sheet. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

In this video, you will learn a formula to find largest values in a given data present in an Excel sheet. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

In this video, you will learn three methods to insert a row or a column into a Excel sheet. The third method uses only keyboard shortcuts which makes it possible to complete this task in a jiffy. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

If you are a long list of data with certain data repeated multiple times, this video will help you to find the unique list out of that data. Use Advanced Filter feature in Excel. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

If you are having subscript and superscript in your data, Excel doesn't provide the feature directly on the ribbon (as word does) to apply it. In this video we see the location from where we can use these features. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

Options to calculate EMI | PMT formula in Excel Use PMT formula in Excel. This helps in calculating the EMI value for the loan taken for a certain tenure at rate of interest (which is assumed to be constant over the full tenure of loan) TIMESTAMPS: 00:00 Intro 01:00 Using Math formula 04:00 Excel PMT function 07:51 Minimum values in PMT #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

Keep important columns and rows always visible Use Freeze Panes feature in Excel. This feature helps in keeping required rows and columns always visible and thus improves the understanding of the data . #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks TIMESTAMPS 0:00 Intro 1:40 Freeze Top Row 2:19 Freeze First Column 2:45 Effective way to use Freeze Panes

Transpose data contained in rows into columns or columns into rows in a jiffy Use Transpose feature in Excel instead of Transpose formula. This feature helps in moving the data from rows to columns (or vice versa) i.e. transposing the data. #ProductiveExcel #excelInExcel #ExcelTips #excel #exceltricks

Add comment in a cell for future reference | How to add information to a cell for reference Use Add comment feature in Excel. Add comment provides a way to add comment to a cell which can be used as a way to convey information with the people the file is shared with, moreover it can used as ways of passing instructions w.r.t. say which data should be filled in the cell. Also it acts as a way to...

Sparklines | Productivity Tip 19

Search the Menus | Productivity Tip 18

Difference between Dates in Years | Productivity Tip 17

Make Formulas Easy to Understand | Productivity Tip 16

Find Trend in Data | Productivity Tip 15

Convert Data | Productivity Tip 14

Fill Data in a Flash | Productivity Tip 13

Sum of data in a column | Productivity Tip 12

Ctrl Shift "a" | Productivity Tip 11

Highlight the cells containing formulas | Productivity Tip 10

Format a Cell in Jiffy (Using formatting of another cell) | Productivity Tip 9

See Formulas Present in Excel Worksheet | Productivity Tip 8

Avoid Entering Wrong Formula Name | Productivity Tip 7

Add New Series in Chart | Productivity Tip 6

Insert chart | Productivity Tip 5