How to Disable Scroll Lock in Excel on PC

In this ArticleWhat is Scroll Lock?Have you turned on Scroll Lock?How to Tell if Scroll Lock is EnabledHow to Disable Scroll Lock 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…

Read More

Working with Page Breaks in Excel & VBA

remove column page breaks excel vba

In this ArticlePage Break View ModeInsert Page BreaksDelete Page BreakMove Page BreaksReset Page BreaksHide Page Breaks in Normal ViewPage Breaks – VBA 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…

Read More

What-if Analysis in Excel – Scenario Manager & Goal Seek

what if data analysis excel

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

How to Spell Check in Excel & VBA

how to spellcheck in excel vba

In this ArticleSpell Check in ExcelHow to use spell check in Microsoft ExcelKeyboard Shortcuts to Spell Check in Microsoft ExcelHow to Spell Check Multiple (or All) Worksheets at OnceHow to Spell check using VBALaunch Spellcheck from VBASpell Check Before Closing Workbook (VBA BeforeClose)Highlight Misspelled Words with a VBA MacroVBA Coding Made Easy This tutorial will…

Read More

The Best External Keyboards for Laptops

Keyboard 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

Does Microsoft Believe in Ghosts? – Easter Eggs

Microsoft Windows Vista DVD - 3 Ghosts Hologram

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 More

How Much Time Are You Wasting in Excel?

Excel 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 More

Do Lawyers Need to Know Excel?

Excel 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

“Excel” at Your Internship or First Full-Time Job

Now that the school year has ended, students are beginning to turn their thoughts to summer internships or first full-time jobs. We would like to take some time to discuss how to “Excel” at your internship and receive an offer. Of course, these tips are also relevant for graduates preparing for their first full-time job.…

Read More