A Personal Workbook in Excel holds information that is specific to your computer copy of Excel. The workbook is created by Excel if it is needed, so you have no control over one being created or not. There are a number of things that might get saved, by Excel, in your Personal Workbook, but the … Continue reading Excel – What is a Personal Workbook?
Have you ever had a mouse go bad, and IT can’t get a new one to you right away? Or maybe you are at home and don’t want to go to the store right after your dog chews through your mouse wire. The nice thing about computers is they do not require a mouse. Mice … Continue reading Don’t have a Mouse Available? Use Key Tips – Excel & Office
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?
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 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
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
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
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
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
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