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 15th installment in his series of Excel array formula series, you'll learn how to set up, solve and write conclusions for larger-sized mathematical word problems.
Looking for a primer on how to create and work with arrays 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 for finding the largest improvement in sales from one year to the next.
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 5th installment in his series of Excel array formula series, you'll learn how to create array formula for adding the 3 largest or smallest values in a data set.
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 14th installment in his series of Excel array formula series, you'll learn how to create array formulas for individual stock return and standard deviation given different assumed states of the future economy.
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 for stock portfolio return & standard deviation.
Looking for a primer on how to create and work with names 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 name tricks, you'll learn apply names to formulas using Excel's built-in Apply Name Feature.
Looking for a primer on how to create and work with names 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 4th installment in his series of Excel name tricks, you'll learn to use short Excel names to expedite the formula creation process. For detailed instructions, watch this free video Excel lesson.
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 51st installment in his "Excel Statistics" series of free video lessons, you'll learn how to understand, work with and find simple probabilities in Microsoft Office Excel.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 43rd installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn use a data validation drop-down list to change conditional formatting in a table. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Ever wish you could embed a YouTube video into a Microsoft Office PowerPoint presentation? If you have a live Internet connection when designing your presentation, and will have one when showing it, you can. And it's an easy process to boot. For complete instructions on how to put a YouTube clip into a PowerPoint presentation, watch this helpful video tutorial.
Want to set up a wireless network in your home or office? It's simple. So simple, in fact, that this free networking how-to presents a complete overview of the process in just over four minutes. Set up a WiFi network with this video guide.
Excel dilettantes and seasoned Microsoft Office Pros alike are sure to delight in this tip, which comes to us by way of the 540th installment of ExcelIsFun's series of Excel magic tricks.
Watch this pen spinning video tutorial to learn how to do basic fundamental pen spinning tricks, like the Thumb Around, Thumb Around Reverse, Charge, Pass, Reverse Pass, Fingerpass, Finger Pass Reverse, Sonic, and Sonic Reverse.
Watch this pen spinning video tutorial to learn how to do some basic pen spinning tricks, like the Twisted Sonic, the Reverse Twisted Sonic, Thumb Around, Multiple Thumbspin, Infinity, Shadow, and Back Around.
No time to hit the gym because you're always stuck at the office? Then bring the gym to you with these moves, which you can do right at your desk. Tip: As you get out of your chair throughout the day, try to use only your leg muscles, leaving your arms at your sides and keeping your spine straight. This gives the muscles in your legs a quick workout.
Go ahead and celebrate your individuality—just don't announce to the office that you're a lazy nut-job. You will need: awareness, self restraint, plants, clock, a bowl of candy and personal momentos. Keep politics and religion out of the decor. Keep collectables at home. Interesting not: Plants indicate you are dedicated to your job.
Never again will being out of the office mean you are out of luck when it comes to working with your files. Thanks to the Offline Files and Folders feature in Windows Vista Business, Enterprise, and Ultimate editions, you'll have access to documents, even when you aren't connected to the network. For more on how to work with offline files and folders in Microsoft Windows Vista, watch this video tutorial.
Microsoft Office Excel 2007 spreadsheet manager is a powerful tool that enables information workers to format spreadsheets, as well as analyze and share information to make more informed decisions. In this MS Excel video tutorial, you'll learn about using a pivot table to summarize data.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about basic form customization. Specifically, this video addresses the adding a few navigation buttons and a label to a form. Simple stuff! Take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about creating a letter to multiple recipients using one form letter and a table to populate it. For more on using mail merging in Microsoft Access, watch this how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using the DateDiff function to work out age from birth date. For more, including detailed instructions, watch this Access how-to.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about hiding the backend of the database and opening the switchboard automatically. For more information, watch this MS access video tutorial.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about running a query from a form using a button. To get started running queries from forms in Access, take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn about using mathematical operands and other logical operators to select data in queries. For more information on using logical operators in your own Microsoft Access queries, take a look.
The Microsoft Office Access 2007 relational database manager enables information workers to quickly track and report information with ease thanks to its interactive design capabilities that do not require deep database knowledge. In this Microsoft Access video tutorial, you'll learn how to add and modifying fields to a pre-existing table, and applying these changes to an associated form. To get started adding and modifying fields, tables and forms in Access, take a look!
The Formula AutoComplete feature in Office Excel 2007 helps you avoid syntax or typing mistakes that can break your formula and display an error in the cell. Every step of the way, Formula AutoComplete guides you with ScreenTips that show you how to build your formula. Watch this tutorial and then try it yourself.
In Microsoft Office Excel 2007, you can hide rows and columns in several ways to change your view of the worksheet. When you finish your task, you can unhide the rows and columns to return the worksheet to its original state. This instructional video shows you quick ways to temporarily hide the data you don't want to see — so you can focus on what you do want.
If you're baffled about how to get your own photographs into your Microsoft Office Word 2007 documents, watch this instructional video. A Microsoft employee who uses Word himself shows you how to insert your picture or digital photo into a document and format it the way you want. He addresses questions about terms like "inline" and "floating," and explains how easy it is to set up a watermark.
With watermarks, you can add a new layer of information to your Microsoft Office Word 2007 documents. This tutorial shows you how to add a watermark to whatever section of your document you want and position it on the page where you want it. It demonstrates how to use graphics and text to create a custom watermark, such as your company logo.
Are you using the Microsoft Office Outlook 2007 Navigation Pane as your communications launching pad — where you can get to your most important folders and views with just a click or two? This tutorial shows you how to change the size of the pane to free up more space, customize the buttons and icons so you see what you want first, and arrange the folders for your convenience. You'll also see how easily you can change the organization whenever you want.
In Microsoft Office Access 2007,
If you're new to Microsoft Office PowerPoint 2007 and just want to pick up the basics, watch this tutorial and learn how to get started fast. You'll see how to create your own slides for a show and add headings, bulleted lists, and pictures. Use built-in layouts to organize your slide content. And see how the new Preview feature helps you choose theme colors and background design, minimizing the guesswork and giving you a polished result.
With the Freeze Panes command in Microsoft Office Excel 2007, you can make sure specific rows and columns stay visible while you scroll. Take a look at this instructional video and learn how to freeze and unfreeze rows and columns, and make viewing your worksheet a snap.
This is a tips and tricks video on how to use Microsoft Outlook's calendar function. Outlook is the email software provided by Microsoft Office suite. If you are new to Outlook or Outlook 2007, check out this video and learn some tips and tricks for working with the calenddar.
Jordan explains how to whiten teeth with Photoshop very quick and simply! Make all those coffee drinkers and smokers look like they just spent hours at the dentist''s office and whiten their teeth in minutes in Photoshop instead.
Admit it, you want to fold a JKF-188 jet plane (It's not really origami, because you need scissors). This video tutorial shows how to take an ordinary piece of office paper and create a really fancy paper airplane: the JKF-188 jetplane.
This video will show you how to make an adorable teabag holder that opens up and holds two teabags. This is a very cute gift idea or stocking stuffer idea, and a great thing to bring along to the office. Everyone will marvel at your skill with paper design when they see this project.
This tutorial paper craft video will teach you how to make an exceptionally cute post it note holder that also holds a pen. This is a cute idea for the office or for at home, and your friends and family will surely be impressed by your skill with paper products.
This video tutorial will show you how to make a super cute holder for your Campbell's Cup a Soup. This soup holder will get you compliments at the office or at home! Get your card making supplies ready, because this is a wonderful arts and crafts idea.
Want to be the laziest person in your office? In this how to video we give you excuses and top tips on being lazy and how to make sure no one finds out you're hardly doing any work.
