![Excel spreadsheet displaying a formula for reverse two-way lookup with sample names and associated age data.](https://assets.content.technologyadvice.com/634757213043985746_5a797189e6.webp)
In this Excel magic trick video the tutor shows how to perform reverse two way look up for date and time columns and row headers. In this tutorial he shows a spreadsheet that contains dates in columns ...
![Spreadsheet showing data with headers and values in an Excel format.](https://assets.content.technologyadvice.com/634755821222180903_a51460a011.webp)
ExcelIsFun will show you how to use indirect text and substitute in Excel. Select any date and product and create an intersession. Use Vlookup to look up your columns. Use the match function to find ...
![Spreadsheet showcasing car brand frequencies, including Ford, Toyota, and Honda, with calculations for percentage and mutual exclusivity notes.](https://assets.content.technologyadvice.com/634752726057472247_f4801c5398.webp)
This Excel Statistics series of video shows how to calculate proportions and percentages in Microsoft Excel. This video shows how to do percentage calculations using formulas in Microsoft Excel. To ma ...
![Spreadsheet displaying sales data with highlighted cells for total calculations.](https://assets.content.technologyadvice.com/634752634259162381_016b276160.webp)
Excel Fun will show you how to get the most out of your Excel experience by learning about pivot tables. With Excel and the latest Excel 2010 you can learn how to create a pivot table. Learn where in ...
![Excel spreadsheet showing a formula to calculate the number of years worked between two dates.](https://assets.content.technologyadvice.com/634753164380644688_808660983d.webp)
In this Excel magic trick video the tutor shows how to use the years worked formula using Yearfrac, Int and Datedif functions. He says that using this trick you can find out how many years some one ha ...
![Spreadsheet displayed on a computer screen with data entries.](https://assets.content.technologyadvice.com/634754285143232631_3967d4276f.webp)
This how to video describes how to download and install a free beta version of Microsoft Office. This video directs you to a Microsoft site that allows you to download the beta version of Office. The ...
!["How to Use Microsoft Word to create a brochure" cover image](https://assets.content.technologyadvice.com/634754509366014457_023ca066d9.webp)
Rod Milstead brings us a video on how to create a brochure in Microsoft Word. He shows us how to navigate Microsoft Word in order to create the brochure. He gives us step by step instructions on how ...
![Spreadsheet containing data with various cell entries including numbers, text, and logical values.](https://assets.content.technologyadvice.com/634753410785727835_d0b9d472ae.webp)
ExcelIsFun shows you how to detect if a cell has a number or text. The first thing he explains is to find out what are the different types of things that can go into a cell. Next he talks about the us ...
![Excel formatting options for a selected cell.](https://assets.content.technologyadvice.com/634752893435839656_059b41474d.webp)
In this video the author shows how to perform custom number format for turnover ratio in a Microsoft excel document. He shows how to perform custom number formatting in which he shows how to display a ...
![Presentation slide with text: "I am RK? This is all random Sup ROCKS!!!"](https://assets.content.technologyadvice.com/634753603765447445_c58115a4d6.webp)
Need to make a Powerpoint presentation and you're not sure where to begin? In this three-part video tutorial, learn how to make a Powerpoint presentation from start to finish. A Powerpoint presentatio ...