Excel – Just a spreadsheet?

Don’t Believe It! Don’t believe that Excel is just another spreadsheet program! It is much more. By using 3D functionality, you can make Excel act like a database. Excel is much more robust than it was ten years ago, and it holds much more data. Excel, however, will never be a database. Thus, you need … Continue reading Excel – Just a spreadsheet?

Excel Boot Camp – Become a Master of the Spreadsheet

MCT’s Excel Boot Camp will get your spreadsheet skills into top form! This intensive three-day Excel course will give you the hands-on training you need to go from basic-level user to a master of this all-important application. In three action-packed days, you will master the content of the intermediate, advanced, pivot tables and charts, functions … Continue reading Excel Boot Camp – Become a Master of the Spreadsheet

Removing Duplicate Rows of Information in Excel

When we are working with many rows of data, it would be time consuming to scroll through all the data to see if there are duplicate rows of information. Luckily for us, Excel has a built-in duplicate remover. To use this functionality, we need to make sure we select a cell within the data.  Excel … Continue reading Removing Duplicate Rows of Information in Excel

Copy and Paste Only Values in Excel

If your Excel workbook uses many formulas to display report data for managers or supervisors, and you need to give them only the report worksheet, you can copy just the values of that worksheet and leave all the formulas behind with a special paste. This can be done in a brand new workbook as easily … Continue reading Copy and Paste Only Values in Excel

Enter Formula and Stay in the Same Cell in Excel

By default, in Excel, when you press the Enter key, you will move down to the cell below. When you need to copy a formula down through a number of cells, this is a little bit of a pain; you would need to click the cell you just left again, in order to do so. … Continue reading Enter Formula and Stay in the Same Cell in Excel

Take Excel to the Next Level

So many people use MS Excel daily that it would seem to be the one application everyone understands. It isn’t. While most people use Excel daily, not everyone knows how to do much beyond the basics, and no one knows everything Excel can do. MS Excel has become a very powerful tool for business, and … Continue reading Take Excel to the Next Level

Flash Fill in Excel

In 2013, Microsoft added a little known functionality called “Flash Fill.” This functionality allows you to quickly format items, based on the first one or two line items. Formatting numerous phone numbers or email addresses is no problem, but it works for any combination of items as well. Whether your data takes up two cells … Continue reading Flash Fill in Excel

Using the Table Functionality in Excel

We use lists of information regularly, but inserting a Table can add extra functionality that gives you tools to make your job way easier and in some cases, less complicated. By default, inserting a Table will give you alternating colors of data, which is adjustable to many different colors and options, and gives you drop-down … Continue reading Using the Table Functionality in Excel

Formatting an Entire Worksheet in Excel

Have you ever scrolled down or across an Excel worksheet, and noticed that the background color is no longer showing in the cells? Or maybe the font has changed from the one you always use to a generic font from your settings. This can cause your workbook to appear unprofessional, or for people to wonder … Continue reading Formatting an Entire Worksheet in Excel

Save valuable time with the Double-click Fill Handle in Excel

Creating usable worksheets can be a hassle, especially when you constantly have to left-click the fill handle of the cell and drag the information down to some distant row. This is even more of a pain, when you have to do it repeatedly, which feels like a waste of valuable time. If you have ever … Continue reading Save valuable time with the Double-click Fill Handle in Excel