What is Scroll Lock? The Scroll Lock setting determines what happens when you use the Arrow Keys in Excel. When Scroll Lock is off (the default setting), the Arrow Keys allow you to navigate and select different cells within a worksheet. When Scroll Lock is enabled, the Arrow Keys will instead “scroll” through the active…
Read More
If you don’t manually set Page Breaks, Excel will do it’s best to set appropriate Page Breaks. However, if you’ve ever tried to print an Excel spreadsheet, you know it generally does not do a good job. Any time you print a spreadsheet you should review and edit the Page Breaks before printing. Page Break…
Read More
The what-if analysis tools on Excel allow you to apply different values to formulas and compare results for a variety of scenarios. Why is it important to understand what-if analysis? There are many applications of what-if analysis, such as financial modeling and sensitivity analyses. For example, if you are preparing a financial model, and you…
Read More
This tutorial will demonstrate how to use spell check in Excel and in VBA. Spell Check in Excel Microsoft Excel offers a basic spelling function that can help you check your spelling on any spreadsheet that you produce. This function is very limited, in relation to the spell check function in Microsoft Word or Microsoft…
Read MoreExcel allows you to display comments on the screen, but by default the comments will not print with your spreadsheets.This tutorial will teach you several different methods to print comments in your spreadsheets. Print Comments – Review Ribbon Method: 1. If you have more than one worksheet, select the one that contains the comments you…
Read MoreKeyboard Shortcuts are the key to working efficiently in Excel. Unfortunately, many modern laptops are too small to have a full-sized keyboard, making it harder to use keyboard shortcuts. There are several common keyboard layout shortcomings that are especially limiting: A fn key directly to the left of the CTRL key on the bottom-left of…
Read More
In 2007, Spanish-speaking blogger, Kwisatz discovered a surprising image embedded in the hologram of a Windows Vista DVD: Kwisatz blog has since been taken down, however, the original blog post and images can be seen using Web Archive . It appeared an image of three men (ghosts?) had been embedded onto the DVD. The entire image is less than…
Read MoreInterviewers commonly ask “How would you describe your Excel ability” or “How much experience do you have in Excel?” Taking a quick informal survey, I found most people answered, generically “intermediate”. This makes sense, no one wants to claim to be a beginner, but no one wants to claim to be advanced and be asked…
Read MoreExcel is one of the only business software products that can be considered universal. Excel evolved as the business environment evolved; as firms in leading industries concerned themselves with organizational efficiency, versatility, and agility, “spreadsheet” began to mean completely different things to different people. Most significantly for us, Persons Other than Accountants (POAs) started opening…
Read MoreExcel probably doesn’t come to mind when you think of tools lawyers use. With a surplus of young law school grads but a dearth of job openings, however, a surprisingly high number of legal minds are finding out that technical flexibility is a huge asset. As firms are forced to cut costs, and young lawyers…
Read More