Janice Articles
A browsable archive of Excel tutorials and guides written by Janice.
40 articles
How to Create a Drop Down List in Excel with Data Validation
Are you wondering how to create a drop down list in excel? Don't worry. Our step-by-step guide tells you everything that you need to know....
How to Calculate Hours Between Two Dates and Times in Excel
Calculate elapsed hours between Excel dates and times, display totals over 24 hours, convert to decimal hours, and handle overnight shifts....
How to Convert Excel to Google Sheets
Google Sheets gives you several excellent features, but there may be a time where you need to know how to convert Excel to Google Sheets....
The Data Adds Up: Using the Addition Formula in Excel
In this article you'll learn the basic addition formula for Excel with examples and a how-to guide for entering formulas and using the sum feature....
Pivot Charts: An All-Encompassing Guide
Pivot charts are often the best way to spot trends or errors, and a better way to present your data. Here's everything you need to know to make them in Exel...
HLOOKUP In Excel: Everything You Need to Know
If you're looking on how to use hlookup in excel, you came in to the right place! In this article, we discussed on how to use it and it's common problem....
The Best Excel Book to Purchase from Amazon
We have compiled a list of the ten best Excel book options that can help you use Excel with ease and to its full potential. Check this out!...
How to Create a Database in Excel
Excel database files are useful for creating simple tables or spreadsheets based on numbers and formulas. Learn here on how to create a database in excel....
Google Sheets vs Excel: How Do They Differ?
Google Sheets vs Excel? Check here for the similarities and differences between the two to help you choose which program is right of your budgeting needs....
The History of Microsoft Excel: How It Came to Be
Excel is a popular spreadsheet system, which organizes data in columns and rows. Learn more here about the history of Microsoft excel....
What to Do When Excel Keeps Crashing
Excel hangs or freezes when you open an Excel workbook. Well, this is a very frustrating issue. Learn more common issues why excel keeps crashing....
How to Find Outliers in Excel in 5 Easy Steps
This article will give you a walk-through on how to find outliers in Excel and why finding outliers is an essential piece of data analytics in statistics....
How to Calculate Z Score in Excel: What You Need to Know
Getting some clarity on the topic will make it that much easier to learn how to calculate a z-score in Excel when the time comes....
How to Find Variance in Excel? Follow These Tips
Knowing how to find variance in Excel is a helpful skill to have while designing any spreadsheet, especially if one understands the nuances of the function....
How to Print Labels from Excel: Ultimate Guide
By following instructions on how to print labels from Excel, you'll be able to quickly and easily print any label from Excel....
How to Add a Row in Excel: Step by Step Process
Microsoft Excel is a great tool to use for work, school and even for personal data purposes. In case you're wondering, here's how to add a row in excel....
How to Remove Duplicates in Excel (and Keep the Right Row)
Remove duplicate rows in Excel, choose the columns that define a duplicate, and sort first to keep the record you want. Includes preview and formula alternatives....
How to Round Numbers in Excel: What You Need to Know
Use Excel’s feature to round decimals or large numbers in a spreadsheet. In this article, we'll show you how to round numbers in Excel....
The NOW Function in Excel: What It is and How to Use It
Are you wondering how to use the now function in Excel? Look no further. Our easy step-by-step guide has all of the information that you need to know....
How to Hide Columns in Excel
As great as columns are in Excel you don’t always need to see every single one. Let’s take a look at how to hide columns in Excel, and unhide them too....
How to Randomize a List in Excel: Our Complete Guide
How to randomize a list in excel? How would you do it? In this article, we listed our complete guide to help you on this kind of formula....
Sort Your Life into Neat Little Boxes with These Excel Basics
Jobs nowadays require basic knowledge of Excel. Spark your skills with these excel basics we have on this article that will surely speed up your workflow....
Ready, Set, Scatter: How to Make a Scatter Plot in Excel
This article consists of all the basics of how to make a scatter plot in Excel. By using the guide, readers will be able to generate their own plots as well as format them and add design features....
How to Freeze A Row in Excel: A Practical Guide
Learn to how to freeze a row in excel (or even more than 2 rows) using this practical how-to guide. Excel has an available feature allowing users the ability to freeze a row....
How to Freeze Cells in Excel So Rows and Columns Stay Visible
Do you often work with long rows & columns of data? Minimize the time you spend scrolling up, down, and sideways by learning how to freeze cells in Excel!...
How to Use Goal Seek in Excel
Use this guide to learn how to use goal seek in excel as well as how to put it into action. To use Goal Seek, you will have to open a new sheet....
How to Alphabetize in Excel: Fast & Simple
Using Excel we can properly organize data for our businesses or personal finances. Learn how to alphabetize in excel so it is easy to read and refer back to whenever necessary....
How to Make a Line Graph in Excel
Organize data by learning how to make a line graph in Excel. Present information over time with this simple guide to creating a line graph....
How to Subtract in Excel
Learn how to subtract in Excel with this valuable how-to guide. This article will walk you through each step of the process from start to finish....
Excel SUM Formula: What Is It And When Do I Use It?
Perhaps one of Excel's best-known functions is the SUM formula. Learn more about a subset of data by totaling rows, columns and more with excel sum formula....
5 New and Creative Ways To Utilize Excel
Excel is a program that is beneficial to anyone who wants to organize the utility bills or for professionals who need to stay organized at the office. To most Excel users, it can seem like a pretty cut and dry program. W...
The 20 Most Useful Excel Shortcuts to Utilize
Do you use Excel every day but working with it seems slow and tedious? Learn 20 Excel shortcuts that help make creating spreadsheets faster and easier to do....
Pivot Tables (PV Table): Everything You Need to Know
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, all...
Learn How to Unhide Cells in Excel Using Keyboard Shortcuts or the Home Menu
Learn how to unhide columns in Excel using keyboard shortcuts or the Home Menu methods. While Excel does not allow you to Hide and Unhide individual cells using the Hide/Unhide command, here’s a trick showing how to hide...
The Drop Down Basics: How to Make a Drop Down List in Excel
This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make dropdown lists in an Excel spreadsheet. You can follow the instructions to create a new dropdown list...
How to Use the AVERAGE Function in Excel
To figure out the average of a group of numbers, makes it easier for you to analyze important data. Learn how to use the average function in Excel right here....
How to Move Columns in Excel While Keeping Your Data Intact
Ready to hone your skills in working with Excel spreadsheets for a more organized workflow? Start with learning how to move columns in Excel. This especially helps with columns containing large swaths of data....
How to Add Cells in Excel to Sum Up Totals Automatically
Excel's great for displaying data and even better at crunching numbers. Here's how to add cells in Excel to sum up totals automatically... Even when you change the numbers....
How to Merge Cells in Excel (and Split Them) for Better Layouts
Do you want to make your Excel spreadsheets more presentable? Here are a few useful tips on how to merge cells in Excel that would surely make your work look tidier....
SUMIF and SUMIFS in Excel: Syntax, Examples, and Differences
Learn when to use SUMIF or SUMIFS in Excel, with working text, wildcard, and date examples—and see how their argument order differs....
About Excel Semi Pro
Since 2010, we have been helping people improve their Excel skills. Here, you will find beginner and intermediate tips on navigating spreadsheets to achieve results.
Read more about us