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 very first installment in his series of Excel array formula series, you'll learn how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered automatically by 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 9th installment in his series of Excel array formula series, you'll learn create array formula that counts all the characters in a range of cells.
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 use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)
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 how to use the built-in dynamic range names in Excel 2007 Tables.
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 10th installment in his series of Excel name tricks, you'll learn how to store lookup tables in memory using a named array.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 91st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create an average with multiple criteria using pivot tables (PivotTable). Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 79th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to add conditional formatting to an entire table based on the content of a cell outside the table area. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 54th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to count records exceeding a given hurdle using Excel's advanced filter tool. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 41st installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use a true/false formula with the COUNTIF function to prevent duplicate entries in a list. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 47th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to calculate total plate cost for a print shop using the VLOOKUP function. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.
Microsoft Office files can be password-protected in order to prevent tampering and ensure data integrity. But password-protected documents from earlier versions of Office are susceptible to having their hashes extracted with a simple program called office2john. Those extracted hashes can then be cracked using John the Ripper and Hashcat.
Clipboards may possibly be the most humdrum of office supplies. They're underwhelmingly plain, and serve no other function than holding a notepad steady.
Your home office is missing something… hmm… maybe something to hold your recycled printer paper, and what better to hold your recycle paper than a recycled paper tray? Nextraker shows you a neat hack involving a few dust-collecting compact discs that will make a eco-friendly paper tray to organize your desk. It's a amazing what you can do with a few old CDs.
In this clip, you'll learn how to set up a simple wireless network in a home or office. For more information, including a complete demonstration and detailed, step-by-step instructions, and to get started making phone calls over your own Internet connection, watch this handy home-computing how-to from the folks at CNET TV.
Interested in setting up a WiFi network in your home or office? This brief video tutorial from the folks at Butterscotch will teach you everything you need to know. For more information, including detailed, step-by-step instructions, and to get started configuring your own wireless network, take a look.
Meet the Microsoft Office OneNote graphical user interface (or GUI)! 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 using the OneNote UI yourself, watch this free video guide.
In this Adobe Acrobat 9 Pro tutorial you will learn how to develop a business workflow. Learn how to work with Microsoft Office products like Excel, PowerPoint, CAD drawings and more to create PDF versions of your Office documents, or create entire portfolios to give to clients right in Acrobat 9. Learn how to send files for review, add comments and interactive elements, and enhance PowerPoint presentations in this Acrobat 9 Pro 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 the HLOOKUP function to generate adaptable grades from marks. For more on using HLOOKUP across multiple documents, watch this Microsoft Office how-to.
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 Excel to calculate average values and to pick max and min values. For more on this handy feature of Excel, 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 creating an alphabetically sorted combo box search. For detailed instructions, and to get started using combo boxes yourself, watch this MS 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 using relationships and queries to pull data from tables. For more information, watch this Microsoft Office 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 Office Access 2007 video tutorial, you'll learn about using wildcards to fill in the blanks in Access. For detailed instructions on using Access yourself, watch this video 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 sorting data using queries. For detailed instructions, and to get started using queries to sort data for yourself, 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 a tiny bit of VBA to add a clock to a given form. For step-by-step instructions, take a look!
How many times, when running Mac OS X, have you had a lengthy Word Document or Excel spreadsheet that you needed to zoom in and out of quickly and efficiently? In this video tutorial, you'll learn a handy shortcut doing just that in Microsoft Office. For more, watch this video tutorial.
Take a look at this instructional video and learn how to create and distribute your own form templates with Microsoft Office InfoPath 2007. An easy way to get coworkers to fill out forms is to publish a form template as an e-mail message in Microsoft Office Outlook 2007.
Are your photographs stashed away because you do not have frames to put them in? Watch this video tutorial to learn how to make a desk top photo frame using common office supplies. You will need a CD case, a binder clip and scotch tape.
Watch this video to learn this funny prank to play on your friends. This is highly recommend for college kids. It's good to use in the office on a coworker, your boss, or on your roommate. This is a very simple and highly effective prank. Use this as inspiration for one of your April Fools Day pranks!
In this quick tutorial, I show you how to compare data using an in-cell bar graph in the Open Office Calc Program by using the '=REPT' formula.
In this screencast tutorial, Steve shows you how to quickly and simply create a bar chart, from the data you have entered into your worksheet in Open Office Calc. If you're looking for a simple and clear way to represent your statistical data, then a simple bar chart is an option you should look at using. So check out this tutorial and start making OpenOffice Calc bar charts today.
How to change the alignment of headings in Open Office Calc to fit all your data onto one page.
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.
In this clip, you'll learn how to take advantage of the Microsoft Access QBE interface. 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.
The new version of Microsoft Office has a feature which allows you to batch create PDFs. You can easily convert whole folders or specfic selections of Word, Excel or PowerPoint files into PDF files. You also have the option of converting the files into individual PDFs, or turn them into one large file.
Need some help figuring out how to use permissions in Microsoft SharePoint 2010? This guide will show you how it's done. 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, including detailed, step-by-step instructions, watch this free video guide.
See how to apply condition formatting when working in Microsoft Excel 2007. Whether you're new to Microsoft's popular word processing application application or a seasoned MS Office professional just looking to better acquaint yourself with the Word 2007 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using the useful formatting feature in your own Excel documents, watch this free video guide.
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.
Learn how to customize Web Parts when working in Microsoft SharePoint 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, and to get started using customized Web Parts in your own SharePoint projects, watch this free video guide.
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.
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.
