New to 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 Excel tutorial from ExcelIsFun, the 574th installment in their series of digital spreadsheet magic tricks, you'll learn how to streamline filtering when you have categories of criteria using an array formula that uses the functions COUNTIF, VLOOKUP, ROWS, IF, INDEX, SMALL, and ROW. Also see how to put OR criteria into the IF function as well as how to do an OR coun...
In this video we learn how to use the AutoCorrect function found in Microsoft Excel 2007. This video is the second part of the Microsoft Excel 2007 tips series. The video shows on screen and the host explains how to find the AutoCorrect function and gives an address to download the example spreadsheet from their TeachExcel website. AutoCorrect is a nice function but it is not personalized, and if you often misspell a word it can be handy to add it to AutoCorrect to catch it every time. Unlike...
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 473rd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract a unique list from a group of individual rows.
This video walks you through the steps of solving linear function graphs. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
This video walks you through the steps of solving a exponential decay function. This excellent video shows you a clean blackboard, with the instructors voice showing exactly what to do. Don't fret, any question you may have, will be answered. Watching this video will make you feel like your back in the classroom but rather comfortably from your home.
A video from Helpvids.com that shows how to insert special characters in MS Word 2007. A seldom used function in MS Word is the Insert Symbol function. Symbols like the copyright, infinity, registered trademark, Yen, Pound, Euro etc can be of use in some documents. Word provides an easy way to insert these and many other such symbols into your documents without much hassle (For example, using the Character Map utility provided with Windows).
This video will show you how to use the map function on your iPhone. Follow these steps to use the map function on your iPhone: From the Home screen, tap 'maps' to open the Map window. Use your finger to navigate and scroll around the map. Pinch your fingers apart and you will zoom in to the location, pinch your fingers together and you will zoom out. You can use your GPS to track where you are by tapping the Tracking icon. If you wish to search for a location, simply tap on the Search field ...
As each new version of the award winning Adobe Photoshop is released certain functions remain the same from prior versions while other functions are changed. In the latest version of Photoshop, Adobe Photoshop CS4, the patch tool works significantly differently than prior versions. In this video we are shown how the patch tool originally worked in Adobe Photoshop CS2 compared to how it now functions in Photoshop CS4. Finally the author gives us step by step instructions on how to operate the ...
The is a video from free math tutoring that teaches you about in-equations or inequalities and optimization functions of algebraic problems.
In this lesson, learn what white balance is and how to effectively use this function on your digital camera. Also learn how to use the photo filter function in Photoshop to eliminate and correct color casts created by various light sources. Watch this video photography tutorial and learn how to use white balance on a digital camera and how to correct colors with after-effects lens filters in Photoshop.
If you're an electrical engineer, you needn't worry about this educational video, but if you aren't...
It's nearly impossible not to be at least somewhat familiar with Microsoft Excel. While it's needed for many office jobs and data analysis fields, hackers could also benefit from improving their spreadsheet skills. Many white hats already know some of the essential Excel hacks, such as cracking password-protected spreadsheets, but there's so much more to know from an attack standpoint.
Hashes are commonly used to store sensitive information like credentials to avoid storing them in plaintext. With tools like Hashcat, it's possible to crack these hashes, but only if we know the algorithm used to generate the hash. Using a tool called hash-identifier, we can easily fingerprint any hashes to discover the right Hashcat mode to use to retrieve a password.
One of the most critical bugs to come out in the last five years was Shellshock, a vulnerability which allows attackers to execute arbitrary code via the Unix Bash shell remotely. This vulnerability has been around for a while now, but due to the ubiquity of Unix machines connected to the web, Shellshock is still a very real threat, especially for unpatched systems.
Developers creating login systems know better than to store passwords in plain text, usually storing hashes of a password to prevent storing the credentials in a way a hacker could steal. Due to the way hashes work, not all are created equal. Some are more vulnerable than others, and a little Python could be used to brute-force any weak hashes to get the passwords they were created from.
Welcome back everyone. I apologize for the lack of training articles, but I've been rater busy lately. I've recently picked up a second job and my college courses are now back in session, so I'm a bit strapped for time.
Welcome to a tutorial on crypting technology. In this article, we will be discussing types of crypters, how they work and why they work. After defining these, we will then make our own basic crypter using the function I gave to you as a task to complete by yourself in the previous tutorial.
In previous tutorials we have encountered these things called pointers and addresses but we still don't know what they really are. Let's learn a bit more to clear things up.
Welcome back! Sorry for being so quiet, I've been rather busy with this project lately! Anyways, in the last iteration of how to train your python, we covered lists. Today we'll be introducing iteration and the two loops python has to offer, for and while. Also, we'll be covering a couple general use functions. So, let's get started!
Do you remember the last time we used BeEF? Well, now we get to use it again, but this time with MITMf! We are going to auto-inject the hooking script into every webpage the victim visits!
Deep down, Android is a fork of Linux, which is a desktop operating system that started out as entirely command prompt-based. For that reason, many system-level tasks can still be executed within a terminal emulator app.
HTC pulled out all the stops when designing the HTC One M8. From it's sleek body, to it's incredible sound quality, this thing just oozes sophistication. While all of these add-ons are great, they can be incredibly taxing on the CPU, in turn causing some serious lag.
Chaining methods in PHP can be simple and straightforward if you follow along with this informative video tutorial on PHP OOP methods from JREAMdesign. The key action is to return the object after running the function so that you can run another function to the object directly afterwards.
So you've mastered variables, and now it's time to take a look at functions and how they work on the very basic level in Python. This tutorial also takes a brief look at importing modules, and how they work in your Python program.
In this video 2 people show you copy and paste functions on a Mac and a PC. On the PC, the girl copies a paragraph of text on a web page by highlighting it, right clicking, and selecting copy. Then she opens up a TextEdit program and pastes it into there and saves it. On a Mac, just like the PC, he highlights the paragraph, but this time he drags the highlighted portion right to the desktop. This will automatically create a file right on your desktop. If you open it up, it will open up in a t...
In this tutorial, we learn how to find the arc length of a function. All you're doing when finding arc length is finding the curve between 'a' and 'b'. Imagine this as a string you're pulling straight to see how long it is going to be. The formula says if your function is in 'y=x' you have to take one times the derivative squared. This is a basic formula that you will use to find the arc length. When you plug in your values to this equation, you will find the answer. Practice with the example...
In this tutorial, we learn how to graph a parabola. Quadratic functions are parabolas. To graph these, you will first need to look at the function, which is the set of outputs for a set of inputs. Write this out on a t-chart to find what your 'x' and 'y' values are. Once you find these, you will plug in the coordinates to a graph. After you have written down the coordinates, you can graph your parabola. This is easy to do if you are familiar with quadratic functions and good at math. Just pra...
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, part of his "Excel Finance Class" series of free video lessons, you'll learn how to use the FV function to calculate the future value of an annuity.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 35th installment in his "Excel Finance Class" series of free video lessons, you'll learn how to calculate the present of a loan with the PMT function.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 4nd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to build an amortization table for a consumer loan in Excel with the PMT function.
As you might guess, one of the domains in which Microsoft Excel really excels is finance math. Brush up on the stuff for your next or current job with this how-to. In this tutorial from everyone's favorite digital spreadsheet guru, YouTube's ExcelIsFun, the 43rd installment in his "Excel Finance Class" series of free video lessons, you'll learn how to create an amortization table for a business loan with Excel's PMT function.
In this tutorial, we learn how to evaluate functions. A function is an equation with an input and an output. For the value of "X" there is going to be a value for the rest of the values that are in the equation. To start, write out the equation, then substitute the "x" with the appropriate number. After this, substitute the "x" in the rest of the equation where it belongs. Once finished, work out the rest of the equation in the appropriate order. Now you will be able to finish it and get the ...
In this clip, you'll learn how to make calls into JavaScript functions with .NET code when working in Silverlight. Whether you're new to Microsoft's popular web application framework or a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free MS Silverlight programming lesson. For more information, including a complete demonstration and detailed, step-by-step instructions, take a look.
In this clip, you'll learn how to call .NET functions from JavaScript when working in Silverlight. Whether you're new to Microsoft's popular web application framework or a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free MS Silverlight programming lesson. For more information, including a complete demonstration and detailed, step-by-step instructions, take a look.
In this clip, you'll learn how to make basic calculations with arithmetical functions when coding in PHP. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
In this clip, you'll leawrn how to create math functions when coding in Java. Whether you're new to the Java object-oriented programming language or are a seasoned developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
In this clip, you'll learn how to create a simple array function when coding in PHP. Whether you're new to the PHP: Hypertext Preprocessor scripting language or are a seasoned web developer merely looking to improve your chops, you're sure to find benefit in this free video programming lesson. For more information, including detailed, step-by-step instructions, take a look.
Looking for a quick guide on how to utilize date & time functions in your Access queries? You're in luck. Whether you're new to Microsoft's popular data management application or a seasoned MS Office professional just looking to better acquaint yourself with the Access 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, watch this free video guide.
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 715th installment in their series of digital spreadsheet magic tricks, you'll learn how to take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero.
In this tutorial, we learn how to improve your typing speed. First, log onto your internet browser and go to the website, Typeracer. Once you are on this site, you can create an account and start to type on it! When you are on this, you can go into different types of races, then see what your scores are against other people. You continue to type until you win the race you are in. Once you are finished typing, you will see your stats and you will be able to improve from there. This is a great ...
