Programming with Excel

How To : Use object-oriented programming in Microsoft Excel

This clip offers a general introduction to using VBA within MS Excel. 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 sof ...more

How To : Dominate the New York Times Crossword Puzzle

First off, don't be frustrated. YOU CAN DO IT! Contrary to the message in the image above, it's NOT over. It's just beginning. And when it comes to solving the New York Times crossword puzzle, the old cliche does apply: practice makes perfect. I've read quite a few books and ...more

How To : Calculate the percentage of a number

This video presented by Cris Ippolite makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing flat files, which programs like Microsoft Excel use. Flat files have a big disadvantage: they cannot communicate with other fil ...more

How To : Make sketches with Microsoft Excel

Not only is Microsoft Office Excel handy for drafting documents, it can also be used to make simple illustrations. Quite easily at that. The program's drawing tools are so easy to utilize, in fact, that this free video software tutorial can present a complete overview of the p ...more

News : Microsoft Ribbon Hero

Microsoft Ribbon hero is an application that turns the office into game. It is designed to boost skill and knowledge in Microsoft Office’s latest version. It is released with office 2007 as a social game for increases productivity in office applications. It is compatible with ...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

How To : Use the Format Cells dialog box in MS Excel 2007

See how to use the Format Cells dialog box and the pop-up mini-toolbar 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 ...more

How To : Use Excel date math & time formatting

Once you learn some of the basics, Excel is an easy program to use. With the use of some simple formulas, you can streamline your whole data entry process. Just by typing in =SUM you can set a row or column to show the sum of other entries. It really is that easy. This video w ...more

How To : Use the New Features in Windows Live Hotmail 2011

Hotmail just isn't the same anymore— it's better! In the just-released Windows Live Essentials 2011 from Microsoft, Windows Live Hotmail 2011 is jam-packed full of new features. The new Hotmail makes emailing easier than ever before, allowing you to cut through the inbox clut ...more

News : Microsoft Office 2010 Keynote

Hey has anybody tried Microsoft Office 2010 yet? It looks like they had their major Keynote today (2010-05-12). Being an IT guy I am looking forward to rolling this out in my company. I liked the ribbon when it was introduced in Office 2007 & with Office 2010 it looks like the ...more

How To : Find the diagonal sum in Excel

In this how to video, you will learn how to create a diagonal sum in Microsoft Excel 2007. First, open the program and make a large selection. Type in =int(rand()*500) and then press control enter. This will create random numbers for the cells in the selection. From here, clic ...more

How To : Sort columns in MS Excel

In this how to video, you will learn how to sort columns in Excel with the Excel Experts. This is great if you want to learn the basics of sorting in the program. First, you must have Excel installed and running. Open up a spreadsheet that needs columns to be sorted. Select th ...more

How To : Use Excel percentage number format

This video tutorial will teach you how to format percentage numbers in MS Excel. Excel is a spreadsheet application that allows you to use calculations, graphs, pivot tables and much more to create the spreadsheet you want. You can learn how to avoid common mistakes that occur ...more

How To : Use Microsoft Excel for beginners

MotionTraining gives an overview for using Microsoft Excel for beginners in this video. This video gives a rundown and overview of the basics of this spreadsheet program: from typing in the columns and rows, adding dollar signs to data, and how to make basic calculations. Moti ...more

How To : Use the Arbitrage Pricing Theory (APT)

This video teaches you how to use APT (Arbitrage Pricing Theory) models and formulas. This video shows two specific parts of the APT models the first being the after the fact version and the before the fact version. The before the fact version is focused on as being the most i ...more

How To : Convert Images Into PDF

We always have so many file formats in our computer, we use MS Word to view .doc files, MS Excel to view .xls files, Adobe Reader to view PDF files, image viewers to view all kinds of image formats, and browser to view html files. It seems we need to install many programs to v ...more

How To : Use macro security options in Excel 2007

Some times when you upgrade your Microsoft Excel software to Excel 2007 your old macros may stop working. Some times this may be due to the settings and by enabling the macros you can get your old macros to work. Macros are turn off by default in Excel 2007. You can turn this ...more

How To : Find a P-Value with Excel

So you need to find the p-value for your hypothesis test. To do so, employ the spreadsheet program Microsoft Excel. Using a simple formula, you can easily determine the p-value for your tests and thereby conclude strong or weak support of the null hypothesis. Probability valu ...more

News : Accounting and Finance Degree

Accounting and Finance Degree Are really a person one of all those folks who dread going to university? It's ok in case you are. In any case, I take into account it's important to keep throughout mind just how a lot University lifetime has developed over time just within the ...more

How To : Bash (Shell) Scripting for Beginners

Bash (Shell) Scripting for Beginners Intro I am an occasional Linux user currently playing around in CrunchBang and loving it. Prior to this, I used to dual-boot Windows and xfce-buntu (or xubuntu) at work, and due to some unforeseen circumstances, my screen always went fuzz ...more

Top 10 : Best Ethical Destinations for 2011

By Ethical Traveler As the world becomes ever more interconnected, being an ethical traveler becomes both easier and more urgent. Travelers today have access to far more information than we did even 10 years ago. We can observe–almost in real time–the impact that smart or sel ...more

News : Excited About DeX? Here's a Reality Check

Samsung's new Galaxy S8 can turn into a PC with its DeX dock, but while that may sound like the future of mobile computing on the surface, there are definitely a few issues with the entire setup. The Samsung Desktop Experience (DeX) dock was debuted alongside the Galaxy S8 on ...more

How To : Boost Your Productivity on Android

Not many people use their phone exclusively for making calls or sending messages today. If you're an Android user, the chances are high that you're using your phone or tablet for work-related activities. However, the basic set of apps and services your device was shipped with ...more

How To : The 4 Best Apps for Downloading Movies & TV Shows

Streaming is all the rage these days. But what about when you're on a plane, or have a limited data plan? You probably want to download your movies and TV shows instead. While Netflix is great, you can't rent Guardians of the Galaxy 2 and download it yet. What you need is an a ...more

Next Page
Prev Page
  • Hot
  • Latest