Workbook

How To : Link two (multiple) workbooks & cells in Excel

In this tutorial, we learn how to link two workbooks and cells in Excel. First, save both of the files that you want to link together. Make sure you only have one Excel window open, then double click the other Excel file, don't open separately. Next, type in the equals sign in ...more

How To : Retrieve data from a different workbook in 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, the 90th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a ...more

How To : Apply picture styles in a MS Excel 2007 workbook

See how to apply custom picture styles in Microsoft Excel 2007. Whether you're new to Microsoft's popular digital spreadsheet application or a seasoned business professional just looking to better acquaint yourself with this particular iteration of the program, you're sure to ...more

News : The Ultimate SCRABBLE Word List Resource

To some, SCRABBLE is just a board game to play during family game night or during a casual get-together. Others think of SCRABBLE as a mere hobby. But with any activity, there will always be fanatics—the ones who would rather sell their soul than stop—the ones with a constant ...more

How To : Enter formulas in Excel with a macro

In order to enter formulas in Excels with a macro, you will need to open your spreadsheet. Formulas are used to do calculations. Go to the field, where you want to enter a formula. Type in the formula. Then, highlight the formula. Press Control + C to copy the formula. Next, d ...more

How To : crack password protection on Excel Spreadsheets

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. Well, I'm not one to say nay to a challenge, however ...more

How To : Completely hide the Ribbon menu in Excel

The instructor of this video shows you how to completely hide the ribbon, or the menu, in Excel. If you only want to partially hide the ribbon, you can use the shortcut control + F1. To completely hide the ribbon, though, go to the Visual Basic screen, hit Alt + F11. Then, go ...more

How To : Say the names of school things in French

Watch to learn how to say the names of things that have to do with school, like books, paper airplanes, and soccer balls, in French. un abecedaire - alphabet book un avion en papier - paper airplane un ballon de foot - soccer ball une boite a compare - pencil box un cahier - w ...more

How To : Automatically Hide the Ribbon Menu System in Excel

Teach Excel demonstrates how to completely hide the Ribbon menu system in Excel 2007 as soon as the workbook is opened. This will be done by writing a macro which hides the Ribbon only for the specific workbook in which the macro is implemented. Some helpful shortcuts are Ctrl ...more

How To : Create a hyperlink from one Excel sheet to another

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 326th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more

How To : Create fast formulas for huge Excel spreadsheets

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 ...more

How To : Hide scroll bars, sheet tabs & charts in Excel

This video is a tutorial on how to remove scroll bars, sheet tabs and objects in Excel. To remove scroll bars and sheet tabs, go to the Office button, then Excel Options. On the screen that comes up go to the Advanced tab and scroll down to “Display options for this workbook”, ...more

How To : Find intervals with a TI-83 graphing calculator

Need to know how to use your Texas Instruments graphing calculator for your college math or statistics class? You're in luck... watch this video tutorial to see how to find intervals with a TI-83 graphing calculator. Confidence intervals for single population means: sigma unk ...more

How To : Pull text from Excel cells & separate into columns

Mastering your Excel skills? Have a busy Excel workbook or spreadsheet that needs to some organizing? In this two-part tutorial, learn how to pull text from cells & separate them into multiple columns in MS Excel. You will learn how to use the LEN(), FIND(), LEFT(), and RIGHT( ...more

How To : Create a formula timer in Microsoft Excel

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 2nd installment in his "Excel Formula E ...more

How To : Play the "psychiatrist" party game

Learn how to play the improve game "Psychiatrist" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with her ...more

How To : Connect data to your Visio diagram

Take a look at this instructional video and learn how to analyze how a process or other area is actually performing by connecting data to the shapes in your diagram with Microsoft Visio 2007. You can also add different visual effects based on the data values. For example, you ...more

How To : Remove the macro warning in Excel

In this video tutorial, viewers learn how to remove the macro warning in Microsoft Excel. When you see the warning, click Enable Macros. Then right-click on of the sheet tabs and select View Code. Open the Modules folder menu. Now right-click on the module and select Remove Mo ...more

How To : Write a macro by hand in Excel for beginners

The speaker in this video introduces the concept of macros used in Excel, very simply and lucidly. Two sets of shortcut keys are used, one set to create the macro and the other set to run it. The first shortcut opens up the VBA window (Alt+F11), with a workbook along with the ...more

How To : Use the SUMIF & SUMPRODUCT functions in MS 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 Excel tutorial from ExcelIsFun, the 315th installment in their series of digital spreadsheet magic tricks, you'll learn how (and when) to use the ...more

How To : Use the SUMPRODUCT function in Microsoft Excel

Are you looking for a way to make your Microsoft Excel formulas 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 very first installment in his "Excel Formula Efficiency" se ...more

How To : Play the "dress the mummy" party game

Learn how to play the improve game "Dress the Mummy" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with ...more

How To : Speed up calculations with custom Excel formulas

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 very first installment in his "Excel Fo ...more

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 Excel ...more

How To : Play the "interrogation" party game

Learn how to play the improve game "Interrogation" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with he ...more

How To : Play "the wind blows for" party game

Learn how to play the improve game "The Wind Blows For" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" wi ...more

How To : Play the "lines from a hat" party game

Learn how to play the improve game "Lines from a Hat" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with ...more

How To : Play the party game "charades"

Learn how to play the improve game charades at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with her stude ...more

How To : Use Microsoft Excel 2007 as a complete beginner

If you're a novice looking to learn how to use Microsoft Excel, a video series from digital spreadsheet guru ExcelIsFun is a great place to start. But which of his many series should you choose? The one titled "Excel Basics," that's which! This free video MS Excel lesson, the ...more

How To : Play the "throw the story" party game

Learn how to play the improve game "Throw the Story" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with ...more

How To : Play the "quirks" party game

Learn how to play the improve game "Quirks" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with her stude ...more

How To : Encrypt your Microsoft Office documents

Check out this tutorial and learn how to encrypt Microsoft Office files to help prevent unauthorized people from opening a workbook, document, or presentation. Watch the video to see how easy it is to set a password to help you control who can open or modify the Office files y ...more

How To : Play the "slideshow" party game

Learn how to play the improv game "Slideshow" at your next party in this free video that will keep your party guests entertained and thinking on their feet. Teri Lynne has been teaching Drama for 7 years for both private and public schools. She often uses "games" with her stu ...more

How To : Pair or match with a TI-83 graphing calculator

Need to know how to use your Texas Instruments graphing calculator for your college math or statistics class? You're in luck... watch this video tutorial to see how to pair or match with a TI-83 graphing calculator. Here are some paired (or matched) samples. Please note, thi ...more

News : Required Reading

This class is not only about learning the tools, but having ideas to actually create with the tools. Anyone can learn After Effects but not everyone can express themselves with this tool. Hopefully by the end of the semester will not only your toolset be larger, but your min ...more

Prev Page
  • Hot
  • Latest