Function Search Results

How To: Customize Your Mac's Top Keys to Control Either Functions or Built-in Features Without Using “Fn”

Mac keyboards are great when listening to music or watching a movie, since you can control what's playing without going back into iTunes or QuickTime Player. However, when you're using an app like Photoshop that uses the F7, F8, and F9 as shortcuts, it gets pretty annoying to have to hold down the Fn key. Why can't you just hit the back, play/pause, and skip buttons alone?

How to Train Your Python: Part 10, Making Our Own Functions

Welcome back! In the last iteration of how to train your python, we covered error detection and handling. Today we'll be diverging from this and discussing functions. More specifically, we'll be creating our own functions. First we'll need to understand exactly what a function is, then we'll get on to making our own! So, let's get started!

How To: 9 Ways to Use Gatorade for Function, Fun, & Frivolity

Gatorade: its popular red flavor can stain the whitest fabric, and its sweet taste is oddly refreshing after breaking a sweat. If you've ever participated in a sport, you probably spent halftime at games and practice breaks chugging the stuff. Though it made its name as a sports drink, Gatorade is also a well-known hangover helper—but its beneficial and interesting uses don't end there. The brightly colored drink can do so much more than just hydrate you.

How To: Use the SUMIF function with an array in Microsoft 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 694th installment in their series of digital spreadsheet magic tricks, you'll learn how the SUMIF function (and COUNTIF, etc.) cannot accept arrays. If you need to sum by year from transactional data the SUMIF and YEAR functions cannot be used together. Instead we can use the SUMPRODUCT function.

How To: Use the DATEDIF function in Microsoft Excel 2007

Looking for a primer on how to use the DATEDIF function in MS Excel 2007? You're in luck. 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 2007 workflow, you're sure to be well served by this video tutorial. For more information, including step-by-step instructions, take a look.

How To: Use the ADDRESS function in Microsoft Excel

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 98th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to use the ADDRESS function to make labels in templates easier for users to understand.

How To: Use the AGGREGATE function in Microsoft Excel 2010

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 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...

How To: Find the inverse of a function in algebra

Need a little help figuring out how to find the inverse of a function in algebra? Watch this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this free math tutorial, you'll learn how to calculate the inverse of a given algebraic fun...

How To: Use VLOOKUP function formulas in Microsoft Excel

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 7th installment in his "Highline Excel Class" series of free video Excel lessons, you'll learn how to work with VLOOKUP function formulas in MS Excel. Specifically, you'll see the following:

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" series, you'll learn about the basics of Excel's SUMPRODUCT function — why some people use double negative and why other use times one.

How To: Multiply matrices with the MMULT function in MS Excel

Looking for a primer on how to create and work with array formulas in Microsoft Office Excel? You've come to the right place. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 12th installment in his series of Excel array formula series, you'll learn how to use the array function MMULT to multiply multiple matrices in matrix algebra. (NB: This is an array function that requires the Ctrl + Shift + Enter trick.)

How To: Look up formulas in Excel with the CHOOSE function

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 557th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the CHOOSE function look up a formula or function depending on your drop-down selection. See also how to create combo box form controls and data validation lists with the VLOOKUP function.

How To: Create a chart for a linear function of X in MS 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 239th installment in their series of digital spreadsheet magic tricks, you'll learn how to create a chart for a linear function of X in Excel as well as how to use a text formula to display a function of X.

How To: Calculate the slope of a linear function

Need some help figuring out how to find the slope of a linear function? See how it's done with this free video algebra lesson. Need help finding the From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test). With this installment from Internet pedagogical superstar S...

How To: Use the sparkline function in Microsoft Excel 2010

There is a new function in MS Excel 2010 called ‘Sparkline’ which helps you quickly find trends associated with a set of data. To create Sparkline, you can go to ‘Insert’ tab and then select ‘Sparkline’ section and then select the graph type. After you enter the data range and location range, the Sparkline will show up indicating the trend based on the data range you identified earlier. You can change the types and styles of your Sparkline easily. As the video demonstrates, whenever you use E...

How To: Find the domain of a function without graphing

Want to find the domain of a function without graphing it? Learn how with this free video lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Find and sketch the domain of a multivariable function

Looking for a primer on how to find and sketch the domain of a function z = f(x, y) in calculus? Learn how with this free video calc lesson. From Ramanujan to calculus co-creator Gottfried Leibniz, many of the world's best and brightest mathematical minds have belonged to autodidacts. And, thanks to the Internet, it's easier than ever to follow in their footsteps (or just finish your homework or study for that next big test).

How To: Use the CONFIDENCE.T function in Microsoft Excel 2010

New to Microsoft Excel 2010? Looking for a few good tips and tricks? Look no further. In this free video tutorial from everyone's favorite MS Excel guru, YouTube's ExcelIsFun, the 7th installment in his series of Excel 2010 video tutorials, you'll learn how to use Excel's new CONFIDENCE.T function to calculate the margin of error for a T distribution confidence interval.

Prev Page