Esi Ms Analysis Search Results

How To: Migrate from Microsoft Access 2003 to Access 2007

Interested in upgrading from Microsoft Access 2003 to MS Access 2007? 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 making the switch from Access 2003 to 2007 yourself, watch this free video guide.

How To: Use Application Parts when working in MS Access 2010

Learn how to work with Application Parts when using Microsoft Access 2010. 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started working with Application Parts in your own Access projects, watch this free video guide.

How To: Begin with a minimal master page in MS SharePoint 2007

Start from a minimal master page when using Microsoft 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, watch this free video guide.

How To: Use the new presentation themes in MS PowerPoint 2010

Microsoft PowerPoint 2010 includes more than just a host of new features, it also offers a significant number of new presentation themes. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using PowerPoint 2010's new themes in your own digital slideshows, watch this free v...

How To: Use the new Paste features in MS PowerPoint 2010

Learn how to use the new Paste functions in Microsoft PowerPoint 2010. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the PowerPoint 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the new PowerPoint Paste tools yourself, watch this free video guide.

How To: Use the MS Office Ribbon interface in PowerPoint 2010

Meet the Microsoft Office 2010 Ribbon interface. Whether you're new to Microsoft's popular presentation application or a seasoned MS Office professional just looking to better acquaint yourself with the Outlook 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started creating and using the Ribbon interface in your own PowerPoint projects, watch this free video guide.

How To: Dock a Microsoft OneNote 2010 window

Learn how to dock an MS OneNote window. Whether you're new to Microsoft's popular notetaking application or a seasoned MS Office pressional just looking to better acquaint yourself with the OneNote 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started docking windows yourself, watch this free video guide.

How To: Use the NETWORKINGDAYS.INT function in MS Excel 2010

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 and Mr. Excel, the 23rd installment in their joint series of digital spreadsheet magic tricks, you'll learn how to use the NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T functions in MS Excel.

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: 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: Create permanent consecutive integers 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 12th installment in his series of Excel array formula series, you'll learn how to create array formulas with the ROW & COLUMN functions that will in turn permit you to create a set of permanently consecutive integers.

How To: Apply conditional formatting to a row in MS Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 80th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to highlight an entire record (row) in a database that matches a bounced email addresss. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Cross-check two lists for discrepancies 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 528th installment in their series of digital spreadsheet magic tricks, you'll learn how to check two data sets (lists & tables) to see if there are discrepancies using the MATCH and VLOOKUP functions.

How To: Extrapolate given daily fixed costs 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 325th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula that takes a fixed daily cost and calculates the monthly total for months with different number of days.

How To: Convert TRUE & FALSE values to 1 & 0 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 314th installment in their series of digital spreadsheet magic tricks, you'll learn four different methods for converting TRUE and FALSE values to 1 and 0 (zeroes).

How To: Use templates in MS Word

Templates are an excellent way to save time and increase your productivity when you're working in Microsoft Word. There are a number of templates already in the program from headings to endings of letters. You can even create your own templates to customize the program for yourself. This video tutorial will show you how to use templates in MS Word.

How To: Conditionally format with MS Excel's DATEDIF function

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 271st installment in their series of digital spreadsheet magic tricks, you'll learn how to use conditional formatting and the DATEDIF function to add formatting to a cell based on the content of a different cell.

How To: Make personalized placemats easily

If I had kids, this is something I would totally use to not only entertain them but give them something fun to look at during dinner. This fun tutorial shows you how to take some simple foam and use glitter, markers, and other items to make cool placemats. Enjoy!

How To: Format decimals & fractions as inches 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 235th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a custom number format for inches that will allow you to type decimals or fractions and have it formatted as inches.

How To: Count values between a lower & upper bound 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 175th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMPRODUCT function and an array of TRUE & FALSE to count values between an upper and lower bound.

How To: Print multi-page stencils in MS Paint

Have need for a giant stencil (and use Microsoft's popular MS Paint software)? Then you've need for this free video tutorial, which explains how to change the page setup settings in Microsoft Paint to print multiple-page stencils. For more information, including a step-by-step walkthrough of the process, watch this how-to.

How To: Use Spellcheck/Thesaurus/AutoCorrect in MS Word 2007

As you type in Microsoft Word, take care to notice when the computer puts a red squiggly line underneath a word you typed. If you see a red squiggly line, the word is spelled incorrectly. If you right-click on the word, MS Word will show you a list of correctly spelled words that it guesses you were trying to spell. If you wish to check the entire document, you can click the Tools tab at the top of the page and then spell check. This will go through the document and point out every misspelled...

How To: Insert the current time and date in MS Word 2007

In this video you will learn how to insert the current time and date in MS Word 2007. In order to do that, just follow these easy and quick steps and instructions. The first thing you need to do is to click the Insert tab. Now, you need to select a space where your date and time will be placed. The next step is to click the Date & Time button, and select the format that you want. Click the OK button, and you are done. If you followed the simple steps correctly, then you won't have any problem...

How To: Insert special characters in MS Word 2007

A video from Helpvids.com that shows how to insert special characters in MS Word 2007. A seldom used function in MS Word is the Insert Symbol function. Symbols like the copyright, infinity, registered trademark, Yen, Pound, Euro etc can be of use in some documents. Word provides an easy way to insert these and many other such symbols into your documents without much hassle (For example, using the Character Map utility provided with Windows).

How To: Do basic statistical analysis in Microsoft 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 nth installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to do basic statistical analysis in Excel. Specifically, this video covers the following topics:

How To: Work with probabilities in Microsoft Office Excel

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 50th installment in his "Excel Statistics" series of free video lessons, you'll learn the basics of probability: