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
Programming with Excel
When programming an Excel-file with links between sheets and assorted macros for whatever is needed you may want the file to behave as a program so that users can not access the ribbon even by double-clicking on the top bar. Protect the code from being accessed by pressing alt ...more
Repeating a task using a For...Next loop : Excel: VBA in Depth from lynda.com Watch the entire course at http://www.lynda.com/home/DisplayCourse.aspx?lpk2=62906&utm_source=youtube&utm_medium=viral&utm_content=youtube&utm_campaign=youtube In Excel: VBA in Depth, Excel and VBA ...more
What's the easiest way to keep track of your website passwords? Maybe in a password-protected document on your computer? Makes sense. But surprisingly, this is no easy task in Mac OS X. Snow Leopard does not have an easy one-click option for password protecting files and fold ...more
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
PrimoPDF is a free program that will allow you to convert any document (Microsoft Word, Excel, PowerPoint and more) into a usable PDF file. This tutorial walks you through downloading, installing and using the PrimoPDF program to convert your files to PDFs. PrimoPDF even allow ...more
The DeskPDF programs, published by DocuDesk, offer several methods for converting files in one format to an entirely different format - such as turning an HTML table on a web page into an Excel file or turning an RSS feed into an ebook file.
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
This video, presented by Cris Ippolite, makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing that programs like Microsoft Excel uses, what in the databases circles, are called flat files. This flat files have a big dis ...more
Xtracharts, a control for Winforms, allows the user to easily export charts made using the program into a PDF, HTML or MHT, Excel spreadsheet or standard image. This tutorial shows the Winforms user how to properly code and then export the chart.
When converting an Excel file to an Adobe PDF document, you might sometimes accidentally export several pages of empty space. This tutorial briefly explains how to use the Acrobat program to convert your spreadsheet or worksheet to PDF format and avoid the blank gaps.
Cordell Connect is useful software for managing projects for your business. One of the functions of this program is being able export your reports to either an Excel spreadsheet or a PDF document for a greater ease of data manipulation and communication.
Converting an Excel spreadsheet to a single PDF file is quite easy, even if there are multiple worksheets in your document. This tutorial even demonstrates a common Excel error and how adjust your program's dpi settings to avoid double spooling.
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
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
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
See how to use themes to set color, font and effects settings for a Microsoft Excel 2007 workbook. 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 iterat ...more
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
Speed up your MS Excel workflow with these handy formatting key commands. 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'r ...more
In this video, learn how to export reports to Word, PDF, Excel, and/or TXT formats. Learn step-by-step how to export your reports to any program or format in just a few easy steps.
Adding formatting to plain Excel spreadsheet is a wonderful way of increasing the readability and improving the overall look and feel of your data. With this software how-to from ExcelIsFun, you'll learn all about using the Microsoft Office program's formatting features. As an ...more
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
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 demonstrates how to use the Excel function SQRT. This allows you to determine the square root of any number, within a spreadsheet program.
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
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
See how to create value-based formatting using data bars and color scales in 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 busi ...more
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
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
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
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
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
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
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
To customize the over all design of a specified document, you need to adjust Page Layout settings. This is easily done by clicking the Page Layout button and customizing settings such as orientation, scaling, and margins. With this tutorial, learn how to open the Page Setup d ...more
A few days ago, CloudOn released their free mobile app that brought Microsoft Office directly to your Apple iPad. The cloud-based service effectively runs Office on their end, allowing you to use apps like Word and PowerPoint to edit your documents, which you would house in Dr ...more
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
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
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
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
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 video demonstrates how to use the Excel function ASINH. This program determines the inverse hyperbolic sine of a 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.
This video demonstrates how to use the Excel function ATAN to determine the inverse trigonometric tangent function in a spreadsheet program.
This video tutorial shows how to use the Excel function ACOT. This function determines the inverse cotangent of a number within a spreadsheet program
We are most certainly not machines. We all need some downtime every once in a while to set our sanity scales back in balance, which in turn, makes us more productive workers. This is a premise that several forward-thinking employers fully understand, but these types of compani ...more
Crayon, a free 3D drawing application by the mysteriously named arkalian, showed up in the Windows Store recently, so I gave it a try like I do all new apps for Windows Holographic. Truthfully, I loaded it up not expecting much, but wow, was I wrong. It's a simple idea, but it ...more
When it comes to text documents and spreadsheets, Microsoft Office is the be-all and end-all office suite—but it's not cheap. Paying anywhere from $140 to $400 puts a big dent in your bank account, especially if you're a broke college student eating ramen for breakfast, lunch, ...more
Yesterday, Microsoft released the customer preview of its newest version of Office, the first version optimized for both touchscreens and desktop systems. The entire suite got a much-needed facelift and a few new cool features. Here are some of the most notable changes. Cloud ...more
Apple's codec for photos and videos in iOS 11, HEVC (High-Efficiency Video Coding), as well as the container, HEIF (High-Efficiency Image File Format), result in a reduction in size for pictures and movies without sacrificing quality. Seems like a win-win situation, but Window ...more
In our previous article, we learned how to take advantage of a feature, Dynamic Data Exchange (DDE), to run malicious code when an MS Word document is opened. Because Microsoft built DDE into all of its Office products as a way to transfer data one time or continuously between ...more
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
Welcome back my fellow hackers! In my last few articles, I've concentrated on what is called a listener, which is basically the same thing as backdoor and rootkit, only "listener" sounds much less malevolent than the other two terms. First, I covered embedding a listener in ...more
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
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
When performing something such as a mass mailer attack on a company, sending executables usually isn't the best option. That's why, in this tutorial, I'll be teaching you how to code a VBA script macro into a Word document in order to compromise a system. Combined with a littl ...more
Welcome back, my hacker apprentices! Although there is a multitude of different hacker types, the one target they all share is the database. I often refer to the database as the hacker's Holy Grail, or the ultimate prize for an effective hack. That's because the database—alm ...more
Have you ever seen those super-expensive universal remote controls like the Logitech Harmony and thought to yourself, "Man, I really want one of those, but that's just too much money"? You're not alone. Luckily, if you're an owner of an Android device with an infrared (IR) bl ...more
Each day, we read about another security breach somewhere in our digital world. It has become so commonplace that we hardly react anymore. Target, J.P. Morgan, iCloud, Home Depot, and the list goes on and on. Those are just the big ones that get reported in the news. Millions ...more
Welcome back, my greenhorn hackers! For over 15 years, a tiny but powerful tool has been used by hackers for a wide-range of activities. This tool goes by the name of netcat, and although well known in hacking circles, it's virtually unknown outside. It's so powerful and usef ...more