Baking a cake is relatively easy... if you happen to have a cookbook or some boxed cake mix nearby. And though you can use the internet or your favorite cooking app, it can be nice to just cook without a recipe. That seems impossible with baking, which is such an exact science ...more
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 529th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
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
Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 348th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to build a formula that will take in ...more
This video shows how to find the formula of a piecewise function when given a graph. The first step is to write a definition for the graph, which is done by identifying the different domains shown in the graph. The second step is writing formulas for each domain specified by t ...more
Like many others, I like a good cocktail every now and then, and I've always been impressed when my cocktail enthusiast friends would come up with a new drink or even just remember how to concoct a Clover Club (FYI, it's made with gin, raspberry syrup, lemon, and egg white). T ...more
In order to convert Celsius to Fahrenheit, you will need to use this formula: F = 9/5C + 32. Therefore, you will need to solve for C or substitute values and solve in that manner. To find Fahrenheit temperature for -20 degrees Celsius, you can just plug it into the formula. T ...more
In this tutorial, we learn how to find the standard deviation with the Z-Score formula. First, take your problem and write it out one by one underneath each other. Then, you will need to substitute the numbers in for the variables that are in the problem. Once you do this, you ...more
Pickling isn't rocket science. In fact, anyone can make their own speciality pickles using just about any fruit or vegetable. For example, I've pickled everything from lemons, watermelon rinds, and apples to red onions, carrots, radishes, and cucumbers. Don't Miss: DIY Pickle ...more
As you might guess, one of the domains in which Microsoft Excel really excels is business 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 39th installment i ...more
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 242nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
In this tutorial the instructor shows how to find the area of an oblique triangle using different formulas. To find the area of an oblique triangle there are different formulae. The first formula to calculate the area of a triangle is area A = (1/2) * a * b * Sin(C), where a a ...more
This video is recorded in a mathematics class room. It is very clear by the sound and picture. The faculty here is explaining that the ratio between two numbers can be found using various formulae and methods. For example, 3:1 is the ratio between p and q. Likewise he explaine ...more
The man was requested to solve a short, basic chemistry exercise. He starts by explaining the meaning of the terms involved in the problem: molecular mass, empirical formula and molecular formula. He also explains the way the are connected, for a better understanding of the wa ...more
Learn how to convert a formula to a value in a Microsoft Excel 2010 spreadsheet. 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 2010 workflow, you're sure to ...more
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 233rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
In this video the tutor shows how to simplify a quadratic formula result. You can solve a quadratic equation using the quadratic formula. The first thing you have to do when given the quadratic equation is bring all the terms to one side so that you have a zero on the other si ...more
The battle between Pepsi and Coke has been a grueling one, with both sides securing their secret formulas for great tasting, addicting sodas behind lock and key. But even big time companies screw up every now and then, and one of the most guarded trade secrets in the beverage ...more
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 578th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
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 8th installment in his series of Excel array formula seri ...more
In this video tutorial it shows you how to find the x-bar by using the Z-score formula. In the beginning of this video the formula is displayed on the right, while the values that you need to plug in are on the left. Once you plug in the values and do the cross multiplying, al ...more
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 228th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more
Looking for a primer on how to create and work with arrays 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 3rd installment in his series of Excel array formula series, you' ...more
In this free video math tutorial, we learn how to use the Z-Score formula to find a data point (Xi) in statistics. With mathematics, as with anything else, not everyone progresses at the same rate. Stats is no exception. Happily, in the age of Internet video tutorials, this is ...more
In this tutorial the instructor explains the percentile formula. He says that the percentile formula is used to find the percentile rank of a data point in a group of data. He takes an example that consists of the lengths of puppies. Now he intends to find out the percentile r ...more
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
In this video, we learn how to derive and use the slop formula. The slope of a line is equal to change in y divided by the change in x. First, put the first point on the coordinate point. Then, represent the X and Y by X1 and Y1. Then, put the second point on the plane, repres ...more
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 336th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ROWS, COLUMN ...more
Find the midpoint of two points using a easy formula. Each coordinate has a x and y. X being the first number and y being the second number. So using the formula of x one plus x two then divide the sum by two. Using the same formula with the y coordinates. After plugging the n ...more
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 666th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the ...more
Need to know how to find the formula for a piecewise function from a graph? 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 th ...more
Excel 2008 for Mac makes it easy to create formulas for cells. You could always do it before, but now with the new Formula Builder feature, building formulas just got one step closer to simple. The Microsoft Office for Mac team shows you just how to build formulas by using the ...more
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 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
Robert demonstrates how to quickly insert formulas into Excel. To create a sum, highlight your selected cells and press the sum key. Expand the formula by clicking on the fill handle. Double click on the fill handle to expand the formula. To sum vertical columns, highlight all ...more
In this tutorial, we learn how to find the formula of a given sequence. First, you need to decide what you're starting with. Start with a1, then continue on with a2, a3, and a4. Eventually, you will have an "An". You will have an "n" in your numerator and the denominator will ...more
Check out this informative video tutorial from Apple on how to create formulas with Quick Formula in Numbers '09. iWork '09, the office productivity suite from Apple, is the easiest way to create documents, spreadsheets, and presentations. Writing and page layouts are easy in ...more
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 ...more
This video shows how to enter values into cells using Excel macros and Visual Basic. This includes a sample Expense Report that is used in this demonstration. In this demonstration, we will create the macro that inputs a title as "Expense Report", Three columns i.e. "Date", "I ...more
The video is a tutorial in trigonometry. The teacher teaches that the tangent or the tan of an angle is the ratio of the opposite side to the adjacent side of a right angled triangle. If one side and one angle is given then the value of the unknown side can be found by solving ...more
In this tutorial, we learn how to use the Quintile Formula in Statistics. To find the quintile rank of a formula that is in a certain set, you will first need to count the number you are given. Then, read the equation so you understand what the R, N, equal side, and other numb ...more
In this tutorial, we learn how to use the distance formula for two points. The distance formula is D= the square root of (X2-X1) squared, plus (Y2 minus Y1) squared. It may look confusing, but it's just a derivation of a theorem. First, find the two points that you have and gr ...more
In this free video science lesson from Internet pedagogical superstar Salman Khan, you'll learn how to determine the empircal and molecular formulas of a substance given percent composition. Whether you need help studying for that next big test or could just use a hand finishi ...more
The Pythagorean theorem is a simple theorem that states that - for a right angled triangle the square of the length of the hypotenuse is equal to the sum of the squares of the length of the remaining two sides. In this video, a right angled triangle with three sides, namely a ...more
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 210th installment in their series of digital spreadsheet magic tricks, you'll learn what to do if ...more
In this video, we learn how to draw a Formula 1 Ferrari F60. Start out by drawing of the car, then start to shade it in. Shade in the wheels and then the rest of the vehicle with a lighter pencil. After this, use the eraser to erase different parts of the car to make it look m ...more
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 207th installment in their series of digital spreadsheet magic tricks, you'll learn how to set up ...more
Scientists have recently released a mathematical breakdown of the perfect handshake. The University of Manchester researchers discovered that nearly one-in-five people hate the handshake, listing complaints such as sweaty palms, limp wrists, gripping too hard and no eye contac ...more
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 9th installment in his "Excel Formula E ...more
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
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 and Mr. Excel, the 45th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
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 and Mr. Excel, the 12th installment in their joint series of digital spreadsheet magic tricks, you'll l ...more
Oh, don't look so grumpy, Coco. I'm sure Nylon's secret formulas will only be used in the direst of situations: A) Sometimes a girl can't wait for the latest runway shades to hit the shelves OR B) Dead broke! (and saving for that pricey Chanel bag anyway). Here are five reci ...more
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 652nd installment in their series of digital spreadsheet magic tricks, you'll learn see how to cre ...more
In this Excel magic trick video the tutor shows how to change operator in a formula from a drop down using Choose function. He shows a basic work book which can be downloaded from the internet for hands-on to the tutorial. In this trick the tutor shows how to include some oper ...more
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 292nd installment in their series of digital spreadsheet magic tricks, you'll learn how to extract ...more
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 649th installment in their series of digital spreadsheet magic tricks, you'll learn see how to inc ...more
A beginner's Microsoft Excel tutorial that covers working with formulas, formatting, auto-formatting, dates, and more in Microsoft Excel. Part 1 of 2 - How to Use formulas and formatting in Microsoft Excel. Part 2 of 2 - How to Use formulas and formatting 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 692nd installment in their series of digital spreadsheet magic tricks, you'll learn how to increme ...more
This is a video tutorial in the Education category where you are going to learn how to compare 2 distributions with the Z-Score formula. In this example Doug's class has X bar as 71 and a standard deviation of 4. Corey's class has X bar as 68 and a standard deviation of 11. If ...more
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 589th installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
How To:
Use Genmoji to Create Custom Emoji That Work Just Like Regular Emoji in Messages, Notes, and More
How To:
Make Typing Text Easier to Read on iPhone, iPad, or Mac with Apple's Hover Typing Tool
How To:
Change the Default Web Browser App on Your iPhone to Open Links in Chrome, Firefox, Safari, and More
How To:
Use Apple Intelligence's Image Playground to Craft Custom Drawings and Animations for Almost Anything You Can Think Of
How To:
Follow the 2024 Election Results in Real Time with Apple News' Live Activity for iPhone, iPad, and Apple Watch
How To:
Experience Music on Your iPhone Like Never Before with Music Haptics, Which Lets You Feel Every Beat
How To:
Generate Text, Images, and Insights with Apple Intelligence's Built-in ChatGPT Integration
How To:
Remove Unwanted Objects, People, and Distractions in Photos on Your iPhone, iPad, or Mac
How To:
Quickly Pixelate Faces in Photos on Your iPhone, iPad, or Mac to Blur Out People's Identities
How To:
New Menu Lets You Set Default Apps on Your iPhone or iPad for Calling, Messaging, Emailing, Web Browsing, and More
How To:
30 Must-Know New Features in iOS 18.1 and iPadOS 18.1 That'll Make You Want to Update
How To:
Easily Record Phone Calls on Your iPhone and Get Auto-Generated Transcripts and Summaries
How To:
Download and Install iOS 18.2 Beta or iPadOS 18.2 Beta to Try New iPhone or iPad Features First
How To:
Apple Music's 17 Hidden Features and Changes You Might've Missed on iOS 18 and iPadOS 18
How To:
Create and Manage Reminders Without Ever Leaving the Calendar App on Your iPhone, iPad, or Mac
How To:
Apple's Latest Podcasts App Update Brings 7 Must-Try Features in iOS 18, iPadOS 18, and macOS 15
How To:
Apple's Big TV App Update Gives You 10 New Features and Changes to Enhance Your Viewing Experience
How To:
Link to Specific Start Times in Apple Podcasts Episodes from iPhone, iPad, Mac, or the Web Player
How To:
Everything You Can Do with the Camera Control Button on Your iPhone 16 or 16 Pro
How To:
Always-Updated List of Apps That Support the Camera Control Button on iPhone 16 Series Models
How To:
Use Genmoji to Create Custom Emoji That Work Just Like Regular Emoji in Messages, Notes, and More
How To:
See Passwords for Wi-Fi Networks You've Connected Your Android Device To
How To:
30 Must-Know New Features in iOS 18.1 and iPadOS 18.1 That'll Make You Want to Update
How To:
Remove Unwanted Objects, People, and Distractions in Photos on Your iPhone, iPad, or Mac
How To:
Use Apple Intelligence's Image Playground to Craft Custom Drawings and Animations for Almost Anything You Can Think Of
How To:
Create an Admin User Account Using CMD Prompt (Windows)
How To:
Experience Music on Your iPhone Like Never Before with Music Haptics, Which Lets You Feel Every Beat
How To:
Follow the 2024 Election Results in Real Time with Apple News' Live Activity for iPhone, iPad, and Apple Watch
How To:
16 Harry Potter Spells for Siri That Turn Your iPhone into a Magical Elder Wand
How To:
CC in a Physical Business Letter
How To:
Make Spoofed Calls Using Any Phone Number You Want Right from Your Smartphone
How To:
Use Odin to Flash Samsung Galaxy Stock Firmware
How To:
Generate random numbers (with decimals) in Excel
How To:
Run Mac OS 7 on Windows XP
How To:
Use FaceTime's Secret Hand Gestures and Reaction Buttons to Add Animated On-Screen Effects to Your Video Feed
How To:
Dial These Secret Codes to See if Someone Is Hijacking Calls & Texts on Your iPhone
How To:
Clone Any Android App on Your Samsung Galaxy Phone Without Using Any Third-Party Tools
Warning:
Sensitive Info You Black Out in Images Can Be Revealed with a Few Quick Edits on Your iPhone
How To:
Schedule Messages to Send Later Automatically Using iMessage
How To:
Clear Your Frequently Used and Recent Emoji from Your iPhone's Keyboard
How To:
Download and Install iOS 18.2 Beta or iPadOS 18.2 Beta to Try New iPhone or iPad Features First
How To:
Turn Any Website into a Full-Screen App on Your iPhone
How To:
13 Tips Every Apple Pencil User Needs to Know for iPad
How To:
20 Surprisingly Practical Uses for Apple AirTags
How To:
Apple Music's 17 Hidden Features and Changes You Might've Missed on iOS 18 and iPadOS 18
Redstone Logic Gates:
Mastering the Fundamental Building Blocks for Creating In-Game Machines
How to Hack Wi-Fi:
Cracking WPA2 Passwords Using the New PMKID Hashcat Attack
How To:
Phish for Social Media & Other Account Passwords with BlackEye
How To:
Find the Version Number for Any App on Your iPhone or iPad — Even Stock Apple Apps
How To:
Install Facebook Lite on Your iPhone
How To:
Use Samsung's Hidden Undo & Redo Gesture for Galaxy Devices
How To:
Use Google Assistant to Quickly Post to Twitter, Facebook, Instagram, Snapchat & TikTok
How To:
Make a three string guitar out of a cigar box
How To:
Use Burp & FoxyProxy to Easily Switch Between Proxy Settings
How To:
Test Your Samsung Phone by Using Secret Code *#0*#
How To:
You're Using Lidar on Your iPhone and iPad — And You Don't Even Know It
How To:
Your iPad Has a Hidden Built-in Calculator You're Not Using — Here's How to Unlock It
How To:
Make the USB Connection on Your Android Phone Default to File Transfer Mode
How To:
Fold an Origami F-18 Fighter Jet Out of a Dollar Bill
How To:
Prevent Thieves from Turning On Your iPhone's Airplane Mode, So You Have a Better Chance to Track It Down
