Excel may not always be the most exciting program to utilize at home or at the office, but it’s an essential one that keeps over millions of users organized and able to do their tasks with relative ease. Whether you are relatively new to the world of Excel or you’ve been using it on a …
Learning the shortcuts on any program can cut the time it takes to produce a document. With a program like Excel that has so many uses, knowing some of its shortcuts can make navigating, entering formulas, and setting up worksheets quicker to do. Reasons to Use Shortcuts Excel has many uses, although creating spreadsheets is …
When working with Excel spreadsheets, it can be difficult to extract the information you need from large sets of data. Pivot Tables (pv table) offer a great way to quickly condense and analyze, and present your data, allowing you to make informed decisions in both your professional and personal life. Pivot Tables allow you to effortlessly …
This article shows you how to make a drop down list in excel. It provides two ways for you to quickly and easily make drop down lists in an Excel spreadsheet. You can follow the instructions to create a new drop down list that will help streamline efficiency when collecting information in your spreadsheet. A dropdown list …
I wrote a post stating that I could not find the Windows Ctrl+Home keyboard shortcut equivalent on a Mac. Well I’m here to tell you that I found the keyboard shortcut combination that does the same thing on a Mac. The Excel Gods are with me. Hallelujah! Finding My Way Home The key to finding …
One of my all-time favorite keyboard shortcuts in Excel is CTRL+Home, but on a Mac there is no Home button. Hence a constant source of frustration these last two years. I finally decided to do something about that and recently figured out a solution using VBA and the Personal Macro Workbook. But before I go …
I want to have Excel 2011 (for Mac) open to a blank worksheet that is zoomed to 125%, and it has taken a very long time to figure this out. It involves saving a template to a buried location, and then manipulating the file in Finder to remove the extension. Simple, once you know the …
I recently found myself with a new, loaner laptop and a brand new copy of Excel 2003 as my default spreadsheet program. This was fine until I realized there were a number of things “missing.” Like shortcuts and settings that I’ve changed over the years to make Excel serve me, instead of the other way …
