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
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
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
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
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
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
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:
Your iPhone's Hidden Back Tap Button Has 6 More Actions Available with iOS 18
How To:
Your iPhone's Clock App Just Got a Big New Feature with iOS 18
How To:
Apple's Messages App Has Some Cool New Text Editing Features and Effects for iMessage — Here's How It All Works
How To:
Your Lock Screen Just Got 13 Times Cooler with iOS 18 and iPadOS 18
How To:
22 Features the iPhone 16 and 16 Pro Models Have That Other iPhones Don't
How To:
21 iPhone 16 Pro Features You Won't Find on Apple's iPhone 16 or 16 Plus
How To:
These Are the Only Differences Between iPhone 16 Pro and 16 Pro Max
How To:
iPhone 16 Series — Preorder and Release Dates, Prices, and Where to Get One
How To:
11 New Apple Maps Features That Improve Hikes, Search, Favorites, Saved Locations, and More on Your iPhone
How To:
Create Custom Offline Routes for Walks and Hikes in Apple Maps
How To:
Safari's New Summary Feature Boils Webpages Down to Key Highlights for You — Here's How It Works
How To:
Your iPhone's Action Button Has 19 More Actions Available — Here's What's New and Changed with iOS 18
How To:
Apple's Weather App Just Got 13 New Features and Changes in the Latest iPhone Software Update
How To:
The Easiest Way to Find, Share, and Manage Wi-Fi Passwords Your iPhone and Other Apple Devices Auto-Saved for You
How To:
Apple's Massive Control Center Update Gives You 11 New Must-Try Features on iPhone and iPad
How To:
Safari's Secret Weapon to Distraction-Free Browsing Gives You Complete Control Over Webpage Annoyances
How To:
6 States Support Digital Driver's Licenses in Apple Wallet — Which States Are Next?
News:
Apple Rereleases iOS 17.6.1 for iPhone with Important Bug Fixes
How To:
Are Your Devices Compatible with iOS 18, iPadOS 18, and macOS 15? Here's the Complete List
How To:
Swap the Flashlight and Camera Lock Screen Controls on Your iPhone to Open Apps, Toggle Settings, and More
How To:
Your Lock Screen Just Got 13 Times Cooler with iOS 18 and iPadOS 18
How To:
Apple's Messages App Has Some Cool New Text Editing Features and Effects for iMessage — Here's How It All Works
How To:
Your iPhone's Hidden Back Tap Button Has 6 More Actions Available with iOS 18
How To:
Your iPhone's Clock App Just Got a Big New Feature with iOS 18
How To:
16 Harry Potter Spells for Siri That Turn Your iPhone into a Magical Elder Wand
How To:
See Passwords for Wi-Fi Networks You've Connected Your Android Device To
How To:
Use FaceTime's Secret Hand Gestures and Reaction Buttons to Add Animated On-Screen Effects to Your Video Feed
How To:
Create an Admin User Account Using CMD Prompt (Windows)
How To:
These Are the Only Differences Between iPhone 16 Pro and 16 Pro Max
How To:
Schedule Messages to Send Later Automatically Using iMessage
How To:
See What Traffic Will Be Like at a Specific Time with Google Maps
How To:
The Fastest Way to Toggle Your Pixel's Flashlight On/Off — Even When Your Screen Is Locked
How To:
Get Instant Solutions to Mathematical Problems on Your iPhone or iPad with Apple's New Math Notes
How To:
Use Collapsible Sections to Conquer Clutter in Text-Heavy Notes on Your iPhone, iPad, or Mac
How To:
Make Spoofed Calls Using Any Phone Number You Want Right from Your Smartphone
How To:
19 Harry Potter Spells Your Android Phone Can Cast Using Google Assistant
How To:
If 'Messages' Consumes Too Much iPhone or iCloud Storage, Don't Delete Your Conversations Just Yet
How To:
There's an Easy Way to See All the Unsent Messages in Your iMessage Conversations
How To:
Find Passwords in Exposed Log Files with Google Dorks
How To:
This iOS Shortcut Finds & Downloads Free Songs for You to Listen to Offline on Your iPhone
How To:
Safari's New Summary Feature Boils Webpages Down to Key Highlights for You — Here's How It Works
How To:
Are Your Devices Compatible with iOS 18, iPadOS 18, and macOS 15? Here's the Complete List
How To:
Dial These Secret Codes to See if Someone Is Hijacking Calls & Texts on Your iPhone
How To:
CC in a Physical Business Letter
How To:
Use Burp & FoxyProxy to Easily Switch Between Proxy Settings
Warning:
Sensitive Info You Black Out in Images Can Be Revealed with a Few Quick Edits on Your iPhone
How To:
Apple's Massive Control Center Update Gives You 11 New Must-Try Features on iPhone and iPad
Android Basics:
How to See What Kind of Processor You Have (ARM, ARM64, or x86)
How To:
The Complete Guide on How to Build a Crystal Radio—Plus How They Work
How To:
AirPods Are Getting Even Better Thanks to iOS 18
How To:
Use Odin to Flash Samsung Galaxy Stock Firmware
How To:
Make the Most of Apple Intelligence's Writing Tools to Proofread, Rewrite, Summarize, and Create Content
How To:
100+ Secret Dialer Codes for Your iPhone
How To:
Turn Your Gag Reflex Off with Pressure Points
How To:
The Easiest Way to Secretly Record Someone's Conversation with Your iPhone
How To:
Roll Sushi—The Ultimate Guide
How To:
Use SpiderFoot for OSINT Gathering
Gaslighting 101:
How to Turn People's Own Thoughts Against Them
How To:
The Top 80+ Websites Available in the Tor Network
How to Hack Wi-Fi:
Stealing Wi-Fi Passwords with an Evil Twin Attack
