How-To
How To Merge Cells, Columns & Rows In Excel
When working with data in Excel, it’s common to merge cells, columns, and rows to combine numbers or text. There...
Microsoft Excel
How-To
How to Insert an Excel Worksheet into a Word Doc
If you’ve ever wanted to include data that you have in an Excel file into a Word document, you’ve probably...
How-To
The Ultimate Microsoft Excel Beginner’s Guide
In an article written in 2018, Robert Half, a company specializing in human resources and the financial industry, wrote that...
How-To
How To Merge Data In Multiple Excel Files
When you’re working in Microsoft Excel, you may find that your data has become a little hard to follow, with...
How-To
How to Link Cells Between Sheets and Workbooks In Excel
Microsoft Excel is a very powerful multi-purpose tool that anyone can use. But if you’re someone who works with spreadsheets...
How-To
How to Find Matching Values in Excel
You’ve got an Excel workbook with thousands of numbers and words. There are bound to be multiples of the same...
How-To
How To Fix a Row In Excel
Dealing with very large Excel spreadsheets isn’t always easy. This is especially true when you have lots of embedded calculations...
How-To
How to Switch Between Worksheets in Excel
Excel is a very powerful program. If you’re someone who uses spreadsheets often, learning how to operate Excel can make...
How-To
How To Fix Arrow Keys Not Working In Excel
When you’re working on an Excel spreadsheet, the best way to move between cells is to use the arrow keys...
How-To
An Advanced VBA Guide For MS Excel
If you are just getting started with VBA, then you’ll want to start out studying our VBA guide for beginners....
How-To
What Is a VBA Array in Excel and How to Program One
VBA has been part of the Microsoft Office suite for many years. While it doesn’t have the full functionality and...
How-To
How To Create a VBA Macro Or Script In Excel
Microsoft Excel enables users to automate features and commands using macros and Visual Basic for Applications (VBA) scripting. VBA is...
How-To
How to Remove, Crack, or Break a Forgotten Excel XLS Password
It can be really frustrating when you go to use a password-protected resource and you have forgotten the password. Even...
How-To
Use the Keyboard to Change Row Height and Column Width in Excel
These days people are moving over to touch interfaces at a rapid pace, but for certain types of work a...
How-To
How To Share An Excel File For Easy Collaboration
Collaboration is important in many work spaces. Since most projects require files to be accessed by a lot of users,...
How-To
Basic One-Column and Multi-Column Data Sorting in Excel Spreadsheets
Two of Excel’s primary functions are to allow you to manipulate and view data from different perspectives, and one of...
How-To
Retrieve Excel Data From a Web Page Directly
Excel is an incredibly powerful piece of software that can do almost any mathematical or logical calculations you could want....
How-To
10 Excel Tips and Tricks for 2019
In this article, I’ll be covering 10 Excel tips that you can use to boost productivity and make your work...
How-To
How to Create a Simple Pivot Table in Excel
If you are in the field of finance or accounting, you already know that most of the job opportunities require...
How-To
How to Use If and Nested If Statements in Excel
One Excel function that I use quite a bit in my formulas is the IF function. The IF function is...
How-To
How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel
The three most commonly used formulas in Excel that perform simple mathematical calculations are COUNT, SUM and AVERAGE. Whether you...
How-To
Use Dynamic Range Names in Excel for Flexible Dropdowns
Excel spreadsheets often include cell dropdowns to simplify and/or standardize data entry. These dropdowns are created using the data validation...
How-To
Google Sheets vs Microsoft Excel – What are the Differences?
Previously, we wrote about the differences between Google Docs and Microsoft Word and in this post, we’re going to talk...
How-To
Why You Should Be Using Named Ranges in Excel
Named ranges are a useful, but often underutilized, feature of Microsoft Excel. Named ranges can make formulas easier to understand...
How-To
When to Use Index-Match Instead of VLOOKUP in Excel
For those of you who are well-versed in Excel, you are most likely very familiar with the VLOOKUP function. The...
