Have you ever needed to delete every other row in Excel? You are not alone. There are a few ways to accomplish it. It's a pretty good candidate for a VBA solution, but I'm going to show you how to quickly delete every other row without using VBA or a plugin. I...
Excel
How to Load Stock Information in Excel? It’s Easier Than You Think
There are plenty of websites that display stock tickers, technical information, and other important stock Information. Even though several websites do a fantastic job, sometimes you want to analyze them in your own little spreadsheet. Getting Stock Market Data into...
Create Tables
We will create some brand new tables in SQL Management Studio using Excel as a template in this tutorial. The sample data is a fictitious list of Experts and their areas of specialty. Below is a quick Description of our tables and a short sampling of each. This...
VLOOKUP Reference and Quick Tips
Vlookup has been a leading feature of Microsoft Excel for a long time. For many users, its the first function they think of when opening a spreadsheet. Excel has several types of Lookups but VLOOKUP is the most commonly used of the bunch. Let this page be your...
How to make Shareable Spreadsheets
I want to share a really helpful concept with my Excel Shortcut readers. It's called Spreadsheet Shareability and it will definitely help you get recognition as an Excel Pro within your Organization. Have you noticed that certain Spreadsheets are shared and/or...