Embedding documents in an Excel workbook is a technique that is not widely used, mostly because not many people know you can embed a document in a worksheet. There are three different ways to embed and/or link documents in Excel, but we are going to embed a document directly in Excel, with no links. First, … Continue reading Embedding Documents in Excel
Using 3D References between worksheets in an Excel workbook has been around for many years. It allows us to use Excel more like a database than a spreadsheet. As Excel functionality has increased, so has Excel’s capabilities, including the speed that connections update, and the types of connections that can be made between different … Continue reading Creating 3D References between Workbooks in Excel
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