PowerPivot is an added functionality in Excel that offers a dynamic way to display information from other sources. A KPI (Key Performance Indicator) allows a user to dynamically create visuals for data being displayed in the PowerPivot table. Once you have a PowerPivot table setup, which requires a number of steps that include activating the … Continue reading PowerPivot KPI Setup – Excel
When prepping a workbook for a template, typically it needs to be cleared of data, so that the template is ready for new data each time a new workbook is created. The functionality, on the other hand, needs to be left intact, so that a user does not need to recreate the wheel every time … Continue reading Show Formulas Shortcut – Excel
Did you know that there are ways to reduce your workload by automating many of the tasks you do in Excel? Our Excel Functions and Formulas class will empower you with the ability to build complex formulas, to make crunching your numbers simple. We will even teach you ways to make your spreadsheets more … Continue reading Why do all that work when you can automate? – Colorado
Did you know that there are ways to reduce your workload by automating many of the tasks you do in Excel? Our Excel Functions and Formulas class will empower you with the ability to build complex formulas, to make crunching your numbers simple. We will even teach you ways to make your spreadsheets more easily … Continue reading Why do all that work when you can automate? -Arizona
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