Office Environment Search Results

How To: Import different types of data 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're in the right place. In this tutorial from everyone's favorite digital spreadsheet guru, ExcelIsFun, the 23rd installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to import data into Excel from text files, web sites, Excel files and Microsoft Office Access files. Also see how to import currency rates and major indicies from ...

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: Transpose columns to rows & rows to columns in Excel

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 2nd installment in his series of Excel array formula series, you'll learn how to use the array TRANSPOSE function to transpose a table, switching rows and columns to columns and rows.

How To: Calculate expected return with an Excel array formula

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 3rd installment in his series of Excel array formula series, you'll learn how to create an array formula that will calculate the expected return for a given stock.

How To: Use the FREQUENCY function in Microsoft 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 8th installment in his series of Excel array formula series, you'll learn how to use the array FREQUNCY function correctly.

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: Copy & paste a list of all names in an Excel workbook

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 12.66th installment in his series of Excel name tricks, you'll learn how to paste a list of all names in the workbook, both the name and the formula that defines the name.

How To: Average with the MONTH function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 90th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll see a complicated average calculation with multiple criteria using the MONTH function on a date field. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Calculate monthly sales with Excel's SUMPRODUCT & TEXT

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 45th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the SUMPRODUCT & TEXT functions together in 1 formula to sum the month's sales. Learn to love digital spreadsheets more perfectly with the tricks outlined in this free Microsoft Office how-to.

How To: Organize your life in Microsoft Access

Brand new to Microsoft Office Access? This seven-minute free video lessson, which presents a general orientation to using the popular database program, will see that that you're well versed in all of the fundamentals. Learn how to create databases and forms, how to run queries and more. For the specifics, watch this free MS Access video tutorial.

How To: Draw and paint rock cliff mountain cliff environment

How to draw and paint rock cliff mountain environmental concept background. This landscape scene is created in a video demonstration using Photoshop. his step by step video shows you laying down the base color, blocking in shape for painting, assigning value and color composition, and refining detail for the final concept painting.

How To: Manage Office themes when using Microsoft Excel 2011

Need some help figuring out how to handle Office themes from within Excel 2011? This video will show you how it's done. Whether you're new to Microsoft's popular digital spreadsheet application, new to Excel 2011 or even an expert merely looking to brush up on the fundamentals, you're sure to be well served by this quality video tutorial from the folks at Lynda. For all of the details, and to get started better managing Office theme settings yourself, watch the video.

How To: Apply for California food stamps

In this tutorial, we learn how to apply for California food stamps. First, to go the website: California Food Stamps. After you are on this site, you will see a pop up where you can enter in your name and e-mail, as well as more information about food stamps in California. After you enter in your information, you will receive an e-mail with two links on it. One will be for the application and the other will be to find an office near you. Print out the application and fill it out entirely, fol...

How To: Kill bed bugs in the workplace

Bed bugs appearing in the office space is becoming more and more common. Often, someone brings a bed bug to the office on their clothes, and the bed bug roams away from the garment. These don't normally turn into reproducing infestation.

How To: Navigate and use the MS OneNote 2010 user interface

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.

How To: Put a poster comp in another environment in Photoshop

This tutorial utilizes the Distort tool in order to convincingly put a comp of a poster into a second environment. Whether you're new to Adobe's popular graphics editor or a seasoned design professional looking to better acquaint yourself with the various features and functions of Photoshop, you're sure to benefit from this free software tutorial. For more information, watch this designer's guide.

How To: Export PDF files to Office formats in Acrobat 9 Pro

In this Adobe Acrobat tutorial the instructor shows how to export PDF files to other office formats. He shows how to do this with a live example. He chooses the file menu and from there goes to the export sub menu and shows all the different file format options that are available for exporting. For demonstration purposes he saves the current PDF in Microsoft Word format. He opens the converted file and shows the results of conversion. This video demonstrates the features of Adobe Acrobat 9 to...

How To: Develop a business workflow in Acrobat 9 Pro

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.

How To: Use HLOOKUP across two worksheets in Microsoft Excel

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.

How To: Calculate averages in Microsoft Office Excel

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.

How To: Create a combo box in Microsoft Office Access 2007

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.

How To: Use queries to pull data from tables in MS Access

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.

How To: Use wildcards in Microsoft Access 2007

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.

How To: Sort data with queries in Microsoft Office Access 2007

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.

How To: Add a clock to a form in Microsoft Office Access 2007

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!