Microsoft Search Results

How To: Calculate salary based on work experience in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 629th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the VLOOKUP, MATCH, DATEDIF, SUMIF, SUMPRODUCT and INT functions to look up salary based the number of relevant years worked.

How To: Summarize budget data via PivotTable in MS Excel 2010

Learn how to create a summary of your budget data. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the Excel 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started summarizing your own budget data, watch this free video guide.

How To: Use the Windows 7 Ease-of-Access Magnifier

Need help figuring out how to enable the Microsoft Windows 7 Ease-of-Access Magnifier tool? It's easy! So easy, in fact, that this Win 7 accessibility guide can present a complete walkthrough of the process in just over a minute and a half. For details, as well as to get started using the Windows 7 Magnifier yourself, watch this helpful how-to.

How To: Boot your computer from a bootable CD

Learn how to boot up your Microsoft Windows PC from a CD-ROM! It's easy. So easy, in fact, that this home computing how-to from the folks at CNET TV can present a complete (and somewhat talky) overview of the process in just over a minute's time. For the specifics, and to get started booting your own PCs from optical media, watch this handy how-to.

How To: Use advanced Windows Vista keyboard shortcuts

Addicted to keyboard shortcuts? Interested in adding a few more to your arsenal? This home computing how-to from the folks at CNET TV demonstrates a number of intermediate- and advanced-level shortcuts sure to speed up your Microsoft Windows Vista workflow. For the specifics, and to get started using these useful Windows key commands yourself, watch this handy how-to.

How To: Learn the most useful Excel 2007 formatting shortcuts

Speed up your MS Excel workflow with these handy formatting key commands. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.

How To: Create a CSS-based layout in Adobe Dreamweaver CS5

Learn how to use CSS (cascading style sheets) to style pages created in Adobe Dreamweaver CS5. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started applying CSS formatting to your own pages, watch this free video guide.

How To: Customize the Quick Launch bar in SP Designer 2007

Learn how to customize the Quick Launch bar within SharePoint Designer 2007. Whether you're new to Microsoft's popular content management system (CMS) or a seasoned MS Office professional just looking to better acquaint yourself with the SharePoint 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.

How To: Make an Excel PivotTable year category from text dates

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 612th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a Year Category for a PivotTable from dates entered as text using the RIGHT function and the ampersand (&) join symbol.

How To: Track your Internet bandwidth use for free

Looking for an easy way to meter of your Internet bandwidth usage? This free video tutorial from the folks at CNET TV has got you covered. It details two freeware applications — one for Microsoft Windows, one for Mac OS X — that will help you keep track of your bandwidth usage. For the specifics, and to get started monitoring your own Internet usage, watch this helpful how-to.

How To: Make a Windows 7 system repair disc

Need some help figuring out how to burn a Microsoft Windows 7 system repair CD? It's easy! So easy, in fact, that this free home computing how-to can present a complete (and somewhat talky) overview of the process in just over a minute's time. For specifics, and to start making your own Windows 7 restore discs, watch this PC user's guide.

How To: Speed up Windows Vista with a flash drive

Want to speed up a Microsoft Windows Vista PC? Have a USB drive? This PC user's guide from CNET TV demonstrates how to take advantage of Windows Vista's Readyboost feature to convert your flash drive into extra virtual ram for your computer. For specifics, and to get started speeding up your own sluggish Vista PC, watch this handy how-to.

How To: Average rank scores given a tie in Excel 2010

New to Microsoft Excel 2010? Looking for a few good tips and tricks? In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the very first installment in his series of Excel 2010 video tutorials, you'll learn how to use use the RANK.AVE function to average rank scores in the event of a tie. See the new Excel 2010 RANK.AVE and RANK.EQ functions.

How To: Use the TRANSPOSE & FREQUENCY array functions in Excel

hether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 38th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TRANSPOSE & FREQUENCY functions.

How To: Work with date functions (TODAY, NOW, DAY) in MS Excel

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 12th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use the TODAY, NOW, DATE, YEAR, MONTH, DAY and EDATE functions.

How To: Record absolute and relative macros in MS Excel 2007

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you've come to the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how (and when) to record absolute and relative macros in MS Excel 2007.

How To: Fix common Excel spreadsheet problems & errors

Whether you're interested in learning Microsoft Excel from the bottom up or just looking to pick up a few tips and tricks, you're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.

How To: Calculate future value for a sinking fund in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 48th installment in his "Excel Business Math" series of free video lessons, you'll learn how to use the Excel functions FV and PMT to make a future value calculation for a sinking fund.

How To: Do 1-, 2- & 3-way lookups with Excel's INDEX & MATCH

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 44th installment in his "Excel Business Math" series of free video lessons, you'll learn how to run 1-way, 2-way & 3-way lookups using the INDEX and MATCH functions.

How To: Calculate future value & total interest in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 56th installment in his "Excel Business Math" series of free video lessons, you'll learn how to make calculations for future value and total interest earned.

How To: Convert price to selling price markup in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 51st installment in his "Excel Business Math" series of free video lessons, you'll learn how to convert markup on cost to markup on selling price.

How To: Calculate invoices and trade discounts in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 43rd installment in his "Excel Business Math" series of free video lessons, you'll learn how to complete an invoice and calculate trade discounts.

How To: Calculate incentive rates by formula in MS Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 39th installment in his "Excel Business Math" series of free video lessons, you'll learn how to calculate (piecework/comission) incentive rates by Excel formula.

How To: Solve a basic percent formula word problem in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 28th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve a basic percent (rate * base) formula word problem using Excel.

How To: Solve rate-of-change business math problems in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 30th installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve business math word problems that involve rate of change (increase or decrease).

How To: Solve rate/percent increase/decrease problems in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 32nd installment in his "Excel Business Math" series of free video lessons, you'll learn how to solve increase and decrease (Rate and Percentage) applied business math word problems.

How To: Work with mathematical word problems in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 13th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for math word problems in Excel.

How To: Make calculations for markup & markdown in Excel

As you might guess, one of the domains in which Microsoft Excel really excels is business math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 7th installment in his "Business Math" series of free video lessons, you'll learn how to make calculations for markup (mark up) & markdown (mark down).