Not every client or coworker likes to mine through a spreadsheet to find all the important data. So, with Excel 2008 for Mac, you can easily share that data without sending the entire Excel spreadsheet. To do this, all you need to do is to use the "copy as picture" option. The Microsoft Office for Mac team shows you just how to insert a spreadsheet snippet in this how-to video.
One of the advantages of an iPad over, say, an iPhone is that you've ample space with which to display and manipulate complex documents. As such, it's a natural fit for Apple's popular spreadsheet application, Numbers. In this video guide from Apple, you'll learn how work with tables, charts, formulas, photos and graphics using the Numbers app on your own iPad.
This clip presents a general overview of how to execute a VBA routine within an MS EXcel spreadsheet. Whether you're new to Microsoft's popular digital spreadsheet application, new to Visual Basic for Applications (VBA) or merely new to using the two in tandem, you're sure to benefit from this free video software tutorial from the folks at Lynda. For more information, including detailed, step-by-step instructions, take a look.
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 622nd installment in their series of digital spreadsheet magic tricks, you'll learn how to to write an array formula using the SUMPRODUCT, MOD, IF, ROWS, INDEX, SMALL, and ROW functions that will retreive only even row values.
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 18th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROW, CHAR and RANDBETWEEN functions to randomly generate letters. See also how to randomly create letter sequences.
Learn how to add SmartArt to your Microsoft Excel 2010 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 2010 workflow, you're sure to be well served by this video tutorial. For more information, and to get started using SmartArt in your own Excel projects, watch this free video guide.
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.
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 11th installment in their series of digital spreadsheet magic tricks, you'll learn how to measure variation in a spreadsheet using functions like STDEV.
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 25th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to interpret and resolve the nine most common Excel formula errors — namely, ####, #NAME?, #N/A, #REF!, #VALUE!, #NUM!, #DIV/0!, Circular Reference, and #NULL!.
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 19th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE and RANDBETWEEN functions to randomly generate words.
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 26th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to use spreadsheet construction guidelines to fix common problems:
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 278th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the INDEX and ROWS functions to write a formula that will return each 10th value and place them all in a column.
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 Excel tutorial from ExcelIsFun, the 537th installment in their series of Excel magic tricks, you'll learn how to drill through a spreadsheet to speed up formatting, formula creation and editing.
Open Microsoft Office Excel. Across the top notice letters (columns), along the sides are numbers (rows). The columns and rows can be extended by highlighting sections and right clicking and choosing the high of the row. You can also select to add a border, and change the orientation of your cells.
Always make sure you've formatted your numbers correctly within the proper cells when you're developing a spreadsheet in Microsoft Excel. There are a variety of number formatting functions you can use to make your spreadsheet more readable, and this tutorial explains how to use number formatting correctly.
Are you looking for a way to make your Microsoft Excel formulas simpler, faster and more efficient? If so, you're in the right place. With this free video lesson from everyone's favorite digital spreadsheet guru, YouTube's ExcelsFun, the 10th installment in his "Excel Formula Efficiency" series, you'll learn how to use Manual Calculation for huge spreadsheets so that recalculation only occurs when you want it to occur.
In this Excel magic trick video the tutor shows how to print labels on each page of a large spreadsheet in Microsoft Excel. He shows how to download the sample work book so that you can try the tutorial hands-on. He shows a spread sheet which he intends to print and wants the label of columns to be printed in the top and left of a page. For that he shows the page setup preview where you can check the print preview of the pages about to be printed. He shows that the columns appear on only the ...
Here is a quick video on how to convert Excel spreadsheet data to XML for import into Flash or Flex. Don't spend time typing all that data again, instead create a schema in Excel and convert it to XML.
This video tutorial is in the software category where you will learn how to remove tabs and scroll bars from an Excel spreadsheet. Open a work sheet and you will find scroll bar on the right and at the bottom. But, why should you take them off? If you are making a user form that you want to send to your employees and you don't want them to mess it up, then you may do this. Go to the office button and click on 'excel options' at the bottom. On the next window go to the 'advanced' tab and scrol...
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 14th installment in their joint series of digital spreadsheet magic tricks, you'll learn how to create formulas and Conditional Formatting that will display UP, DOWN, and SIDE arrows to indicate up or down for a list of numbers.
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 45th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to perform debt analysis with the following input variables: % Down Payment, APR, Years, Points, Extra Fee. See how to calculate Amount to Borrow, Monthly Pay...
In this Excel basic video the instructor shows how to setup a spreadsheet and use cell references. Cell references are used in Excel to refer to other cells in a formula. When a formula contains data based on the cell reference the formula auto generates the result each time the value in the cell changes as the formula contains only the reference to the cell and not the actual data present in it. In this video the tutor goes on and shows how to write a few basic formulas using cell references...
The Costsheet demonstrates how to enable macros in Excel 2007 to run correct spreadsheets. First, open up the spreadsheet. Make sure that the macros are enabled. If they have not, enable the macros by placing them in a trusted source by saving them in a particular folder. You can also choose to recognize the publisher as a trusted source. Click the office button and scroll down to Excel options. Click on the trust center option and go to trust center settings. Then, view the trusted locations...
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 99th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to create and use the mathematical constant e in Excel. Also learn about the EXP function.
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 Excel tutorial, you'll learn about simple formatting, background colour, gridlines, alignment. For more information on formatting spreadsheets within MS Excel, watch this helpful how-to.
This video is an Excel magic trick which shows how to select cells in Excel through keyboard shortcuts. He starts by the basics where he shows how to select a range of cells in excel work book. He shows how to jump to the top and bottom of the selection area. He even shows how to use shift key to select the whole range. Finally he shows how to hold control, shift and click to select the whole ranges. He even shows how to select ranges top to bottom and from left to right. This video shows how...
If you've ever entered a lot of data into an Excel spreadsheet before, then you know that putting together even one spreadsheet is a pain in the butt. So if you are required to place all the data on one spreadsheet onto another spreadsheet, don't slave away for hours copying and pasting.
While all Web 2.0 applications are by no means equal, certain among them can save you time, money, and frustration–one such web app is the Zoho Sheet spreadsheet utility, which is comparable to Excel from the Microsoft Office suite. For more information, or to get started using the Zoho Sheet online spreadsheet application for yourself, take a look!
There's an epidemic on the Internet, and the disease—Facebook. It's an addiction comparable to a hot cup of coffee in the morning or a soothing cigarette throughout the day—in worse case scenarios, a hit from the crack pipe. If you're on Facebook, you know what I'm talking about. You're addicted to finding out what's going on with your friends and addicted to telling those friends everything you're doing. You can't stop, even when you're at work.
When planning a wedding, maintaining your guest list is one of the most important things that will help you stay organized (as well as sane). See how to start a guest list spreadsheet to use during your engagement, up to the wedding, and even after.
This video goes over how to add sheets and tables to your existing spreadsheet in Numbers '08. It's pretty straightforward so you should have no problems at all.
Treat your spreadsheet like a presentation and make it exciting by adding images, movies and sound. Not sure how? Then watch this tutorial on customizing your spreadsheets in Numbers '08.
Hello! I am working on merging two databases. The first has 1,500 contacts - just first name, last name, and company. The second has 5,000+, with first, last, company and email. I want to search the 5,000 email list, if the name appears on the 1500 list, I want to copy the email address from the 5,000 list.
This video demonstrates how to use the ISLEAPYEAR determining function in a spreadsheet. This determines whether a date falls in a leap year within a spreadsheet program.
This tutorial shows the use of the Excel program PROPER. This capitalizes the first letter of every word of a text stream in a spreadsheet program.
This tutorial demonstrates how to use the Excel function SQRT. This allows you to determine the square root of any number, within a spreadsheet program.
NovaPDF is a computer program that will allow you to export your Excel spreadsheets into the popular PDF format. This brief tutorial walks you through how to use the Print command in Excel to get a usable PDF using NovaPDF.
Hi again, Just wanted to share a neat little code that I found way back, when I was presented with a spreadsheet which was locked and asked to ''unlock'' it or do whatever it takes to enable the user to edit it's contents.
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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract first and last names from an Excel spreadsheet and rearrange them using a formula.
Great news! — Excel isn't just for Windows anymore. Okay, so it's been available on the Mac for awhile now, but if you haven't used it yet, why not start now? Getting started with Excel 2008 for Mac is easy, and this video overview will show beginners or even the most seasoned professional spreadsheet worker a thing or two. The Microsoft Office for Mac team shows you just how to get started in this how-to video.
