Featured post

8 Tough Interview Questions and Answers to Ace Them

Read more

Resources

Excel Challenge # 10

Excel Challenge # 10

In this challenge, we are exploring charts. How good are you with charts in Excel? Can you solve this challenge?

How to Alphabetize in Excel

How to Alphabetize in Excel

Sharpen your sorting skills now with these tips on how to alphabetize in Excel.

200+ Best Excel Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Excel. Well, get ready to be even fan...

Excel Custom Number Format - A Beginner’s Guide

Excel Custom Number Format - A Beginner’s Guide

A number format controls how cells with numeric data appear in Excel. Learn about how Excel custom number formats work in this beginner's guide.

Excel Challenge # 9

Excel Challenge # 9

Think sorting data in Excel is simple enough? Well, try this challenge and let's see if you still think so.

How to Use the FREQUENCY Excel Function

How to Use the FREQUENCY Excel Function

The FREQUENCY Excel function simplifies the task of grouping values, especially in large datasets. Learn more!

How to Use Excel Solver

How to Use Excel Solver

Excel solver can be applied to workforce management, maximizing profitability, and financial planning. Learn how to use the tool!

How to Make a Graph in Excel

How to Make a Graph in Excel

You can make a graph in Excel for simple, advanced, and complex data. Here's how to make a graph in Excel.

Join 303,200 serial learners

Subscribe to our newsletter and receive exclusive content before everyone else.

The Excel TEXT Function

The Excel TEXT Function

The Excel TEXT function allows you to convert numbers to Excel text format using Excel’s format codes. Learn all about it.

Excel Challenge # 8

Excel Challenge # 8

Use the VLOOKUP and IF functions to solve this new Excel challenge that takes you into a contact center. Take the challenge to learn real-world Exc...

12 Basic Excel Formulas You Need to Know

12 Basic Excel Formulas You Need to Know

Don’t know much about how to use Excel formulas? Learn about these 12 basic Excel formulas to get started in Excel.

How to Remove Duplicates in Excel

How to Remove Duplicates in Excel

Let’s clean up your worksheet by learning how to find, and then, how to remove duplicates in Excel.

How to Use the Excel INDIRECT Function

How to Use the Excel INDIRECT Function

With a single argument, you can add sophistication to your worksheet by allowing it to behave dynamically. That’s the Excel INDIRECT function.

How to Create a Histogram in Excel

How to Create a Histogram in Excel

Histograms are useful for reporting on statistical data, especially when large datasets are involved. Here’s how to create a histogram in Excel.

How to Strikethrough in Excel

How to Strikethrough in Excel

The strikethrough effect is an effective way to visually highlight that a task has been completed. Learn how to strikethrough in Excel.

Standard Deviation Formula in Excel

Standard Deviation Formula in Excel

Excel eliminates the manual work by offering not one, but six functions to calculate standard deviation. Learn about the standard deviation formula...

How to Use the Excel SUMPRODUCT Function

How to Use the Excel SUMPRODUCT Function

The Excel SUMPRODUCT function allows you to do tasks you’re probably doing quite often now, but much more quickly. Learn more in this beginner's gu...

99 Insanely Helpful Word Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in Word. Well, get ready to be even fanc...

100 Insanely Helpful PowerPoint Shortcuts for PC and Mac

So you think you’re fancy, huh? Just because you know how to copy and paste without the click of the mouse in PowerPoint. Well, get ready to be eve...

Excel Challenge 7

Excel Challenge 7

Help this book store owner solve this Excel data management challenge using the XLOOKUP function.