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 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a nam ...more
Teach Excel demonstrates how to make an Excel dynamic named range across multiple rows. Highlight the cells that you want to include in your named range and give it a name. You can then use that name in formulas. But it's not a dynamic named range so it won't account for added ...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. With this video tutorial from ExcelIsFun, the 376th installment in their series of digital spreadsheet video tutorials, you'll learn how to an array formul ...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 202nd installment in their series of digital spreadsheet magic tricks, you'll learn how to create ...more
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 533rd installment in their series of digital spreadsheet magic tricks, you'll learn how to create a formula t ...more
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 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub ...more
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 186th installment in their series of Excel magic tricks, you'll see how to extract records that meet two cond ...more
In this video, ExcellsFun takes you step by step on how to calculate your employee payroll using an excel spread sheet. ExcellsFun teaches you how to take the base pay of various employees' salaries and determines how much you are paying them over a week, month, and year. Exce ...more
Create a table with sales data with this video. Insert the values in the table. Just set the name as 'sd' that means of sales data. Just imagine we have columns A to J. So start values with A2 and end with J9. In menu bar type as A2 to J9. It's just as to select as a table wi ...more
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 262nd installment in their series of Excel magic tricks, you'll see how to create a Weekly Chart that can sh ...more
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel. To use the Vlookup function in Excel 2007: 1. Click on the Formulas tab on the ri ...more
This video shows the method to find the variance and standard deviation using Excel. The variance shows the variability of the data points from the median. We find the difference of the median and the mean. We write the formula using '=' sign. The median and data points are pu ...more
We're on sheet, tab, filter. We want to talk about filter, but we also want to talk about an Excel table or list. It is simply a data set with field names at the top, records in rows, no blanks anywhere and no other data sets touching this data set. When we convert to a table, ...more
If you're looking for a way to create a student report, Microsoft Excel makes it easy to create a wonderful spreadsheet with tons of information. This video shows an example of a student report being created, which has three simple items in the columns of the sheet, which are ...more
In a flurry of moves today, Microsoft has not only released their suite of Office apps for the iPad, but they also updated their Android and iOS Office Mobile apps to allow for creating and editing documents without requiring an Office 365 account (so long as it's for "home" u ...more
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 ...more
Microsoft Excel is one of the most widely used tools in the professional sphere. It's also one that's difficult to master beyond a superficial understanding of how to input data. The All-In-One Microsoft Excel Certification Training Bundle can teach you how to make this multif ...more
Microsoft Excel is one of the most useful tools you can bring into your professional life. However, as useful as Excel is, it can also be difficult to learn on your own. The All-In-One Microsoft Excel Certification Training Bundle is an incredible tool that will take you from ...more
Data analytics is one of the hottest fields around. With so much data at our fingertips, top companies are seeking experts to put all of this information to real-world use. The 2020 Master Microsoft Excel & Power BI Certification Bundle is your ticket to a new career. This ni ...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
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
How To:
17 New Accessibility Features Coming to iPhone and iPad with iOS 18 and iPadOS 18
How To:
Apple's Repair Mode for iOS Makes Prepping Your iPhone to Be Fixed Easier and More Secure
How To:
Apple's iOS 17.5 Gives Your iPhone 32 New Features and Changes — Here's Everything You Need to Know About
How To:
Apple News Gives You More Options for Automatic Downloads on iOS 17.5
How To:
Apple Has a Killer New Word Game Puzzle Called Quartiles on iOS 17.5
How To:
Apple Integrates Game Center Leaderboards into News+ Puzzles with iOS 17.5
How To:
11 Big New Features for Apple News on Your iPhone with iOS 17.5
How To:
15 iPhone Tips for Busy Users to Maximize Your Productivity
Home Screen Customization:
How to Hide and Show Specific Home Screen Pages on Your iPhone
How To:
Make Your iPhone Do All Your Talking for You on Calls and in Person
How To:
Add Website Shortcuts to Your iPhone's Home Screen for Fast Access to Web Apps and Bookmarks
News:
Apple Pencil 3 Is Almost Here — And It Comes with Squeeze Gestures and These Other Features
How To:
The Messaging Trick You Never Knew You Needed
How To:
Customize and Use Control Center on Your iPhone for Quick Access to Your Most-Used Apps, Features, and Settings
How To:
Identify Any Song Playing on Instagram, TikTok, and Other Apps on Your iPhone Using Shazam
How To:
Download and Install iOS 17.5 Beta on Your iPhone — And Try New Features Before Everyone Else
How To:
Download and Install iPadOS 17.5 Beta on Your iPhone to Explore New Features Before Everyone Else
How To:
Update Your iPhone's Lock Screen with an Attention-Grabbing Note, Reminder, Warning, or Other Custom Message
How To:
Your iCloud Email Lets You Create Aliases to Protect Your Primary Email Address and Organize Your Inbox
How To:
Use Your iPhone's Built-in Image Analyzer to Reveal the Hidden Meaning Behind Symbols, Signs, and More
How To:
Apple's iOS 17.5 Gives Your iPhone 32 New Features and Changes — Here's Everything You Need to Know About
How To:
See Passwords for Wi-Fi Networks You've Connected Your Android Device To
How To:
Create an Admin User Account Using CMD Prompt (Windows)
How To:
17 New Accessibility Features Coming to iPhone and iPad with iOS 18 and iPadOS 18
How To:
7 Hidden iPhone Apps You Didn't Know Existed
How To:
Use FaceTime's Secret Hand Gestures and Reaction Buttons to Add Animated On-Screen Effects to Your Video Feed
Modular Origami:
How to Make a Cube, Octahedron & Icosahedron from Sonobe Units
How To:
Dox Anyone
How To:
Brute-Force FTP Credentials & Get Server Access
How To:
Make Spoofed Calls Using Any Phone Number You Want Right from Your Smartphone
How To:
Exploit EternalBlue on Windows Server with Metasploit
How To:
Check if Your Wireless Network Adapter Supports Monitor Mode & Packet Injection
How To:
Scan for Vulnerabilities on Any Website Using Nikto
How To:
Find Identifying Information from a Phone Number Using OSINT Tools
How To:
Make the USB Connection on Your Android Phone Default to File Transfer Mode
How To:
The Easiest Way to Secretly Record Someone's Conversation with Your iPhone
Warning:
Sensitive Info You Black Out in Images Can Be Revealed with a Few Quick Edits on Your iPhone
How To:
The Trick That Lets You Link to Specific Start Times in YouTube Videos Right from Your Phone
How To:
CC in a Physical Business Letter
How To:
Crack SSH Private Key Passwords with John the Ripper
How To:
Use Odin to Flash Samsung Galaxy Stock Firmware
How to Hack a Vending Machine:
9 Tricks to Getting Free Drinks, Snacks & Money
How To:
Hack Apache Tomcat via Malicious WAR File Upload
How To:
Gain SSH Access to Servers by Brute-Forcing Credentials
Gaslighting 101:
How to Turn People's Own Thoughts Against Them
How To:
Fold the Record-Setting Glider-Style Paper Airplane (Guinness World Records)
How To:
Get Root with Metasploit's Local Exploit Suggester
How To:
Find the Most Accurate Weather Source for Your Area (And See Which Apps Use It)
How To:
Find Passwords in Exposed Log Files with Google Dorks
How To:
Scan Websites for Interesting Directories & Files with Gobuster
How To:
Remove Unnecessary Profiles & Certificates on Your iPhone to Protect Your Privacy & Security
How To:
Set Up Greenify Without Root & Save Battery Life on Any Android
How To:
Easily Remove Unwanted People and Objects in Your Photos with Google's Magic Eraser
Making Electromagnetic Weapons:
EMP Generator, Part One
How To:
Install TWRP Without a Computer
How To:
Exploit Routers on an Unrooted Android Phone
How To:
Top 9 Task Managers for iPhone and iPad
HowTo:
Levitate Pencil Lead
How To:
Clone Any Android App on Your Samsung Galaxy Phone Without Using Any Third-Party Tools
How To:
Use Burp & FoxyProxy to Easily Switch Between Proxy Settings
