Microsoft Search Results

How To: Build and use array formulas 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 36th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn most everything there is to know about working with array formulas in Microsoft Excel.

How To: Use Microsoft Excel 2007 for statistics

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 very first installment in his "Excel Statistics" series of free video lessons, you'll learn how to get started doing statistical analysis in Microsoft Excel 2007.

How To: Sort and extract by cell color in Microsoft Excel 2007

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 33rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to sort by color in Excel 2007 as well as how to use the copy and paste tools to extract records. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Create a daily Gantt Chart in Microsoft Excel

New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this two-part Excel tutorial from ExcelIsFun, the 564th installment in their series of Excel magic tricks, you'll learn how to create a cell chart using conditional formatting with Logical TRUE FALSE formulas to create a Gantt Chart. Functions used include WORKDAY, AND, NOT, NETWORKDAY.

How To: Use conditional IF formulas in Microsoft Office Excel

New to 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 Excel tutorial from ExcelIsFun, the 334th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the IF function. This video starts with IF function basics and then shows 12 different examples of how the IF function can be used in formulas. Also see how to use AND, OR, SUM, AVERAGE, STDEVP and VLOOKUP functions.

How To: Use Microsoft Word 2010's Backstage view option

Microsoft Word 2010 prevails with new advancements. New options such as Backstage view allows the user to work efficiently and utilize new abilities when managing documents. It succeeds with new abilities that will allow the user to complete tasks quicker than before. Working with the newly enhanced ribbon allows the user to navigate with an easy, more personal customized environment. Now with more options and commands at your fingertips, it is evidently shown that Microsoft is gifting users ...

How To: Calculate return on equity, assets and profitability in Microsoft Excel

As you might guess, one of the domains in which Microsoft Excel really excels is finance 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 19th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate return on equity, assets, and profitablility — return on investment (RoI).

How To: Turn a Microsoft Windows PC into a web server with XAMPP

In this clip, you'll learn how to convert a Microsoft Windows desktop or laptop computer into a personal web server (or webserver) with XAMPP, an Apache distribution that compes preloaded with PHP and MySQL. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look

How To: Use mathematical operators in queries in Microsoft Access 2007

In this clip, you'll learn how to employ mathematical operators when running queries in 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, including step-by-step instructions, watch this free video guide.

How To: Use the Microsoft Office Ribbon UI in PowerPoint 2010

In this clip, you'll learn how to utilize the MS Office Ribbon interface when working within 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 creating and using the Ribbon interface in your own PowerPoint projects, watch this free video guide.

How To: Edit and delete scenarios in Microsoft Excel 2007

Learn how to edit and delete scenarios in your Excel 2007 workbooks. 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 2007 workflow, you're sure to be well served by this video tutorial from the folks at Lynda. For more information, and to get working with scenarios in your own MS Excel 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: Work with the VBA environment in Microsoft Excel 2007

Learn how to use the VBA environment within MS Excel 2007 to create custom macros. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started working within Excel 2007's VBA environment yourself, watch this free video guide.

How To: Record custom macros in Microsoft Excel 2007

Want to record your own custom macros within MS Excel 2007? See how it's done. Whether you're new to Microsoft's popular spreadsheet application or a seasoned business professional just looking to better acquaint yourself with the unique features of Excel 2007, you're sure to be well served by this video tutorial. For more information, and to get started recording your own macros, take a look.

How To: Format a drive for both Mac OS X and Microsoft Windows

Have an external hard drive that you'd like to use with both an Apple computer and a Microsoft Windows PC? With the FAT32 file format, it can be done! And this home computing how-to from the folks at CNET TV will show you how. For more information, including detailed instructions, and to get started sharing your own HDs between Mac and Windows computers, watch this free video tutorial.

How To: Sync Microsoft Office Outlook with Google Calendar

Looking for a guide on how to synchronize Microsoft Office Outlook with your Google Calendar account? 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 combining your Outlook and Google calendars, watch this PC user's guide.

How To: Upgrade from Microsoft Windows XP to Windows 7

Decided you want to leapfrog Vista and upgrade from Microsoft Windows XP directly to Windows 7? 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 about six minutes' time. For specifics, and to start installing Win 7 on your own computer, watch this PC user's guide.

How To: Take screenshots in Microsoft Windows 7

Need a little help figuring out how to capture screenshots in Microsoft Windows 7? 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 get started taking your own screengrabs in Win 7, watch this PC user's guide.

How To: Customize the Microsoft Windows 7 Start Menu

Need a little help figuring out how to customize your Microsoft Windows 7 Start Menu? 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 a minute's time. For specifics, and to get started personalizing your own Win 7 Start Menu, watch this PC user's guide.

How To: Calculate a bonus in Microsoft 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 and Mr. Excel, the 24th installment in their joint series of digital spreadsheet magic tricks, you'll learn 5 different methods for calculating a bonus using VLOOKUP, MAX, Boolean, and 2 IF formulas.

How To: Turn a range of cells upside down in Microsoft 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 and Mr. Excel, the 10th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to invert a range (turn a range of cells upside down) with two different INDEX formulas.

How To: Use wildcard counts in Microsoft 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 and Mr. Excel, the 3rd installment in their joint series of digital spreadsheet magic tricks, you'll see three methods to count records that contain the letter D.

How To: Calculate subtotals 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 18th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to calculate (and sum) subtotals in Excel. See how to do subtotaling with the SUM function.